How to link an Access/VB app. to an internet based database

[Winla]

Supposed I have an Access or SQLServer DB with a known IP address on internet, Can I link DIRECTLY my VB or Access desktop program to that database? How? Thx for any idea.

[kb244]

SQL = Yes (just use the IP as the location)
Access = No (you cannot conect to an access DB over the net)

[Winla]

Thank for replying.
I just can't find info about this subject. Could you tell me where I could find more info.?

Can I still use ADO to access a SQLServer through internet? How about speed and security?

Thanks alot

[kb244]

yes you can still access SQL Server thru ADO (since it's accessing it over the net anyways, even thru the DSN) also Security, that depends on how you have SQL Server setup, speed, that also depends on how you have SQL Server setup, but in general, should be pretty secure (using a password) and speed should be very good (compared to access, and others)

I think what you want to look for is setting up a DNS-Less connection, if you cant or dont know how to register a DSN for that SQL on the machine the ADO connection is running from.

[Winla]

here is my connection syntax for ADO

myConnection="Provider=sqloledb; Data Source=server;" & _
"Initial Catalog=pubs; User Id=sa; Password=;"

where to specify that IP address?

Also, if using DSN, for seting up DSN on client machine, I need to specify the server of the DB. Since DB is located on internet, how to specify the server and the DB?

You know, I am talking about link to a DB through internet, not a local network.

thx

[Winla]

kb244, you are right. I have found the right answer from MSDN
Thx.