PDA

View Full Version : Problems using embedded sql against Pervasive database.



Karl A. Sørensen
31-May-2005, 04:33 AM
I have installed the connectivity kit version 2.0.0.236 for Pervasive.SQL,
and I want to test embedded SQL against our Pervasive database. I use our
registration key for Pervasive.SQL connectivity kit to register the ODBC
connectivity kit, and I get a message telling me that I have successfully
registered the ODBC connectivity kit. I now use the databasebuilder to
"Connect to odbc", select our system DSN, select a table to connect to,
select some indexes, and all is ok. I can view the file in dbbuilder and the
data in dbexplorer.

I then try to use embedded sql to connect to our database in the following
way:

Move (Create(self,U_cSQLHandleManager)) to hSQL
Get SQLConnect Of hSQL ODBC_DRV_ID "DSN=DG10" To hDb

Problem:
This produces an error message "Dataflex is not installed in termlist.cfg,
please run DFSETUP. ODBV_DRV.CFG. Error number: 28676"

Any idea what is wrong ??

I have tried to install the conn. kit again. I have tried to delete the .DFR
and .CFG file, and register again, but nothing helps.

Regards
Karl

Karl A. Sørensen
31-May-2005, 04:34 AM
Forgot to say that I am using VDF9.1 on WinXP.

Karl

"Karl A. Sørensen" <kas@kamstrup-ems.no> wrote in message
news:14EsvPcZFHA.3896@dacmail.dataaccess.com...
>I have installed the connectivity kit version 2.0.0.236 for Pervasive.SQL,
>and I want to test embedded SQL against our Pervasive database. I use our
>registration key for Pervasive.SQL connectivity kit to register the ODBC
>connectivity kit, and I get a message telling me that I have successfully
>registered the ODBC connectivity kit. I now use the databasebuilder to
>"Connect to odbc", select our system DSN, select a table to connect to,
>select some indexes, and all is ok. I can view the file in dbbuilder and
>the data in dbexplorer.
>
> I then try to use embedded sql to connect to our database in the following
> way:
>
> Move (Create(self,U_cSQLHandleManager)) to hSQL
> Get SQLConnect Of hSQL ODBC_DRV_ID "DSN=DG10" To hDb
>
> Problem:
> This produces an error message "Dataflex is not installed in termlist.cfg,
> please run DFSETUP. ODBV_DRV.CFG. Error number: 28676"
>
> Any idea what is wrong ??
>
> I have tried to install the conn. kit again. I have tried to delete the
> .DFR and .CFG file, and register again, but nothing helps.
>
> Regards
> Karl
>