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

For servers, I've had to create the DSN via:
C:\Windows\SysWOW64\odbcad32.exe. I've had to use it to create
connections to SQL from Access.

You might want to check to see if you have that file on your system.

Larry Mrazek
lmrazek at lcm-res.com

On Wed, Jun 27, 2012 at 3:05 PM, Brad Marks <BradM at blackforestltd.com> wrote:
>
> 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.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com