09-01-2011 07:30 AM
I am working with a company that has an abundance of MS ACCESS 2003 applications and I have created a new SLX customization that they will want to be able to read from. It makes heavy usage of dates, so i really want them to get the data from the OLEDB provider.
I don't see a way to get ACCESS to use SLX via OLEDB - it seems to be limited to ODBC.
So my question is two fold here...
1. Is there a way for MS Access to read SalesLogix data via OLEDB?
2. (if not) Is there a way to set up an ODBC driver to use the SLX provider?
Plan B is to set up a view for them that handles the GMT conversion.
any ideas out there?
09-01-2011 11:29 AM
09-01-2011 01:13 PM
Yep.. I just tested it in Access2007 (Table->Import->ODBC database...) and created a system DSN using the Slx Native Client to a SQL2005 server hosting several SalesLogix db's on my "StarGate" main db server.. from Access in my laptop.
Linked the table(s).. opened them in access.. (did Account/Contact) and did a joined query.
09-01-2011 01:35 PM
When I go to create a system DSN - I don't see SalesLogix as an option.
I can attach via SQL Client, but that is what i am trying to avoid here.
Am I missing something here?
09-01-2011 02:08 PM
You want to "create" a new system DSN as you step thru... and it will let you select SQL server. After it's created, then you can use it.