invalid file dsn problem

Posted on 2003-02-20
Medium Priority
Last Modified: 2006-11-17
hi ppl, i need help in the following issue.

we have a web application KService running on our w2k web
server SVR21. in KService we use a file DSN to connect to
database, and the file is here: "C:\Program Files\Common
Files\ODBC\Data Sources\KCONN.DSN". not frequently, one
per month, we will encounter the "invalid file dsn
problem", which said that "KCONN.DSN" was an invalid file
dsn. if we restart IIS service, the problem goes away. we
can also wait for hrs, the problem goes itself.

can any1 advise me on this issue? any wrong doing i may
have done to the server or to the application?

Thanks very much!
Question by:timothymo
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
  • 2
LVL 10

Expert Comment

ID: 7986846
Instead of using a dsn, have you tried an explicit connection string ?

Author Comment

ID: 7990675
as we have other concerns, file dsn is the only way we could accept.

definitely, connect string or system dsn will work.

Accepted Solution

hakyemez earned 300 total points
ID: 8021424
Open Registry Editor
Create NewString Value
Name  = DefaultDSNDir
Value = C:\Program Files\Common Files\ODBC\Data Sources


Copy below text open note pad paste it here and save document as dns.reg and run it

"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"


Author Comment

ID: 8022031
i checked the registry in the server, it does have this registry entry, with the value you mentioned above.

Now what i suspect is that at the time the problem came, the server had problem to get this value. i cant verify this until it happens again. also, the server registry may somehow got problem.

Thanks for the information!!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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…
Suggested Courses

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