Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

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
0
MaxwellTurner
Asked:
MaxwellTurner
  • 2
  • 2
  • 2
1 Solution
 
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
 
Nick67Commented:
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
 
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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now