MS has several samples of creating views of other data sources from within SQL 7. I have a customer who would like me to do the same thing using an Informix database which resides on their UNIX box. I have the ODBC for the Informix connection installed and tested. I was able to create the linked...
alexm,
What you are looking to do is create a linked server. Using ODBC you can create a linked server using the sp_addlinkedserver stored procedure. You then create a login for the server using the sp_addlinkedsrvlogin.
The last set is to create a view based on the linked server. For more...
My company is in the process or writing a VB 6 app which is accessing an existing Sybase SQL Anywhere 5.0 database. I need the app to be able to connect up via the modem to update remote users. The app works just fine as long as I am phyically connected to the network, but if I RAS in I am able...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.