User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,809 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,512 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1262 | Replies: 1
Reply
Join Date: Nov 2006
Posts: 1
Reputation: vr4indian is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
vr4indian vr4indian is offline Offline
Newbie Poster

Question dataabse connectin string problem?

  #1  
Nov 20th, 2006
hello friend

i have two website . both hosted on diff. server

now what i need is to connect second website database from first website


***
detail
***

when user register on first website a insert query should also make on second website database.

can you tell me how can i write my conenction string:


server1:rs397.secureserver.com (database: abc) , website 1: www.example1.com
server2:rs455.secureserver.com (database: 3214), website 2: www.example2.com

waiting for any one urgent reply
vr4indian@yahoo.com is my email id or you can also reply on this message
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Sep 2006
Posts: 91
Reputation: ses5909 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
ses5909 ses5909 is offline Offline
Junior Poster

Re: dataabse connectin string problem?

  #2  
Jan 4th, 2007
You can't use one connection string; you need two and you will have to call te query twice. is there a reason you are storing the same info on two servers?

I believe mysql can support joining two tables from two databases, but im not sure if they are on different servers.
Last edited by ses5909 : Jan 4th, 2007 at 3:12 pm.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MySQL Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 6:24 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC