?
Solved

Database connection to SQL server 08 advice !!!!

Posted on 2008-10-13
1
Medium Priority
?
357 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 2000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

589 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