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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-28 : 11:50:08
|
Nilav writes "I've created a connection string as described in the 'sql books online':
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=sqloledb;Persist Security Info=False;User ID=userid;PWD=password;Initial Catalog=CBI_scad;Initial File Name=c:\mssql7\Data\CBI_Scad_Data.mdf;"
it seems to be correct, but I get this error:
ADODB.Connection error ' 800a0e7a'
ADO could not find the specified provider.
/test/connectsa.asp, line 10
so what? The 'sqloledb' provider has not been installed by the sql server 7 installation ?
could anybody help me please?
Thanks,
Nilav" |
|
|
|
|
|
sqloledb connection