Connect to Paradox database from VB.
It is necessary to me to work with a database 'Paradox' from VB 6.0 and ADO.
What connection string me need for it?
What connection string me need for it?
Asked:
Who is Participating?
Here is the link to
Paradox Driver Programming Considerations:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetparadox_driver_programming_considerations.asp
Paradox Driver Programming Considerations:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetparadox_driver_programming_considerations.asp
Courtesy of Dave_Greene
ADO Connection Strings
http://www.able-consulting.com/ADO_Conn.htm#RDSConnectProperty
ODBC Driver for Paradox
oConn.Open "Driver={Microsoft Paradox Driver (*.db)};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbq=c:\dbpath\;" & _
"CollatingSequence=ASCII;"
ADO Connection Strings
http://www.able-consulting.com/ADO_Conn.htm#RDSConnectProperty
ODBC Driver for Paradox
oConn.Open "Driver={Microsoft Paradox Driver (*.db)};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbq=c:\dbpath\;" & _
"CollatingSequence=ASCII;"
For the jet Engine use:
<----- Code Begin ----->
Sub OpenParadox(strDBPath As String)
Dim cnnDB As ADODB.Connection
Set cnnDB = New ADODB.Connection
' Specify Paradox by using the Extended Properties
' Paradox 3.x
' Paradox 4.x
' Paradox 5.x
With cnnDB
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Extended Properties") = "Paradox 5.x"
.Open strDBPath
Debug.Print .ConnectionString
.Close
End With
Set cnnDB = Nothing
End Sub
<----- Code Begin ----->
<----- Code Begin ----->
Sub OpenParadox(strDBPath As String)
Dim cnnDB As ADODB.Connection
Set cnnDB = New ADODB.Connection
' Specify Paradox by using the Extended Properties
' Paradox 3.x
' Paradox 4.x
' Paradox 5.x
With cnnDB
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Extended Properties") = "Paradox 5.x"
.Open strDBPath
Debug.Print .ConnectionString
.Close
End With
Set cnnDB = Nothing
End Sub
<----- Code Begin ----->
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month11 days, 2 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
http://www.able-consulting.com/ADO_Conn.htm
ODBC Driver for Paradox
oConn.Open "Driver={Microsoft Paradox Driver (*.db)};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbq=c:\dbpath\;" & _
"CollatingSequence=ASCII;"
Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update Paradox ISAM fDBF files. (Q230126).
For more information, see: Paradox Driver Programming Considerations