I receive the following error when trying to connect to a Pervasive
database through ODBC:

ERROR [08S01] [Pervasive][Pervasive ODBC Client Interface][Pervasive
ODBC Client Interface][Pervasive ODBC Client Interface LNA]No available



transport protocol for the Pervasive Network Services Layer.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested
(see SQLSetEnvAttr).


The application is working fine on my development machine (windows XP
with IIS 5.0 and .NET framework 2) and doesn't work on my web server
(windows server 2003 web edition with IIS 6.0 and .NET framework 2)


Any ideas?

This error indicates that the Pervasive client is trying to connect to
the database server, and it can't seem to find it, or communications
doesn't work. Verify that you can PING the database server by name
from the web server -- if this fails, then you won't have connectivity
at all.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 10/2006 ***

jan82 wrote:

Hi Bill

I can perfectly ping the database server from the client (webserver in
this case). The weird thing is that I can execute SQL queries on the
datasource on the webserver. The connection seems to work. Only my
web applications return this error, while they DO work on my
development machine. My development machine runs win XP and connects
to the database seemlessly. When I run the PSA, all tests succeed,
except for the "relational" database test. This returns the same
error.

Greetz!

Jan

Bill Bach schreef:

Hi Jan,

This is a wild guess: Could this be a firewall issue on the webserver?
The default TCP/IP port for the Pervasive Relational Engine is 1583.
Check your configuration to see what it's currently set at, then check
to see that it's open through your webserver firewall. Or,
alternatively, set the PSQL TCP/IP port to one that is open.

Wayne
Analytica Business Systems, Inc.
www.analyticabiz.com
waynef at theabovedomain dot com
Subscribe to our Pervasive News Feed at:
http://www.analyticabiz.com/rss20.php


jan82 ha scritto:

Hi Wayne

When I change the port number, I get a timeout. So I guess the port is
open on the webserver, and the communication succeeds. But still the
same error...

Wayne schreef:

How about trying to bypass ODBC? Use ADO instead, since the app is
running under IIS. Use a connection string like this:

Provider=PervasiveOLEDB;Server=<server>;Data Source=<Server DSN>;User
ID=<youruserid>;Password=<password>

jan82 ha scritto: