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,da taPath, 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

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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - May 2008 ***



Telia News wrote:



--

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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - May 2008 ***



Telia News wrote:



--

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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - May 2008 ***



Telia News wrote:



--

I run locally on vista 64bit.
I do not run any pervasive 64bit components.
I have installed PSQL-Workgroup-10.10.056.000-win.x86 and things works
better.
and most of the DTI works.
The remaining problems so far is:

::PvDeleteDSN does not find a existing DSN.

CDatabase db;
db.Open(OdbcConnectString); -> Prompt:
"Pervasive ODBC Engine Interface
Connection failed because you attempted a DSN less connection, Please...."

In both cases there is a DSN when you look in
C:\Windows\SysWOW64\odbcad32.exe

**************
After installing PSQL-Workgroup-10.10.057.000-win.x86 there is no more
problems for me with DTI
Case closed !!!


"Bill Bach" <goldstar (AT) speakeasy (DOT) net> skrev i meddelandet
news:TIWdnY1NxcOwddrVnZ2dnUVZ_tDinZ2d (AT) speakeasy (DOT) net...

I run locally on vista 64bit.
I do not run any pervasive 64bit components.
I have installed PSQL-Workgroup-10.10.056.000-win.x86 and things works
better.
and most of the DTI works.
The remaining problems so far is:

::PvDeleteDSN does not find a existing DSN.

CDatabase db;
db.Open(OdbcConnectString); -> Prompt:
"Pervasive ODBC Engine Interface
Connection failed because you attempted a DSN less connection, Please...."

In both cases there is a DSN when you look in
C:\Windows\SysWOW64\odbcad32.exe

**************
After installing PSQL-Workgroup-10.10.057.000-win.x86 there is no more
problems for me with DTI
Case closed !!!


"Bill Bach" <goldstar (AT) speakeasy (DOT) net> skrev i meddelandet
news:TIWdnY1NxcOwddrVnZ2dnUVZ_tDinZ2d (AT) speakeasy (DOT) net...

I run locally on vista 64bit.
I do not run any pervasive 64bit components.
I have installed PSQL-Workgroup-10.10.056.000-win.x86 and things works
better.
and most of the DTI works.
The remaining problems so far is:

::PvDeleteDSN does not find a existing DSN.

CDatabase db;
db.Open(OdbcConnectString); -> Prompt:
"Pervasive ODBC Engine Interface
Connection failed because you attempted a DSN less connection, Please...."

In both cases there is a DSN when you look in
C:\Windows\SysWOW64\odbcad32.exe

**************
After installing PSQL-Workgroup-10.10.057.000-win.x86 there is no more
problems for me with DTI
Case closed !!!


"Bill Bach" <goldstar (AT) speakeasy (DOT) net> skrev i meddelandet
news:TIWdnY1NxcOwddrVnZ2dnUVZ_tDinZ2d (AT) speakeasy (DOT) net...