Unix Technical Forum

Problems with a JET-ODBC-Connection and Access97-Runtime

This is a discussion on Problems with a JET-ODBC-Connection and Access97-Runtime within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have a very strange problem with a JET-ODBC-Connection. Using Access97-Runtime, we connect the table with a DSN-less-ODBC-Connection to ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 10:01 PM
Andreas Lauffer
 
Posts: n/a
Default Problems with a JET-ODBC-Connection and Access97-Runtime

I have a very strange problem with a JET-ODBC-Connection.
Using Access97-Runtime, we connect the table with a
DSN-less-ODBC-Connection to SQLServer 2000 SP3.
The Application runs on a Windows Server 2003 Terminal-Server with
CITRIX Metaframe.
Office 2003 is also installed (no Access2003)
And now the problem:
-------------------------------------------------------
When our application is installed anew, the ODBC-Connection works fine.
When I start any Office2003-Application like Winword, the system files
MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
Suite to check this issue).
Afterwards, our Application doesn't run anymore, the Application quits
without any error.
If I copy the MSJINT35.DLL anew from the install-directory, our
application runs again correctly.
The strange thing is, that the "changed" MSJINT35.DLL is exactly the
same as the original file. Version, Metadata, Language, Filesize, and
even a Hex-based-compare result that the files are identically.
Nevertheless, a copy of the file into system32 is a workaround to fix
the problem for a few hours.
---------------------------------------------------------
Does anyone has any idea? PLEASE HELP!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 10:01 PM
Ron Hinds
 
Posts: n/a
Default Re: Problems with a JET-ODBC-Connection and Access97-Runtime

How are you installing the app? I use Wise Install Builder, which installs
the Access 97 runtime into it's own folder - C:\Program Files\Access 97
Runtime. It installs the DLLs in question into that folder, too. The reason
being - when an app looks for DLL's it starts with the folder the app
started in, then looks in the folders in the PATH environment variable (e.g.
System32). You could probably solve your problem by having your installer
put the DLLs in question into the Runtime folder.

"Andreas Lauffer" <alweb01@online.de> wrote in message
news:1132133394.166634.268470@z14g2000cwz.googlegr oups.com...
> I have a very strange problem with a JET-ODBC-Connection.
> Using Access97-Runtime, we connect the table with a
> DSN-less-ODBC-Connection to SQLServer 2000 SP3.
> The Application runs on a Windows Server 2003 Terminal-Server with
> CITRIX Metaframe.
> Office 2003 is also installed (no Access2003)
> And now the problem:
> -------------------------------------------------------
> When our application is installed anew, the ODBC-Connection works fine.
> When I start any Office2003-Application like Winword, the system files
> MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
> Suite to check this issue).
> Afterwards, our Application doesn't run anymore, the Application quits
> without any error.
> If I copy the MSJINT35.DLL anew from the install-directory, our
> application runs again correctly.
> The strange thing is, that the "changed" MSJINT35.DLL is exactly the
> same as the original file. Version, Metadata, Language, Filesize, and
> even a Hex-based-compare result that the files are identically.
> Nevertheless, a copy of the file into system32 is a workaround to fix
> the problem for a few hours.
> ---------------------------------------------------------
> Does anyone has any idea? PLEASE HELP!
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com