slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: Can you query SLX DB with standard ADODB.Connection?

thepip3r
Posts: 16

Can you query SLX DB with standard ADODB.Connection? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Aug 09 6:15 PM

My DBADM is telling me that you have to have some kind of slx-specific provider to be able to access the SLX database from vbscript. Is this true? Can I not just use a read-only u/n and pw to bind to the server on a specific port and query the DB? ...or in other words, the sqloledb provider will not work?

[Reply][Quote]

Ajmal
Posts: 1

Re: Can you query SLX DB with standard ADODB.Connection? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Aug 09 12:51 AM

This will work , but however it is recommended to use this API to connect to DB while creating,updating records in SalesLogix Database. For Selecting records ordinary ODBC will works charm.

The API takes care of updating necessary related tables, for offline synchronization.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Can you query SLX DB with standard ADODB.Connection? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Aug 09 2:20 AM

It is just a SQL/Oracle database. You can query the data just as you would any SQL/Oracle database. However, using the SLX provider you will have security built in, so the user who's credentials are used to authenticate will only see those records that he/she has access to. This is all for reading from the database only. Once you start talking about updating the database a whole new set of caveats apply.

[Reply][Quote]

thepip3r
Posts: 16

Re: Can you query SLX DB with standard ADODB.Connection? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Aug 09 10:25 AM

Thanks for confirming my suspicions guys.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/19/2024 7:32:46 PM