How to create a Sql Server ODBC that is available to network PC's
Posted on 2011-09-23
I have several Access 2007 'front-end' databases that have tables which link to the corresponding 'back-end' Access database. I am in the process of migrating to SQL SErver 2008 and want to link the tables in the 'front-end' databasses to my new SQL Server. I did this by creating a System ODBC SQL Server driver, however, the table is only avalable on the machine with the driver ... if I open the database on another machine, the ODBC connection fails.
Is there a way to create a ODBC driver that is avalable to all PC's within our domain? ... or do I have to install the OBDC driver on every PC?