problem accessing access 97 database through odbc on windows 2003 sp1

[vginders]

Hello,


We have a legacy application which relies on an Access 97 database
(upgrading is nog an option atm). As we are setting up a new server
(Windows 2003), we started experiencing problems running that
application after installing all required updates (Windows, Office, ..)
It did work before updating, with a basic OS + application
installation. Somewhere an update dit break things, but we do not know
which one.

Now for the problem. When starting the application, following error is
returned:

---------------------------
ODBC Microsoft Access Driver Login Failed
---------------------------
Cannot open a database created with a previous version of your
application.
---------------------------
OK Cancel
---------------------------

OK let's you choose another mdb (not an option) and CANCEL fails the
app, which is the problem

Current versions:
* JET version: 4.0.6305.00 - not sure which this is, it's more recent
than JET 4 SP8 which is the lates I can download separately.
* Office 2000 SR1 with latest updates
* MDAC 2.8 SP2 ON WINDOWS SERVER 2003 SP1 (2.82)(ComponentChecker 2.0)

What we tried so far, to no good:
* http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q310804
* http://support.microsoft.com/default.aspx?scid=kb;EN-US;310937
* downgrading MDAC, which is seems useless (has no effects on file
versions + no relation to odbc?)
* downgrading JET 4 (by manually replacing odbcjt32.dll in system32 and
system32/dllcache)
* Googled to death on the matter, but no others solutions were brought
up.

Hopefully someone can help us out, we're migrating to Windows 2003
Terminal services, and this application is mission-critical.

thx,

Serge

 

[Wayne Morgan]

Access 97 uses Jet 3.51, not Jet 4. Have you installed SP3 for Jet 3.51?
Since this is running in Terminal Services, you'll need the Jet 3.51 files
on the server. I just took a look at mine and it doesn't have the Jet 3.51
files installed by default. If you're not sharing the file with Office 97
users, you may want to use Office 2000 to upgrade the file to the 2000
format. Before you do, install SP3 for Office 2000, it will help avoid a
very nasty bug that occurs when you bring an object with code into the file
and don't compile the code before closing the file.

To get the Jet 3.51 files on the server, you'll need to download the older
Jet and MDAC files. A good place to start looking for these is
http://msdn.microsoft.com/data/downloads/updates/default.aspx. However,
before installing these files, I would check with the folks in the 2003
Server newsgroups to see if there are any problems you may encounter by
installing these.

 

[Rick Brandt]

Hello,


We have a legacy application which relies on an Access 97 database
(upgrading is nog an option atm). As we are setting up a new server
(Windows 2003), we started experiencing problems running that
application after installing all required updates (Windows, Office,
..) It did work before updating, with a basic OS + application
installation. Somewhere an update dit break things, but we do not know
which one.

Now for the problem. When starting the application, following error is
returned:

---------------------------
ODBC Microsoft Access Driver Login Failed
---------------------------
Cannot open a database created with a previous version of your
application.
---------------------------
OK Cancel
---------------------------

OK let's you choose another mdb (not an option) and CANCEL fails the
app, which is the problem

Current versions:
* JET version: 4.0.6305.00 - not sure which this is, it's more recent
than JET 4 SP8 which is the lates I can download separately.
* Office 2000 SR1 with latest updates
* MDAC 2.8 SP2 ON WINDOWS SERVER 2003 SP1 (2.82)(ComponentChecker 2.0)

Access used Jet 3.51, not Jet 4. It appears that this is the cause of your
error.

 

[vginders]

Thank you for your reply.

I installed the 3.51 files (Jet35sp3.exe) but there seems not to be an
odbcjt32.dll incorporated in that service pack, so I still only have
JET 4 drivers for Access odbc.

In the meantime I'm escalating this problem in
microsoft.public.windows.server.general as you suggested.

Serge

 

[Wayne Morgan]

To get all of the Jet 3.5 files installed properly, you may need to install
Access 97 on the server then uninstall it. Also, the newest MDAC versions
may not have the Jet 3.51 ODBC driver, you may have to download an older
version, but I suspect it would be installed with Access 97.