SQL Express, can I use it?

[Edgar]

Do I need to purchase the $10 SQL database addon even if my database is located in the App_Data folder of my application?

I forgot to mention my database is MS SQL Server 2005, the mdf file located in the App_data folder...

[wisemx]

Hi,
Express DBes are not supported but there is a nice feature in the Control Panel once you add a SQL Server option to Attach an Express DB.
You can't use the Express DB as is, you must migrate it to SQL Server.
Note: This is a good thing, I can provide links where you can see that Microsoft has specifically asked Shared hosts to not support Express versions of SQL Server on-line.
All the best,
Mark

[Guest]

Do you support Access MDB in the App_Data directory so I can access it vir "|DataDirectory|" in my Web.Config and use System.Data.OleDB provider? And can I upload the MDB file from my local machine rather than have to create it through some on-line admin tool?

TIA
John

[wisemx]

Hi,
Take a look at this thread:
http://community.discountasp.net/showthread.php?t=8799
All the best,
Mark

[Guest]

Hi Mark,
Thank you for that link. It is an excellent response and the idea suggested works. But my question is, can I create a directory on my site called App_Data and give it full permissions? If so then I can use the |DataDirectory| in Web.Config without the need of the additional code.

TIA,
John

[wisemx]

Hi,
DASP provides a secure folder for this you should use instead, each new site gets a folder named '_database'. You can however do it the way you mentioned, I don't have code for that right now but I did test it on DASP servers that way too.
All the best,
Mark
Note: The reason DASP provides that secure folder is due to the need for additional security for Access.