32 bit app on a 64 bit machine ODBC?

[Guest Shootsie]

I have an app that is written in VB 6 and uses an ODBC connection to

connect to a data source. When I run the application on a 64 bit O/S,

it does not connect to the ODBC. I have tried connecting to a 64 bit

ODBC connection (SQLNCLI.DLL), and also connecting to a 32 bit ODBC

connection (SQLSRV32.DLL) on the same machine and in both cases it

does not connect and there is no error message either in the system

logs or in the event logs.

 

Please let me know if you need any more ifnormation.

 

Thanks in advance!

[Guest Shootsie]

Re: 32 bit app on a 64 bit machine ODBC?

 

On Feb 6, 1:29 pm, Shootsie <shoot...@gmail.com> wrote:

> I have an app that is written in VB 6 and uses an ODBC connection to

> connect to a data source.  When I run the application on a 64 bit O/S,

> it does not connect to the ODBC.  I have tried connecting to a 64 bit

> ODBC connection (SQLNCLI.DLL), and also connecting to a 32 bit ODBC

> connection (SQLSRV32.DLL) on the same machine and in both cases it

> does not connect and there is no error message either in the system

> logs or in the event logs.

>

> Please let me know if you need any more ifnormation.

>

> Thanks in advance!

 

One more note: I have MDAC version 2.82.3959.0

 

Thanks!

[Guest Shootsie]

Re: 32 bit app on a 64 bit machine ODBC?

 

On Feb 6, 1:42 pm, Shootsie <shoot...@gmail.com> wrote:

> On Feb 6, 1:29 pm, Shootsie <shoot...@gmail.com> wrote:

>

> > I have an app that is written in VB 6 and uses an ODBC connection to

> > connect to a data source.  When I run the application on a 64 bit O/S,

> > it does not connect to the ODBC.  I have tried connecting to a 64 bit

> > ODBC connection (SQLNCLI.DLL), and also connecting to a 32 bit ODBC

> > connection (SQLSRV32.DLL) on the same machine and in both cases it

> > does not connect and there is no error message either in the system

> > logs or in the event logs.

>

> > Please let me know if you need any more ifnormation.

>

> > Thanks in advance!

>

> One more note:  I have MDAC version 2.82.3959.0

>

> Thanks!

 

Ok, I figured it out -- for those who are having this same problem you

need to add via %SystemRoot%\sysWOW64\odbcad32.exe which, as far as I

can tell is not available for the system administration menu.

[Guest Charlie Russel - MVP]

Re: 32 bit app on a 64 bit machine ODBC?

 

Correct. You need to run the 32-bit ODBC Administrative app to administer

32-bit ODBC. It's a bit awkward, I agree.

 

============================

From a post by Pascal Deliot:

 

It's important to understand which kind of DSN you have. On an x64 system,

you can create an ODBC connection(DSN) on the 32-bit side of the system or

on the 64-bit side of the system.

 

32-bit applications will only see ODBC connections created in the 32-bit

side, and 64-bits applications will only see ODBC connections from the

64-bit side. Each kind of application has is own registry.

 

To setup DSN for 32-bit application you must use:

%WINDIR%\SysWOW64\odbcad32.exe

and for 64-bit application you must use:

%WINDIR%\System32\odbcad32.exe

 

HTH

=================================

 

Pascal hasn't been around these newsgroups in quite a while, but his help

lives on.

 

--

Charlie.

http://msmvps.com/xperts64

http://mvp.support.microsoft.com/profile/charlie.russel

 

 

"Shootsie" <shootsie@gmail.com> wrote in message

news:893789e9-26d9-44d7-beb2-b90f0751c128@p69g2000hsa.googlegroups.com...

On Feb 6, 1:42 pm, Shootsie <shoot...@gmail.com> wrote:

> On Feb 6, 1:29 pm, Shootsie <shoot...@gmail.com> wrote:

>

> > I have an app that is written in VB 6 and uses an ODBC connection to

> > connect to a data source. When I run the application on a 64 bit O/S,

> > it does not connect to the ODBC. I have tried connecting to a 64 bit

> > ODBC connection (SQLNCLI.DLL), and also connecting to a 32 bit ODBC

> > connection (SQLSRV32.DLL) on the same machine and in both cases it

> > does not connect and there is no error message either in the system

> > logs or in the event logs.

>

> > Please let me know if you need any more ifnormation.

>

> > Thanks in advance!

>

> One more note: I have MDAC version 2.82.3959.0

>

> Thanks!

 

Ok, I figured it out -- for those who are having this same problem you

need to add via %SystemRoot%\sysWOW64\odbcad32.exe which, as far as I

can tell is not available for the system administration menu.