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

[121steuart]

I am creating an MS Access application that will be run off-hours, no human intervention needed. Here's the code I'm using to open and test the connection. Dim dbs As DAO.Database Dim sConnStr As String Dim qdf As DAO.QueryDef sConnStr = "ODBC;Driver={Progress OpenEdge 10.2B Driver};SERVER=JCFFIMS01;DATABASE=FOUND;UID=sysprogress;PWD=password" Set dbs = CurrentDb Set qdf = dbs.CreateQueryDef("") qdf.Connect = sConnStr 'actual driver file name pgoe1025.dll qdf.SQL = "SELECT * from FOUND_sql_Fund_Rep" qdf.ReturnsRecords = False qdf.Execute dbFailOnError When I run this code I receive an error message that states: "ODBC--connection to 'FoundSQL92' failed." The application will be querying many tables in the progress db, not just the one indicated in the test query. I am using MS Access 2016 Progress DB version 10.2B

Continue reading...