VServer list of Databases
Damon Pillinger
daisychain at iinet.net.au
Wed Feb 22 13:23:50 CST 2006
Hi Guys,
Am using this to get a list of databases on the server, it has worked
fine for the past hour but it now stops
vs=new VServer("192.168.0.1","sa","sa")
if vs<>nil then
vs.OpenSession()
listbox1.deleteAllRows
i1=vs.DatabaseCount
MsgBox str(i1)
for i = 1 to i1
dbi=new VDataBaseInfo
dbi = vs.DatabaseInfo( i )
ListBox1.AddRow dbi.Name
next
end if
There are 3 databases according to the i1 variable.
The first database "master" loads the information fine, but when it hits
dbi = vs.DatabaseInfo( i ) where i=2 it just locks up.
Any ideas, I have restarted the server, disabled/enabled the network
connections, deleted the databases and recreated etc...
I don't know if this counts but I had progressed all the way to running
SQL queries on the database/table and it returned weird characters i.e.
should have been 111 but returned 1 surrounded by unknown characters.
Thanks
Best regards
Damon L. Pillinger
Director Daisychain EDi
Suite 3
4 Winston Court
Moorabbin 3189
Phone : +61 3 9532 1220
Fax : +61 3 9532 1280
More information about the Valentina
mailing list