Database question

  • Thread starter Thread starter Bart Schelkens
  • Start date Start date
B

Bart Schelkens

Hi,

It might be a stupid question. If so then please tell me.

I have a website that is linked with a database.
Both are on the providers servers.

I also have a .Net-application (Winforms) that will have to use the same
database.

Is it possible to link my .Net-application (Winforms) with the database on
my providers servers?
If so, how can I do this?

Thanks.
 
I wouldn't say it is a stupid question :-) I would say it is a strange
question! Theoretically YES it is possible, how? it depends on what you
have!
Kind of database, how to connect to it ... and stuff like that. There is no
difference between connecting to a database through a WEB application or
through a normal Win application, both use the same connection technique ..

Regards,

Veszko
 
Well I'm using a Access-database (.mdb)
So how would i connect both my applications to the database on the hosting
server ?

See the reason i'm asking is that i'm rewriting an VB6 application, that had
a special module to synchronise a local database with the database on the
hosting server.

I would like to try it without the synchronisation. That's why i would like
them to connect both to the database on the hosting server.
 
I'll certainly read it
So this would be the way to connect a local winforms-application with a
database on a hosting server that is connected to an Access-database?
 
Yes, this is possible. No, it's not a particularly good idea. When you
access a web-based JET database (Access .mdb) all of the physical IO goes
over the web. Even when you access it over the LAN, it's still a (serious)
potential point of failure. It would be far safer to use MSDE.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
 
Hi Bill,
Yes, this is possible. No, it's not a particularly good idea. When you
access a web-based JET database (Access .mdb) all of the physical IO goes
over the web. Even when you access it over the LAN, it's still a (serious)
potential point of failure. It would be far safer to use MSDE.
Click to expand...

With a webservice as I adviced in this thread? Only the dataset goes over
the Web.

I am quite sure you did not read the whole thread, however I could not
resist to message this.

:-)

Cor
 
Ah yes...
But running an Access database on a web server... THAT's a problem unless
you don't care about performance, reliability or security.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
 
Back
Top