Re: Witango-Talk: Witango 5.5 and Pervasive v9 - Function Sequence Error

Francesca Arecco Tue, 23 May 2006 06:30:28 -0700

Hi David, here are the procedure I followed to have a JDBC connection between Witango and Pervasive. It's "my way" to achieve the goal, I wasn't able to find a well documented official way. WITANGO SERVER SIDE You need a JVM installed on the server (I have 1.5.0). The JVM installed has to able to use Pervasive JDBC driver. My solution was to copy the file jpscs.jar, pvjdbc2.jar, pvjdbc2x.jar from PVSW\BIN to {JAVA_HOME}lib\ext. This way the PVSW file become JVM extension. Witango Server has to be able to correctly load that JVM.On witango.ini file,set the parameter JAVAVIRTUALMACHINE value to the path of jvm.dll file. Finally you have to define the JDBC DSN. The JDBC DSN are collected in {WITANGO_SERVER}/Configuration/jdbc.ini file. Following a DSN exmple from my jdbc.ini file.
<?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd"> <JDBCINI Version="0x00010000"> <DataSources> <DataSource ID="Ici2001Internet"> <DSN>Ici2001Internet</DSN> <DriverClass>com.pervasive.jdbc.v2.Driver</DriverClass> <URL>jdbc:pervasive://192.168.1.107:1583/Ici2001Internet</URL> <Properties> <Property ID="server"> <Name>server</Name> <Value>192.168.1.107</Value> </Property> <Property ID="port"> <Name>port</Name> <Value>1583</Value> </Property> </Properties> </DataSource> </DataSources> </JDBCINI>The URL address has the following sintax: jdbc:pervasive://{PVSW_SERVER IP ADDRESS}:1583/{ODBC DSN NAME}WITANGO STUDIO SIDE You have to define a deployment DSN during .taf/.tcf development. The DSN has obiouvsly to use the JDBC driver. The JDBC driver is not listed but if you write it, it will work. I hope this can help. I contacted off topic Rick Sander as well, to solve anyway my ODBC problem. Best Regards Francesca
David Green wrote:

Francesca,

I would love some advise... I'm not sure where to get started. Any help is greatly appreciated.

Thanks,

David Green
[EMAIL PROTECTED]
Systems Insight, Inc.

Francesca Arecco wrote:

Hi David,
if you need further information on how to use JDBC on Pervasive just let me know.
I can give you some (little) advice.

Regards
Francesca

David Green wrote:

Thanks Francesca,

The Witango version we're using is 5.5... which I thought used the 3.51? I'm not positive of this, but I thought I had heard that.

Anyone else experienced this problem? I guess I'll start researching JDBC...

Thanks,

David Green
[EMAIL PROTECTED]
Systems Insight, Inc.

Francesca Arecco wrote:

Hello,

I have the same issue (Witango 5.0, Pervasive v9 on Windows 2003 Server). I encountered the problem during the upgrade from the configuration Witango 5.0 and PSQL v8.5 on Windows 2000 Server.

The only hint I was able to find was the problem "could" be connected to different ODBC version. I checked and I found Pervasive v9 has ODBC v 3.51 and Witango 5.0 has ODBC v3.0.

The only way I found to avoid the problem was to use JDBC connection instead of ODBC.

Best Regards
Francesca

David Green wrote:

Hello,

We're having issues with Witango 5.5 and Pervasive v9 on Windows 2003 Server. This is a brand new machine, etc. Basically, we can't run any applications with database queries. We're trying to upgrade from our existing system which is Win 2K - Witango 5.0 and Pervasive 2000i.

When we run any database queries, we get the following error:

[Microsoft][ODBC Driver Manager] Function sequence error
HY010

We've tested the datasource connection with asp from the same machine and it works fine... We're only getting this error when we call the DSN through Witango. Any suggestions? Any Help?

Thanks,

David Green
[EMAIL PROTECTED]
Systems Insight, Inc.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

--
Francesca Arecco
Area Sistemi Informativi
A&B SpA - Informatica e Ricerca Operativa
tel +39.010.648671
fax +39.010.6486752

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

--
Francesca Arecco
Area Sistemi Informativi
A&B SpA - Informatica e Ricerca Operativa
tel +39.010.648671
fax +39.010.6486752

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

-- 
Francesca Arecco
Area Sistemi Informativi
A&B SpA - Informatica e Ricerca Operativa
tel +39.010.648671
fax +39.010.6486752




________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Witango 5.5 and Pervasive v9 - Function Sequence Error

Reply via email to