Attempting Paradox Connection

C

cpopham

Well-known member
Joined
Feb 18, 2004
Messages
273
I am trying to connect to a Paradox database. There is not a lot of info out there on this. Any help would be appreciated. This is my Code:

Code: 
Dim strCnPaFAPark As String = _
                                     "Driver={Microsoft Paradox Driver (*.db )};" & _
                                     "DriverID=538;" & _
                                     "Fil=Paradox 5.X;" & _
                                     "DefaultDir=C:\Chester\Test_Databases\FaPark.db;" & _
                                     "Dbq=C:\Chester\Test_Databases\FAPark.db;" & _
                                     "CollatingSequence=ASCII"

        Try
             // open the connection to reqtrak_data.mdb
            cnPaFAPark = New Odbc.OdbcConnection(strCnPaFAPark)
            cnPaFAPark.Open()
        Catch ex As Exception
             // if unable to open the connection to FAPark
            MessageBox.Show(ex.Message, "Opening FAPark Connection")
        End Try

When I attempt to connect, I get this a message about making sure the path name is spelled out correctly?

Thanks, Chester
 
Meaning it cant find the database? Is Dbq the right parameter and point to the correct location? and Im assuming DefaultDir should not have a filename.
 
Back
Top