Brett Flagg 8.Jan.09 02:37 PM a Web browser LC LSXLC LSX - All ReleasesWindows
Hello!
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"
sqlSource.Connect
Question:
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
goto skip
else
sqlsource.connect
end if
skip:
Any suggestions?
Thanks,
Brett
(i hope I conveyed this correctly)
Return to top
LCConnection connection question (Brett Flagg 8.Jan.09)
. . 
Print this page
