error with javascript in ASP

From: andre (hklkl_at_po.nl)
Date: 05/30/04 

Date: Sun, 30 May 2004 12:16:14 +0200

Hi,

Maybe not the right newsgroup, but it's an ASP problem, so ..

This ASP file works fine with VBscript:
<%
set objdc = Server.CreateObject("ADODB.Connection")
objdc.Open("provider=msdasql; driver={microsoft access driver (*.mdb)};
dbq=d:\access\newres.mdb")
sql="select dag, aantalu from daguur;"
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql, objdc, 3, 3
rec=rs.recordcount
rs.movefirst
da=rs.Fields("dag").Value
aanu=rs.Fields("aantalu").Value
...
%>
But how to translate this in Javascript? I tried this but ger the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x4a8 Thread 0x6e8
DBC 0x227335c Jet'.
/respen/newres/testj.asp, line 4

<%@ language=javascript %>
<%
var objdc = Server.CreateObject("ADODB.Connection")
objdc.Open("provider=msdasql; driver={microsoft access driver (*.mdb)};
dbq=d:\access\newres.mdb")
sql="select dag, aantalu from daguur;"
var rs=Server.CreateObject("ADODB.Recordset")
rs.Open("sql, objdc, 3, 3")
rec=rs.recordcount
rs.movefirst
da=rs.Fields("dag").Value
aanu=rs.Fields("aantalu").Value
%>

Thanks
Andre

Relevant Pages

  • odbc in ASP: error with javascript
    ... Maybe not the right newsgroup, but it's an ODBC problem, so .. ... set objdc = Server.CreateObject ... sql="select dag, aantalu from daguur;" ...
    (microsoft.public.data.odbc)
  • ADO doesnt work with javascript
    ... set objdc = Server.CreateObject ... var sql="select dag, aantalu from daguur;" ...
    (microsoft.public.data.ado)
  • Active Server Pages and ADO
    ... ' Create and establish data connection ... Set objDC = Server.CreateObject ... Set objRS = Server.CreateObject ...
    (microsoft.public.data.ado)