Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC to specific Instance
- Thread starter circulent
- Start date
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.
[sub]____________ 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[/sub]
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.
[sub]____________ 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[/sub]
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
-SQLBill
Posting advice: FAQ481-4875
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question