[THIN] Re: Microsoft Jet database engine error on Windows 2008

  • From: Angela <angela_smith9@xxxxxxxxxxx>
  • To: "thin@xxxxxxxxxxxxx" <thin@xxxxxxxxxxxxx>
  • Date: Wed, 8 Jan 2014 14:51:49 +1100

Hi Ben

Yes I'm using the 32 bit ODBC application.  The App wont allow the user to 
login if the ODBC connection is wrong.  This is definitely OK.  Thanks for the 
email though..

Ang

> From: Ben.Pelzer@xxxxxxxxxxx
> To: thin@xxxxxxxxxxxxx
> Date: Tue, 7 Jan 2014 12:10:18 +0100
> Subject: [THIN] Re: Microsoft Jet database engine error on Windows 2008
> 
> Hi Angela,
> 
> You mentioned ODBC connections
> Have you checked that your application is using the 32bit ones?
> On a 64bit system you have 2 ODBC connection ²possibilities²: 32bit and
> 64bit
> 
> 64bit:
> c:\Windows\System32\odbcad32.exe (!)
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
> 
> 32bit:
> c:\Windows\Syswow64\odbcad32.exe (!)
> HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC
> 
> The odbcad32.exe really are switched, so watch out for that!
> 
> Cheers,
> Ben
> 
> On 07-01-2014 11:53, "thin-digest@xxxxxxxxxxxxx"
> <thin-digest@xxxxxxxxxxxxx> wrote:
> 
> >
> > ------------------------------------
> >thin Digest    Tue, 07 Jan 2014        Volume: 12  Issue: 204
> >
> >In This Issue:
> >       #1:     From: Angela <angela_smith9@xxxxxxxxxxx>
> >               Subject: [THIN] Microsoft Jet database engine error on 
> > Windows 2008
> >
> >----------------------------------------------------------------------
> >
> >Msg: #1 in digest
> >From: Angela <angela_smith9@xxxxxxxxxxx>
> >Subject: [THIN] Microsoft Jet database engine error on Windows 2008
> >Date: Tue, 7 Jan 2014 21:53:36 +1100
> >
> >Hi
> >
> >
> >I have a internally built MS Access based front end application that
> >hooks into a
> >SQL Server backend.  The client works fine from Windows 2003 32 bit
> >Citrix system.  Im trying to get the App to run from a 64 bit Windows 2008
> >R2 Citrix Server.  I can login to the DB but get the following error:
> >
> >
> >
> >Microsoft Office Access
> >
> >The Microsoft Jet database engine cannot open the file xxxxxx.  It is
> >already opened exclusively by another user, or you need permission to
> >view its
> >data.
> >
> >
> >
> >Detailed information:
> >
> >1. The database front end is based on Microsoft Access 2003. MS Access
> >2003 is currently running on a Windows 2003
> >32 bit Citrix server and it works fine which rules out any folder ACL
> >issue
> >
> >2. The database back-end is running on
> >Windows 2008 SQL Server
> >
> >3. The MDB file resides on a central network location
> >
> >4. The only thing required in the past to get the Application to work is
> >to
> >create a ODBC SQL connection and install MS Access 2003 on Citrix Server
> >
> >5. User access is fine as the Application works on the old 32 bit Citrix
> >system
> >
> >6. IIS is not installed nor is it needed
> >
> >7. Not a locking issue as I have up to 20 users accessing the DB from the
> >old
> >Citrix system at any one time.  Application only fails on Windows 2008 64
> >bit system
> >
> >
> >
> >The new OS system is Windows 2008 R2 64 bit but the version of MS Access
> >2003
> >installed in 32 bit.  Has anyone seen a similar issues?
> >
> >Thanks
> >Ang
> >
> >
> >------------------------------
> >
> >End of thin Digest V12 #204
> >***************************
> >************************************************
> >For Archives, RSS, to Unsubscribe, Subscribe or
> >set Digest or Vacation mode use the below link:
> >//www.freelists.org/list/thin
> >************************************************
> 
> 
> 
> Met vriendelijke groet,
> 
> drs. Ben Pelzer
> Senior Consultant
> 
> E-mail: Ben.Pelzer@xxxxxxxxxxx
> 
> Amerikalaan 90 - 6199 AE  Maastricht-Airport
> Tel: +31 43 850 7000
> Fax: +31 43 352 1718
> Internet: www.openline.nl
> 
> 
> ��+r�z�RJ��˛���m�n�+����ǭ(��+U��*'��^�ǭ��ޖ�%�y!���0~���+-����X���a�
                                          

Other related posts: