Connecting from classic ASP app to an instance of SQL server 2008

My classic ASP app is connecting to SQL server 2000 installed on a network server. The current code works:

myConn.Open ("Driver={SQL Server};Server=myNetServ;Database=myDB;UID=myID;PWD=myPWD;Trusted_Connection=No;")

Now my app needs to connect to a named instance "SQL2008" of the SQL server 2008 installed on the same network ser开发者_如何学Pythonver. This code doesn't work:

myConn.Open ("Driver={SQL Server Native Client 10.0};Server=myNetServ\SQL2008;Database=myDB;UID=myID;PWD=myPWD;Trusted_Connection=No;")

you could just build an odbc connection and use that to connect to the instance