打开两个带密码的数据库出错了

[xlp_007]

<%
Set conn = Server.CreateObject("ADODB.Connection")
dbpath="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\data\ProDone1.dll;User ID='admin';Password=;Jet OLEDB:Database Password='123'"
conn.Open dbpath
Set conn = Server.CreateObject("ADODB.Connection")
dbpath1="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\data\ProDone.dll;User ID='admin';Password=;Jet OLEDB:Database Password='123'"
conn.Open dbpath1
conn.execute"insert into [;database=F:\data\ProDone.dll].Products select * from([;database=F:\data\ProDone1.dll].Products)"
conn.close
set conn=nothing
%>
提示我密码无效,测试后应该是两个库同时打开的问题,望大虾们解决一下.

[xlp_007]

上去让大家帮忙解决.

[wwwwb]

conn.execute"insert into [;database=F:\data\ProDone.dll;pwd=123].Products select * from([;database=F:\data\ProDone1.dll;pwd=123].Products)"

[changechange]

不需要用两个 CONNECTION ，随便用哪个然后直接执行 SQL 语句

如果还提示密码无效表明你的密码错了


Set conn = Server.CreateObject("ADODB.Connection")
dbpath="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\data\ProDone1.dll;User ID='admin';Password=;Jet OLEDB:Database Password='123'"
conn.Open dbpath
conn.execute "insert into [;database=F:\data\ProDone.dll;pwd=123].Products select * from([;database=F:\data\ProDone1.dll;pwd=123].Products)"

[xlp_007]

问题解决,谢谢两位热心的**牛人,呵呵~~~