[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: DSN - less ODBC connection to DB via MS Access DAO

  • Thread starter Thread starter 121steuart
  • Start date Start date
Status
Not open for further replies.
1

121steuart

Guest
Now I get this error: Reserved error (-7778); there is no message for this error. After Googling the error I have compacted and repaired the DB and made sure the linked table has an index. I made sure the driver name below is connected to the correct dll (in the ODBC interface, driver tab). Here's my latest code: Dim dbs As DAO.Database Dim tdf As TableDef Dim sConnStr As String Dim bRefreshLinks As Boolean Set dbs = CurrentDb bRefreshLinks = False sConnStr = "DRIVER={Progress OpenEdge 10.2B Driver};HOST=jcffims01;PORT=2600;DB=found;UID=sysprogress;PWD=password;DIL=0" For Each tdf In dbs.TableDefs If Left$(tdf.Name, 5) = "FOUND" Then Set tdf = dbs.TableDefs(tdf.Name) tdf.Connect = sConnStr tdf.RefreshLink ' Relink the table. If Err <> 0 Then bRefreshLinks = False Exit Function End If End If Next td f

Continue reading...
 
Status
Not open for further replies.
Back
Top