<p>I'm writing an MFC App to automatically configure Postgresql with ODBC for use by another app. The idea being that the user runs the app and it automatically creates the database and the tables within it. My problem is that when I set up the File DSN it seems to require the name of the database it will access. This appears in the DSN file as ..</p>

<pre><code>DATABASE=mydb
</code></pre>

<p>However I haven't created mydb yet so can't connect to Postgresql ! I have tried editing the DSN file so this line reads ..</p>

<pre><code>DATABASE=
</code></pre>

<p>and removing it totally but then I get an error and can't connect.</p>

<p>Is it possible for a DSN file to allow access to any database ? If so how do I do this ?</p>

<p>Thanks</p>

<p>Ian</p>

One simple option would be to create a view to render an XML-version of an Excel File. You could either use the new Office 2007 version, or the older 2003 version. We chose the 2003 version so that more people could use it, but that's up to you, of course.
XML 2003 ref on MSDN
XML 2007 ref on MSDN