Using ASPRunner.Net v3 build 88, I have been unable to connect to an existing database.mdf.
Also have been unable to create a new database and attach it.
I have however fould a work around for the above problem as follows:
In ASPRunner.Net v3 I created a new database called database1.mdb (access database).
Then created the required tables etc. I then built a project to produce '.aspx' files.
Next I created a database file database1.mdf using web developer 2005 express edition
and saved it in the following path:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Finaly I altered the web.config file from:-
<connectionStrings>
<add name="Project1ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Documents and Settings\Admin\My Documents\Visual Studio 2005\WebSites\TopJobs\App_Data\database1.mdb;
User Id=admin;Password="
providerName="System.Data.OleDb" />
</connectionStrings>
The following connection string works:
<connectionStrings>
<add name="Project1ConnectionString" connectionString="Data Source=.\SQLExpress;
AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\database1.mdf;
Database=database1;Trusted_Connection=Yes" providerName="System.Data.SqlClient"/>
</connectionStrings>
The work around is a bit long winded,
I would like to be able to create the whole project and tables in a '.mdf' database file using ARPRunner.NET
Can you help?
Is the problem caused because I am trying to connect to SQL Server 2005 Express edition
and ASPRunner.net is designed to connect to the full version of SQL Server?
One further point: When using the '.aspx' files generated by ASPRunner.NET on an internet server
running MS SQL Server 2000 I made the following changes to the web.config file:
<connectionStrings>
<add name="Project1ConnectionString" connectionString="Data Source=mssql07.oneandone.co.uk;
Initial Catalog=db193116785;User ID=dbo193116785;Password=zEJXprKY" providerName="System.Data.SqlClient"/>
</connectionStrings>
