DataSource Controls :: How To Connect To Multiple Databases

Jun 8, 2010

i want to know how to connect to multiple databases in sql from our code??

View 4 Replies

Similar Messages:

DataSource Controls :: How To Create Multiple Records In A Dataset From Multiple Databases

Mar 7, 2011

I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.

I am reagin the connection string paths from a table in a database.

I am asking for your help in trying figure out my logic.

Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?

Here is my beginning code which deals with one database:


View 2 Replies

Web Forms :: How To Connect To Multiple Databases On Same Page

May 7, 2015

how to connect to multiple database?

View 1 Replies

Web Forms :: Dynamically Connect To Multiple Databases At Runtime By Changing Connection String?

Nov 14, 2013

i have a dropdownlist contaning i want to connect my database by dropdown selection.if i select 2013 it will connect 2013 database ,if i select 2014 it connect 2014 so on..

View 1 Replies

DataSource Controls :: How To Make One DataContext For Multiple Databases

Apr 17, 2010

I have 2 databases one called DB1, and the other DB2. Both of them has exactly the same design (tables, procedures and etc..)

Now, I am using SQLMETAL to create the DataContext. problem is that there are two lines that direct to a certain database and so I cannot use the same code for both databases.

here is the code:


Now, What I am lookin for is a programmatically way to change this two lines (DataBaseAttribute and the connrection string) .

The easiest solution for me of course is to create the class twice, with the same code and just change manually what I need which is not what I am looking for.

There is a full discussion with microsoft stuff right here: [URL]

View 4 Replies

DataSource Controls :: How To Handle Membership Info Among Multiple Databases

May 13, 2010

I'm creating a site that will offer several different services (blogs, videos, images..), all under the same site.

Each service will use a separate database and all services must use the same membeship info. Users will only need one login to access all these services.

For the membership database i will use the default aspnetdb database.

There are two ways i can think of:

1) Use a join-query between two databases, each time i want to show some service records per user.

2) Create a custom membership-info table in each service's database, and keep it in sync with the master membership table in aspnetdb database.

The custom membership table will be like this:

Id - int, primary, identity
UserId - uniqueidentifier (of aspnetdb database)

What is the best way to do this in the long run, when i will have six or seven or more services ?

View 2 Replies

Databases :: Data Access Layer For Multiple Databases?

Jul 6, 2010

i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and 3.5 based on database connection

View 1 Replies

Databases :: How To Connect To MySQL

Jan 18, 2010

I am also having the same problem while establishing a connection in mysql and how do i solve it...

View 5 Replies

Databases :: How To Connect Essbase From C#

Dec 16, 2010

How to connect Essbase from

View 1 Replies

Databases :: Connect To Oracle Without DSN?

Oct 4, 2010

I need to find a way to connect to the remote Oracle server without a DSN. There are some practical problem for accessing the server using a DSN. I need a way to connect to Oracle server like I connect to SQL Server etc. For example, in SQL server, I can connect directly with server using Servername (IP adress) + Username + Password + DB Name. Any way to connect to the Oracle server like in SQL Server we do ??

View 6 Replies

Databases :: Connect To Oracle DB?

Jul 8, 2010

Is required to install Oracle client software to connect Oracle DB?

As following code will generate exception, prompt:"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."

using System.Data.OracleClient;


string connectionString=string.Format("Data Source={0};User Id={1};Password={2};",dataSource,"id","pwd");

using (OracleConnection connection=new OracleConnection(connectionString))




View 1 Replies

Using LINQ To Connect With Two Or More Databases?

Nov 22, 2010

I am developing an ASP.NET application in which i need to provide support for two databses MySql and MSSQLServer 2005 and 2008 (one database will be used at a time).1)How will i configure the app to connect with different databases without reinstalling the app i.e use configuration?2)How will i configure the LINQ?3)Shouldn't i use NHibernate?

View 2 Replies

Databases :: How To Connect DB2 Database

Dec 6, 2010

i want to connect Db2 database with my .net to fetch data from my DB2 database through my application then how to genrate crystal report through this data.

View 2 Replies

SQL Server :: Connect To Two Databases?

Sep 24, 2010

