ASP, ODBC, Pervasive.SQL 7.0

[SCraig]

I'm trying to to use Perasive 7.0 with an ASP page. I'm using Windows 2000. I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]General error.

Any help would be great.
Jonathan Craig

 

[mirtheil]

Are you using a DSNless connection or an ODBC DSN? If you're using a DSN, go into the ODBC Administrator and "configure" the data source. Without changing anything, click "OK" and see if it gives you an error?
Another option is to turn on ODBC tracing, run the ASP page and see what's being written to the ODBC trace file. Make sure you turn off tracing once the ASP page has returned the error because tracing kills performance.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[SCraig]

mirtheil,
I have tried both. Here is the sample code:

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.ConnectionString = "DRIVER={Pervasive Software ODBC-32};DATAPATH=c:\pvsw\demodata;DDFPATH=c:\pvsw\demodata"
objConn.Open 'Fails here.

and

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.ConnectionString = "DSN=Demodata"
objConn.Open 'Fails here.

We are using Pervasive.SQL 7.0. I do not have any of the service packs installed. My Pervasive ODBC driver is version 2.53.03. I'm running Windows 2000 Pro. I'm also using the Pervasive.SQL Workstation Engine.

Thanks for your help.

 

[TomKane]

Did you ever get to the bottom of this one?

 

[SCraig]

No have not solved this yet. Can get no reponse from this board...

 

[TomKane]

Did you see this?

thread318-471942

 

[SCraig]

TomKane,
Yes, thanks. But it did not help me. I did download the Pervasive trail version 8. Installed it and everything worked. Will do some more testing, if there are any problems with version 8 I will post.

Thanks,
Jonathan Craig

 

[0408]

Dear smcmanus2001, Dear TomKane

I encountered the same problem with this post's owner, i can not solve it till now, I read about 4-5 posts like this, and in all of them i see smcmanus2001's answer or somebody else post the link.

I think your suggestion is very reasonalbe, but it can not work either.

Here the situation is as below:
the DB server is nt4+pervasive.sql7
I have created a user named iusr_fileserver with password blank
The WEB server(iis) is win2000 server
which name is fileserver, so the internet user name is iusr_fileserver

the error still appears as "general error"

I really need help!!!
any kind, any person!
I will appreciate you very much!!

 

[mirtheil]

Turn on ODBC Tracing through the ODBC Administrator and get the actual Btrieve error message.
Also, can you use ODBC from the webserver outside of IIS (through Access, ODBCTest, or something similar)?


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[0408]

I can use the odbc via VB,VC,Access, both ok
but it just can not work using ASP, even via an DLL which is written with VB.

I will try the odbc tracing now

 

[0408]

I have started the tracing, but i can not see the log file when i run the asp, why? where is it? how to do???

 

[0408]

I found it!
the error says

Date Time Component Process Process Name Machine Name Type Category Msg ID Message
---------- -------- --------------- -------- --------------- --------------- ---- ---------- -------- --------------------------------------------------
06-09-2003 15:31:19 ECAS_API 0000076C 2\odbcad32.exe" FILESERVER E ECASAPI (1.2.3.8013): Error 8502 - An error occurred when trying to locate W3UPIxyy.DLL

 

[0408]

But how to resolve?
I can not find the dll in my web server, even in the DB server!

 

[mirtheil]

What is the exact version of the Pervasive ODBC driver? Also, what's the name of the driver ("Pervasive ODBC-32" or "Pervasive ODBC Engine Interface" or "Pervasive ODBC Client Interface&quot?
DId you search for W3UPI*.DLL? The UPI series of DLLs are Pervasive's Utility Programming Interface DLLs.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[0408]

ther driver is
Pervasiv ODBC 32
version 2.54.03.00

I searched the w3*.dll, and got nothing, both in the webserver and dbserver,

thank you for your help, i really appreciate anyone who give any suggestion or advice here!!!

 

[mirtheil]

If you're getting that error message, then you've got some mismatched components. Have you ever installed Pervasive.SQL 2000 or V8? DO you have any files in the C:\Program Files\Pervasive or c:\program files\PSA directory?
At this point, I would recommend downloading PSA from Pervasive's web site (http://www.pervasive.com/support/updates/psa_update.asp. Install and run it to analyze/archive the components on the WebServer. Then once that's done, reinstall the Pervasive.SQL 7 client including the ODBC 2.54 driver.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[0408]

Crying.......

I downloaded the PSA, and reinstalled the ODBC driver(i did not install pervasive sql engine on the webserver, since i think it is not necessary, and the db i used is in the DB server)

But nothing changed!
the error still says:
An error occurred when trying to locate W3UPIxyy.DLL

When i copied an file named W3u104i.dll to my winnt/system32
the error changed to

ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the WSE
06-11-2003 16:29:17 ECAS_API 000008FC 2\odbcad32.exe" FILESERVER E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the WSE


I am at the edge to crazy!!
Please help me! Please!

 

[0408]

Help!!!

 

[mirtheil]

Is the PVSW\BIN directory in the system path? If not, add it.
Also, where's the data (local or remote to the webserver)?

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[0408]

how to see?
how to add?

And, the data is in the DB server, not the webserver.