Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2008-06-10 : 15:26:58
|
| We are migrating an old classic ASP application from a SQL Server 2000 back end to a SQL 2005 back end. The below connection does not work after pointing to the new SQL 2005. It works just fine when pointing to a SQL 2000 db. Did the connection string change for 2005?The UID defined in the connection string has admin rights for the database. Any help would be much appreciated! Thanks<%'A Standard connection for MIS report users, called by'all MIS Web reportsset cn=server.createobject("ADODB.Connection")cn.provider = "sqloledb"provstr = "server=CustbSvr;Database=MibBillSysProd;UID=MISRPT_User;PWD=MISWEBRPTS;"cn.open ProvStr%> |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Problems connecting to SQL 2005 using ASP