Link to home
Start Free TrialLog in
Avatar of zrlittle
zrlittle

asked on

Error 7399 Access from SQL

Trying to create a linked server acces to SQL.... getting an error message Error 7399 OLE DB provider 'Micorsoft.Jet.OLEDB.4.0' reported an error. OLE DB error trace  [OLE/DB provider 'Micorsoft.Jet.OLEDB.4.0'  IDBInitialize::Initialize returned 0x80004005: ].

When Ilook this up in technet it says that this is related to not having the latest version of JET 4.0 but when I check my version is after version 8

Help!!
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image



did you check the version of Microsoft Jet 4.0 (Msjet40.dll) on the database server?
Avatar of zrlittle
zrlittle

ASKER

Yes I did... iThe DB server is a win 2k box that I have rulled all the way up to sp4 update rollup1...

Therefore my version of Jet 4.0 should be fine....
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial