Solved

Use System DSN

Posted on 2016-08-03
6
70 Views
Last Modified: 2016-08-18
Hi,

Can we make use of one System DSN on the connection string? Is there an example to that?
0
Comment
Question by:HuaMinChen
6 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 41740330
Hi HuaMinChen
The following is an example of basic connection string referencing System DSN:
DSN=myDsn;Uid=myUsername;Pwd=;
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41740339
What should be 'Uid' in above?
0
 
LVL 17

Assisted Solution

by:Barry Cunney
Barry Cunney earned 150 total points
ID: 41740349
The 'Uid' should be the user name associated with the DSN

So if the DSN pointed to a SQL Server database, then the Uid would be the SQL Server user/login

Please let me know if this helps
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 41

Expert Comment

by:pcelba
ID: 41740453
The best reference to connection strings is here: http://www.connectionstrings.com/
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41741683
Barry,
I put Windows account below (as database user and password is already System DSN)
6a.png
but then it is not prompting me with the password (which I expect to happen).

As we're using Third-party report tool (called Ariacom), which is deploying web report using their DLL file, on IIS. It is depending on System DSN and is running fine within Win 2003 server. Now within Win 2008 server, how can I refer to relevant System DSN in above?
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 350 total points
ID: 41742511
If you're using an AD Account then you can't provide an UID and PWD, since those fields are only for SQL Server logins.
For AD Accounts you'll need to use Trusted Connection or Integrated Security options (it will use the credentials of current logged user).
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

705 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

19 Experts available now in Live!

Get 1:1 Help Now