Hi,
I am doing a sample VS 2008 project.
I have added a dbml file.On the designer,I have dragged a table "emp" from a database "Employee" which is in my server(for example Server1).
It created an app.config with connection string as
<connectionStri ngs>
<add name="LinQ2008. Properties.Sett ings.EmployeeConnect ionString"
connectionStrin g="Data Source=Server1; Initial Catalog=Employe e;User ID=abc;Password =somepassword"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>
Next,I have added another dbml file.On the designer,I have dragged a table from a database "Employee" which is in a diffferent server(for example Server2).
Now in app.config the connection string is created as
<connectionStri ngs>
<add name="LinQ2008. Properties.Sett ings.EmployeeConnect ionString1"
connectionStrin g="Data Source=Server2; Initial Catalog=Employe e;User ID=xyz;Password =somepassword"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>
My doubt is
(1) When two datasources/servers having same database name(for example Employee) are there,then if we drag a table from Employee database from "Server1", a connection string is created as "EmployeeConnec tionString" in app.config.
If we drag a table from Student database from "Server2", another connection string is created as "EmployeeConnec tionString1" in app.config.
How to have a common connectionstrin g name instead creating different connection strings.
Thanks,
Silpa
0 1394 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Paul Robinson |
last post by:
I am developing a website in ASP that connects to a Sybase database.
However, when I try to open a connection to the database the page will not
load. The script does not timeout, nor the connection. Further, the Sybase
server shows no connection. Because the page is hanging I am unable, with my
limited knowledge, to query the error collection.
After many tries I will get an error page ...HTTP 403.9 Access forbidden:
Too many users are...
|
by: JWM |
last post by:
I am trying to implement Oracle connection pooling for the following code,
which was written by someone else. Here is my main question -- this java
file creates code that is executed every hour, but once per week, the oracle
server is brought down for backup. At that time, I get an error that looks
like I have the wrong credentials for the database. For every subsequent
attempt to run the hourly process, I am getting a broken pipe error,...
|
by: H |
last post by:
This is a question that has haunted me for quite some time.
if you build a 4 tier database application where the 4th tier is the
database server (MS SQL 2000), where do you build the connection string?
The obvious answer is to hard code it into the middle layer and use a config
file.
The problem is the database application needs to be distributed to
purchasing clients. Therefore, you do not know, at development, what the SQL
|
by: Alec |
last post by:
Hi All,
I am currently trying to link in Access 97 to a table in a MSSQL 7
server. Initially the link is fine, however, when I close the access
database and re-open it from the same network lacation on a different
machine, it tells me that the ODBC connection to 'SQL Server Name'
failed.
How can I create the linked table permenant no matter what machine the
networked database is opened on?
|
by: sam44 |
last post by:
Hi,
At startup the user log on and chooses the name of a client from a
dropdownlist, which then changes dynamically the connection string (the
name of the client indicates which database to use).
I then change dynamically the connection string by doing :
My.Settings.Item("ConnectionString") = "some connection sring"
The problem is that if another user loggs in and chooses another
client, then obviously it changes the connection string...
| |
by: Sankalp |
last post by:
Hi,
I am using VB 2005. My application has many data bound controls. The
connection is stored in the app.config file.
I want the application to start with a default connection string and
while during the runtime, the user can click on a button and change the
connection string without exiting the application.
I would really appreciate any sort of help.
|
by: viepia |
last post by:
Hi,
My project writes records to a new SQL Server 2005 database with
currently 18 tables. When I change the Database Diagram for my
database I save the copy the list of changed tables to a notepad text
file; then one at a time I delete the changed tables from my DBML
Diagram and drag a replacement from the Server Explorer Table list. Is
there a better way to keep the Database Diagram and DBML Diagram in
sync? I would rather not...
|
by: Johnson |
last post by:
I'm trying to fix a "sub optimal" situation with respect to connection
string management. Your thoughtful responses will be appreciated.
I just started with a new client who has a bunch of legacy ASP.NET
applications that all manage connection strings in Web.config the same way,
like this:
This client has one Web.config file per application, and that one Web.config
file is duplicated across all environments (i.e., dev machines, test,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |