<div>
Instead of using a dsn, have you tried an explicit connection string ?
</div>


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

<div>
as we have other concerns, file dsn is the only way we could accept.<br />
<br />
definitely, connect string or system dsn will work.
</div>


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

definitely, connect string or system dsn will work.

<div>
i checked the registry in the server, it does have this registry entry, with the value you mentioned above.<br />
<br />
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.<br />
<br />
Thanks for the information!!
</div>


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!!

<div>
<div class="content wysiwyg-content">
hi ppl, i need help in the following issue.<br />
<br />
we have a web application KService running on our w2k web <br />
server SVR21. in KService we use a file DSN to connect to <br />
database, and the file is here: &quot;C:\Program Files\Common <br />
Files\ODBC\Data Sources\KCONN.DSN&quot;. not frequently, one <br />
per month, we will encounter the &quot;invalid file dsn <br />
problem&quot;, which said that &quot;KCONN.DSN&quot; was an invalid file <br />
dsn. if we restart IIS service, the problem goes away. we <br />
can also wait for hrs, the problem goes itself.<br />
<br />
can any1 advise me on this issue? any wrong doing i may <br />
have done to the server or to the application?<br />
<br />
Thanks very much!
</div>
</div>


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!

invalid file dsn problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.