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


Similar Messages:

Databases :: Connect Other Server Mysqldatabase

Oct 19, 2010

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

the thing is my sql server is present in other ip for example: www.example1.com

i need to fetch the data from another ip call www.example2.com

View 1 Replies

Databases :: ODBC 3.51 Driver]Can't Connect To MySQL Server

Feb 17, 2010

System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)

[Code]...

View 5 Replies

Databases :: Server Explorer - Unable To Connect To Oracle

Jan 31, 2011

Using VS 2008 and oracle 10g.

I have installed oracle odp.net (11.1.0.7.20). This client installation includes all VS developer tools.

All my application seems to be working ok. I have never attempted to use VS Server Explorer.

For ReportViewer I was trying to create a dataset and in the server explorer I was trying to create a new dataconnection for oracle. As soon as I click new connection I get the following error.

An unexpected error occured in Oracle Data Net provider for .NET. contact the provider vendor to resolve this problem.

Also I am unable to add a server to the server explorer. When I enter the IP address of

oracle DB Server, it gives the following error.

An error occured while connecting to 999.99.99.999

View 7 Replies

Databases :: Connect MySQL Server It Says "there Is No Support Prior To 5.0"?

Jan 16, 2011

I m using visual studio 2010 and i downloaded mySQL connector /net 6.3 (latest one). But when i try to connect mySQL Server it says "there is no support prior to 5.0". I think our mySQL server is version 4.0. How can i connect it?

View 1 Replies

Configuration :: Accessing Databases / Able To Connect To Database Present In Same Server But Not With Database Present In Other Server?

Mar 8, 2011

I am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.

I am using MS-access. I dont know the changes to be done and syntax for database connection.

View 3 Replies

Databases :: How To Connect To MySQL

Jan 18, 2010

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

View 5 Replies

Databases :: How To Connect Essbase From C#

Dec 16, 2010

How to connect Essbase from asp.net.

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 dataSource ="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=addr)(PORT=pt))(CONNECT_DATA=(SERVICE_NAME=svc)))";

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

using (OracleConnection connection=new OracleConnection(connectionString))

{

connection.Open();

}

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 ASP.net 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 application.how to fetch data from my DB2 database through my Asp.net application then how to genrate crystal report through this data.

View 2 Replies

Databases :: How To Connect Mysql Database

Jun 11, 2010

how to connect mysql database in asp.net?

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 asp.net & display it on gridview.

[Code]....

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 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

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'.':

[Code]....

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 ODP.net provider or i need to use ODP.net 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

[Code]....

View 2 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 below..it 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 asp.net,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 asp.net application. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

View 3 Replies

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 asp.net code??

View 4 Replies

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

May 18, 2010

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

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

[Code]....

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

Databases :: ORA-12154: TNS:could Not Resolve The Connect Identifier Specified?

Oct 6, 2010

I have a fresh install of 10g ODAC that I have loaded. My Oracle client interface connects to the db just fine but when I attempt to connect with my ASP.NET project, I get the following error: ORA-12154: TNS:could not resolve the connect identifier specified

View 3 Replies

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

May 7, 2015

how to connect to multiple database?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved