11/22/2024 8:51:28 PM
|
| |
| 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 using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Finding SalesLogix Servers on network
Posted: 05 Mar 08 1:55 PM
|
I am using SalesLogix version 7.0.1. This used to work, but I'm not sure if it ever ran with this version of SalesLogix. Is there another way to do this now?
Private Sub SLXLogin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Form will timout and produce error after 10 minutes
Dim tmrTimeOut As New System.Timers.Timer(3600000)
tmrTimeOut.Start()
' Define Event for Timer elapsing
AddHandler tmrTimeOut.Elapsed, AddressOf OnTick
Me.CenterToScreen()
Dim szSql As String
' Use no_alias connection string to find all SLXServers
Dim conSLX As New OleDbConnection("Provider=SLXOLEDB.1;Initial Catalog=NO_ALIAS;Extended Properties=PORT=1706;LOG=ON")
Try
' slx_GetServerList is a OLEDB stored procedure supported by the SalesLogix OLEDB Provider
strSql = "slx_GetServerList"
conSLX.Open()
Dim cmdSLXServers As New OleDbCommand(strSql, conSLX)
Dim rdrSLXServers As OleDbDataReader
rdrSLXServers = cmdSLXServers.ExecuteReader(CommandBehavior.Default)
' Add each server to Server combobox
While rdrSLXServers.Read()
cboServers.Items.Add(rdrSLXServers.GetValue(0))
End While
rdrSLXServers.Close()
cmdSLXServers.Dispose()
conSLX.Close()
Catch excSLX As Exception
ErrMsg = excSLX.Message
SendErr()
End Try
End Sub
Now, it gives me only the name of the old server that is still on the network being used as a file server. Thanks |
|
|
|
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!
|
|
|
|
|
|
|
|