Trouble Establishing a Connection in SalesLogix Using ADO Instead of Application.GetNewConnection

Question: I can’t seem to get a connection to work in SalesLogix when I don’t use Application.GetNewConnection

Sub UpdateScores()
Dim Conn
Dim ConnString

ConnString = “Provider=SLXOLEDB.1;Data Source=servername;Initial Catalog=dbname;…etc…”

Conn = CreateObject(“ADODB.

Connection”)
Conn.Open ConnString

‘…rest of sub…
End Sub

My “Conn” is always set to an empty string on the CreateObject line above which is a problem.  Why is this happening?

 
Answer: So your conn is a null or empty object?  The code you are using needs to “set” the object reference when you use CreateObject.

Set
Conn = CreateObject(“ADODB.Connection”)

Conn.Open ConnString

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!