0 Replies Latest reply: May 5, 2011 3:32 PM by treehuggerinny RSS

    Unidentified error when testing recordset, help please!

    treehuggerinny

      Hi,

       

      I have created a dsn and a connection string that test fine on my web host (crystaltech), but I get an unidentified error when I test them on DW CS4. Any thoughts?

       

      This is my connection string:

      "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\inetpub\bnicrossroadsconnections\dbs\members.mdb;"

      which generates this code:

      <%

      ' FileName="Connection_ado_conn_string.htm"

      ' Type="ADO"

      ' DesigntimeType="ADO"

      ' HTTP="true"

      ' Catalog=""

      ' Schema=""

      Dim MM_testConn_STRING

      MM_testConn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\inetpub\bnicrossroadsconnections\dbs\members.mdb;"

      %>

       

      My dsn code is:

      <%

      ' FileName="Connection_odbc_conn_dsn.htm"

      ' Type="ADO"

      ' DesigntimeType="ADO"

      ' HTTP="true"

      ' Catalog=""

      ' Schema=""

      Dim MM_memberconn_STRING

      MM_memberconn_STRING = "dsn=memberdsn;uid=bnixroads;pwd=pass;"

      %>

       

      What am I doing wrong?

       

      Many thanks!!!