I've been having SQL Compact file sharing violations (A different process might be using the file. [
\\<path_to_ my_ hosting_ server>\App_Data\mydbname.sdf ] ) after deploying my WebMatrix project to my hosting provider. Consequently, I'm now trying to get MySQL to work.
On this page
http://www.asp.net/webmatrix/tutorials/connecting-to-a-sql-server-or-mysql-database-in-webmatrix it mentions that in the database type dropdown, I should see an option to choose MySQL. I don't. Does anyone else? I'm kinda wondering if I may need to re-download
WebMatrix again, although I'm fairly certain when it came out of beta, that I did. I appreciate any insight you may have.
ThumbDog
Member
74 Points
28 Posts
WebMatrix and MySQL
Jan 18, 2011 10:07 PM|LINK
Hello All...
I've been having SQL Compact file sharing violations (A different process might be using the file. [ \\<path_to_ my_ hosting_ server>\App_Data\mydbname.sdf ] ) after deploying my WebMatrix project to my hosting provider. Consequently, I'm now trying to get MySQL to work.
On this page http://www.asp.net/webmatrix/tutorials/connecting-to-a-sql-server-or-mysql-database-in-webmatrix it mentions that in the database type dropdown, I should see an option to choose MySQL. I don't. Does anyone else? I'm kinda wondering if I may need to re-download WebMatrix again, although I'm fairly certain when it came out of beta, that I did. I appreciate any insight you may have.
Cheers
SQL Compact File Sharing Violations MySQL
rlucero
Member
64 Points
12 Posts
Re: WebMatrix and MySQL
Jan 19, 2011 03:18 PM|LINK
I believe that you need the MySQL Connector installed. That will be installed as a part of any PHP/MySQL application installs.
Hope this helps.
-Robert
ThumbDog
Member
74 Points
28 Posts
Re: WebMatrix and MySQL
Jan 20, 2011 06:31 PM|LINK
Thanks for the suggestion. When I'm able to successfully deploy, I'll give it a shot.