32/64-bit compatibility issues

[Former Member]

Hi,

I have some doubts on the 32-bit/64-bit compatibility between SQL Server, SAP and the underlying OS. Can somebody explain me in a general manner how does this all work?

Q1: my SQL Server 2000 (32-bit) is connected through the NSX SAP connector to SAP R/3 v6. Does a migration of my SQL 2000 32-bit to a 64-bits version have any impact on the connection to SAP (R/3 v6)? Shall I migrate also SAP to a 64-bit version to avoid inconsistencies?

Q2: does SAP give any support on the NSX SAP connector?

Q3: what are the best connectors on the market to connect SQL to SAP ?

Thanks for your help!

If it's not the right forum please address me to the correct one...

F

[former_member189546]

hello,

For new systems need to use connector for Microsoft.NET

https://service.sap.com/connectors

regards,

John Feely

[former_member184473]

Hi Francesco,

Clarify what you mention by "NSX SAP connector".

SAP recommends to keep your environment (Database, OS, SAP kernel) in the same architecture, so all this components in 32 or 64 bits.

Regards,

Eduardo