Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

connect to Paradox 5.0

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  Creating a DSN via odbc - But do i need one at al..  
Author Message
Julia Chen

External


Since: Jun 07, 2004
Posts: 1



(Msg. 1) Posted: Mon Jun 07, 2004 5:47 pm
Post subject: connect to Paradox 5.0
Archived from groups: microsoft>public>vb>database>odbc (more info?)

Hi,


I try to connect to a paradox database called contact.db
here is my code

<% @language=VBscript %>
<%

set adoConn=Server.CreateObject("ADODB.Connection")

strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\test\contact.db;Extended Properties Settings=Paradox 5.x;"

adoConn.connectionString=strConn
adoConn.Open

sSQL="select * from contact2 where UDF38='Y' and u_lastdate='05/20/2004'"

set reList = adoConn.Execute(sSQL)

%>


However, it has Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.

Please help...

JC

 >> Stay informed about: connect to Paradox 5.0 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to connect - Hi I am in need to work with VB with database as FielMaker 6.0. please assist me to make a connection string for connecting Vb to Filemaker6.0 please provide the connection string. thanks in advance Yoshitha

Change connect string for Excel Queries using an ODBC Driver - Reference: ODBC Connection for MAS90 MAS200 In Excel we have an ODBC Connection String with a physical (hard coded) path to the data. We have changed the servers. We do not want to recreate all of the queries. How can we edit the ODBC path inside of..

HOWTO: Clone SQL db ? - Hi all, I'm having a SQL Server database called X. For testing and training, I would like to make a copy of the entire DB to Y. This copy should include all data, properties, indexes, views, etc. Unfortunately, all my attempts to automate this..

ISA 2006 with My sql Connection - Hi, Please help me,acutually I am facing problem with ISA 2006.It does not connect Mysql data base. It is giving error"Can't connect to Mysql server on "IP" 10060."

Compile Error - Can anyone please help me to solve this problem I have when I tried to compile and run my program written in VB 6.0? Problem: I used variable declaration such as db as Database and ws as Workspace. I use ODBC way to connect my VB form interface with....
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]