Printable View
Ok... I am trying to get my database skills going... What I would like to do is connect to my database through code... but here is the catch..
I have my database on a web server..
How do I use code to connect to the database on a remote server? Would some kind soul out there give me an example how to connect to the database through code and display data?? Please comment heavily so I can see what each action is for?
Thanks in advance.
Anjari
what kind of database. If it is Access, you cant do that as far as I know.
yea it's an access database... but its not 100% necessary to use access....
Anjari
Use a server based database such as SQL Server or MySQL.
MySQL is free and is very similar to SQL server, so I would suggest using that.
Once you do that it is as simple as setting up a connection string in your database. This link from MySQL.com has all of the information you need to connect to a MySQL database:
http://www.mysql.com/articles/dotnet/
why not build a webservice that sits with the remote database and you just call methods on the webservice which querys the db and returns you dataset
I have used this approach often its really nice and not too much slower
Could you explain a little more?
Thanks,
Anjari