ODBC to specific Instance

[circulent]

I have a SQL Server 2005 database with 2 separate instances. I need to create an ODBC connection from another server to this box, but am not sure how to specify the specific instance.

Thoughts? Thanks

 

[onpnt]

That's confusing. 1 database, 2 instances?

Anyhow, just create a linked server entry. There really is no need for an ODBC setup for that task

And you specify the instance by name. Either if it is the default name or a named instance. Meaning when the DB Server was setup you either left it the name of the actual server or changed it to something specific.

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[SQLBill]

When you set up ODBC, you will come to a window for "Create a new data source to SQL Server". There will be three text boxes. The bottom one is for selecting your server. Use the servername\instance name combination and I believe that's all you need.

-SQLBill

Posting advice: FAQ481-4875

 

[circulent]

Perfect. Thanks