Creating an ODBC linked server in SQL2005

[KEMoore]

I am trying to read data located on an ODBC box.
I have multiple queries built in SQL2005. Now I just need to be able to access this data from the ODBC server in the SQL2005.
I have tried to create a linked sever and failed miserably.
I have an ODBC connection set up on my machine with the following settings:
Data Source Name: MSXXXP1
Description: Client data source
Server Name: tcp:XXX.XXX.XXX.XXX.XXXX
ServerDSN: MSXXXP1


Any help is greatly appreciated.

[ck9663]

I am trying to read data located on an ODBC box.
I have multiple queries built in SQL2005. Now I just need to be able to access this data from the ODBC server in the SQL2005.
I have tried to create a linked sever and failed miserably.
I have an ODBC connection set up on my machine with the following settings:
Data Source Name: MSXXXP1
Description: Client data source
Server Name: tcp:XXX.XXX.XXX.XXX.XXXX
ServerDSN: MSXXXP1


Any help is greatly appreciated.

From your ODBC server, can you access your SQL Server? Post what have you done so far.

-- CK

[KEMoore]

From your ODBC server, can you access your SQL Server? Post what have you done so far.

-- CK

Thank you for the response.
The ODBC sever is tricky. It's a Linux box and I have not been able to connect it to SQL yet. Thats what I would like to do, is create a linked server between the two. The only way that I've found I'm able to pull data out of the ODBC is using SQL 2000 DTS export.

[sujitkar]

Hi friends,
I am using SQL Server 2005.

I have an MS-Access database which is protected by MDW file. Through shortcut (specifying the workgroup) only, I can open that database file(MDB). Now I have created an ODBC to that database. I have checked the ODBC in excel 2007. it works nicely there. But when I am trying to use it in the Linked Server in SQL Server, it doesnot work. Actually I dont know whether it works or not. when I am trying to fetch the record using <LINKED_SERVER_NAME>...<TABLE_NAME>, it gives the following error message-

"An invalid schema or catalog was specified for the provider MSDASQL for Linked Server <LINKED_SERVER_NAME>