I've had a site up and running for quite some time with "ASPNETDB.MDF" as database. I recently got a request to make a second site with it's own database, but that also includes a admin interface to manage the first site's database.

"Fine", I thought. "I'll just add a new connection string and point to the first database.". But unfortunately it seems to involve a few more steps then that.

My connection strings are:

<add name="ASPNETDBConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
<add name="myfirstsite_ASPNETDBConnectionString" connectionString="Database=myfirstsite_aspnetdb;Data Source=.SQLEXPRESS;AttachDbFilename=C:\Inetpub\myfirstsite\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True" pro

But whenever I start up my first website I can't access the database through my second one. I just keep receiving the error: "Cannot open user default database. Login failed. Login failed for user 'MYCOMPUTERWEB01ASPNET'."

And if I were to start up my second one first I can do what I want, but then the first site would get the same error. So I guess the error is somehow related to the database already being in use.

View 9 Replies

Databases :: How To Connect Mysql Database

Jun 11, 2010

how to connect mysql database in

I am install mysql 5.0 then i install sqlyog.

After that i create the database sample in mysql with the help of sqlyog.

I want to connect the database in & display it on gridview.


How we set the connection string in mysql for use on aspx page?

View 1 Replies

Databases :: How To Connect From A Web Application To Db2 Database

Feb 17, 2011

How do I connect from a web application to db2 database?

View 3 Replies

Databases :: Connect With Mysql On Remote Pc

Jan 18, 2010

I am trying to connect with mysql on remote pc. When i am connecting with localhost mysql it is working properly but when i change "localhost" with IP address it show error.

View 4 Replies

Databases :: How To Connect Mysql To Database

Mar 15, 2010

I have the following piece of code in my web.config file.. I am trying to connect to a MySQL database. The code compiles fine and when I am ruuning the website I come across this error - 'Keyword not supported: 'server'.':


View 7 Replies

Databases :: Connect To Oracle From .Net Framework 3.5?

Mar 8, 2011

I need to connect to oracle database (10g) which is on different server.

Can i use the latest provider or i need to use provider related to oracle 10g only?

After installing the ODP.Net what are the next steps to do in order to connect to database....

View 6 Replies

Databases :: Connect To An Excel File?

Mar 18, 2011

We have an MVC application where we have put an excell loader. It works fine in the VS studio environment but on the IIS (64 bit) we get an error message .->

Microsoft.ACE.OLEDB.12.0 provider is not registrated on the local machine.The excell (2010) is 32 bit, but the IIS is 64 bit. Here the code


View 2 Replies

Databases :: Connect Other Server Mysqldatabase

Oct 19, 2010

I have implementing one application to view the user details in using mysql database.

the thing is my sql server is present in other ip for example:

i need to fetch the data from another ip call

View 1 Replies

Databases :: Unable To Connect To Any Of The Specified MySQL Hosts

Dec 7, 2010

i have used the following connection string, but it only works for localhost, when i am trying to upload it on server it gives error.,error is specied urgent plz resolve as soon as possible...

<add name="connectionname" connectionString="Server=servername;port=3307;User Id=xyz;Password=abc; database=databasename"/> Error - Unable to connect to any of the specified MySQL hosts. Exception Details:
MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.

View 1 Replies

Databases :: Can't Connect Oracle 10g XE And 9i Client In Same Machine

Feb 10, 2011

I can't connect to both 9i and 10g from,when i installed 9i client in a machine which already contain 10g xpress edition and no 10g client 9i client used to connect 9i db in another machine. Both 9i and 10g can be connected with TOAD. i got the following error msg from the application. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

View 3 Replies

Databases :: How To Connect Using Oracle.DataAccess.Client

May 18, 2010

I want to insert some values (from web application) in a table on oracle DB that hosted on a machine rather than the machine that hosts the application

i use "oracle.dataaccess.client" and the following function


but i get the following exception

The type initializer for "Oracle.DataAccess.Client.OracleConnection" threw an exception

View 5 Replies

Databases :: Connect Sqldatasource With Mysql In VS 2005?

Jan 17, 2010

I'd like to know how to connect sqldatasource with mysql in VS 2005.

View 5 Replies

Copyrights 2005-15, All rights reserved