ODBC – API – SQLBindParameter – Date, Time – Timestamp – Error Messages

Background Wanted to highlight a few less than intuitive error messages one can run into when trying to work on dates using the SQLBindParameter. BTW,  our programming language is C and ODBC. Code 1) DATE_STRUCT // SQL_C_TYPE_DATE // SQL_TYPE_DATE Code Output 2) SQL_TIMESTAMP_STRUCT // SQL_C_TYPE_TIMESTAMP // SQL_TYPE_TIMESTAMP Code Output 3) SQL_TIMESTAMP_STRUCT // SQL_C_TYPE_TIMESTAMP // SQL_TYPE_TIMESTAMP … Continue reading ODBC – API – SQLBindParameter – Date, Time – Timestamp – Error Messages

Microsoft Visual C++ – Compiling for 64-bit

Background As I tried to run our little ODBC application noticed that we have not created the targeted ODBC Data Source. Error Error Image Error Text Remediation Created the datasource and as I thought more, opted to consider 64-bit platforms, as well Target - x64 Objective Let us compile our application and target 64-bit bitness. … Continue reading Microsoft Visual C++ – Compiling for 64-bit

Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

Background Wanted to give a quick update on the Azure Data Studio Extension, sqlops-spexecutesql-to-sql. Lineage Azure Data Studio – Extension – "sqlops-spexecutesql-to-sql" Original Post Date Posted :- 2019-August-24th Link Bug Report Outline Filed a bug. The code is on GitHub and path way to filling a bug it to : Sojourn to GitHub Access Pejman … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

PostgreSQL :- Database Backup & Load – File is in Text Format

Background Here is our second post. The first post covers database backup and restore with the backup file formatted using a custom format. That post is here. Backup & Restore Introduction In this post we will take the following track :- Backup Invoke the pg_dump utility File format will be plain text ( -Fp ) … Continue reading PostgreSQL :- Database Backup & Load – File is in Text Format

PostgreSQL :- Database Backup & Restore – File is in Custom Format

Background A long three day weekend is a good time to catch up on house work, grocery runs, cooking, worship service. Added in SQL Server and here Tuesday Morning a tiny bit of PostgreSQL, as well. Backup & Restore Outline _base.cmd Set up environments backup.cmd restore.cmd Scripts _base.cmd backup.cmd restore.cmd References AxiomMQ Jovana Dačić Backup … Continue reading PostgreSQL :- Database Backup & Restore – File is in Custom Format

Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql”

Background Reviewing a few SQL Statements and noticed some of them came across as prepared statements. Wanted to see if I will be able to understand them by converting them to plain generic SQL. SQL Sample SQL Here is a sample SQL Traditional SQL Here is a hand crafted comversion Azure Data Studio Extension I … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql”

SSIS :- Exception – Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException

Background Deployed a new SSIS package. It is time to test it out. But, really having problems. Error Error Text Error Image Troubleshooting Googled for help. Landed @ Title :- Deploying single SSIS package to SQL 2016 from SSDT 17.0-17.4 Description :- Deploying a single SSIS package with VB script task, targeted for SQL 2016 … Continue reading SSIS :- Exception – Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException