473,399 Members | 4,254 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

problem accessing access 97 database through odbc on windows 2003 sp1

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...;EN-US;Q310804
* http://support.microsoft.com/default...b;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

Nov 13 '05 #1
0 2042

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Fons Dijkstra | last post by:
Hello, I'm using the mx.ODBC.Windows package in order to read/write a MSAccess database. Everything works fine apart from the DATE format handling. I'm using the default "datetimeformat" (i.e....
10
by: David ROBERT | last post by:
Hello, I need to read data from a MS Access database. The program (reader) is installed on a linux box and is written in python langage. The database is MS Access 2002 installed on a Win XP box...
13
by: Wolfgang Kaml | last post by:
Hello All, I have been researching newsgroups and knowledgebase all morning and not found a solution that would solve the problem I have. I am having an ASP or ASPX web page that implement a...
6
by: Mikey G | last post by:
Hi, Here is a shorter code example since the last message I posted got truncated. So the problem is I created a simple VB.NET 2003 application through Visual Studio that connects to a MySQL...
4
by: StefanSerena | last post by:
Hi I'm running Windows 2000 and Office 2003. I want to copy tables from an unknown database format into Access 2.0 and I could do it quite easily if it weren't for the fact that recent...
2
by: Frank Millman | last post by:
Hi all I have found a problem using MS Sql Server connecting via the odbc module from python-win32. I am liaising with Mark Hammond, and he is trying to help, but he is very busy, and I...
6
by: SEFL | last post by:
Hi there, I'm trying to write a VBS that accesses a local database on my system (personal project). I'm running Windows XP 64-bit with Access XP. Every time I try to access the database on...
13
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
0
by: raylopez99 | last post by:
10 years ago, the below was written (see very end, after my signature RL). What, if anything, has changed? I have Access 2003 and soon Access 2007 on a Windows XP Professional or Windows...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.