How to create a Sql Server ODBC that is available to network PC's

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?

Thanks
Max
LVL 1
MaxwellTurnerAsked:
Who is Participating?
 
Nick67Connect With a Mentor Commented:
The driver must be available on all the machines.
The DSN (data source name, which is how you configured a driver to hook up to an ODBC source) usually is distributed to machines as well.
You can create DSN-less connections.
You can google up lots of good information about doing that.

But the driver--that you gotta have
0
 
Kelvin SparksCommented:
Yes, the drivers must be on every machine. Generally the old SQL Driver is installed with windows - while prefereable, you do not have to use the SQL Native Client 10.0 driver.

Kelvin
0
 
MaxwellTurnerAuthor Commented:
I may have mis-used the word 'driver' ... yes, most of our machines have the drivers ... I was referring to the DSN.  By 'distributed to each machine' I assume you mean must manually be added to each machine, unless I use DSN-less connections.  Never heard of that, but  it sounds like what I need.  I will look into that.

Thanks,
Max
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Nick67Commented:
You can link tables using code.  That's the heart of a DSN-less connection
0
 
Kelvin SparksCommented:
You can also create the dsn in your code.
0
 
MaxwellTurnerAuthor Commented:
Thanks all,

DSN-less connection is the best solution for me.  All my dbases have a opening form, so it should work great.

Thanks again,

Max
0
All Courses

From novice to tech pro — start learning today.