hi all,

could someone tell me, how to configure the odbc client interface on windows server 2003 (64 bit)? It'd be fine if you could help me! Here is the system configuration of our client/server:
   PSQL CLIENT: 64 bit processor;windows server 2003 (64 bit);p sql v9.5 client
   PSQL SERVER: 32 bit processor; windows server 2003 (32 bit);p sql v9.5 server

On the server side is, hopefully, correct installed i. e. connection to PSQL Server is successful. On the client side connection is successful too. But all this tests are executed by ODBC Administrator of PSQL.

Our target is integrating data from PSQL Server to SQL Server (also 64 bit) on PSQL Client. So we try to connect to the PSQL Server on odbc interface by using Integration Services from Microsoft SQL Server, but it failed!-(

Regarding to http://www.tek-tips.com/viewthread.cfm?qid=1258682&page=1 i inserted following data to ODBCINST.INI on PSQL Server and following keys and its value in Register Manager on PSQL Client:

ODBCINST.INI on PSQL Server: 

   [Pervasive ODBC Engine Interface (32 bit)]
   Driver=<pervasive_path>\Bin\w3odbcei.dll
   Setup=<pervasive_path>\Bin\w3odbces.dll
   32Bit=1
   [Pervasive ODBC Client Interface (32 bit)]
   Driver=<pervasive_path>\Bin\w3odbcci.dll
   Setup=<pervasive_path>\Bin\w3odbccs.dll
   32Bit=1
   [ODBC 32 bit Drivers]
   Pervasive ODBC Engine Interface (32 bit)=Installed
   Pervasive ODBC Client Interface (32 bit)=Installed

Keys and its value in Register Manager on PSQL Client:

1. Under ODBC Core in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI insert a Dword Value named UsageCount with value of 2.

2. Under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Core create a key called FileList
      Under this key insert the following strings with their corresponding values
      ctl3d32.dll    "<winsysdir>\ctl3d32.dll"
      DS32GT.dll    "<winsysdir>\DS32GT.dll"
      MFC30.dll    "<winsysdir>\MFC30.dll"
      MSVCRT20.dll    "<winsysdir>\MSVCRT20.dll"
      ODBC16GT.dll    "<winsysdir>\ODBC16GT.dll"
      ODBC32.dll    "<winsysdir>\\ODBC32.dll"
      ODBC32GT.dll    "<winsysdir>\ODBC32GT.dll"
      ODBCCP32.cpl    "<winsysdir>\ODBCCP32.cpl"
      ODBCCR32.dll    "<winsysdir>\ODBCCR32.dll"

3 . Under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers create a new string with its value
      Pervasive ODBC Engine Interface    "Installed"

4. Under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI create a key called Pervasive ODBC Client Interface

      Under this new key insert the following strings with their corresponding values
      APILevel    "2"
      ConnectFunctions    "YYY"
      Driver    "<pervasive_path>\bin\w3odbcci.dll"
      DriverODBCVer    "02.50"
      FileUsage    "0"
      Setup    "<pervasive_path>\bin\w3odbccs.dll"
      SQLLevel    "0"

      Under this same key insert a Dword called UsageCount with its value of 1
 

After making modifications data access  on ODBC interface not possible yet. Now i am at my wits' end.

Thanks so much for your help in advance and hope to hearing from you soon.

Khan
 

 THe ODBC drivers are 32 bit.  I don't believe 32 bit drivers can be accessed through a 64 bit application.  I read somewhere that it might be possible to create a 32 bit named instance of SQL Server 64 bit and use that but the 32 bit drivers cannot be used in the 64 bit SQL Server.