[AccessD] Finding and Installing SQL Drivers

[David Emerson]

Thanks Stuart.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Tuesday, 7 July 2020 7:35 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Finding and Installing SQL Drivers

Programs & Feature will only show drivers that have been installed as
standalone 
installations. It won't tell you what drivers have been installed by a
package such as MS 
Office.

A better place to look is under the Drivers tab in the two  odbcad32.exe
applications
which you will find in ..\ system32\ (for 64 bit drivers) and ..\SysWow64\
(for 32bit drivers)

That will tell you the version numbers and DLL names of all of the
installed drivers.

> gADODBConnection.ConnectionString = "Provider=sqloledb;Data
> Source=NZS00SQL1;Initial Catalog=StockData5;Integrated Security=SSPI;"

That would be sqloledb.dll,
 probably in C:\Program Files (x86)\Common Files\System\Ole DB for the  32
bit driver
and C:\Program Files\Common Files\System\Ole DB for 64 bit

> qdefTemp.Connect = "ODBC;DRIVER=SQL
> Server;SERVER=NZS00SQL1;DATABASE=StockData5;Trusted_Connection=Yes"

That's probably MSODBCSQL.xx.dll  in system32 and sysWOW4 for the 64/32 bit
drivers.
(where xx is the version number)

Yes, the driver needs to be installed on the machine running the application

On 7 Jul 2020 at 18:41, David Emerson wrote:

> Hi Team,
> 
> 
> 
> I asked a client what ODBC drivers they have installed on their RDS
> computers.  They found none on either when they looked in the Programs
> and Features section of the Control Panel.
> 
> 
> 
> I have two connection strings that work:
> 
> 
> 
> gADODBConnection.ConnectionString = "Provider=sqloledb;Data
> Source=NZS00SQL1;Initial Catalog=StockData5;Integrated Security=SSPI;"
> 
> 
> 
> qdefTemp.Connect = "ODBC;DRIVER=SQL
> Server;SERVER=NZS00SQL1;DATABASE=StockData5;Trusted_Connection=Yes"
> 
> 
> 
> I have a few  questions:
> 
> 
> 
> What is the driver that they are using?
> 
> 
> 
> Where would it be installed?
> 
> 
> 
> I am also wanting to update the drivers to the latest ones - I am
> guessing that it should it be installed on the computer running the
> Access program and not the computer hosting the SQL server.  Is this
> correct?
> 
> 
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com