DSNless Connection String
I am attempting a DSNless connection to an Access Database. Here is the connection string:
<%
var MM_NCIMHC2_STRING = strConnection = "DBQ=" & server.mappath("\CS\NCIMHC
%>
This resides on an ASP page in the connections folder and is called NCIMHC2.asp
The asp code to connect to the databse using the DSNless sting is as follows:
<!--#include virtual="/CS/Connections/N
<%
var Recordset1 = Server.CreateObject("ADODB
Recordset1.ActiveConnectio
Recordset1.Source = "SELECT * FROM NCIMHC";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
I get the following error:
Microsoft JScript runtime error '800a1391'
'server' is undefined
/CS/Connections/NCIMHC2.as
I assume this has to do with the sever.mappath in the connection string but am unclear as to why. I appreciate your wisdom and wil award accordingly.
<%
var MM_NCIMHC2_STRING = strConnection = "DBQ=" & server.mappath("\CS\NCIMHC
%>
This resides on an ASP page in the connections folder and is called NCIMHC2.asp
The asp code to connect to the databse using the DSNless sting is as follows:
<!--#include virtual="/CS/Connections/N
<%
var Recordset1 = Server.CreateObject("ADODB
Recordset1.ActiveConnectio
Recordset1.Source = "SELECT * FROM NCIMHC";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
I get the following error:
Microsoft JScript runtime error '800a1391'
'server' is undefined
/CS/Connections/NCIMHC2.as
I assume this has to do with the sever.mappath in the connection string but am unclear as to why. I appreciate your wisdom and wil award accordingly.
actually it might be valid i think i read it wrong
sorry
Scott
sorry
Scott
ASKER
Ihave now changed the connection string to :
<%
var MM_NCIMHC2_STRING = "DBQ=" & Server.MapPath("\CS\NCIMHC
%>
And now get the following error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/CS/NCIMHC/Test.asp, line 5
<%
var MM_NCIMHC2_STRING = "DBQ=" & Server.MapPath("\CS\NCIMHC
%>
And now get the following error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/CS/NCIMHC/Test.asp, line 5
A good reference for connection strings:
http://www.connectionstrings.com/
in particular
http://www.connectionstrings.com/?carrier=access
try that as an example
Scott
http://www.connectionstrings.com/
in particular
http://www.connectionstrings.com/?carrier=access
try that as an example
Scott
ASKER
I tried the examples to no avail...
try doing a response.write on MM_NCIMHC2_STRING just to see what is getting set
ASKER
I get a "0". I t must not be getting to the databse. The conection sstring must not be right somehow?
ASKER
I figured it out:
<%
FileName="Connection_ado_c
Type="ADO"
DesigntimeType="ADO"
HTTP="true"
Catalog=""
Schema=""
var MM_NCIMHC_STRING = "Provider=Microsoft.Jet.OL
%>
I am using Javascript so needed to use DSNless connectin with Javascript.
<%
FileName="Connection_ado_c
Type="ADO"
DesigntimeType="ADO"
HTTP="true"
Catalog=""
Schema=""
var MM_NCIMHC_STRING = "Provider=Microsoft.Jet.OL
%>
I am using Javascript so needed to use DSNless connectin with Javascript.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I could be wrong but does server not have to be uppercase ie Server
also this is not a valid string
var MM_NCIMHC2_STRING = strConnection = "DBQ=" & server.mappath("\CS\NCIMHC
Scott