Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

Connecting to both mssql and mysql?

mikek12004's Avatar
Familiar Sight
  
Join Date: Sep 2008
Location: Athens, Greece
Posts: 186
#1: May 5 '09
Is it possible to have two connections at the same time one at mysql and one at mssql or the 2nd connection will automatically close the 1st (cause I need data from both)
code green's Avatar
Expert
  
Join Date: Mar 2007
Location: England
Posts: 1,076
#2: May 5 '09

re: Connecting to both mssql and mysql?

Yes you can with no problems.
MySql uses mysql_.. functions wheras mssql uses mssql_....
Be careful not to confuse the two.
You can also have more than one connection to MySql or MsSql
at the same time, but you must always quote the relevant resource.
prabirchoudhury's Avatar
Familiar Sight
  
Join Date: May 2009
Location: Wellington, New Zealand
Posts: 152
#3: May 6 '09

re: Connecting to both mssql and mysql?

that you could have in the same place with different connection string

read more abt that in my blog



Prabir Choudhury’s blog
My Site
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved