ADO - Remote Databases - SQL Server

[Mc Brain]

How do you do to connect to a SQL Server through Internet. I mean, I'm connecting to the server through ADO with some code, part of which is posted beneath:


Set mCN = New ADODB.Connection
With mCN
.ConnectionString = "driver={SQL Server};uid=sa;server=cedi_acad_adm;database=Books"
.CursorLocation = adUseClient
.Open
End With


However, I'm wondering whether there's a way to connect to it through Internet. What I want to do is to be able to perfom queries from home also, not only at work.

[Mc Brain]

oh, com'on... 17 views, and no replies? Am I asking something impossible? or It's possible but just don't know how to do it?

[kovan]

its bad idea to use an application (vb) to connect remotely
infact its VERY bad, cus its slow..

if you want to have internet databases
you use asp(vb script and ado)

[Mc Brain]

that slow? But is there any way to connect to the server so I could "see" if it worth or not?

[kovan]

not sure.... but
you can try RDO..
dont know much about it thou..