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: Default DataSource and InitialCatalog

Lou
Posts: 81

Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:04 PM

v7

When SalesLogix is initially installed, what are the default values for DataSource and InitialCatalog? Is there a procedure that can get these values for any computer that is used?

Just let me know if more details are needed.

Thanks in advance!
Lou

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:14 PM

Take a look here: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=55

"Data Source" specifies the host name or IP address of the SalesLogix Server.

"Initial Catalog" is a valid alias/connection that has been configured in the Connection Manager on the SalesLogix Server.

[Reply][Quote]

Lou
Posts: 81

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:23 PM

Thanks for the speedy reply, Ryan!

I had already reviewed that same document. Getting these values is no problem on the local network. I need to know how to get these values when they are unknown.

Thanks!

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:26 PM

There is no way to get them if they are unknown (without asking the user) since there could be several SLX servers on a network, and each could have several connections defined on them.

You can create a login screen and present the possible servers and connections a user could choose from. For this info see here: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=57

Is that what you are after?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:28 PM

If you have a scenario where the SLX client will be running you can use COM to get the connection details (but the client *must* be running to do so). For an example of this look here: http://saleslogixblog.com/rfarley/archive/2005/05/25/2856.aspx

[Reply][Quote]

Lou
Posts: 81

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:43 PM

What about the default values for the connection to the EVAL database? No tricks to get that?

[Reply][Quote]

Lou
Posts: 81

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:47 PM

Wait...I think found what I needed in the link for building login screens. Thanks, Ryan!

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:48 PM

No. Like I said, there could possibly be several SLX servers on a network. Which one should it give you?

Any of those SLX servers may or may not have an eval, and the database might not even be named eval.

What exactly are you after? What's the scenario of what you're trying to accomplish? Maybe there is some other route I could offer you.

[Reply][Quote]

Lou
Posts: 81

Re: Default DataSource and InitialCatalog Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 07 4:58 PM

I thought there may be a default location when SalesLogix is installed. I used EVAL as an example. It makes sense, though that there could be several different servers and aliases. The link you gave me to the documentation for building a login screen was VERY helpful. It identified the stored procedures for listing the available servers and aliases.

Thanks!

[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): 11/22/2024 8:39:14 PM