hello,

my problem is one connection type works & one does not...

using vb6:

this connection works...
con.Open "PROVIDER=MSDASQL;DSN=MyDsn"

this connection does not...
con.Open "Provider=PervasiveOLEDB;Data Source=MyDsn"

it has the following error msg: "unable to connect to the relational engine, is database name and server available?"

any suggestions are appreciated.

also, which is faster, odbc or oledb?

thanks

First, the OLEDB connection should actually be:
con.Open "Provider=PervasiveOLEDB;Data Source=MyDatabaseName"
and if it's on a remote server, it should be:
con.Open "Provider=PervasiveOLEDB;Data Source=MyServerDatabaseName;Location=MyServer"

Second, neither is faster. Both go to the same mechanism on the engine (the relational engine). So, while ODBC may be a little faster to connect, running queries should be the same.
Note: This is for V8. For P.SQL 2000i, ODBC is faster than OLEDB because OLEDB parses the SQL statement on the local machine and only sends MKDE calls to the server. THis means that for 2000i, ODBC is faster because the SQL queries are handled at the server for ODBC but not for OLEDB.

thanks again