ASP中的javascript错误 [英] error with javascript in ASP
问题描述
也许不是正确的新闻组，但这是一个ASP问题，所以..
这个ASP文件适用于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 。打开sql，objdc，3，$
rs.movefirst
da = rs.Fields（" dag" ;）。价值
aanu = rs.Fields（" aantalu"）。价值
....
％>
但是如何在Javascript中翻译呢？我尝试了这个但是错误：
Microsoft OLE DB Provider for ODBC Drivers（0x80004005）
[Microsoft] [ODBC Microsoft Access Driver]一般错误无法打开
注册表项''临时（易失性）Jet DSN用于进程0x4a8线程0x6e8
DBC 0x227335c Jet''。
/ respen / newres / testj。 asp，第4行
<％@ language = javascript％>
<％
var objdc =服务器。 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"）。值
aanu = rs.Fields（" aantalu"）。值
％>
Tha nks
Andre
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
推荐答案
andre写道：
andre wrote:
也许不是正确的新闻组，但它是一个ASP问题，所以..
这个ASP文件与vbscript一起工作正常b> ：
<％
设置objdc = Server.CreateObject（" ADODB.Connection"）
objdc.Open（" provider = msdasql; driver = {microsoft access driver（* .mdb）};
dbq = d：\access\\\
ewres.mdb"）
sql =" select dag，aantalu from daguur;"
set rs = Server.CreateObject（" ADODB.Recordset"）
rs.Open sql，objdc，3
rec = rs.recordcount
rs.movefirst
da = rs.Fields（" dag"）。值
aanu = rs.Fields（" aantalu"）。值
...
％>
但是如何在Javascript中翻译这个？我试过这个但是错误：
Microsoft OLE DB Provider for ODBC Drivers（0x80004005）
[Microsoft] [ODBC Microsoft Access Driver]一般错误无法打开
注册表项''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"）
您正在将字符串参数传递给Open，这是无稽之谈，你只需要
rs.Open（sql，objdc，3,3）;
rec = rs.recordcount
rs.movefirst
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")
You are passing a string argument to Open which is nonsense, you simply need
rs.Open(sql, objdc, 3, 3);
rec=rs.recordcount
rs.movefirst
制作
rs.movefirst（）;
，也许你甚至需要不同的套管
-
Martin Honnen
http://JavaScript.FAQTs.com/
Make that
rs.movefirst();
where maybe you even need different casing
--
Martin Honnen
http://JavaScript.FAQTs.com/
andre写道：
也许不是正确的新闻组，但这是一个ASP问题，所以..
这个ASP文件工作正常vbscript ：
<％
设置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，
rec = rs.recordcount
rs.movefirst
da = rs.Fields（" dag"）。值
aanu = rs.Fields（aantalu）。值
...
％>
但是如何在Javascript中翻译它？我尝试了这个但是错误：用于ODBC驱动程序的Microsoft OLE DB提供程序（0x80004005）
[Microsoft] [ODBC Microsoft Access驱动程序]一般错误无法打开
注册表项''临时（ volatile DSN for process 0x4a8 Thread
0x6e8 DBC 0x227335c Jet''。
/respen/newres/testj.asp,line 4
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
Martin在你的rs.open行中处理了这个问题，但是这不是
解决这个问题，这是由你使用msdasql提供程序引起的
而不是本机Jet OLEDB提供商。您的连接字符串应为：
" provider = Microsoft.Jet.OLEDB.4.0;数据源= d：\ access \ newres.mdb"
如果您认为确实需要使用已弃用的msdasql提供程序来解决某些原因，然后查看这篇文章：
http：// www。 aspfaq.com/show.asp?id=2009
应该引导您阅读这篇知识库文章：
http://support.microsoft.com/?kbid=315456
HTH，
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复，请删除
没有垃圾邮件
Martin dealt with the problem in your rs.open line, but that does not
address this problem which is caused by your use of the msdasql provider
instead of the native Jet OLEDB provider. Your connection string should be:
"provider=Microsoft.Jet.OLEDB.4.0; Data Source =d:\access\newres.mdb"
If you think you really need to use the deprecated msdasql provider for some
reason, then check out this article:
http://www.aspfaq.com/show.asp?id=2009
which should lead you to this KB article:
http://support.microsoft.com/?kbid=315456
HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
感谢您的回复。
我改变了两件事，但现在我得到了：
Microsoft JET数据库引擎（0x80004005）
不是有效的文件名。
/ respen /newres/testj.asp，第4行
我去了你引用的网站，但找不到那个错误。
这适用于VB，也许javascript的语法是错误的？
再次感谢
Andre
" Bob Barrows [MVP] " <再****** @ NOyahoo.SPAMcom>在留言中写道
新闻：％2 **************** @ TK2MSFTNGP12.phx.gbl ...
Thanks both for replying.
I change both things but now i get:
Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/respen/newres/testj.asp, line 4
I went to the site you referenced, but could not find that error.
This works with VB, maybe the syntax is somewhere wrong for javascript?
Thanks again
Andre
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
andre写道：
也许不是正确的新闻组，但这是一个ASP问题，所以..
这个ASP文件工作正常使用vbscript ：
<％
设置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
rec = rs.recordcount
rs.movefirst
da = rs.Fields（dag）。值
aanu = rs.Fields（" aantalu"）。值
...
％>
但是如何用Javascript翻译这个？我尝试了这个但是错误：用于ODBC驱动程序的Microsoft OLE DB提供程序（0x80004005）
[Microsoft] [ODBC Microsoft Access驱动程序]一般错误无法打开
注册表项''临时（ volatile）Jet DSN for process 0x4a8 Thread
0x6e8 DBC 0x227335c Jet''。
/respen/newres/testj.asp,line 4
Martin处理你的问题.open line，但是这并没有解决由于你使用msdasql提供程序而不是本机Jet OLEDB提供程序而导致的这个问题。您的连接字符串应该
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
Martin dealt with the problem in your rs.open line, but that does not
address this problem which is caused by your use of the msdasql provider
instead of the native Jet OLEDB provider. Your connection string should
be：
" provider = Microsoft.Jet.OLEDB.4.0;数据源= d：\ access \ newres.mdb"
如果您认为确实需要使用已弃用的msdasql提供程序，请查看以下内容：b br /> http://www.aspfaq.com/show.asp？ id = 2009
这将引导您阅读这篇知识库文章：
http://support.microsoft.com/?kbid=315456
HTH，
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我不经常检查它。如果您必须离线回复，请删除
NO SPAM
be:
"provider=Microsoft.Jet.OLEDB.4.0; Data Source =d:\access\newres.mdb"
If you think you really need to use the deprecated msdasql provider for
some reason, then check out this article:
http://www.aspfaq.com/show.asp?id=2009
which should lead you to this KB article:
http://support.microsoft.com/?kbid=315456
HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
这篇关于ASP中的javascript错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
