[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
>>
>
>