sql connection

Results 1 to 2 of 2

Thread: sql connection

  1. #1
    Nilav Guest

    Default sql connection

    I&#039ve created a connection string as described in the &#039sql books online&#039: <BR>Set Conn = Server.CreateObject("ADODB.Connection") <BR>Conn.Open "Provider=sqloledb;Persist Security Info=False;User ID=userid;PWD=password;Initial Catalog=CBI_scad;Initial File Name=c:mssql7DataCBI_Scad_Data.mdf;" <BR><BR>it seems to be correct, but I get this error: <BR><BR>ADODB.Connection error &#039 800a0e7a&#039 <BR>ADO could not find the specified provider. <BR>/test/connectsa.asp, line 10 <BR><BR>so what? The &#039sqloledb&#039 provider has not been installed by the sql server 7 installation ? <BR>could anybody help me please? <BR><BR>Thanks, <BR><BR>Nilav

  2. #2
    Join Date
    Dec 1969

    Default RE: sql connection

    generally in ASP a SQLOLEDB string looks more like this<BR><BR>"provider=SQLOLEDB;server=OMALLY;datab ase=Interactive;uid=****;pwd=*****"<BR><BR>try that (accessing by server name)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts