Mass updating of ODBC Drivers

I am needing to update the ODBC drivers of 50 desktops to SQL2008 (SQL native client 10.0). They are all currently using 2000 drivers but will need to be using 10.0 after updating SQL from 2000 to 2008. Is there a script or Utility that can do this?
Larry KiterlingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
If you install the Native Client (e.g, by using the corresponding MSI from https://www.microsoft.com/en-us/download/details.aspx?id=27596), ODBC drivers will be installed too. The MSI allows for all common switches, including silent install.
0
Larry KiterlingAuthor Commented:
Wow nice. Is there a script I can run to have all current ODBC connections to use the new driver?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Nothing you could use as-is. odbcconf can be used to configure a driver, DSN etc. via a batch file. Or you perform a manual installation on one machine, export HKLM\Software\ODBC from registry, and remove anything but
  HKLM\Software\ODBC\ODBC.INI\«DSN»                              
  HKLM\Software\ODBC\ODBC.INI\ODBC Data Sources      (leave only the DSN value)
  HKLM\Software\ODBC\ODBCINST.INI\«Native Client driver»
  HKLM\Software\ODBC\ODBCINST.INI\ODBC Drivers         (leave only the driver value)
The reg entries above assuming you are using 32bit OS & driver, or 64bit OS & driver, but not 64bit OS & 32bit drivers. In that case you'll need to look for HKLM\Software\WoW6432Node\ODBC (if I recall correctly).
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Larry KiterlingAuthor Commented:
Awesome. Which one do I need to download? I have mostly 64bit machines but some 32 bits

      
ENU\x86\PowerShellTools.msi

ENU\IA64\PowerShellTools.msi
      
ENU\IA64\RBS.msi
      
ENU\IA64\SapBI.msi
      
ENU\IA64\SharedManagementObjects.msi
      
ENU\IA64\sql_rmo.msi
      
ENU\IA64\SqlCmdLnUtils.msi
      
ENU\IA64\sqlncli.msi
      
ENU\IA64\SQLServer2005_BC.msi
      
ENU\IA64\SQLSERVER2008_ASADOMD10.msi
      
ENU\IA64\SQLSERVER2008_ASAMO10.msi
      
ENU\IA64\SQLSERVER2008_ASOLEDB10.msi
      
ENU\IA64\SQLSysClrTypes.msi
      
ENU\IA64\sqlxml.msi
16.8 MB
      
ENU\IA64\SSBEAS.msi
4.7 MB
      
ENU\IA64\Synchronization.msi
3.7 MB
      
ENU\IA64\SyncServicesADO.msi
2.1 MB
      
ENU\x64\PowerShellTools.msi
2.1 MB
      
ENU\x64\RBS.msi
4.5 MB
      
ENU\x64\SapBI.msi
2.9 MB
      
ENU\x64\SharedManagementObjects.msi
15.1 MB
      
ENU\x64\sql_rmo.msi
8.7 MB
      
ENU\x64\SqlCmdLnUtils.msi
11.8 MB
      
ENU\x64\sqlncli.msi
7.8 MB
      
ENU\x64\SQLServer2005_BC.msi
18.1 MB
      
ENU\x64\SQLSERVER2008_ASADOMD10.msi
6.8 MB
      
ENU\x64\SQLSERVER2008_ASAMO10.msi
4.4 MB
      
ENU\x64\SQLSERVER2008_ASOLEDB10.msi
42.9 MB
      
ENU\x64\SQLSysClrTypes.msi
1.9 MB
      
ENU\x64\sqlxml.msi
12.4 MB
      
ENU\x64\SSBEAS.msi
2.6 MB
      
ENU\x64\Synchronization.msi
2.6 MB
      
ENU\x64\SyncServicesADO.msi
1.2 MB
      
ENU\x86\RBS.msi
3.4 MB
      
ENU\x86\SapBI.msi
2.0 MB
      
ENU\x86\SharedManagementObjects.msi
10.0 MB
      
ENU\x86\sql_rmo.msi
8.9 MB
      
ENU\x86\SqlCmdLnUtils.msi
6.9 MB
      
ENU\x86\sqlncli.msi
4.4 MB
      
ENU\x86\SQLServer2005_BC.msi
11.0 MB
      
ENU\x86\SQLSERVER2008_ASADOMD10.msi
4.4 MB
      
ENU\x86\SQLSERVER2008_ASAMO10.msi
2.7 MB
      
ENU\x86\SQLSERVER2008_ASOLEDB10.msi
19.0 MB
      
ENU\x86\SQLServer2008_DMAddin.msi
17.5 MB
      
ENU\x86\SQLServer2008_DMViewer.msi
9.2 MB
      
ENU\x86\SQLServerBestPracticesPolicies.msi
1.3 MB
      
ENU\x86\SQLSysClrTypes.msi
1.5 MB
      
ENU\x86\sqlxml.msi
7.1 MB
      
ENU\x86\SSBEAS.msi
2.1 MB
      
ENU\x86\Synchronization.msi
2.7 MB
      
ENU\x86\SyncServicesADO.msi
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Look for the sqlncli.exe ones.
You should also have them on your install media resp. ISO or whatever you have for MSSQL Server install, btw.
0
Larry KiterlingAuthor Commented:
This for 64 bit

ENU\IA64\sqlncli.msi

And this for 32bit?

ENU\x86\sqlncli.msi
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
For 64bit you need    ENU\x64\sqlncli.msi, the other one is for Itanium (http://www.intel.com/content/www/us/en/processors/itanium/itanium-processor.html).
0
Larry KiterlingAuthor Commented:
I've installed the 32 bit driver and it shows up in the drivers list but do I need to do anything else for it to use it when I move to SQL2008 from 2000?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Yes. The OS in-build drivers for MSSQL 2000 are different, and you need to change or redefine DSNs using the driver. That's what http:#a40945047 is about.
0
Larry KiterlingAuthor Commented:
Would I be able to use the 2008 driver on the SQL2000?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Yes, and vice versa. Only restrictions are new datatypes (date without time portion etc.).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Larry KiterlingAuthor Commented:
Thanks Qlemo.. this is a huge migration for us and i'm actually excited to take it on now.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.