Edit: You can always go to Connection Strings to check out what you might need.
If that still doesnt connect Id double check your driver name and that your access to your server is fully qualified. As we are under Office 365 business category and very less knowledge for string or VBA code and I’m help you to move your thread into Microsoft programming category for further dedicated help. I think the ODBC reference is peculiar to connections linked internally within Access and its not something I see in vb/vba using ADODB. This connection method allows PivotTable® Service to tunnel through firewalls or proxy servers to the Analysis server. Since, the ODBC driver connection value is usually used in the VBA code so the VBA could connect to the DB without asking for permission.
Hi, The connection string used in the VBA code could be incorrect (using 'SERVER' instead of 'HOST'), it should most probably be either something like: sConnStr = "DRIVER= HOST=localhost PORT=12345 DB=sports2000 UID=sysprogress PWD=sysprogress DIL=0" (for an ODBC connection without DSN defined as shown in the example VBA code provided) or sConnStr = "DSN=sports2000 Uid=sysprogress Pwd=sysprogress " (for an ODBC connection with a DSN defined in %windir%\system32\odbcad32.exe or %windir%\syswow64\odbcad32.exe) If you test the ODBC connection string from outside of the VBA code of your MS Access application using the instruction from the following article I wrote on: /./how-to-test-an-odbc-connection-dsn-on-windows-using-powershell are you then able to connect to the OpenEdge 10.2B database? Also MS Access exist in both a 32 and 64 bit version and will need to use the matching 32 or 64 bit OpenEdge ODBC driver to be able to connect to the OpenEdge database. This feature enables a client application to connect to an Analysis server through Microsoft® Internet Information Services (IIS) by specifying a URL in the Data Source property in the client applications connection string. Excel 2010 DSN-less connection to SQL Server.