how do i connect to a remote database

30 Dec 2005 10:51 PM

Gerlop

i have a website that i use to file all my clients information, the go online
and they type the information. i'm using an microsoft access database. Now,
i want to create a windows application that i can run whenever a want to
transfer the new information that is on my website database to my local sql
server database. I just want to know how do i make a connection to the
database onlie using visual studio .net 2005 or if you have another option
please let me know.

Thanks.

31 Dec 2005 2:36 AM

William (Bill) Vaughn

Why not use a SQL Server database instead of JET/Access on the server? It
(JET) is not (was never) designed to be used on a server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote

"Gerlop" <Ger***@discussions.microsoft.com> wrote in message
news:F65A4EF0-863F-4566-AFB3-224AA6051389@microsoft.com...
>i have a website that i use to file all my clients information, the go
>online
> and they type the information. i'm using an microsoft access database.
> Now,
> i want to create a windows application that i can run whenever a want to
> transfer the new information that is on my website database to my local
> sql
> server database. I just want to know how do i make a connection to the
> database onlie using visual studio .net 2005 or if you have another option
> please let me know.
>
> Thanks.

31 Dec 2005 8:59 AM

Cor Ligthert [MVP]

Gerlop,

Create a webservice to get the information.

I hope this helps,

Cor

3 Jan 2006 5:47 PM

Paul Clement

On Fri, 30 Dec 2005 14:51:02 -0800, Gerlop <Ger***@discussions.microsoft.com> wrote:

¤ i have a website that i use to file all my clients information, the go online
¤ and they type the information. i'm using an microsoft access database. Now,
¤ i want to create a windows application that i can run whenever a want to
¤ transfer the new information that is on my website database to my local sql
¤ server database. I just want to know how do i make a connection to the
¤ database onlie using visual studio .net 2005 or if you have another option
¤ please let me know.

Do you have access to the file through the network or only HTTP?

Paul
~~~~
Microsoft MVP (Visual Basic)