[sballios]

Any suggestions would be appreciated.

We are trying to make a remote connection from one server to another and use the remote machines

OBDC connection to get data from netsuite.com. Both servers have the netsuite.com ODBC drivers installed and locally each can connect to netsuite.com successfully using a linked server in SQL Server. When we

try and set up a linked server to access a remote server and use that ODBC connection, it fails with the following error.

We need to use this setup because our production server will not have the ODBC setup on it.

Linked Server created using

EXEC sp_addlinkedserver

@server=’DEVSERVER’,

@srvproduct=’NetSuite.com’,

@provider=’MSDASQL’,

@datasrc=’NetSuite.com’,

@provstr=’Database=NetSuite.com;Uid=xxxxx@xxxxx.co m;Pwd=#######’

[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

OLE DB error trace [OLE/DB Provider ‘MSDASQL’ IDBInitialize::Initialize returned 0x80004005: ].

Msg 7399, Level 16, State 1, Line 2

OLE DB provider ‘MSDASQL’ reported an error.
This is a cached copy. Click here to see the original post.

[sballios]

RE: ODBC and Remote Connections

So has anyone tried anything like this?

[Author]

Posts