64 bit ODBC and a 32 bit ODBC

[Guest Harrysmithsteven@gmail.com]

Hey group!

 

I'm quite new to this ODBC and would really like it if you could

clear

up some of my queries...I apologize if some of the questions seem

ridiculous...:)))

 

 

Im trying to get my C# .NET application running on a 64 bit machine

and am facing a few problems.

The app makes use of an odbc connection and this is where I am

getting

confused and I havent been able to get any reliable sources online...

 

 

What is the difference between a 32 bit odbc and a 64 bit odbc

connection?

 

 

Can a 64 bit Application make use of a 32 bit odbc connection?

 

 

Can a 32 bit Application make use of a 64 bit ODBC connection?

 

 

**Im using SQL server as the database which is 32 bit. And my app is

compiled as "Any CPU".

 

 

And Ive gotten to know that if we compile the app in "Any CPU"

configuration it runs as a 64bit app on a 64 bit machine...so my

question is can my app make use of a 64 bit odbc is it possible? (or

32 bit odbc?)

 

 

or should i force it to run as 32 bit and make use of a 32bit odbc ?

whts the difference between the two?

 

 

An advance Thank you for taking the time to help me out!!

[Guest Tony Sperling]

Re: 64 bit ODBC and a 32 bit ODBC

 

I have no experience from working with any of that, but the ODBC is labeled

as being a 'driver', which in usual terms often mean device drivers. Any

such thing has to be of the same bitness as the OS itself.

 

Some apps are written with driver-like code inside a *.DLL and is equally

restrictive for the same reason - on top of which you also cannot make

system calls to *.DLL's of the wrong bitness, even in the event that they

would not contain any driver-like code at all!

 

You can run a 32bit OS on a 64bit capable CPU, and you can run 32bit

applications on that system and use 32bit drivers and make calls to 32bit

*.DLL's.

 

You can also run a AMD64bit OS on this system and run the same 32bit

application (does not apply to Itanium) - in which case the rest of the

named modules will have to be still 32bit. Install a 64bit application and

these modules will all have to be 64bit.

 

I guess this would explain your situation, but others may have more

exhausting comments?

 

 

Tony. . .

 

 

 

<Harrysmithsteven@gmail.com> wrote in message

news:ec49cb03-b89d-4a86-99a1-2ed9ee40c1f2@k13g2000hse.googlegroups.com...

> Hey group!

>

> I'm quite new to this ODBC and would really like it if you could

> clear

> up some of my queries...I apologize if some of the questions seem

> ridiculous...:)))

>

>

> Im trying to get my C# .NET application running on a 64 bit machine

> and am facing a few problems.

> The app makes use of an odbc connection and this is where I am

> getting

> confused and I havent been able to get any reliable sources online...

>

>

> What is the difference between a 32 bit odbc and a 64 bit odbc

> connection?

>

>

> Can a 64 bit Application make use of a 32 bit odbc connection?

>

>

> Can a 32 bit Application make use of a 64 bit ODBC connection?

>

>

> **Im using SQL server as the database which is 32 bit. And my app is

> compiled as "Any CPU".

>

>

> And Ive gotten to know that if we compile the app in "Any CPU"

> configuration it runs as a 64bit app on a 64 bit machine...so my

> question is can my app make use of a 64 bit odbc is it possible? (or

> 32 bit odbc?)

>

>

> or should i force it to run as 32 bit and make use of a 32bit odbc ?

> whts the difference between the two?

>

>

> An advance Thank you for taking the time to help me out!!

>

>

[Guest Jeff Gaines]

Re: 64 bit ODBC and a 32 bit ODBC

 

On 15/07/2008 in message

<ec49cb03-b89d-4a86-99a1-2ed9ee40c1f2@k13g2000hse.googlegroups.com>

Harrysmithsteven@gmail.com wrote:

>And Ive gotten to know that if we compile the app in "Any CPU"

>configuration it runs as a 64bit app on a 64 bit machine...so my

>question is can my app make use of a 64 bit odbc is it possible? (or

>32 bit odbc?)

 

I get confused about all the different ways of accessing data but I use

ADO.NET and it only has 32 bit drivers, so apps have to be compiled as 32

bit specific, otherwise they fail silently.

Does your app work if you compile it as x86 rather than x64?

 

--

Jeff Gaines Damerham Hampshire UK

There is no reason anyone would want a computer in their home.

(Ken Olson, president Digital Equipment, 1977)

[Guest Jeff Gaines]

Re: 64 bit ODBC and a 32 bit ODBC

 

On 15/07/2008 in message <xn0fsq08bbulwh4001@msnews.microsoft.com> Jeff

Gaines wrote:

>On 15/07/2008 in message

><ec49cb03-b89d-4a86-99a1-2ed9ee40c1f2@k13g2000hse.googlegroups.com>

>Harrysmithsteven@gmail.com wrote:

>

>>And Ive gotten to know that if we compile the app in "Any CPU"

>>configuration it runs as a 64bit app on a 64 bit machine...so my

>>question is can my app make use of a 64 bit odbc is it possible? (or

>>32 bit odbc?)

>

>I get confused about all the different ways of accessing data but I use

>ADO.NET and it only has 32 bit drivers, so apps have to be compiled as 32

>bit specific, otherwise they fail silently.

>Does your app work if you compile it as x86 rather than x64?

 

 

I don't think I worded that very well :-(

I use MSFT Access with ADO.NET so it may be the Access drivers that are 32

bit.

 

--

Jeff Gaines Damerham Hampshire UK

There are 10 types of people in the world, those who do binary and those

who don't.

[Guest Harrysmithsteven@gmail.com]

Re: 64 bit ODBC and a 32 bit ODBC

 

On Jul 15, 8:26 pm, "Jeff Gaines" <whitedra...@newsgroups.nospam>

wrote:

> On 15/07/2008 in message <xn0fsq08bbulwh4...@msnews.microsoft.com> Jeff

>

> Gaines wrote:

> >On 15/07/2008 in message

> ><ec49cb03-b89d-4a86-99a1-2ed9ee40c...@k13g2000hse.googlegroups.com>

> >Harrysmithste...@gmail.com wrote:

>

> >>And Ive gotten to know that if we compile the app in "Any CPU"

> >>configuration it runs as a 64bit app on a64bitmachine...so my

> >>question is can my app make use of a64bitodbcis it possible? (or

> >>32bitodbc?)

>

> >I get confused about all the different ways of accessing data but I use

> >ADO.NET and it only has 32bitdrivers, so apps have to be compiled as 32

> >bitspecific, otherwise they fail silently.

> >Does your app work if you compile it as x86 rather than x64?

>

> I don't think I worded that very well :-(

> I use MSFT Access with ADO.NET so it may be the Access drivers that are 32bit.

>

> --

> Jeff Gaines Damerham Hampshire UK

> There are 10 types of people in the world, those who do binary and those

> who don't.

 

Hi Jeff,

yes it does work in 'x86' mode....

[Guest Jeff Gaines]

Re: 64 bit ODBC and a 32 bit ODBC

 

On 16/07/2008 in message

<e0bfd445-e267-40e7-b3c1-3a764117da61@y21g2000hsf.googlegroups.com>

Harrysmithsteven@gmail.com wrote:

>Hi Jeff,

>yes it does work in 'x86' mode....

 

I would think it's a 32 bit data driver then. The dotnet groups are very

helpful, there's one called:

microsoft.public.dotnet.framework.odbcnet

 

could be worth a try?

 

--

Jeff Gaines Damerham Hampshire UK

If it's not broken, mess around with it until it is