Solved

Database connection to SQL server 08 advice !!!!

Posted on 2008-10-13
1
343 Views
Last Modified: 2012-05-05
Using VBA code and  ms access

Where are the drivers for SQL Server 2008 so i can setup an ODBC connection on the desktop

also if i was to configue a connection string in code and exectue sql directly what would be best.. can this be achievd in ADO any code examples.. have server ip, database name /uname/password

Thanks!
Dave
0
Comment
Question by:david_88
1 Comment
 
LVL 1

Accepted Solution

by:
jantje_20 earned 500 total points
ID: 22701850
What you need first is the SQL 2008 Native Client: http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en it's halfway down the page

The description says "This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.", so I guess examples are included

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Viewers will learn how the fundamental information of how to create a table.

867 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now