 pilot99 wrote:
so i dont really have to change any qqueries for it to work on mysql i just have to change the route to the db |
Oh yes you do, there's no difference on the SQL of Access and MSSQL, but there's differences when you go to MySQL, since it don't support ADO, but there's ways around it, MySQL provives alternate ways to do whatever you want, it may not be worth however to migrate a large applaication from Access/MSSQL to MySQL because of the differences in the queries, but a smaller application is esialy converted.
By the way, you mentioned the root to the DB? In MySQL there's no root to the DB, the DB is declared on the connection string, paths to DBs is another Access specific because it was a file, on MSSQL and MySQL you don't have paths, in fact you don't even need to know where the DB is, the server manages that, you just connect/authorize and query it.
dpyers wrote:
...I figure if the monthly cost difference is less than the cost of a big mack, coke and fries, it's worth skipping lunch one day a month to get mssql... |
Lol, yes, still some charge the earth and heaven for it.
Topic Options
Post Options
Thanks(0)
