Connecting to Paradox Table using ASP
I have been looking all over for working connection strings and recordset coding to connect ASP with Paradox. Can someone help me here please?
[u]Here is my latest code:</u>
Dim oConn 'Connection Object
Dim cmdDC 'Command Object
Dim rsTest ' Recordset
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open = "Driver={Microsoft Paradox Driver (*.db )}; DriverID=538; Fil=Paradox 5.X; DefaultDir=" & Server.Mappath("../Paradox") & "; Dbq=" & Server.Mappath("../Paradox") & "; CollatingSequence=ASCII"
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = oConn
cmdDC.CommandText = "SELECT CompanyName FROM Customer"
cmdDC.CommandType = 1
SET rsTest = Server.CreateObject("ADODB.Recordset")
rsTest.Open cmdDC, , 0, 1
[u]This is the latest error I have been getting:</u>
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Paradox Driver] External table is not in the expected format.
All I need is some kind of code that will allow me to view what is inside the Customer.db file.
|