X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Ado Connection String - Provider, Any Versions    
post Feb 12 2018, 08:40 PM

Posts: 9
Joined: 10-May 16


I have Access 365 set up as a frontend and using SQL Server 2014 as the backend.
I will be using ADO to write new records to a recordset or to update current records.
I was able to get things working just fine when I originally set the Connection String to linked tables in Access.
Now, I want to set the Connection String to SQL Server, not to a linked table in Access.
How do I find the 'Provider', so I can pass that on to the Connection String variable?

See sample code below:

strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" CurrentProject.Path & "\Northwind.accdb"

I need to find the 'Provider for SQL Server. How do I get that?

Thank you,

Go to the top of the page
post Feb 12 2018, 08:46 PM

UtterAccess VIP
Posts: 5,962
Joined: 30-June 11

You may like to read: https://accessexperts.com/blog/2011/03/24/s...crosoft-access/

Also, for finding the proper syntax for connection strings the following site is very helpful: https://www.connectionstrings.com/SQL-server/

Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
post Feb 13 2018, 01:43 PM

Posts: 9
Joined: 10-May 16

Thank you for forwarding this information.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    17th July 2018 - 02:44 AM