Question : We have several sql servers that read from a db2 database on an as400 via Openquery to a […]
Tag: oledb
Linked server – When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?
Question : To configure linked server pointing to a SQL server, there are 4 possible options. Server Type: SQL Server […]
SQL Native Client 11 – SQL Server 2017
Question : We currently connect to SQL Server 2014 with the Native Client without any issues. However, the SQL Server […]
Invalid date format in SSIS
Question : I am using BIDS to export data from Oracle to SQL server. I am using OLEDB source and […]
Selecting from an excel spreadsheet into SQL Server table
Question : This question has been asked before but I tried giving full admin rights to the SQL Server user […]
Invalid date format in SSIS
Question : I am using BIDS to export data from Oracle to SQL server. I am using OLEDB source and […]
trigger – SQL Server 2008 – Msg 7391 – “no transaction is active/unable to begin trans”
Question : I have a trigger on my SQL Server, located in server7. It inserts a data on another server […]
Cannot access a temporary table?
Question : I am using ADO/Visual C++ to access SQL Server database. I find it is OK to create only […]
Upgrading from SQLOLEDB to MSOLEDBSQL
Question : Trying to get a handle on upgrade implications. When I try and install the new MSOLEDBSQL driver, Windows […]
What does it mean? ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Question : Q 1: Whenever an Oracle SP wants to return error code/message, it fails returning below exeption: OLE DB […]
- 1
- 2