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
>