Solved

Use System DSN

Posted on 2016-08-03
6
83 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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
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 46

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Viewers will learn how the fundamental information of how to create a table.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

911 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

22 Experts available now in Live!

Get 1:1 Help Now