Skip navigation
treehuggerinny
Currently Being Moderated

Unidentified error when testing recordset, help please!

May 5, 2011 3:32 PM

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!!!

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points