OS - Pervasive ODBC Drivers Not Visible in ODBC Administrator
OS: Windows 2003
Version: Win64 Server
Issue:
We just installed a new Windows 2003 Server x64 edition, and installed
Pervasive PSQL v10 Win64 edition. However, when we went into the ODBC
Administrator to configure our DSN, the Pervasive drivers are not there!
Resolution:
On a Win64 operating system, the ODBC Administrator accessible from the
Control Panel is the Win64 ODBC Administrator. This version can see
Win64 ODBC drivers only, while the Pervasive SQL engine and ODBC
drivers are still 32-bit. To configure the DSN, you must use the Win32
ODBC Administrator. You c an get to this by starting the PCC and
selecting Tools/ODBC Administrator, or by browsing to
C:\Windows\SysWOW64\ODBCAD32.EXE and launching it manually.
As for the DTI interfacem try running your DTI program as an elevated
user. If you're doing it from the command prompt, try right-clicking
ther command prompt and selecting "Run As Administrator" and see if
that fixes it.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach@[EMAIL PROTECTED]
Chicago: Pervasive Service & Sup****t Class - May 2008 ***
Telia News wrote:
> Hi!
> I have DTI rutines in c++ to create database and DNS that works on
> win XP now both on workgroup and server I am trying to make them work
> on 64bit Vista with Pervasive 10.10 workgroup I have not tried on
> 32bit Vista. simplified code: *********
> PvConnectServer(serverName,userName,password, &hConnection);
> pvDropDatabase(hConnection, oldDBName,0);
> PvDeleteDSN(hConnection, oldDSNName));
>
> pvCreateDatabase(hConnection,newDBName,dictPath,dataPath, dbFlags);
> PvCreateDSN(hConnection,newDSNName), "Pervasive ODBC Engine
> Interface",newDBName, openMode); <- gives P_E_ACCESS_RIGHT *********
>
> I am running as administrator.
> To make it more complicated I am running on vista 64 bit and the
> 32-bit ODBC Administrator is not the default i control panel.
>
> Is there someone who can tell me how to get it working
>
> /Stefan
--
|
