December 16th, 1999, 11:39 AM
I am trying to connect Database file on web ( DSN-Less ) by using ADO data control
following coding : -
ADODC1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false
;server=http://???.???.com;uid=???;password=???;Data Source=\cgi-bin\???.MDB
But the error message occur that " ADO could not find the specified provider"
I don't know what is wrong , in ASP file can connect follow code :-
<%
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("/cgi-bin/???.mdb")
Conn.open
SQL = "Select * from Table01"
set RS = Conn.Execute(SQL)
%>
It work that proved ADO connectable but why not work in VB
Thank you for help
following coding : -
ADODC1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false
;server=http://???.???.com;uid=???;password=???;Data Source=\cgi-bin\???.MDB
But the error message occur that " ADO could not find the specified provider"
I don't know what is wrong , in ASP file can connect follow code :-
<%
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("/cgi-bin/???.mdb")
Conn.open
SQL = "Select * from Table01"
set RS = Conn.Execute(SQL)
%>
It work that proved ADO connectable but why not work in VB
Thank you for help