[AccessD] Windows-7 (64 Bit) ODBC Driver Issue

John,

Sure.

This was our first new PC with Windows-7 64 Bit.

I installed the same Firebird Database driver that is currently being
used on about 15 other PCs (all 32 bit).

When I tried to do the ODBC DSN setup (Control Panel / Admin Tools /
Data Source)
on the new PC, I could not see the Firebird driver.

With the feedback that was posted here on AccessD, I took a look at this
webpage 
http://support.microsoft.com/kb/942976


Embedded on the pages on this website, is this sentence  
 
"The 32-bit version of the Odbcad32.exe file is located in the
%systemdrive%\Windows\SysWoW64 folder."


Instead of going through the normal process to set up the ODBC DSN, I
found Odbcad32.exe in %systemdrive%\Windows\SysWoW64 folder.  I fired up
this exe and was then able to see the Firebird Driver.  The setup then
worked nicely.

I hope that this info is useful.

Brad 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, June 28, 2012 2:20 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue

Care to share what it was in the end?

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it


On 6/28/2012 2:44 PM, Brad Marks wrote:
> John, Lawrence, Jim,
>
> Thanks for the help with this issue.
>
> With your assistance, I was able to get things working last night.
>
> I really appreciate the advice and insights.
>
> Brad
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
> Sent: Wednesday, June 27, 2012 6:12 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue
>
> You need to make sure you use the correct ODBC Admin program (one in
> %systemdrive%\Windows\SysWoW64 folder).  Also make it a system DSN.
See
> the
> following MSKB article:
>
> http://support.microsoft.com/kb/942976
>
> Finially, if your trying to use 32 bit Access with other Office apps
and
> they are 64 bit, that won't fly.  Everything has to be one or the
other.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Wednesday, June 27, 2012 04:06 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue
>
> John,
>
> Thanks for the help.
>
> The new PC has Windows-7 (64 bit), but Access is 32 bit.
>
> It sounds like the 32 Bit ODBC Driver should work.
>
> When I try to set up ODBC and test the connection, the test fails.
>
> Really puzzled.
>
> Brad
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Wednesday, June 27, 2012 1:50 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue
>
>   > Do we need a 64-bit ODBC driver because we have Windows-7 (64
bit),
> even though we are running
> Access 2010 (32-bit).
>
> No, 64 bit drivers don't work with Office x32.
>
> It sounds like maybe the Access installed on that system is X64 and
you
> are trying to use an X32 driver.
>
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
>
> On 6/27/2012 2:19 PM, Brad Marks wrote:
>> All,
>>
>> We have an Access 2010 (32 bit) application that uses ODBC to access
>> data in a Firebird database.
>>
>> This is currently working nicely on a number of PCs that are running
>> Windows XP or Windows-7 32 bit.
>>
>> Today, a new computer arrived which has Windows-7 64 bit.
>> The Firebird Database ODBC Driver that we have been using is 32 bit.
> We
>> cannot get it to work.
>>
>> I am confused.
>>
>> Do we need a 64-bit ODBC driver because we have Windows-7 (64 bit),
> even
>> though we are running Access 2010 (32-bit).
>>
>> Will a 64-bit ODBC driver work with Access 2010 (32 bit)?
>>
>> Thanks for your help,
>>
>> Brad
>>
>
>


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.