Stack Overflow
Stack Overflow

Questions tagged [msdasql]

24 questions
0
votes
0 answers

SQL Server ODBC Linked Server

I'm trying to create a linked server in SQL Server 2017, linked system is odbc (criteria criOdbc) Test 1 from SQL Server Management Studio: select * from OPENROWSET('MSDASQL', 'DSN=criteria64;uid=xxxx;pwd=yyyy;', …
Xilmiki
  • 1,453
  • 15
  • 22
0
votes
0 answers

How to solve intermittent login problems with Oracle and VBA's ADODB

My environment is Windows 10, Office 2019 - 64 bit an Oracle Client 19.3. I've had Office Macro's access Oracle data for years. Recently the Oracle server was upgraded from release 11.g to 18.c. The Macro's work on most PC's, but on a few I have…
user3138025
  • 795
  • 4
  • 17
  • 46
0
votes
0 answers

Can't read time data from DB

I tried to read full date information in the DB file. When I check the data using DBbrowser, it shows as below Date 4/16/2016 16:39:10 4/19/2016 12:50:48 4/22/2016 16:12:24 4/25/2016 10:28:31 4/27/2016 10:51:30 But I can get only date with below…
Taesoo
  • 1
  • 2
0
votes
1 answer

Linked MySQL Table no longer working in Microsoft SQL

I have a Microsoft SQL Server that we linked a MySQL DB to a few months ago, it had been working properly, but in the last two weeks we have not been able to access the table as before. We started receiving the following error in Microsoft SQL…
bfowler
  • 49
  • 1
  • 9
0
votes
0 answers

Trying to establish a linked share connection with SQLite from SQL Server

I am trying to create a linked share connection from SQL Server to SQLite. I have followed all the steps by Graham Okely in the below link. It was really nice and I have been able to create the linked share connection from SQL. Creating a Linked…
Gopakumar N.Kurup
  • 916
  • 4
  • 18
0
votes
1 answer

MySQL > SSMS 2012 Linked Server "Requested conversion is not supported."

This little gem has kept me going for a wee while now and I'm still not much further forward. Environment SSMS 2012 SP1 (target) (Server 2012 64 bit) MySQL (source) Linked server using ODBC 5.3 64bit Unicode driver I am trying to port the tables…
Nique
  • 13
  • 1
  • 5
0
votes
3 answers

Ignored columns using vb6 to extract from excel

I am trying to extract a table of values from an excel (2003) spreadsheet using vb6, the result of which needs to be stored in a (adodb) recordset. The table looks like this: Name Option.1 Option.2 Option.3 Option.4 Option.5 Option.6 …
alex.zambila
  • 159
  • 1
  • 1
  • 10
0
votes
1 answer

Biztalk Server backup Job on SQL Server 2000 fails

We have a Biztalk Server working with SQL Server 2000 at backend. The Biztalk created Backup Job for Full backups and Tran Log backups suddenly started failing with error as below. It uses service Account. Any help with MSDASQL will be…
AK2
  • 71
  • 1
  • 2
  • 7
-1
votes
2 answers

How do I create a volatile table in teradata using OLEDB connector to SAS

This is not a purely Teradata Question. I am not asking to create a volatile table in Teradata. This is a question for someone who uses OLEDB connection to Teradata from SAS. I am aware Volatile tables can be created in a heartbeat using SQL…
user1874594
  • 2,277
  • 1
  • 25
  • 49
1
2