This works:
dim SQLCN
Sub AXFormChange(Sender)
DIm strCONN
Set sqlCN = CreateObject("ADODB.Connection")
''' objConn.ConnectionString = "FileName=\\EVAW41886\VM\SLX.udl;"
strCONN = "Provider=SQLNCLI.1 assword=masterkeyersist Security Info=True;User ID=SYSDBA;Initial Catalog=DEV722;Data Source=192.168.49.36"
sqlCN.Open strCONN
But is there anyway to find out the SQL Server name and SQL Server database name from WITHIN an SLX Script?
With Production, Staging, Dev, Remote OfficeSSSS, Remote Users this could get hairy.
OK so place .udl files everywhere.....ouch.
Any other suggestions?
Maybe a SQL Table in SLX Maybe an SLX Connection Name could be standardized and I could then figure out if the SLX Server connection contained Prod, Stag, Dev, SLXRemote, slxRemoteOffice kinds of stuff??
Thanks! |