DataSource Controls :: Use Two Identical SQL Databases Local And Remote?
Mar 13, 2010
I am developing a website with ASP.NET pages that uses an SQL Server database with LINQ to SQL. I am using Visual Studio's Web Developer along with SQL Server 2008 (Developer Edition) database tables on my personal PC to develop this software. When ready, I intend to transfer the compiled web pages to a web hosting service with an SQL server database that is identical to the database on my PC.
I now have a version of my website deployed on a web hosting service at: [URL] and all of my database tables duplicated at the remote SQL server. However, this version of my website does not work with the database yet. I realize that I can have the VS Server Explorer connect to both databases, but I do not know if the web pages on my PC can use both databases interactively.
I am asking how I can develop my website to use the local SQL Server database and then have the deployed pages use the remote SQL Server database with LINQ to SQL. Do I need to create one version that works with the local database and another deployable version that works with the remote database? What should I do?
View 5 Replies
Similar Messages:
May 20, 2010
I need to insert a record in table which is in remote server....I am using two connection strings for local and remote....both the servers are in same workgroup only...so am able to connect the both.The problem is am filling data of local table in on dataset1 and remote server table data in another dataset dataset2..Now whil inserting a record local an error occured like "This row already belongs to another table" after googlingI found like this like "Dataset.importrow()" instead of "dataset.add()" method...then there is no errors but the inserted record is not inserting in remote server database...
View 5 Replies
Apr 15, 2010
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
View 4 Replies
Mar 30, 2010
How to redirect to a particular website (in local/remote server) when some one enters a website URL in the browser.
View 7 Replies
Jan 21, 2010
I'm developing an ASP.NET Website locally using Web Developer Express Edition and publish my site via ftp to the remote host. Problem: Locally I'm using path settings to xml files etc. different from the remote paths. So each time before I publish my site I have to set the remote paths explicitely commenting out the specific lines of code.
Sample:
if(local) {
XDocument loaded =
XDocument.Load(@"<localpath>jobitemssample_" + companyId +
".xml");
else{
XDocument loaded =
XDocument.Load(@"<remotepath>datajobitemssample_" + companyId + ".xml");
}
How can I achieve an automatic setting mechanism on deployment. How do I know how to set local?
View 2 Replies
Apr 18, 2010
I have an off-line project. User uses a laptop to input data off line into local SQL server express. Once connected to domain (on line), local data will sync with remote SQL server using sync framework. (It is done, works fine)
One job left:
Since another user used another program to update some tables in remote SQL server, such as CUSTOMER, SHIPINFO, my off-line program need to update these new data once connect to domain.
Here is what I design in Pseudo code: (take CUSTOMER as example)
1) In remote SQL server, create a store procedure (sp_customer) to select all CUSTOMERS
2) In application, create a dataset (dst_customer) based on sp_customer
3) Insert all customers data which is in remote SQL server but not in local SQL server based on CUSTOMER_ID
I do not think this a smart way to do it.
View 5 Replies
Jul 5, 2010
can anyone point me to some differences hosting a website on some remote server VS running it locally on dev environment.The reason why i am asking is, If I run my website locally it works fine no exceptions, runs smooth. But when deployed on a remote hosting server. Its like a nightmare to me :(very often i get object Instance not set to instance of object..... I am ok with the error message, But the same situation should happen locally, thats what bothering me:D
View 2 Replies
Jan 25, 2012
So, I've been working on an app that extracts a picture from an ole field in an old access xp db, converts it to a jpg picture, and saves it to a folder to be presented to the user.
After tweaking some permissions on the local iis, the application works fine.
In the remote one however, the application doesn't extract the picture as expected.
I'm using two dlls on there, although I don't know why it wouldn't work.
View 3 Replies
Apr 6, 2010
I'm just wondering what the best practice is for managing web.config connection strings and SMTP settings when working locally in VS2008 and deploying to a remote server?
View 5 Replies
Feb 16, 2010
I want to populate members of a local computer group on a webpage and allow the user to add / remove users of that remote computer from a group say Administrators or Remote Users Group.
The application pool will be running with a user who is admin on all remove systems.
View 5 Replies
Mar 16, 2011
how to create a Web service that returns a JSON(or JSONP). That also should be able to work for cross-domain access aswell as for a local call.. help to get this working or for a few links for further reading about this
View 2 Replies
Jan 18, 2010
I am trying to connect asp.net with mysql on remote pc. When i am connecting asp.net with localhost mysql it is working properly but when i change "localhost" with IP address it show error.
View 4 Replies
Mar 29, 2010
I am trying to make connection to a remote database server and I am getting the following message. I think i have to grant access to the client maching from my database server.. How do i grant access to an ip addess?
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'thelp'@'123.29.14.30' (using password: YES)
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'thelp'@'123.29.14.30'(using password: YES)
View 2 Replies
Oct 25, 2010
I'm using VS2010 and need to give my remote server asp .net account (IUSR_istereos) access to my local intpub folder
how do I do that?
View 5 Replies
Sep 29, 2010
I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts
In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.
[code]....
I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.
View 1 Replies
Jul 30, 2010
How to connect to a remote oracle database with Visual Studio?
I know how to create the connectionSting in web.config. I wonder if I can connect to an oracle database when creating a LINQ class so that tables will show in the Server Explorer.
View 1 Replies
Feb 15, 2011
I am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
I have asp.net2005 on my system with sql server.
View 1 Replies
Jan 25, 2011
I have two textboxes on my webform txtOQty,txtShipQty and Status dropdown list having 3 options.Active,hold,Completed.When txtoqty=txtShipQty then status should changed to Completed.Can any one help me on this,thanks.
View 4 Replies
Nov 26, 2010
My app throw exception with the message of "MSDAORA.1 is not registered on local machine" in iis7, but it's normal in vs(debug mode), what's the problem of that?
OS: Windows Server 2008 Web R2
ODAC version: 11
development and deployment in a same machine.
View 5 Replies
Apr 19, 2010
I've been playing about for ages in an attempt to get a simple bit of code that can detect whether or not SQL Server is listening remotely or just locally.. My pretty lame attempt so far is as follows:
[Code]....
I'm sure there must be a better way to do this! Aside from the fact that this code fails to work properly.
sp.IPAddresses contains:
- 127.0.0.1
- 0.0.0.0
- 10.0.0.10
When I used Surface Area Manager > Surface Area Configuration for Services and Connections and set Remote Connections to "Local connections only" sp.IPAddresses still contains the same addresses.
View 1 Replies
Dec 14, 2010
I have a website I'm trying to catch up to speed on. It is throwing a null exception when the code tries to assign a variable pulled from a SqlDataSource query. The query is below:
[code]....
I want to know if there is a way to test the connection to the remote IP Address perhaps through some debugging tools and as a general question how would the web app authenticate against the remote database? I just see the connection string but no user name etc.
View 5 Replies
Apr 28, 2010
quick question on SQL Studio Mgt Expres (SSMES) 2208. I have been googling around but could not find a clear cut answer to this simple issue:Is it possible to connect to a remote db using SSMES 2008? The options at login appear to be restricted to Database Engine and SQL Server Compact Edition only. On the SSME 2005 version, there was an option to connect to remote db's usging server name & pwd. Has this feature been disabled in the 2008 Express version?
View 2 Replies
Jan 13, 2011
I am fairly new to ASP.net - comming from a PHP / MYSQL background sometimes certain things in ASP.net confuse the hell out of me. In PHP - when writing an application you always connect to an external database server (MYSQL , PostGreSQL ) using a username and password and aswell a datbase server address(mostly localhost). Now with ASP.net i noticed that you can connect to an existing database within SQL server or you can create a local database in the App_Data folder.
The local database seems much easier to work with however my concern is what would you store in a local database? surely you cannot use it as a main database to store all your data(compared to a MYSQL database)? Secondarily with SQL server - when i login into SQL server management express , it uses "Windows Authetication" , i tried to select "Sql Server authentication" and enter my own username and password to login but that did'nt work. How do i deploy a database from SQL server to the web? - in MYSQL for example we would have a SQL dump file , which can be simply imported/exported from server to server.
View 4 Replies
Jun 22, 2010
My asp.net 2.0 is deployed in web hosting.. now here in my server i have configure a static ip.. so how to access my ms sql database all over the world.. i need to know is that i need to write directly connection string in a webconfig of my static ip.. or i need to create a instance of my static ip to ms sql server 2005 to access the database..
View 7 Replies
Mar 25, 2010
In my windows application, i am listing the System DSN's configured on the remote machine in a combobox. Once i select the DSN and click on Connect button, i should be able to connect to the remote database. I am trying to open the connection to the database using ODBC but am getting the below error.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Below is the code sample
string conn = "Provider=MSDASQL;Remote Server=http://BLR1WKD010; Remote Provider=MSDASQL;DSN=" + clsODBC.pDBName + ";UID=" + txtUsername.Text + ";PWD=" + txtPassword.Text;
OdbcConnection odbcConn = new OdbcConnection(conn);
odbcConn.Open();
View 5 Replies
