Connecting remote database

[NagaKiran]

Hi

I need a help.
I have a VB code
In that I want to connect to a remote database thru VB
code.

Can we connect a Access database which is located in a web
server thru VB?
If so how can we connect?

If not, Can we connect a SQL server database which is
located in a web server thru VB?
If so how can we connect?

please provide code or any URL that helps to know about
it...

Thanks in advance

bye

 

[ciruliz ciruliz]

You can use .udl file to specify connection information (create blank
text file & name it blablabla.udl, then view properties)
and in VB use `connection string` property of ADODB.Connection
set it to "FILE NAME=X:\some path\blabla.udl"