Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP 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 March 18th, 2005, 05:23 PM
Registered User
 
Join Date: Mar 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Sappu
Default Getting the a local copy of the Server DB

Hi

How do I get a copy of DB on server to my local system. I am getting some error such as null reference exception when i try to access the
db on server from my local system.

Can anyone explain what are the steps that followed in connecting to a DB in a C# web application?

Thank you
regards
-sappu
 
Old March 19th, 2005, 09:02 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just register the remote SQL Server in the Enterprise Manager and start administering it, just as you would administer a local server.

If the SQL Server is across a WAN/Internet, then you will have to connect using the IP address of the SQL Server. In that case you might have to add a TCP/IP advanced entry on your client PC using the 'Client Network Utility' (Start -> Programs -> Microsoft SQL Server -> Client Network Utility). You'll find the following article helpful:

http://www.verio.net/support/view_ar...fm?doc_id=3851

 
Old March 21st, 2005, 12:27 PM
Registered User
 
Join Date: Mar 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Sappu
Default

Thank you so much for your reply. I greatly appreciate it.

I tried your suggestion but the problem still persists.
My local system is registered to the SQLServer on the Internet and
TCP/IP entry is also added onto my client machine. But I am still
getting the same error. I checked the webconfig file and it is pointing to the right database. I don't know why this error is coming.

Thanks again for your suggestion. If you have any other ideas about this
null reference exception in C# to SQLServer connection, please let me know.

regards
-swapna





Similar Threads
Thread Thread Starter Forum Replies Last Post
help...copy files from sharepoint to local folder pinkflakes .NET Web Services 0 November 3rd, 2007 10:02 PM
Copy Files and Folders on Local Network rupakroy5 VB.NET 2002/2003 Basics 1 May 22nd, 2006 10:09 AM
Copy Local, Reference property ps2goat .NET Framework 1.x 1 October 24th, 2005 03:13 PM
Copy tables from one Access DB to Another mckly VB Databases Basics 1 August 4th, 2004 09:52 AM
Connecting VB Proj to a local Access DB jpaulptr Access VBA 0 May 27th, 2004 12:30 PM





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