Pervasive 2000i sql Client Installation on Win 2003 Server

[Nixx123]

When Running the Pervasive.sql2000i Setup (Build 230)
Client for Windows Patch on my Windows 2003 server
for the sole purpose of installing the ODBC Drivers to create a Connection to My Pervasive Database Server (Also Win2003)
However i recieve the following error : "The program or feature "\??\c:\pvsw\bin\oledbu16.exe" cannot start or run due to incompatibility with 64-bit versions of windows .Please contact the software vendor to ask for a 64-bit Windows compatible version "

After accepting the message i let the setup complete ,
I have check the that following on the Server c:\windows\odbc.ini
& c:\windows\odbcinst.ini please see attached and advise since i am not sure how to rectify this issue

ODBC.INI
[ODBC 32 bit Data Sources]
MS Access 97 Database=Microsoft Access Driver (*.mdb) (32 bit)
dBASE Files=Microsoft dBase Driver (*.dbf) (32 bit)
Excel Files=Microsoft Excel Driver (*.xls) (32 bit)
FoxPro Files=Microsoft FoxPro Driver (*.dbf) (32 bit)
Text Files=Microsoft Text Driver (*.txt; *.csv) (32 bit)
Mozambique=SQL Server (32 bit)
Mozambique_Temp=SQL Server (32 bit)
MonthendMozambique=SQL Server (32 bit)
MozambiqueCitydealer=Pervasive ODBC Client Interface (32 bit)
[MS Access 97 Database]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[dBASE Files]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[Excel Files]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[FoxPro Files]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[Text Files]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[Mozambique]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[Mozambique_Temp]
Driver32=C:\WINDOWS\system32\sqlsrv32.dll
[MonthendMozambique]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[MozambiqueCitydealer]
Driver32=C:\PVSW\Bin\w3odbcci.dll

odbcinst.ini

