| Author |
Topic |
|
BasicSQL
Starting Member
10 Posts |
 Posted - 2011-10-21 : 05:08:30
|
| Hi My first day on this forum, great to be apart of this community. I have a query to pass to yourself, is it possible to have for example say if i had a database on a physical machine and one a virtual machine. Would it be possible to link the two DB up so that the can generically update one another, however one database works off an IDB file (Firebird (Virtual)) and the other works of SQL server (Physical). I have tried 1 thing which was setting up shared network which contained all the Sql DB and IDB but problems started to occurThank you whom answer this question in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-21 : 05:40:47
|
| try setting up a linked server to IDB from sql server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
BasicSQL
Starting Member
10 Posts |
Posted - 2011-10-21 : 05:44:14
|
| I already did that but on a physical level when i tried it from physical to Virtual it kept on staying DB not found even though the right path was specified. |
|
|
|
BasicSQL
Starting Member
10 Posts |
Posted - 2011-10-21 : 05:58:27
|
| Link on a Physical to Virtual is know working, the big question know how can i update from one the Physical Database to the Virtual Database? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-10-21 : 06:08:02
|
| So what you are trying is to connect FROM sql server TO Firebird? In that case it would be a Firebird-problem... I know absolutely nothing about Firebird (haven't even heard of it) but can you create an odbc-connection to it?- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-10-21 : 06:10:36
|
| Got a phone call and didn't refresh before posting (for the second time this week!). How did you set up the link? Is it a linked srever in sql srever, odbc, something else?- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
BasicSQL
Starting Member
10 Posts |
Posted - 2011-10-21 : 08:10:05
|
| I just linked it up via the IP address of the Virtual DB |
|
|
|
BasicSQL
Starting Member
10 Posts |
Posted - 2011-10-21 : 08:12:06
|
| The statements all work with updating the DB tables separately, but how can i get it to update it from a front end database |
|
|
|
BasicSQL
Starting Member
10 Posts |
Posted - 2011-10-27 : 06:25:49
|
| Got everything to work know so jobs done life easier, I do have a question about Dynamic Queries are they are good idea? and what complications could arise? |
|
|
|
|
Is it Possible?