There is a good walkthrough at http://developer.infi.nl/index.php?ID=6&article=6 but after creating the linked server it fails when I try to access it.
Neither server craches the enterprise manager just sits there doing nothing, no processors get 100% used, no memory gets hogged, it just sits there with an hourglass for as long as you are prepared to wait. > > Ah okay, Linked servers I would say would be the way. > > > > I have heard tell that it is possible to perform cross-database > > > > and even cross-server joins in MSSQL but I can't find any good > > > > info on how it is done. Can someone point me in the right > > > > direction, specifically for the cross server stuff? > > > > > > Before you reply, my mistake. By cross-server I should have said > > > cross-platform. I am trying to link a MySQL database into MSSQL. > > > > > > I have found several references online but none of them work so I > > > was wondering if any of you had experience. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4