Jump to content

Problem connecting classic asp to SQLserver 2008 express via IIS7 on win7 64bit


alextf

Recommended Posts

Problem connecting a classic asp project to SQLserver 2008 express with this query strings:conn = "Driver={SQL Server Native Client 10.0}; Server=.\SQLEXPRESS; Database= database; Trusted_Connection=yes"conn = "Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=database;UserID=sa;Password=123"conn = "Driver={SQL Server}; Server=.\SQLEXPRESS; Initial Catalog= database;Integrated Security=True;Network Library =dbmssocn"conn = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=database;Data Source=(local);"_______________________RETURNED ERROR:Classic ASP return this error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied._______________________SQL Server: Authentication: SQL Server and windows authentication modeI’m using IIS7 in a win 64bitDo I need a DB user and password in sql DB and querystring? is the iis7? win7 64bit?______________________Note: VB.NET can access with this conn String: "Data Source=.\SQLEXPRESS;Initial Catalog=nData;Integrated Security=True"Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...