Remote data access

[John C.]

As a new .net developer, I would like to know how a
VB.net Windows application can access a SQL Server
database residing on a web server.

In other words, using the Visual Studio IDE, is there a
way to develop a Visual Basic, Windows application that
can access a SQL Server database over the internet.

Thanks for suggestions,

John C.

[Oleg Tkachenko]

John C. wrote:

As a new .net developer, I would like to know how a
VB.net Windows application can access a SQL Server
database residing on a web server.

In other words, using the Visual Studio IDE, is there a
way to develop a Visual Basic, Windows application that
can access a SQL Server database over the internet.

That's not really good idea to make SQL Server accesible directly from
internet. Instead you can develop simple Web Application, which accepts your
requests, inqueries SQL server and returns results. In .NET it can be done
easily using ASP.NET.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Dino Chiesa [Microsoft]]

Exactly right, Oleg!

On the other hand,
it is possible to connect directly, if that is what you really want to do.

You need the SQL port to be open, typically 1433.
And when you specify the connection, you specify the IP or fully-qualified
host name of the target sql server.
Everything else is the same as if you were building a vb.net app that
connects to a local sql server.

On the other, other hand,
this newsgroup is for XML questions. There is a group dedicated to ado.NET
:
microsoft.public.dotnet.framework.adonet
--
----
Dino Chiesa
Microsoft Developer Division
d i n o c h @ o n l i n e . m i c r o s o f t . c o m

"Oleg Tkachenko" <oleg@NO_SPAM_PLEASEtkachenko.com> wrote in message
news:ut**************@tk2msftngp13.phx.gbl...

John C. wrote:

As a new .net developer, I would like to know how a
VB.net Windows application can access a SQL Server
database residing on a web server.

In other words, using the Visual Studio IDE, is there a
way to develop a Visual Basic, Windows application that
can access a SQL Server database over the internet.
That's not really good idea to make SQL Server accesible directly from
internet. Instead you can develop simple Web Application, which accepts

your requests, inqueries SQL server and returns results. In .NET it can be done
easily using ASP.NET.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel