<div>
What code are you currently using, r u using the sqlconfig... api? if so then could you not try to open as edit. If it failed then try to add on. If that fails then summat is knackered or it already exists!<br />

</div>


What code are you currently using, r u using the sqlconfig... api? if so then could you not try to open as edit. If it failed then try to add on. If that fails then summat is knackered or it already exists!


<div>
&gt; the ini file does not exist and I do not have access to the registry on this computer ..<br />
<br />
Then you are left with trial and error. <br />
Open a connection assuming your DSN exists. Catch an error.<br />
If no error is catched, the DSN exists.<br />
<br />
/gustav
</div>


> the ini file does not exist and I do not have access to the registry on this computer ..

Then you are left with trial and error.
Open a connection assuming your DSN exists. Catch an error.
If no error is catched, the DSN exists.

/gustav

<div>
That is just what I need. &nbsp;Thanks
</div>


<div>
<div class="content wysiwyg-content">
I need a way to check for an existing ODBC connection in the odbc data source administrator. &nbsp;All the research I have done indicates that the values are stored in either the INI file (not in XP) or the registry. &nbsp;I have determined that the ini file does not exist and I do not have access to the registry on this computer so my search skills are limited here. &nbsp;What I would like an easy way to see if the the connection named &quot;tempconn&quot; exists in the registry so that my code does not update the connection information when I use RegisterDatabase to establish the missing connection. &nbsp;This is all being done on an xp system (soon to be vista) inside a ms access database.
</div>
</div>


I need a way to check for an existing ODBC connection in the odbc data source administrator.  All the research I have done indicates that the values are stored in either the INI file (not in XP) or the registry.  I have determined that the ini file does not exist and I do not have access to the registry on this computer so my search skills are limited here.  What I would like an easy way to see if the the connection named "tempconn" exists in the registry so that my code does not update the connection information when I use RegisterDatabase to establish the missing connection.  This is all being done on an xp system (soon to be vista) inside a ms access database.

checking for a specific ODBC connection

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.