ricarditopicaron
asked on
I can't get to work ADO with an Access 97 Database in a Windows 98
In my Windows 2000 Server works just fine. The database and the program are installed in the Windows 98. I already tried installing MDAC_TYP.EXE (the last one) and creating ADO objects with CreateObject and I'm using SP5 in the compiler. Also tried installing Access.
The error raises when I try to open the connection:
"Provider cannot be found"
ConnectionString: cn.ConnectionString = "Provider=Microsoft.Jet.OL EDB.3.51;" & _
"Persist Security Info=False;Data Source=" & _
"base.mdb"
Instructions to make ODBC entries and code to use them are accepted as an answer.
The error raises when I try to open the connection:
"Provider cannot be found"
ConnectionString: cn.ConnectionString = "Provider=Microsoft.Jet.OL
"Persist Security Info=False;Data Source=" & _
"base.mdb"
Instructions to make ODBC entries and code to use them are accepted as an answer.
Provider=Microsoft.Jet.OLE DB.3.51 refers to the DAO engine.
Provider=Microsoft.Jet.OLE DB.4.0 refers to the ADO engnie.
Provider=Microsoft.Jet.OLE
replace "Provider=Microsoft.Jet.OL EDB.3.51;" with "Provider=Microsoft.Jet.OL EDB.4.0;"
ASKER
Jet 4.0 doesn't work in server (3.51 does)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jet SPack does not work either, also ole db SPack doesn't too
(After the provider error I get an oledb error)
(After the provider error I get an oledb error)
As of MDAC 2.5, the JET stack is no longer installed as part of the MDAC installation.
In order to access a JET database (Access), you need the JET stack.
JET can be installed by installing an older version of MDAC - try MDAC 2.12 GA, then 2.5 SP1.
Once these have bene installed, try JET40SP3 and see if that helps.
These must all be installed on the target PC.
I've developed several projects that use JET and ADO, and I've always installed ALL the versions of MDAC and then JET40SP3 and have had no problems.
HTH,
Alon
In order to access a JET database (Access), you need the JET stack.
JET can be installed by installing an older version of MDAC - try MDAC 2.12 GA, then 2.5 SP1.
Once these have bene installed, try JET40SP3 and see if that helps.
These must all be installed on the target PC.
I've developed several projects that use JET and ADO, and I've always installed ALL the versions of MDAC and then JET40SP3 and have had no problems.
HTH,
Alon
Hi
why not create a ODBC name and try to connect like this
Go to control panel,Double click ODBC(System DSN)
Add (Select Microsoft Access Driver(*.mdb)
Press [Finish]
Data Source Name=Base
Description=Connection to Base Database
press select(where your database/location)
example:- [c:\test\base.mdb]
Odbc creation is completed
below code for connection
first you have to add a refrence
project->references->Micro soft ActiveX Data Objects 2.5 Library (tick the check box and press Ok)
Create a comand button or call form_load
dataconnection
public sub dataconnection()
dim cstring as string
dim sql as string
dim oconn as ADODB.connection
dim adors as ADODB.Recordset
On Error GoTo Errconnect
cstring = "Data Source=base;User Id=;Password=;"
Set oconn = New ADODB.Connection
oconn.Open sconnection
Set adors = New ADODB.Recordset
adors.CursorType = adOpenKeyset
adors.LockType = adLockBatchOptimistic
sql="Select * from(Table name)"
adors.Open sql, oconn, , , adCmdText
end sub()
have a try please
H
why not create a ODBC name and try to connect like this
Go to control panel,Double click ODBC(System DSN)
Add (Select Microsoft Access Driver(*.mdb)
Press [Finish]
Data Source Name=Base
Description=Connection to Base Database
press select(where your database/location)
example:- [c:\test\base.mdb]
Odbc creation is completed
below code for connection
first you have to add a refrence
project->references->Micro
Create a comand button or call form_load
dataconnection
public sub dataconnection()
dim cstring as string
dim sql as string
dim oconn as ADODB.connection
dim adors as ADODB.Recordset
On Error GoTo Errconnect
cstring = "Data Source=base;User Id=;Password=;"
Set oconn = New ADODB.Connection
oconn.Open sconnection
Set adors = New ADODB.Recordset
adors.CursorType = adOpenKeyset
adors.LockType = adLockBatchOptimistic
sql="Select * from(Table name)"
adors.Open sql, oconn, , , adCmdText
end sub()
have a try please
H
Hi
forgot to add
Please add this line of code before end sub
exit sub
Errconnect:
msgbox "Error" & err.number & err.description
try this
H
forgot to add
Please add this line of code before end sub
exit sub
Errconnect:
msgbox "Error" & err.number & err.description
try this
H
You surely do something wrong. It is suppose to work since a long time. Have a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q271908.
Also, you can use the Component checker to check the state of your installation: http://www.microsoft.com/data/download.htm#CCinfo
>>(After the provider error I get an oledb error)
Which error?
Also, you can use the Component checker to check the state of your installation: http://www.microsoft.com/data/download.htm#CCinfo
>>(After the provider error I get an oledb error)
Which error?
ASKER
I tried SP3 also but didn't work (emoreau)
Can re-state what is working and where (you are talking about 98 and 2000)?
ASKER
I installed every MDAC_TYP i found here:
http://www.microsoft.com/data/download.htm#Jet4SP3info and didn't work (AlonHirsch )
http://www.microsoft.com/data/download.htm#Jet4SP3info and didn't work (AlonHirsch )
ASKER
Don't try any more!!!!! I solved it!!!!!
It is someone from here!!!
Wait a few hours and I'll tell you (I've got to know)
It is someone from here!!!
Wait a few hours and I'll tell you (I've got to know)
ASKER
I was prooving with "SELECT Name FROM Subjects WHERE Pass=Null" this works only in Jet 3.51, I realized that in Jet 4.0 I have to write it like this "SELECT Name FROM Subjects WHERE Pass IS NULL". But after Jet 4.0 what really did it work was the Jet xxx SP3
Try updating Jet engine also since there is a matter with 3.6