Database Dilemma [modified]
-
hi, I would like to build a Webapplication usin ASP.net through VisualStudio Express. However my host does not support the .mdf database files. Basically i have three options: Set up an ODBC to an Access Database file for free, or Order a Fullblown MS SQL-Server 2005 wich (beeing a Student with little money) would cost money id rather not spend. Finnaly I could also use a MySQL Database for free, but it does not integrate into the VS IDE at all (as far as i know) This new site will replace an old one, wich over the course of the last few years got an average of about 850page views per day. so what should i do? ~Luke -- modified at 9:15 Monday 17th July, 2006
-
hi, I would like to build a Webapplication usin ASP.net through VisualStudio Express. However my host does not support the .mdf database files. Basically i have three options: Set up an ODBC to an Access Database file for free, or Order a Fullblown MS SQL-Server 2005 wich (beeing a Student with little money) would cost money id rather not spend. Finnaly I could also use a MySQL Database for free, but it does not integrate into the VS IDE at all (as far as i know) This new site will replace an old one, wich over the course of the last few years got an average of about 850page views per day. so what should i do? ~Luke -- modified at 9:15 Monday 17th July, 2006
You could change to a host with Sql Server or see if yours has an add on. -- modified at 9:50 Monday 17th July, 2006
-
You could change to a host with Sql Server or see if yours has an add on. -- modified at 9:50 Monday 17th July, 2006
-
but again they want money for it.... i guess the question is rather: Could i use Access? If not, how hard is it to work with MySQL
Why not use SQL 2005 Express? It integrates with the express studios just fine and it doesn't limit you in your programming capabilities. The limitations with SQL 2005 Express are some advanced Database server features, concurrent database access and database size limitation (4GB if I'm not mistaken, I'm certain that on MSDE it was 2GB, but not sure with SQL 2005 Express). MySql is a good option. I've used it and works great with the .net connector found in www.mysql.com. MySql is just a bit different compared to MS SQL (Sql queries change a bit), there are some differences in data types, but they all translate fine to .net through the connector. daniero
-
Why not use SQL 2005 Express? It integrates with the express studios just fine and it doesn't limit you in your programming capabilities. The limitations with SQL 2005 Express are some advanced Database server features, concurrent database access and database size limitation (4GB if I'm not mistaken, I'm certain that on MSDE it was 2GB, but not sure with SQL 2005 Express). MySql is a good option. I've used it and works great with the .net connector found in www.mysql.com. MySql is just a bit different compared to MS SQL (Sql queries change a bit), there are some differences in data types, but they all translate fine to .net through the connector. daniero
-
I have asked about SQL2005 Experss, but my host claimed they did not support it :sigh: i forgot to mention that the MySQL server avaliable is only version 4.1.19 but ill have a look if i cant find a .net connector anyway..
the .net connector itself is free for download in www.mysql.com[^] I've used it witn mysql server versions from 3 to 5 with no problems at all. daniero