Click to See Complete Forum and Search --> : ADODC


December 14th, 1999, 01:03 PM
I am trying to connect Database file on web ( DSN-Less ) by using ADO data control
following coding : -

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