ODBC connect string for named instance?

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.comI 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.
"Richard M. Hartman" <hartman@.onetouch.com> wrote in message
news:%2355fg9unHHA.3544@.TK2MSFTNGP03.phx.gbl...
> 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
>

ODBC connect string for named instance?

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
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.
"Richard M. Hartman" <hartman@.onetouch.com> wrote in message
news:%2355fg9unHHA.3544@.TK2MSFTNGP03.phx.gbl...
> 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
>