Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can a 32bit application access a 64bit sql server database?

As the title states really, I need to know if a 32bit application can access a 64bit sql server database?

like image 953
PDM Avatar asked Jan 04 '12 15:01

PDM


People also ask

How do I use 32-bit ODBC on 64-bit?

To work around this problem, use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32 .exe.

Does SQL Server support 32-bit?

And in 2022, SSMS is still 32 bit.

What is the difference between 32-bit and 64-bit SQL Server?

Key Difference Between 32-bit and 64-bit32-bit processors have 4 GB addressable space while 64-bit processors have 16 exabytes addressable space. 32-bit processors need a 32-bit operating system whereas 64-bit processors can run either on 32 or 64 64-bit operating systems.


2 Answers

Yes

An application won't care if the target database server is 32 or 64 bit, Windows/Unix, Server/Mainframe, local or in the cloud. All it knows is the connection string it sends to a driver on the local OS.

To be clear, the local OS and driver don't care about 32 or 64 bit on the target system

like image 169
gbn Avatar answered Sep 21 '22 01:09

gbn


Yes they can and usually there is no problem.

Some large datasets might cause an issue but you would need a record with over 3gb of data...

like image 25
Martin Samson Avatar answered Sep 20 '22 01:09

Martin Samson