Solved

Add a connection to a SQL database

Posted on 2011-02-28
2
197 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server merge records in one table 2 24
TSQL - How to declare table name 26 30
convert null in sql server 12 34
Query group by data in SQL Server - cursor? 3 34
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 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