My Assistant
![]() ![]() |
|
|
Mar 15 2012, 08:57 AM
Post
#1
|
|
|
New Member Posts: 2 |
Sure could use some advice for an Access Project using a SQL Server. I'm using Strategy to query a JD Edwards Enterprise One database (AS400). The Strategy program uses a an ODBC connection. The System DSN driver for this is "IBM ShowCase IBM i Driver". Currently, I run the Strategy query (filename.DBQ), save it as an Excel Spreadsheet, and then connect Access to the spreadsheet. Lengthy process. When I try to link through ODBC connection in Access, I get a message "Cannot issue a license. The MSACCESS application is not a registered Showcase appliction". Does anyone know a connection string to connect to the IBM ShowCase IBM i Driver? Information required for the driver is Data Source Name:, IBM i IP Address:, TCP Port:, Login, Password and Library. Thanks
|
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 21st May 2013 - 01:47 AM |