?
Solved

Manually installing SQL Server ODBC driver

Posted on 2000-03-21
3
Medium Priority
?
928 Views
Last Modified: 2012-06-27
Is there an API call which will register the SQL Server driver (SQLSRV32.DLL) with ODBC?  If an API call exists, I would assume that it would take care of making the entries in the following registry locations: "HKLM\Software\ODBC\ODBCINST.INI\ODBC Drivers" and "HKLM\Software\ODBC\ODBCINST.INI\SQL Server".  I'm hoping that there is an API call out there called RegisterNewODBCDriver or something like that.

Right now my installation program copies all of the files needed by the SQL Server ODBC driver and it manually creates the registry entries.  This works fine, but I would prefer to call an API function to take care of the registry if possible.  I do NOT want to install the full blown MDAC in this situation, I am only interested in installing and registering the SQL Server driver with ODBC.

Thanks.
0
Comment
Question by:jsullivan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Expert Comment

by:wqw
ID: 2641881
hmmm, never heard of one actually. will be helpfull indeed.

</wqw>

p.s. i'm particularly interested. nevermind my comment :-))
0
 
LVL 7

Accepted Solution

by:
tchalkov earned 400 total points
ID: 2643512
Generally this depends on the version of ODBC you are using. If you are using 3.0 or higher then use the function SQLInstallDriverEx. It is described in MSDN. You don't need anything else.

However if you are using ODBC 2.5 then you must use SQLInstallDriver, and you need an .inf file which describes your driver.
The problem is that SQLInstallDriver is not supported under ODBC 3.0 and higher, so you'll have to know which ODBC version you will support.

Here are a few KB articles which you may find usefull : Q168052, Q158615
0
 

Author Comment

by:jsullivan
ID: 2650726
tchalkov,

Thanks, that was exactly what I needed.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

762 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