ADo connection not made

Results 1 to 2 of 2

Thread: ADo connection not made

  1. #1
    ASHU Guest

    Default ADo connection not made

    for this ASP script I am getting the following [problem<BR><BR>&#060;%<BR>SET dataconn = server.createobject("adodb.connection")<BR> &#039 tried system dsn and file dsn<BR> &#039 st="systemDSN" <BR> &#039 st="FILE NAME=C:TestASPadoa.dsn;"<BR> &#039 dataconn.connectionstring="DSN=somename"<BR> st="pubss"<BR> dataconn.open st,"username","password"<BR>%&#062;<BR><BR>ERROR &#062;&#062;<BR><BR>ADODB.Connection error &#039 800a0e7a&#039 <BR><BR>ADO could not find the specified provider. <BR><BR>/asp/access.asp, line 9 <BR>

  2. #2
    keithadler@hotmail.com Guest

    Default RE: ADo connection not made

    The problem is you&#039re not build a propert connection string. You don&#039t want to necessarily use a DSN to connect to an access database or even a SQL Server. Look into provider strings. You can generate them and copy/paste them into your ASP code using the data environment in Visual BASIC or Visual Interdev.

Posting Permissions

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