Now I'm really confused.
Let me see if this is correct.
if I...
"Create a Database Source (DSN) in Hosting Controller with the name "LocalSqlServer" and then use those credentials. "
Do I need to add a connection string?(since this is the default user is it not?)
Do I need to use a connection string that references the odbc name?
If I ftp a file aspnetdb.mdb (which is created in SQL Server espress) it does not register in the databases in cpanel - only the ones created in Cpanel show so since you do not specifically reference the file path, just the database name how's that going to work?
or if I "Alternatively, create a MS SQL Server database (and a user for it) and use the credential in your application"
well if I create ms SQL Server in CP with name aspnetdb then it creates aspnet_data.mdb in the DB folder - great but I need the db in the app_data file since that is where the application is looking for it - or can I just change the path in the connection string along with the user name and password setup in the cpanel.
Asn if i create the db in cpanel - do I then have to use restore to get my database into the database created in cpanel.
Has anyone out there got a working example of a ASP.NET login that works - it would be great firstly to know that it can be done & then identify the set up in each of the following
1. what is in the web.config file
2. where was the ms SQL Server database created (in cpanel?)
3. how was the aspnetbd db from visual studio transfered into the database created in cpanel
4. what does the odbc datasource reference - the aspnetdb_data (with or without the .mdb)?
|