will pangya work on sql 2008 64bit im asking because my os is 64 bit or should i just install 32bit sql
Printable View
will pangya work on sql 2008 64bit im asking because my os is 64 bit or should i just install 32bit sql
Talking as programmer and IT professional, the server may work for fine at "any" OS architecture than the SQL.
x64 systems just add a couple of new instructions, supporting the old set ones. The same happens with the SQL server - but here it is designed to work only OVER also x64 OS'es (there's nothing about working UNDER specific applications).
So, this stated, all might goes fine, be the OS nor the SQL versions both x32 or x64 (but the OS must be, also, x64 if the SQL platform is).
Other side, I confess never tried running all over a full x64 system, so my statement is merely theoretical and logics based. If wanted, would be better waiting for a plus experienced advice. ^^'
As Xereta already explained the operating system is 32bit backwards-compatible, so there's no problem running the executables. Install the 64bit version of SQL Server if you want, it doesn't matter.
What does matter is that you setup a 32bit ODBC DSN link (see the Common Beginner Questions for more details on that matter) since 64bit Windows systems come with 2 ODBC subsystems (one for 64bit, one for 32bit applications). The most common mistake people make is setting up 64bit DSNs (which the server, being a 32bit application, doesn't care about).
Also the registry comes with a 32bit version (usually under *\SOFTWARE\SYSWOW64)
If any registry settings fail that is for 32bit applications, modify the path to point to SYSWOW64 instead and it should be fine.