[VB.NET/SQL] Connecting VB.NET via internet to SQL

[Echos]

Anyone got any idea how to connect a VB.net proggy to a SQL database.

so far iv got this.

Dim Connection as New SqlConnection("Intial Cataloge=Mir2; User ID=sa; Password=*****; Host=(local); Network Address=***.***.***.***;")

Now that works if the proggy is on the same pc as the sql DB. but wont work across the net... even if its on the same network.

Thanks in advance

 

[Raul_haro]

Re: Connecting VB.NET via internet to SQL

I'm pretty sure that yo can't but idk... if anytone can prove me wrong i'll stand corrected

 

[DeathArt]

Now that works if the proggy is on the same pc as the sql DB. but wont work across the net... even if its on the same network.

*cough* Host=(local); *cough*
Database Source Name - Wikipedia, the free encyclopedia

Raul_haro: You fail.

However, the server you're connecting to MUST accept outside connections ! Standard config is internal connections only.