Solved

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

Posted on 2011-09-23
6
253 Views
Last Modified: 2012-05-12
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
Comment
Question by:MaxwellTurner
  • 2
  • 2
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 36590435
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
 
LVL 26

Accepted Solution

by:
Nick67 earned 500 total points
ID: 36590466
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
 
LVL 1

Author Comment

by:MaxwellTurner
ID: 36590867
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 26

Expert Comment

by:Nick67
ID: 36590896
You can link tables using code.  That's the heart of a DSN-less connection
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 36591086
You can also create the dsn in your code.
0
 
LVL 1

Author Comment

by:MaxwellTurner
ID: 36711105
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
A safe way to clean winsxs folder from your windows server 2008 R2 editions
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question