sql server odbc: ODBC connect string for named instance? -- sql server odbc

ODBC connect string for named instance?

Richard M. Hartman
5/25/2007 10:08:55 AM

sql server odbc:

I am familiar with constructing ODBC connect strings for SQL server
databases using "SERVER=" and "Database=" clauses. If the SQL server is
running a named instance, instead of an unnamed one, do you put the instance
name in the "SERVER=" clause, or is there another clause for that?

--
-Richard M. Hartman

186,000 mi/sec: not just a good idea, it's the LAW!

You have insurance for your car and your health,
why not for your legal needs?
http://www.legalhmo.com

Re: ODBC connect string for named instance?

Rick Byham, (MSFT)
5/25/2007 1:53:42 PM

I can't test this right now, but you should be able to set SERVER to
servername\instancename.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.