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: Gettling of SQL Servers using SalesLogix names

Chris Erichson
Posts: 9

Gettling of SQL Servers using SalesLogix names Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Sep 06 10:54 AM

I am trying to develop a reuseable .NET form to generate a SQL Connection string. I know that I can send a broadcast packet out to get a list of SQL Servers on the local network. I expect that if I sent out this packet , I would only get the SQL server instance names. Does anyone have any experience trying to get the SLX server instance name from the local network?

[Reply][Quote]

Snow Monkey
Posts: 214

Re: Gettling of SQL Servers using SalesLogix names Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Sep 06 11:55 AM

Query the local provider and use slx_GetServerList() stored proc to get the list of slx server on the network.

But this used to have a problem in slx 6.1 - when this is executed the broadcast generated may not pass thru subnets and will only list the server in your own subnet i guess.Dont know whether this problem vanished now with slx 6.2.4

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Gettling of SQL Servers using SalesLogix names Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Sep 06 12:32 PM

This article will show you exactly what you need:
http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=57

-Ryan

[Reply][Quote]

Chris Erichson
Posts: 9

Re: Gettling of SQL Servers using SalesLogix names Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Sep 06 2:36 PM

Thanks both of you, I was hoping I would only have to send a packet to another port but this is a great help. Again thanks!

[Reply][Quote]

Jeremy Brayton
Posts: 491

Re: Gettling of SQL Servers using SalesLogix names Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Sep 06 3:10 PM

Quote:

Originally posted by Nandu

But this used to have a problem in slx 6.1 - when this is executed the broadcast generated may not pass thru subnets and will only list the server in your own subnet i guess.Dont know whether this problem vanished now with slx 6.2.4

The "problem" still exists but it's more of a "functioning as designed" sort of thing. You wouldn't want to send this broadcast packet out across the internet or anything, so it pretty much has to stay localized.

If you REALLY needed to get around the limitation, you could create a peer-to-peer type of thing that would query all of the saleslogix servers for each subnet then used something to compile all of them into one big list. A good bit of work for such a little pay off but it seems doable.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Gettling of SQL Servers using SalesLogix names Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Nov 06 8:17 AM

FYI: The reason broadcast packets do not cross subnets has to do with how the router(s) are setup to handle them. There is a function called "bridging" (vrs routing). Most good routers support bridging but you will (probably) never find a good network engineer that will enable bridging since it can cause what is called a "Braodcast Storm" and take down your network and all of your systems. I once saw a 1000 system net go down this way.. evey piece of equipment in tht net (server room and all) had to be shut down and then individually rebooted after thr routers were "fixed". It took 3 days to get everything back running normal. People got fired.... and they deserved it.

--
rjl

[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/26/2024 6:36:21 AM