Solved

Use System DSN

Posted on 2016-08-03
6
99 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 11

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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 42

Expert Comment

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

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 51

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

Optimum High-Definition Video Viewing and Control

The ATEN VM0404HA 4x4 4K HDMI Matrix Switch supports 4K resolutions of UHD (3840 x 2160) and DCI (4096 x 2160) with refresh rates of 30 Hz (4:4:4) and 60 Hz (4:2:0). It is ideal for applications where the routing of 4K digital signals is required.

Question has a verified solution.

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

When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

617 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