Stack Overflow
Stack Overflow

Questions tagged [msdasql]

24 questions
18
votes
7 answers

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"

Having an interesting issue. I'm reading from an excel file on a server via an OpenRowset in Sql2005. I've run the query a number of times without any problems. I've just gone out for a quick meeting and suddenly I get the error "Cannot initialize…
StevenMcD
  • 17,262
  • 11
  • 42
  • 54
7
votes
1 answer

Query MYSQL Database From MSSQL Windows10

I have a MYSQL database I would like to link my MSSQL database to. Previously I had this system working, utilising the MSDASQL Linked Server Provider, and creating an ODBC datasource using the latest MYSQL odbc driver. Since my Windows 10 Upgrade…
markthewizard1234
  • 501
  • 6
  • 22
2
votes
1 answer

Pervasive The OLE DB provider "MSDASQL" for linked server reported an error. The provider reported an unexpected catastrophic failure.

MSSQL 2016 link to a Pervasive server. It can see the DBs on the Pervasive database, and tables but when you do a select SELECT * FROM OPENQUERY(LinkedServer, 'SELECT * FROM DB.Table') I get Msg 7399, Level 16, State 1, Line…
JeffS
  • 21
  • 1
  • 3
2
votes
1 answer

ODBC Connection String to Amazon Redshift

Is there a way to specify in a connection string the settings of 'Additional Options' ? I am trying to create a connection string for accessing Amazon Redshift from SAS with SAS/Access to OleDb installed. Because I only have access to OleDb I will…
Richard
  • 25,390
  • 3
  • 25
  • 38
2
votes
1 answer

Linked Server: Cannot obtain the schema rowset "DBSCHEMA_INDEXES" for OLE DB provider "MSDASQL"

When selecting from a certain tables in Teradata from SQL Server Management Studio, over an ODBC Linked Server Connection For certain tables I get the above error, for others i don't. It seems random. Error Details: OLE DB provider "MSDASQL" for…
Gabriel
  • 595
  • 7
  • 10
2
votes
1 answer

Timberline ODBC Error with SQL Server Linked Server: Cannot initialize the data source object

Just to lay the ground work: On a 64bit Windows server we have a 64bit install of SQL Server 2008 R2 We installed a 32bit version of SQL Server Express on the same machine Using the 32bit Express version, we successfully created a linked server to…
Casey Crookston
  • 13,016
  • 24
  • 107
  • 193
1
vote
1 answer

"Requested conversion is not supported" using a linked server and ODBC

Our web application stores UTF-8 encoded data in VARCHAR fields. Recently, we have provided our customers access to this data via ODBC using DataDirect's OpenAccess ODBC driver. This is achieved using DataDirect's OpenAccess SDK, writing a C# .Net…
StewartFip
  • 11
  • 1
  • 3
1
vote
1 answer

ODBC--Call failed on RecordSet

Hellow i need your help i have a access database software, so i decided to migrate into sql server by sql migration assistant after that i tested my linked tabled to my access Graphical user, but fails some of code it seems doesn't applied in that…
Six Richie
  • 15
  • 3
1
vote
1 answer

SQL Server 2016 Fails Cryptically (Error #7303) on Link to MySQL, But Access 2016 Succeeds with Same System DSN

I am going around in crop circles, trying to set up a linked server (from SQL Server 2016 to MySQL). Here is the basic procedure that I used: Create a Linked Server to MySQL from SQL Server. Upon clicking OK to create the new linked server, I…
JOINtheFun
  • 27
  • 1
  • 1
  • 8
1
vote
2 answers

Remote query with variable using MSDASQL

I am trying to create a query for an SSRS report. I need to get the last 3 months transactions from a linked server (to an iSeries). So I have built a SQL variable that I want to execute with OpenQuery declare @EarliestDate varchar(8), @SQL…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
1
vote
1 answer

SUBSTRING with WHERE clause in MSDASQL causes error

I'm testing a feature in a Progress OpenEdge application that loads data into DB tables. Many of the fields in the table I'm testing are limited by our application to 256 characters, so I'm doing some edge case testing, trying to load in entries…
Anastasya Lundquist
  • 600
  • 1
  • 7
  • 21
1
vote
2 answers

Get along with image sql server linked servers from PostgreSQL

When obtaining an image grabde with sql server linked servers from PostgreSQL, I get the following error: OLE DB provider 'MSDASQL' for linked server 'bd_acceso_ruisegip' returned data that does not match expected data length for column '[MSDASQL] .…
Diodito
  • 11
  • 4
1
vote
1 answer

Linked server INSERT, UPDATE and DELETE fails with "Unknown provider error"

Suddenly INSERT, UPDATE and DELETE fails for a certain file (a table in a remote system which I believe is an AS/400). The linked server that we make use of is set up in SQL Server, and it's using an ODBC data source (DSN). The Data source is an…
Andreas Jansson
  • 830
  • 1
  • 9
  • 21
0
votes
1 answer

Getting "7302 - Cannot Create an instance of OLE DB" Error after ACE/ODBC Driver update

We're running SQL Server 2014 with all the latest service packs. Our users heavily rely on OPENROWSET for importing XLSX, CSV and TXT files. Example: SELECT * FROM OPENROWSET ('MSDASQL','DRIVER={MICROSOFT access TEXT DRIVER (*.TXT, *.CSV)};',…
Depth of Field
  • 307
  • 2
  • 16
0
votes
0 answers

Transfering data to mysql from sql server using linked servers

My problem is that i'm trying to transfer some data to mysql from my sql server and it returns this error OLE DB provider "MSDASQL" for linked server "SRV" returned message "[MySQL][ODBC 8.0(a) Driver]Optional feature not supported". Msg…
Anas El Mouki
  • 1
1
2