9/13/2025 11:27:16 AM
|
| |
| 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!
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
Can you query SLX DB with standard ADODB.Connection?
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? |
|
|
|
Re: Can you query SLX DB with standard ADODB.Connection?
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. |
|
|
|
Re: Can you query SLX DB with standard ADODB.Connection?
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. |
|
|
| |
|
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!
|
|
|
|
|
|
|
|