Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 3rd, 2006, 08:09 AM
Registered User
 
Join Date: Nov 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default could smb help to make run the DB on a hoster?

...here's the deal: I have a database called ISDB.mdf in my App_Data folder. And I'm deploying the website by coping its content to the ftp-server. Here you can see what it says when it tries to connect to the database: http://fewer.russia.webmatrixhosting.net/Main.aspx

So, is it me or its the server's specifications? I tried to make couple of changes in my web.config but have no positive results at all

...and, of course, everything works just fine on my local desktop server

Would be glad to hear any suggestions
 
Old December 3rd, 2006, 01:20 PM
Friend of Wrox
 
Join Date: Apr 2004
Posts: 204
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It looks like its a problem with your connection string. Can you post it - minus your password of course.

You might also check to see if you can connect to the remote database using Access via ODBC. If you can't, it's a good indication that ther problem lies with your setup.

Good luck!

Aaron

 
Old December 3rd, 2006, 05:52 PM
Registered User
 
Join Date: Nov 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

it looks just like this:
 <connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ISDB.mdf;Integrated Security=true;User Instance=True"
     providerName="System.Data.SqlClient" />
  </connectionStrings>


I do admit I'm a newbie... but... what should be done with it? And, if everything is really involved can anyone post a link with necessary information or tell me where to look and for what.

Thanks. Just for the reading also.

 
Old December 3rd, 2006, 06:52 PM
Friend of Wrox
 
Join Date: Apr 2004
Posts: 204
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yeah, I doubt your web host is using SQLExpress, although I could be wrong. You should check with them. They're probably using the full blown SQL 2005 or SQL 2000. If so, you'll need to get the info from your web host, then open SQL Management Express. If you don't already have it you can download a copy for free. Then navigate to your SQLExpress server, right-click on the database name and click Tasks, then Export. That will take you to a wizard where you can export your tables to another server. You'll tell it to use your web server, give it all the right credentials and then BAM! database migrated. Note that it won't copy your Identities and Primary Keys. Or relationships I believe. You'll need to re-establish those once you've copied the tables. Then change your connection string in your web.config to point to your new remote database. Then you should be golden.

Aaron






Similar Threads
Thread Thread Starter Forum Replies Last Post
Webpage with DB conection make SQL OVERFLOW rtr1900 Classic ASP Databases 3 March 28th, 2008 07:30 AM
make a windows application run contineously anisht C# 2005 1 March 24th, 2008 11:14 PM
how do i make a script run in background LIMONADA VBScript 6 April 25th, 2006 11:21 AM
make .js file run as fast as possible crmpicco Javascript 4 October 24th, 2005 11:35 AM
How to make insert statments for current db method Access VBA 8 March 23rd, 2005 10:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.