Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krabople
Starting Member
17 Posts |
 Posted - 2007-09-20 : 05:33:56
|
| Hi, I have been using Microsoft Access for a couple of years and we have just switched to SQL Server. However, I'm having problems querying the Mysql databases our company has in place. I have managed to establish connections in the Visual Studio but can't seem to link tables from two different databases like I could in Access. Is this possible? Also, is it possible to connect to the mysql database via management studio? Apologies for my complete lack of knowledge! |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-09-20 : 07:32:03
|
| Are you using Microsoft SQL Server or MySQL? This is a Microsoft SQL Server Forum, so you may want to post your question in a different forum.Jim |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-20 : 08:09:06
|
quote:
Originally posted by krabople
Hi, I have been using Microsoft Access for a couple of years and we have just switched to SQL Server. However, I'm having problems querying the Mysql databases our company has in place. I have managed to establish connections in the Visual Studio but can't seem to link tables from two different databases like I could in Access. Is this possible? Also, is it possible to connect to the mysql database via management studio? Apologies for my complete lack of knowledge!
If you want to link SQL Server to your MySQL database you can use the linked servers feature of SQL Server. See this article for more:http://www.databasejournal.com/features/mssql/article.php/3085211
Future guru in the making. |
|
|
|
krabople
Starting Member
17 Posts |
Posted - 2007-09-20 : 08:39:36
|
| That's spot on, cheers Zoroaster |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-20 : 09:10:03
|
quote:
Originally posted by krabople
That's spot on, cheers Zoroaster
Your welcome.
Future guru in the making. |
|
|
|
|
|
|
Querying to Mysql database