<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:12pt"><font size="2">hello all,<br><br>i have a remote db and a local db but can't seem to access them concurrently.<br>remote db is called 'atc test 3' and accessing it is not a problem.<br>local db is at </font><font size="2">'C:\files\dev\dbLocal\local atc test 3.vdb' ...and accessing it is a problem</font><font size="2"><br><br><br>Private Sub TEST_CONCURRENT_REMOTE_AND_LOCAL()<br><br> Dim conn_Remote As VConnection<br> Dim db_Remote As VDatabase<br> Dim curs_Remote As VCursor<br> <br> Dim db_Local As VDatabase<br> Dim curs_Local As VCursor<br> <br> Valentina.InitClient<br><br> Set conn_Remote = New VConnection<br> conn_Remote.Init
"localhost", "sa", "sa"<br> conn_Remote.Open<br><br> Set db_Remote = New VDatabase<br> db_Remote.InitClient conn_Remote<br> db_Remote.Open "atc test 3"<br><br> Set curs_Remote = db_Remote.SqlSelect("SELECT * FROM Agency")<br> Debug.Print "remote records: " & curs_Remote.RecordCount<br> <br> Set db_Local = New VDatabase<br> db_Local.InitLocal kStorageDefault<br><br></font><font size="2">'// everything works up to this point</font><br><font size="2">'// the local db does exist and is usable...i can open it in non-client mode and in vstudio:</font><br><font size="2">'// i simply can't get the following line to run...it just returns a runtime error:<br><br> db_Local.Open "C:\files\dev\dbLocal\local atc test 3.vdb"<br><br> Set curs_Local =
db_Local.SqlSelect("SELECT * FROM Agency")<br> Debug.Print "local records: " & curs_Local.RecordCount<br>...<br>...<br>End Sub<br><br></font><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><font size="2">i've noodled around with GetLocalConnection but got nowhere.<br>documentation is really sparse and </font><font size="2">i'm stumped...can anyone help me out?<br><br>thanks,<br>george</font><br><br></div></div>
</div></body></html>