UtterAccess.com
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    
 
   
dobropivo
post Feb 12 2018, 08:40 PM
Post#1



Posts: 9
Joined: 10-May 16



Hi,

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,

Larry
Go to the top of the page
 
DanielPineault
post Feb 12 2018, 08:46 PM
Post#2


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
 
dobropivo
post Feb 13 2018, 01:43 PM
Post#3



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