tags:

views:

16

answers:

1
Q: 

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

Hi,

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 server. 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;")

Please help!

related questions

asp consuming a web service, what do do with recordset object ?
How exactly do you configure httpOnly Cookies in ASP Classic?
Replace huge Case statement in Classic ASP
How do the CakePHP and codeigniter frameworks compare to the ASP.NET MVC framework?
Why do I get this error "[DBNETLIB][ConnectionRead (recv()).]General network error" with ASP pages
ASPSmartUpload v3.2
Are there benefits to Classic ASP over ASP.net
Why continue writing legacy systems?
Remote Debugging Server Side of a Web Application with Visual Studio 2008
Migrating from ASP Classic to .NET and pain mitigation
VBScript/ASP Classic
What is this 'Multiple-step OLE DB' error?
Code Classic ASP in Linux
How do I secure a folder used to let users upload files?
ASP/VBScript - Int() vs CInt()
What's the best way to manage a classic asp front-end using Visual Studio 2008?
Calling ASP.NET web service from ASP using SOAPClient
IIS 6/COM+ hangs
Select Query on 2 tables, on different database servers
Calling REST web services from a classic asp page
How to run remote shell scripts from ASP pages?
What is the IDE for classic ASP and VBScript?
Using ConfigurationManager to load config from an arbitrary location
What is the best way to iterate through an array in Classic Asp VBScript?
How do I build a collection in classic ASP?