UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Connecting Access To Ibm Showcase Strategy Query    
 
   
bryan1671
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 01:47 AM

Tag cloud: