How can I LINK SQL 2000 to an ODBC Database

[CortexWayne]

Hi! I'm a french Canadian so excuse my poor english...

I have a SQL 2000 Server on my PDC and I have a dedicated server for our production management system with an ODBC database.

On my SQL 2000 server, I can import data via ODBC...

Here is my problem. My production management system requiere lisence that worth 3000$ each. I have 13 of them. But we implemented a new program linked to our production management system which use the ODBC to connect with. Now this new program need 42 connections to the production management system... The whole laboratory. To save 87 000$ I need to link my SQL 2000 Server directly to my production management system. This way, instead of connecting my new program to The ODBC, I'll connect it to my SQL Server and it will have only 1 connection.

What I'm unable to do is linking my SQL Server to my ODBC management system. I can import but not link(live data).

All help would be greatly appreciated.
Martin Lamontagne.

 

[osjohnm]

Hi

You can add the ODBC database as a linked server.

This can be done thru Enterprise Manager or using sp_addlinkedserver.

Look in BOL at "Adding linked servers". There should be an example of connecting to an ODBC database.

Hope this helps

John

 

[osjohnm]

Hi

Once you have setup the linked server you can query the server directly.

In the following thread I explained to someone how to setup a linked server between two sql servers. The principles are the same so this thread will give you an idea of how to go about it.

thread183-389495

Make sure you go through BOL to find the correct syntax or correct data source provider.

John

 

[CortexWayne]

Thx! Everything as worked! Sorry for my late late response..