Colibri/Btrieve Database Access

[Mighty]

Hi,

I am new to the list and have an ODBC conenction question. I have set up a System DSN on my machine to a remote Btrieve database. I am using Colibri ODBC for btrieve to make the connection. I am trying to access a table from this database through an asp page running on PWS on my local machine ( NT Workstation ). Howver, the page always times out.

Does anybody out there know what I have to do to get this working??

Mighty

 

[Swany]

I've only used the Pervasive ODBC driver for B-Trieve access, but the details should be the same. Make sure you can access the database via Microsoft Access using the ODBC driver. Also make sure you have MDAC 2.5 or 2.6 installed.

<%
set db = server.createobject(&quot;ADODB.connection&quot
set rs = server.createobject(&quot;ADODB.recordset&quot

db.open &quot;dsn=BTtrieveDSN;uid=user;pwd=pass&quot;

rs.open &quot;select * from mytable&quot;

rs.close

db.close

%>