database help

Hi

Could you look at this .PDF file I have looked at several things and unsure of how to get database into my Application.

Stephen

 

...Your database objects need to be in your DASP SQL Server.
You can place Access databases in your App_Data folder.
Your App_Code folder is used for Data Sets that are used by your ASP.NET forms for SQL Server.
Any SQL Server records need to be pumped or attached via the feature in your Control Panel.

 

Hi

I have finally found the .MDF file on my computer it was barried within so many folders. I have tried using the windows search to find this folder and came up with no results. I found the file by going SQL Management Studio and found a way to dig deep into the folders and here is the address for the file:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CAT181.MDF
As I went to this file I came up with an error. Please look at the .PDF within the .zip folder for this error.
Could you look at the second .PDF within the same .zip folder for me it is showing an ERROR message in red.

Stephen

 

...Please watch this Webcast I created which shows how to work with MDF files on DASP Servers.
http://www.dasptv.com/avc-view.aspx?videoid=30&categoryid=1

 

Hi Mark

I think I finally was able to convert my MS ACCESS 2007 database to MS SQL and I was able to finally locate the .MDF file and I then was able to create a APP_DATA folder and installed my .MDF file into it and I named it STEVE.MDF.
I then was able to to run the Application without errors and then I was able to publish the Application without errors. The next step I did was to attach the database to control panel in the DISCOUNTASP.NET it was attached ok and then I tried to run the Application on my WEBSITE and I am still getting an error could you take a look at it, you will be able to view it within the zip folder that I have attached.

Stephen

 

...Hard to say for sure but while the error looks like the SQL Server conn is not correct I'm guessing you got a handle on that and the problem is that an actual Data Set is missing.

 

Hi Mark

I had contacted Discountasp.net trying to see what help they could give me and they told me to read this article KB:

Do you support MS SQL 2005 Express database on DiscountASP.NET servers?SQL Express is designed for desktop database development purposes and is not suitable for a shared hosting environment due to security and performance issues. Microsoft actually recommends disabling this service on shared hosting platforms. However, you can use the SQL 2005 Attach tool in control panel to attach a SQL Express database to our SQL 2005 database.
Folder: Databases > MS SQL 2005
Modified 3/15/2011 / 91% Relevant

Is that what I am using. Is that what SQL Server Management Studio is and if so how do I fix it.

Stephen

 

...You watched my Webcast right?
And you are still using the Conn string I created for you right?

Thing is, you have to use the Attach tool to bring any SQL Express DB into your site.
Be aware however that each time you do that it resets your DASP SQL Server DB.

You want to use the Express DB Attach feature once, from then on you need to work with your remote DASP SQL Server.

 

Hi Mark

As far as I know I am because I had to rewrite part of the code because I was getting errors when I tried to publish my application. I found that I had alot of corrupt config strings within the web config and the data gridview. After I got it working agian I remembered about the connectionstring you told me about I hope I put it in correctly it seems to run ok with it except for the output. I have watched that video several times there is just so much to remember.

 

I was wondering if you could recheck my code and make sure things are ok.

THANK YOU
Stephen

 

...Went in just now and took a look at your changes.
In the web.config for your Catalog app you are using "steveConnectionString2", which references a SQL Express DB.
Your DASP SQL Server conn string is "steveConnectionString", which is still the way I left it but your app doesn't use it.

The SQL Sever Express files are not supported on DASP servers.

Remember what you can do to prevent this is use your remote DASP SQL Server from your local project as the data source.
All the best,
Mark

 

Hi Mark

The type I am using below is not of anger or maddness it is to show that I am very happy.

THANK YOU SO MUCH YOU DO NOT KNOW HOW MUCH THIS MEANS TO ME I HAVE BEEN TRING TO GET THIS APPLICATION UP AND RUNNING ON OUR WEBSITE FOR ABOUT A YEAR AND A HALF. I ALSO HAD MY BOSS ON ME DAY AFTER DAY TRING TO GET IT UP AND WORKING. With your help it is know working, you have done alot for me.

Thank You
Stephen

 

...Not a problem, always willing to help.

 

Well I learned a lot.
Mark when I upgrade my db and forum I need you on speed dial or I will just make the drive to JC.

 

...The Batcave (My undergound Bike garage) is always available for the best Tea, Espresso, Kefir and Kombucha. ;-)