Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]Gen

Status
Not open for further replies.
memo13cr

memo13cr

Technical User
Apr 11, 2005
8
US
I work with Persasive 7.5 and ASP, the last week it was working, but i have some days that out this error:
I have this error Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]General error.

This is my code:
<%@ Language=VBScript %>
<html>
<head>
<body>

<%


Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DRIVER={Pervasive Software ODBC-32};DATAPATH=R:\MACOLA75\DATA;DDFPATH=R:\MACOLA75\DATA"
objConn.Open
mySQL = "Select ITEM_NO FROM IMINVLOC_SQL"
set rstemp = Conn.Execute(mySQL)

%>
<table border="1" width="66%" height="26">

<td width="27%" height="20">&nbsp;<%=RStemp("ITEM_NO")%></td>
<%
rstemp.close
objConn.Close

%>
</body>
<html>



I need you help please!!
 
Sort by date Sort by votes
The connection string you have (objConn.ConnectionString = "DRIVER={Pervasive Software ODBC-32};DATAPATH=R:\MACOLA75\DATA;DDFPATH=R:\MACOLA75\DATA") is not correct for PSQL 7.5. You need one like:
objConn.ConnectionString = "DRIVER={Pervasive ODBC Client Interface};ServerDSN=<ServerEngineDSN>;ServerName=<ServerName>"

You might also try using an actual DSN like:
objConn.ConnectionString = "DSN=ClientDSNName"

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
 
Upvote 0 Downvote
Hi Thanks for your replay, Already this working in the server, but in the moment i want to enter from mi pc win 2000 pro, show me this error:
I have this error Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]General error.

Why in the server where already this working, and the clien not working??

Thanks for you help
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
DDF Builder for Actian fka Pervasive SQL
Replies
3
Views
314
mirtheil
mirtheil
ianbtheog
  • Locked
  • Question
Connection Manager is not running at the specified port number - Pervasive 13.31.014 - Intermittent
Replies
2
Views
316
ianbtheog
ianbtheog
profoundhypnotic
  • Locked
  • Question
How to read a csv file in Pervasive?
Replies
1
Views
318
mirtheil
mirtheil
michellepace
  • Locked
  • Question
Source control for pervasive? (git)
Replies
1
Views
209
mirtheil
mirtheil
Ambientguitar
  • Locked
  • Question
Need help opening a Pervasive Database or BTR files
Replies
3
Views
344
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top