Solved

Add a connection to a SQL database

Posted on 2011-02-28
2
192 Views
Last Modified: 2012-05-11
Hi

I am trying to create a new ODBC Data Source in SQL Server on the DSN Tab as shown in the image below but when I click "Add" I'm not sure how to add a SQL Database Image
0
Comment
Question by:murbro
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 500 total points
ID: 34998503
See here -

http://www.truthsolutions.com/sql/odbc/creating_a_new_odbc_dsn.htm

You could select SQL Native Client (preferred) as the driver instead of SQL Server.
0
 

Author Closing Comment

by:murbro
ID: 34998714
thanks
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

746 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

12 Experts available now in Live!

Get 1:1 Help Now