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!

External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Accessing slx_DBIDs from a remote Linux server

John Mark
Posts: 2

Accessing slx_DBIDs from a remote Linux server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Nov 06 9:25 PM

Our application uses PHP in Linux platform but have saleslogix in a different server in Windows platform. Is there a way I can access slx_DBIDs remotely using PHP on Linux. If this is not possible, can this procedure be implemented as a stored procedure in SQL Server?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Accessing slx_DBIDs from a remote Linux server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Nov 06 12:33 AM

Quote:

Originally posted by John Mark

Is there a way I can access slx_DBIDs remotely using PHP on Linux?

No. Not possible. You have to have the OLE DB Provider installed to use it. It won't work in a Linux environment.

Quote:

Originally posted by John Mark

can this procedure be implemented as a stored procedure in SQL Server?

Not really. The procedure is implemented in the SLX OLE DB Provider only. It is not a "real" function or procedure in the database. So, it is only available for use in a connection using the SLX provider. The answer here is no, you cannot call it from a SQL proc. However, you can use OLE objects in T-SQL, so you could use sp_OACreate to create an ADODB.Connection & ADODB.Recordset to call the slx_dbids proc inside a SQL proc. However, not the best idea IMO.

What I would suggest is to create a webservice on a Windows box that can make the calls to the slx_dbids proc (and other SLX functions as well) and pass results back to the PHP app on the Linux box.

-Ryan

[Reply][Quote]

John Mark
Posts: 2

Re: Accessing slx_DBIDs from a remote Linux server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Nov 06 12:38 PM

Thanks Ryan for your reply

[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): 10/31/2024 8:06:24 PM