[SQL Server (32 bit)]
Driver=C:\WINDOWS\system32\sqlsrv32.dll
Setup=C:\WINDOWS\system32\sqlsrv32.dll
32Bit=1
[ODBC 32 bit Drivers]
SQL Server (32 bit)=Installed
Microsoft Access Driver (*.mdb) (32 bit)=Installed
Microsoft Text Driver (*.txt; *.csv) (32 bit)=Installed
Microsoft Excel Driver (*.xls) (32 bit)=Installed
Microsoft dBase Driver (*.dbf) (32 bit)=Installed
Microsoft Paradox Driver (*.db ) (32 bit)=Installed
Microsoft Visual FoxPro Driver (32 bit)=Installed
Microsoft FoxPro VFP Driver (*.dbf) (32 bit)=Installed
Microsoft dBase VFP Driver (*.dbf) (32 bit)=Installed
Microsoft Access-Treiber (*.mdb) (32 bit)=Installed
Microsoft Text-Treiber (*.txt; *.csv) (32 bit)=Installed
Microsoft Excel-Treiber (*.xls) (32 bit)=Installed
Microsoft dBase-Treiber (*.dbf) (32 bit)=Installed
Microsoft Paradox-Treiber (*.db ) (32 bit)=Installed
Microsoft Visual FoxPro-Treiber (32 bit)=Installed
Driver do Microsoft Access (*.mdb) (32 bit)=Installed
Driver da Microsoft para arquivos texto (*.txt; *.csv) (32 bit)=Installed
Driver do Microsoft Excel(*.xls) (32 bit)=Installed
Driver do Microsoft dBase (*.dbf) (32 bit)=Installed
Driver do Microsoft Paradox (*.db ) (32 bit)=Installed
Driver para o Microsoft Visual FoxPro (32 bit)=Installed
Microsoft ODBC for Oracle (32 bit)=Installed
Microsoft FoxPro Driver (*.dbf) (32 bit)=Installed
Pervasive ODBC Client Interface (32 bit)=Installed
[Microsoft Access Driver (*.mdb) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odbcjt32.dll
32Bit=1
[Microsoft Text Driver (*.txt; *.csv) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odtext32.dll
32Bit=1
[Microsoft Excel Driver (*.xls) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odexl32.dll
32Bit=1
[Microsoft dBase Driver (*.dbf) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\oddbse32.dll
32Bit=1
[Microsoft Paradox Driver (*.db ) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odpdx32.dll
32Bit=1
[Microsoft Visual FoxPro Driver (32 bit)]
Driver=C:\WINDOWS\system32\vfpodbc.dll
Setup=C:\WINDOWS\system32\vfpodbc.dll
32Bit=1
[Microsoft FoxPro VFP Driver (*.dbf) (32 bit)]
Driver=C:\WINDOWS\system32\vfpodbc.dll
Setup=C:\WINDOWS\system32\vfpodbc.dll
32Bit=1
[Microsoft dBase VFP Driver (*.dbf) (32 bit)]
Driver=C:\WINDOWS\system32\vfpodbc.dll
Setup=C:\WINDOWS\system32\vfpodbc.dll
32Bit=1
[Microsoft Access-Treiber (*.mdb) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odbcjt32.dll
32Bit=1
[Microsoft Text-Treiber (*.txt; *.csv) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odtext32.dll
32Bit=1
[Microsoft Excel-Treiber (*.xls) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odexl32.dll
32Bit=1
[Microsoft dBase-Treiber (*.dbf) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\oddbse32.dll
32Bit=1
[Microsoft Paradox-Treiber (*.db ) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odpdx32.dll
32Bit=1
[Microsoft Visual FoxPro-Treiber (32 bit)]
Driver=C:\WINDOWS\system32\vfpodbc.dll
Setup=C:\WINDOWS\system32\vfpodbc.dll
32Bit=1
[Driver do Microsoft Access (*.mdb) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odbcjt32.dll
32Bit=1
[Driver da Microsoft para arquivos texto (*.txt; *.csv) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odtext32.dll
32Bit=1
[Driver do Microsoft Excel(*.xls) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odexl32.dll
32Bit=1
[Driver do Microsoft dBase (*.dbf) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\oddbse32.dll
32Bit=1
[Driver do Microsoft Paradox (*.db ) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odpdx32.dll
32Bit=1
[Driver para o Microsoft Visual FoxPro (32 bit)]
Driver=C:\WINDOWS\system32\vfpodbc.dll
Setup=C:\WINDOWS\system32\vfpodbc.dll
32Bit=1
[Microsoft ODBC for Oracle (32 bit)]
Driver=C:\WINDOWS\SysWOW64\msorcl32.dll
Setup=C:\WINDOWS\SysWOW64\msorcl32.dll
32Bit=1
[Microsoft FoxPro Driver (*.dbf) (32 bit)]
Driver=C:\WINDOWS\system32\odbcjt32.dll
Setup=C:\WINDOWS\system32\odfox32.dll
32Bit=1
[Pervasive ODBC Client Interface (32 bit)]
Driver=C:\PVSW\Bin\w3odbcci.dll
Setup=C:\PVSW\Bin\w3odbccs.dll
32Bit=1

 

[mirtheil]

It looks like the ODBC driver is installed. Are you having any problems? The file (oledbu16.exe) is used by the PCC to display 16 bit settings. It has nothing else to do with the product.

If you are having a problem with ODBC, please post what you are doing and what error or behavior you are seeing.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[Nixx123]

Hi
Basically , i am trying to Install the Pervasive sql 2000i Clientg Software on a Windows 20003 SP 2 64 bit Virtual Server
To use the Client ODBC Interface Driver for a DTS package to extract Data from the Target Pervasive Server
On installation of the Pervasive Client SQL 2000I software
I received the above error :"The program or feature "\??\c:\pvsw\bin\oledbu16.exe" cannot start or run due to incompatibility with 64-bit versions of windows

Is there a way i can use the 32 bit Odbc Administrator but point it to the Driver=C:\PVSW\Bin\w3odbcci.dll

 

[mirtheil]

Does the install continue after the oledbu16.exe error? Does it finish successfully?
If so, then the client is installed. Based on your ODBC.INI, the driver is installed.

Is there a way i can use the 32 bit Odbc Administrator but point it to the Driver=C:\PVSW\Bin\w3odbcci.dll

I don't understand. If you start the 32 bit ODBC Administrator (in c:\windows\syswow64\odbcad32.exe), do you see the Pervasive driver in the Drivers tab?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[Nixx123]

The Install Completes Successfully ,
When launching the ODBCAD32.EXE from Start /Run
selecting the Drivers Tab , there is no Pervasive Driver

 

[Nixx123]

Mirtheil!
I will need to pick this up with you tomorrow ,
Due to the Time Difference between you and myself ,
I am + 9 Hours ahead of you

Kind regards
Nixx123

 

[mirtheil]

I'll send this so you see it tomorrow morning.
Make sure you're using the right ODBC Administrator. DON'T use the one in C:\WINDOWS\SYSTEM32. USE the one in C:\WINDOWS\SYSWOW64.
Look in the registry in the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI key. CHeck for the Pervasive driver there. If it's there, then you should be seeing it in the ODBC Admin.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[Nixx123]

Hi

I have used the ODBC from C:\WINDOWS\SYSWOW64.
Thanks
But i would like to understand even though the driver installs
for 64 bit compatibility why the error when running the Client Install

 

[mirtheil]

The error is because the program (oledbu16.exe) is a 16 bit program and 64 bit operating systems don't run 16 bit applications. All that program does is add 16 bit configuration options into the Pervasive Control Center. The PSQL client will work just fine even with that error. In PSQL v9, when the PCC was re-written, that program was not needed and not included.

All of that being said, PSQL 2000i, v8, and even some of v9 were never tested on 64 bit operating systems. None of those versions are supported by Pervasive either. The only versions that are tested and supported on 64 bit operating systems are PSQL v10 and v11. Just something to think about.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[Nixx123]

Thank you !!

 

[Nixx123]

Just in relation to the above , when viewing the Client Tables
i noted that in one Table a value is representing [ , ] for a IEEE Float Data type
From the Client machine that is connecting to the Pervasive Server .
When viewing the same value in the same Table on the Server Database Engine , Table and Column the same Data type is represented as a [.]

Any thoughts on this ?

 

[mirtheil]

Not sure what that could be. Starting a new thread might get you more ideas.
Best guess is that the machines have different display or regional settings for numeric data types in the OS.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com