Pervasive, ASP, IIS

[TomKane]

Hello,

We're trying to access Pervasive data from an ASP page. IIS in the mix also. When we try to connect we get the error:

Message "ERROR [S1000] [Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]General error.
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)."

Has anybody ever come across this before? Any help would be appreciated.

Thanks,
Tom

PS, I put this in the Btrieve forum as well - sorry about that - my hand slipped.....

 

[mirtheil]

What version of the engine are you using? Are you able to access the database through ODBC through something like Access/MS Query or the Pervasive Control Center (if you're using 2000 or V8)? What operation is giving that error message?
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[TomKane]

Hi,

Thanks for the response. We are using P.SQl 7 SP5. We use P.SQL through VB and MS Query no problem. We've never tried the ASP thing before. It might be a security issue with IIS - but were wondering if anyone else had ever had this and how did they get around it. The problem happens as soon as we try to connect to the database.

Thanks again,
Tom

 

[mirtheil]

What operation is giving the error message?
I've used the sample below before to get a start on ASP development.

http://www.pervasive.com/ComponentZ...ategoryID=9&Page=1&CategoryName=Miscellaneous

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

 

[TomKane]

Thanks for that - I'll give it a try and see what happens - thanks again

 

[Smcmanus2001]

I don't know whether you have it solved or not (probably You have by now), But if you haven't. Usually this problem is related to mapping to the DBs with a Drive mapping or native connection rather than a ODBC connection. This is assuming you have your passwords syncronised, I have all my IIS Servers (Web based) off the Domain, and logged on with a Web password that is mapped to the Database that has another local password that matches the Web Server Password.
(ie, WEbserver: Userid:iuser_web1 Passassword1
Database: Userid:iusr_web1 Passassword1)

If I can Map a Drive to the Database Server, it will carry those authorities over to the ODBC connection, which PSql7 needs to be through a '\\Database\data' Type of mapping)

 

[0408]

Dear smcmanus2001, and others

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 your answer or somebody else post the link.
I dont find your email, so i write here.

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!!

 

[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 TomKane post the link.

I think smcmanus2001's 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!!

 

[Smcmanus2001]

What I have done, is make the users accounts you create all local, local to the Web server, as well as the File Server. If Webserver is WB1 and Files Server is FS1 The User account is IUSR_WS1, make sure you define the account as IUSR_WS1. Under the IIS Connect as Thingy, use IUSR_WS1 not WS1\IUSR_WS1. This is how I have it setup on my system, been workin for a couple of years now.

 

[0408]

i really have done all that as you had did!
the odbc tracing file said the error is as below:

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


please see more info about my question in another post:
thread318-432781

 

[Smcmanus2001]

Well my Official Technical term here is YUK!!. I would say you need to uninstall and reinstall Servicepacks, and then the PSQL Driver. I don't know this particular error, but i would say, you have a Windows Problem, Try the standard stuff, Dll versions, based on path, etc etc.

Maybe someone else has a better idea of this particular problem.

 

[0408]

Service Pack? You mean service pack of what?
windows? or something others?

 

[Smcmanus2001]

I was talking about the Service Pack of Windows NT. SP6a most likely.

 

[0408]

my webserver is win2000 server