Desktop application and DB on web server
-
Hi, I'm new in DB programming in .net context and I have a question. If I use a DB in my internet site (es www.mysite.org), I can quering this DB from my desktop application using ADO.net? Thank a lot.
Alex
-
Hi, I'm new in DB programming in .net context and I have a question. If I use a DB in my internet site (es www.mysite.org), I can quering this DB from my desktop application using ADO.net? Thank a lot.
Alex
Yes, as long as the database server can be connected to remotely. If it can't be done that way, you can always create a web service to handle the access, and just connect to the web service instead.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997 -
Hi, I'm new in DB programming in .net context and I have a question. If I use a DB in my internet site (es www.mysite.org), I can quering this DB from my desktop application using ADO.net? Thank a lot.
Alex
-
Yes, as long as the database server can be connected to remotely. If it can't be done that way, you can always create a web service to handle the access, and just connect to the web service instead.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997My 5! Good answer since it's most likely that the webserver is behind a firewall. A webservice is a good and viable solution.
-
Hi, I'm new in DB programming in .net context and I have a question. If I use a DB in my internet site (es www.mysite.org), I can quering this DB from my desktop application using ADO.net? Thank a lot.
Alex
I second (third?) a Web Service. But I question the need to query from the client side. You'll have to be very wary of SQL injection, but you can probably minimize the risks.
