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 January 6th, 2011, 09:30 AM
Authorized User
 
Join Date: Dec 2010
Posts: 21
Thanks: 4
Thanked 1 Time in 1 Post
Default

Thanks, Imar, I thought that might be a problem. Yes they provide connection string information, but again, they require you to create the tables, roles, etc manually. I guess there's no other way around it, but I'll see if they'll let me copy the tables, roles, etc over.

Right back atcha,

MtheK
 
Old January 6th, 2011, 09:34 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

These two areas (connection string and tables) don't have to be related. You can use their connection string and then create the table in a way that works for you, either:

a) running aspnet_regsql if you can access their SQL Server from your machine

b) Manually running the SQL scripts necessary for the application services (take a look in the folder C:\Windows\Microsoft.NET\Framework\VersionNumber)

c) Using the publishing wizard as explained in the book

d) Using import / export in SQL Server (again, if you can access SQL Server remotely).

In other words: lots of alternatives, and certainly no need to manually create tables, views and stored procedures.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
The Following User Says Thank You to Imar For This Useful Post:
MtheK (January 7th, 2011)
 
Old March 8th, 2011, 08:42 PM
Authorized User
 
Join Date: Dec 2010
Posts: 21
Thanks: 4
Thanked 1 Time in 1 Post
Default It's working for us now

Hey, sorry for not getting back to you sooner. We ended up hosting our own website. It was a lot easier that way. Thanks for the help





Similar Threads
Thread Thread Starter Forum Replies Last Post
Write to a database MMJiggy62 Beginning VB 6 3 August 24th, 2006 12:11 AM
Write data from access database to text files hayley Classic ASP Basics 1 February 1st, 2005 08:54 AM
Write to DataBase HELP!!! reidcor Javascript 3 January 19th, 2005 02:58 PM
Database Write and Email inquiringminds BOOK: Beginning ASP 3.0 9 September 21st, 2004 06:33 AM





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