hongjun
asked on
vb connection string needed
How to connect to Paradox 7.0 using VB 6? I am able to connect to other (earlier) versions of Paradox but using odbc but not to 7.0.
hongjun
hongjun
Or you can try this:
connectString = "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=C:\windows\desktop\ ;Extended Properties=Paradox 7.x"
You have to change the datasource obviously
connectString = "Provider=Microsoft.Jet.OL
You have to change the datasource obviously
ASKER
emoreau, the link cater for ver 5.x.
hongjun
hongjun
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sample ADO Connection Code (Never try)
Dim WithEvents adoRS As Recordset
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=MSDASQL;dsn=para dox7;uid=; pwd=;"
Set adoRS = New Recordset
adoRS.Open "select * from kmzd", db, adOpenStatic, adLockOptimistic
Dim WithEvents adoRS As Recordset
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=MSDASQL;dsn=para
Set adoRS = New Recordset
adoRS.Open "select * from kmzd", db, adOpenStatic, adLockOptimistic
<ping..>
ASKER
Experts, I am asking this question on behalf of a friend. Still waiting for her to give any reply. Her question is here https://www.experts-exchange.com/questions/20308837/Read-a-Paradox-file-urgent-pls-help.html
hongjun
hongjun
With mdac 2.6 you can read tables but not write to them. Maybe MDAC 2.7 from http://www.microsoft.com/data is better.