Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Nickel Contributor
Posts: 56
Registered: ‎03-26-2009

Using MS Access to read SLX data

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?

 

thanks

 

ws

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Using MS Access to read SLX data

You were trying to use the linked server approach?

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Nickel Contributor
Posts: 56
Registered: ‎03-26-2009

Re: Using MS Access to read SLX data

This would be Access attaching SalesLogix as an external data source

 

ws

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Using MS Access to read SLX data

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.

 

;-)

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Nickel Contributor
Posts: 56
Registered: ‎03-26-2009

Re: Using MS Access to read SLX data

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?

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Using MS Access to read SLX data

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.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html