SPSSX Discussion

ODBC Error In Win7 64 Bit

Classic

List

Threaded

7 messages Options

Bob Walker-2

ODBC Error In Win7 64 Bit

Hi,

I’m running Win7 64-bit and an ODBC string that worked fine in XP generates this error:

>Warning. Command name: GET DATA

>SQLDriverConnect failed :[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

I am looking on the Microsoft site for drivers but no luck thus far.

Regards,

Bob Walker

Surveys & Forecasts, LLC

www.safllc.com

Bob Walker-2

Re: ODBC Error In Win7 64 Bit

A search of both Win7 and SPSS KB’s indicates that Microsoft does not provide a 64-bit ODBC driver for MS Office, so at this time there is no resolution to this problem. So we have a 64-bit OS, and 64-bit SPSS, and no way to import an MS Access database. Amazing…

Regards,

Bob Walker

Surveys & Forecasts, LLC

www.safllc.com

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob Walker
Sent: Wednesday, March 03, 2010 1:45 PM
To: [hidden email]
Subject: ODBC Error In Win7 64 Bit

Hi,

I’m running Win7 64-bit and an ODBC string that worked fine in XP generates this error:

>Warning. Command name: GET DATA

>SQLDriverConnect failed :[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

I am looking on the Microsoft site for drivers but no luck thus far.

Regards,

Bob Walker

Surveys & Forecasts, LLC

www.safllc.com

wsu_wright

Re: ODBC Error In Win7 64 Bit

This seems odd. I'm running both 64 bit Win 7 & SPSS. Win 7 comes equipped with the ODBC drivers for excel, dbase & MS access. The SPSS data pack provides additional drivers. Can you provide both your syntax & the error code?

David

---- Bob Walker <[hidden email]> wrote:

> A search of both Win7 and SPSS KB's indicates that Microsoft does not
> provide a 64-bit ODBC driver for MS Office, so at this time there is no
> resolution to this problem. So we have a 64-bit OS, and 64-bit SPSS, and no
> way to import an MS Access database. Amazing.
>
>
>
> Regards,
>
>
>
> Bob Walker
>
> Surveys & Forecasts, LLC
>
> <http://www.safllc.com> www.safllc.com
>
>
>
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob
> Walker
> Sent: Wednesday, March 03, 2010 1:45 PM
> To: [hidden email]
> Subject: ODBC Error In Win7 64 Bit
>
>
>
> Hi,
>
>
>
> I'm running Win7 64-bit and an ODBC string that worked fine in XP generates
> this error:
>
>
>
> >Warning. Command name: GET DATA
>
> >SQLDriverConnect failed :[Microsoft][ODBC Driver Manager] The specified DSN
> contains an architecture mismatch between the Driver and Application
>
>
>
> I am looking on the Microsoft site for drivers but no luck thus far.
>
>
>
> Regards,
>
>
>
> Bob Walker
>
> Surveys & Forecasts, LLC
>
> www.safllc.com
>
>
>

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Francien Berndsen

Re: ODBC Error In Win7 64 Bit

I was interested in this issue because I import a lot of Access databases
(mostly at work where we use Win XP). At home I use Win 7 64 bit & SPSS 18.
So I tried it at home and I found out I'm not able to import an Access
database...

I used the database wizard, but when I click on MS Access-database I need to
login (?) with a password (?). I can't just click on ok, because then I see
the same error message text as Bob Walker.

So if there is a solution, I'm very very very interested.

Francien

> -----Oorspronkelijk bericht-----
> Van: SPSSX(r) Discussion [mailto:[hidden email]] Namens David
> Wright
> Verzonden: donderdag 4 maart 2010 12:28
> Aan: [hidden email]
> Onderwerp: Re: [SPSSX-L] ODBC Error In Win7 64 Bit
>
> This seems odd. I'm running both 64 bit Win 7 & SPSS. Win 7 comes
> equipped with the ODBC drivers for excel, dbase & MS access. The SPSS
> data pack provides additional drivers. Can you provide both your syntax &
> the error code?
>
> David
>
>
> ---- Bob Walker <[hidden email]> wrote:
> > A search of both Win7 and SPSS KB's indicates that Microsoft does not
> > provide a 64-bit ODBC driver for MS Office, so at this time there is no
> > resolution to this problem. So we have a 64-bit OS, and 64-bit SPSS, and
> no
> > way to import an MS Access database. Amazing.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Bob Walker
> >
> > Surveys & Forecasts, LLC
> >
> > <http://www.safllc.com> www.safllc.com
> >
> >
> >
> > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Bob
> > Walker
> > Sent: Wednesday, March 03, 2010 1:45 PM
> > To: [hidden email]
> > Subject: ODBC Error In Win7 64 Bit
> >
> >
> >
> > Hi,
> >
> >
> >
> > I'm running Win7 64-bit and an ODBC string that worked fine in XP
> generates
> > this error:
> >
> >
> >
> > >Warning. Command name: GET DATA
> >
> > >SQLDriverConnect failed :[Microsoft][ODBC Driver Manager] The specified
> DSN
> > contains an architecture mismatch between the Driver and Application
> >
> >
> >
> > I am looking on the Microsoft site for drivers but no luck thus far.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Bob Walker
> >
> > Surveys & Forecasts, LLC
> >
> > www.safllc.com
> >
> >
> >
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

wsu_wright

Re: ODBC Error In Win7 64 Bit

I believe this may be a Microsoft issue rather than SPSS. I opened the Win 7 64 bt ODBC manager & tried to configure the MS access driver & the OS returned an error message saying the driver needed to be reinstalled. I also tried this on a Win 7 64 bit machine that did not have SPSS installed & the same error message. I then tried the above on an XP (both 32 & 64 bit) machine and had success in opening the MS access driver. So I cannot confirm it, but in just trying to access the MS access driver from the operating system's ODBC manager caused failure independent of SPSS.

David,

---- Francien Berndsen <[hidden email]> wrote:

> I was interested in this issue because I import a lot of Access databases
> (mostly at work where we use Win XP). At home I use Win 7 64 bit & SPSS 18.
> So I tried it at home and I found out I'm not able to import an Access
> database...
>
> I used the database wizard, but when I click on MS Access-database I need to
> login (?) with a password (?). I can't just click on ok, because then I see
> the same error message text as Bob Walker.
>
> So if there is a solution, I'm very very very interested.
>
> Francien
>
> > -----Oorspronkelijk bericht-----
> > Van: SPSSX(r) Discussion [mailto:[hidden email]] Namens David
> > Wright
> > Verzonden: donderdag 4 maart 2010 12:28
> > Aan: [hidden email]
> > Onderwerp: Re: [SPSSX-L] ODBC Error In Win7 64 Bit
> >
> > This seems odd. I'm running both 64 bit Win 7 & SPSS. Win 7 comes
> > equipped with the ODBC drivers for excel, dbase & MS access. The SPSS
> > data pack provides additional drivers. Can you provide both your syntax &
> > the error code?
> >
> > David
> >
> >
> > ---- Bob Walker <[hidden email]> wrote:
> > > A search of both Win7 and SPSS KB's indicates that Microsoft does not
> > > provide a 64-bit ODBC driver for MS Office, so at this time there is no
> > > resolution to this problem. So we have a 64-bit OS, and 64-bit SPSS, and
> > no
> > > way to import an MS Access database. Amazing.
> > >
> > >
> > >
> > > Regards,
> > >
> > >
> > >
> > > Bob Walker
> > >
> > > Surveys & Forecasts, LLC
> > >
> > > <http://www.safllc.com> www.safllc.com
> > >
> > >
> > >
> > > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> > Bob
> > > Walker
> > > Sent: Wednesday, March 03, 2010 1:45 PM
> > > To: [hidden email]
> > > Subject: ODBC Error In Win7 64 Bit
> > >
> > >
> > >
> > > Hi,
> > >
> > >
> > >
> > > I'm running Win7 64-bit and an ODBC string that worked fine in XP
> > generates
> > > this error:
> > >
> > >
> > >
> > > >Warning. Command name: GET DATA
> > >
> > > >SQLDriverConnect failed :[Microsoft][ODBC Driver Manager] The specified
> > DSN
> > > contains an architecture mismatch between the Driver and Application
> > >
> > >
> > >
> > > I am looking on the Microsoft site for drivers but no luck thus far.
> > >
> > >
> > >
> > > Regards,
> > >
> > >
> > >
> > > Bob Walker
> > >
> > > Surveys & Forecasts, LLC
> > >
> > > www.safllc.com
> > >
> > >
> > >
> >
> > =====================
> > To manage your subscription to SPSSX-L, send a message to
> > [hidden email] (not to SPSSX-L), with no body text except the
> > command. To leave the list, send the command
> > SIGNOFF SPSSX-L
> > For a list of commands to manage subscriptions, send the command
> > INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

Francien Berndsen

Re: ODBC Error In Win7 64 Bit

I did a little search today after reading David's anwer.
I read on Microsoft.com that there is a 64-bit ODBC-driver:

---
A 64-bit version of the Microsoft Windows operating system includes the
following versions of the Microsoft Open Database Connectivity (ODBC) Data
Source Administrator tool (Odbcad32.exe):
The 32-bit version of the Odbcad32.exe file is located in the
%systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the
%systemdrive%\Windows\System32 folder.
---

When I open the 64-bit version and configure the Access driver I see the
same error message as David, but the 32-bit version doesn't show an error.
So, might it be possible to use the 32-bit OCDB-driver with SPSS 18 64-bit?

Francien

> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]]
> Verzonden: zaterdag 6 maart 2010 13:27
> Aan: [hidden email]; Francien Berndsen
> Onderwerp: Re: ODBC Error In Win7 64 Bit
>
> I believe this may be a Microsoft issue rather than SPSS. I opened the
> Win 7 64 bt ODBC manager & tried to configure the MS access driver & the
> OS returned an error message saying the driver needed to be reinstalled.
> I also tried this on a Win 7 64 bit machine that did not have SPSS
> installed & the same error message. I then tried the above on an XP (both
> 32 & 64 bit) machine and had success in opening the MS access driver. So
> I cannot confirm it, but in just trying to access the MS access driver
> from the operating system's ODBC manager caused failure independent of
> SPSS.
>
> David,
>
>
>
>
>
>
> ---- Francien Berndsen <[hidden email]> wrote:
> > I was interested in this issue because I import a lot of Access
> databases
> > (mostly at work where we use Win XP). At home I use Win 7 64 bit & SPSS
> 18.
> > So I tried it at home and I found out I'm not able to import an Access
> > database...
> >
> > I used the database wizard, but when I click on MS Access-database I
> need to
> > login (?) with a password (?). I can't just click on ok, because then I
> see
> > the same error message text as Bob Walker.
> >
> > So if there is a solution, I'm very very very interested.
> >
> > Francien
> >
> > > -----Oorspronkelijk bericht-----
> > > Van: SPSSX(r) Discussion [mailto:[hidden email]] Namens
> David
> > > Wright
> > > Verzonden: donderdag 4 maart 2010 12:28
> > > Aan: [hidden email]
> > > Onderwerp: Re: [SPSSX-L] ODBC Error In Win7 64 Bit
> > >
> > > This seems odd. I'm running both 64 bit Win 7 & SPSS. Win 7 comes
> > > equipped with the ODBC drivers for excel, dbase & MS access. The SPSS
> > > data pack provides additional drivers. Can you provide both your
> syntax &
> > > the error code?
> > >
> > > David
> > >
> > >
> > > ---- Bob Walker <[hidden email]> wrote:
> > > > A search of both Win7 and SPSS KB's indicates that Microsoft does
> not
> > > > provide a 64-bit ODBC driver for MS Office, so at this time there is
> no
> > > > resolution to this problem. So we have a 64-bit OS, and 64-bit SPSS,
> and
> > > no
> > > > way to import an MS Access database. Amazing.
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > >
> > > >
> > > > Bob Walker
> > > >
> > > > Surveys & Forecasts, LLC
> > > >
> > > > <http://www.safllc.com> www.safllc.com
> > > >
> > > >
> > > >
> > > > From: SPSSX(r) Discussion [mailto:[hidden email]] On
> Behalf Of
> > > Bob
> > > > Walker
> > > > Sent: Wednesday, March 03, 2010 1:45 PM
> > > > To: [hidden email]
> > > > Subject: ODBC Error In Win7 64 Bit
> > > >
> > > >
> > > >
> > > > Hi,
> > > >
> > > >
> > > >
> > > > I'm running Win7 64-bit and an ODBC string that worked fine in XP
> > > generates
> > > > this error:
> > > >
> > > >
> > > >
> > > > >Warning. Command name: GET DATA
> > > >
> > > > >SQLDriverConnect failed :[Microsoft][ODBC Driver Manager] The
> specified
> > > DSN
> > > > contains an architecture mismatch between the Driver and Application
> > > >
> > > >
> > > >
> > > > I am looking on the Microsoft site for drivers but no luck thus far.
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > >
> > > >
> > > > Bob Walker
> > > >
> > > > Surveys & Forecasts, LLC
> > > >
> > > > www.safllc.com
> > > >
> > > >
> > > >
> > >
> > > =====================
> > > To manage your subscription to SPSSX-L, send a message to
> > > [hidden email] (not to SPSSX-L), with no body text except
> the
> > > command. To leave the list, send the command
> > > SIGNOFF SPSSX-L
> > > For a list of commands to manage subscriptions, send the command
> > > INFO REFCARD
> >
> > =====================
> > To manage your subscription to SPSSX-L, send a message to
> > [hidden email] (not to SPSSX-L), with no body text except the
> > command. To leave the list, send the command
> > SIGNOFF SPSSX-L
> > For a list of commands to manage subscriptions, send the command
> > INFO REFCARD

Francien Berndsen

Re: ODBC Error In Win7 64 Bit

> I usually export the access data to a Dbase IV file, and read that into
> SPSS. Not quite as nice, but it will act as a workaround.
>
> Greg Black

Yes, I know this option. Unfortunately, it's indeed not so nice and it has
limitations (length of variable name).

Francien

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD