Problem connecting with DevartODBCExactTarget driver

Problem connecting with DevartODBCExactTarget driver

Postby mkeyes » Thu 19 Jan 2017 16:47

I'm attempting to test the Marketing Cloud ODBC driver and am having issues creating a linked server. Here are the details:

Windows 10
SSMS 13.0 (2016)
64 bit driver
Connected to local SQLExpress SQL Server

ODBC 64bit data source set up and "Test Connection" returns a success.

I get this error when I create a linked server:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The OLE DB provider "SQLNCLI11" for linked server "MYSFMCINSTANCE" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "MYSFMCINSTANCE". (Microsoft SQL Server, Error: 7399)


Checking / Unchecking Allow Inprocess on MSDASQL does not make a difference.

Any idea what the issue could be?
mkeyes
 
Posts: 4
Joined: Thu 19 Jan 2017 16:15

Re: Problem connecting with DevartODBCExactTarget driver

Postby AlexP » Mon 23 Jan 2017 08:04

Hello,

When creating Linked Server, you chose the wrong provider. From the Provider drop-down list you need to select Microsoft OLE DB Provider for ODBC Driver
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Problem connecting with DevartODBCExactTarget driver

Postby mkeyes » Mon 23 Jan 2017 15:39

Thanks for your reply. That helped in that when I right click on the linked server and choose "test connection" it succeeds. However, when I expand the "table" node in the "default" catalog node I get this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The OLE DB provider "MSDASQL" for linked server "MYSFMCINSTANCE" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "MSDASQL" for linked server "MYSFMCINSTANCE". (Microsoft SQL Server, Error: 7399)


"Allow Inprocess" is unchecked for MSDASQL
mkeyes
 
Posts: 4
Joined: Thu 19 Jan 2017 16:15

Re: Problem connecting with DevartODBCExactTarget driver

Postby AlexP » Tue 24 Jan 2017 08:37

Which authentication are you using in SSMS: Windows or SQL Server?
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Problem connecting with DevartODBCExactTarget driver

Postby mkeyes » Tue 24 Jan 2017 14:22

I'm connecting to the SQL Server on localhost using Windows Authentication
mkeyes
 
Posts: 4
Joined: Thu 19 Jan 2017 16:15

Re: Problem connecting with DevartODBCExactTarget driver

Postby AlexP » Wed 25 Jan 2017 07:56

Try to use SQL Server authentication
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Problem connecting with DevartODBCExactTarget driver

Postby mkeyes » Thu 26 Jan 2017 17:46

SQL Server Authentication did not work. I was still getting the initial error in SSMS. However, I was able to use a different query analyzer (one called Database.NET) to see the connection. That tool worked immediately and easily with the System ODBC connection. So, problem solved!
mkeyes
 
Posts: 4
Joined: Thu 19 Jan 2017 16:15

Re: Problem connecting with DevartODBCExactTarget driver

Postby AlexP » Fri 27 Jan 2017 08:34

Glad to see that you have found the solution. If you have any other questions, feel free to contact us
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to ODBC Drivers