Dim connect As New LCConnection ("odbc2") ' set the appropriate properties to connect to odbc2 ' note the use of dynamic properties to do this ' all properties of a connection may be referenced ' by name connect.Database = "Northwind" connect.Userid = "user id here" connect.Password = "pwd here" REM try the connect connect.Connect Print "Successfully connected to ODBC2." End Sub
How can I successfully use LSX code to connect to SQL Server 2000?
It should connect.
I've been writing LC-LSX code since 1998, and I'm still not sure of all the correct properties for the various connectors. To see what the field names are for a particular connector, I look at the DECS or LEI connection form in Designer. Most often, the field names used on the Connection Document form have the same names as the properties used by the LC-LSX.
Do you have comments on this Ask the Expert question and response? Let us know.
This was first published in June 2004