Brett Flagg 8.Jan.09 02:37 PM a Web browser LC LSX LC LSX - All Releases Windows
I have a script that queries for employee information on a SQL Server .. using oleDB...
This simple connect stuff is where I'm at:
Dim sqlSource As New LCConnection ("oledb")
Dim sqlSource_FieldList As New LCFieldList
sqlSource.provider = "sqloledb"
sqlSource.init_datasource = "etrav-hack"
sqlSource.Userid = "UserID"
sqlSource.Password = "UserIDPwd"
sqlSource.init_catalog = "Qcrr"
sqlSource.metadata = "employee_information"
How can I determine if the sqlSource.Connect is active or not?
I call this public subroutine from another function and I'm connectiong and reconnecting to sql on every interation of the loop.
I think it would be great if I can say something like..
if sqlSource.connect = True then
(i hope I conveyed this correctly)