"ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/evalForm.asp, line 45"
where line 45 is the connection string to sql.
Expand|Select|Wrap|Line Numbers
- Set conn = Server.CreateObject("ADODB.Connection")
- Set rs = Server.CreateObject("ADODB.Recordset")
- conn.open "driver={SQL server};server=<servername>;Uid=<username>;Pwd=<password>;Database=<databasename>;"
website built with visual studio on xp sp 3, sql manahement console 32 bit.
server that will host is sql 64 bit. It works fine on the 32 bit. Afte much research online found a few links that suggest "provider={SQLOLEDB};server=<servername>;Uid=<user name>;Pwd=<password>;Database=<databasename>;"
Yet I still receive the same error message.