×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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!!

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

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.
http://www.mirtheil.com

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

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close