invalid file dsn problem

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!
timothymoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndresMCommented:
Instead of using a dsn, have you tried an explicit connection string ?
0
timothymoAuthor Commented:
as we have other concerns, file dsn is the only way we could accept.

definitely, connect string or system dsn will work.
0
hakyemezCommented:
Open Registry Editor
Goto
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN
Create NewString Value
Name  = DefaultDSNDir
Value = C:\Program Files\Common Files\ODBC\Data Sources

or

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

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
timothymoAuthor Commented:
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!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.