Re: [gnome-db] unixodbc and gnome-db

["Le Lain, Olivier" <olivier lelain xrce xerox com>]

Thank you very much : it's working now.
Indeed , the right connection string was :

STRING=name_of_DSN

Maybe it worths including it in the doc as a simple example for ODBC.


Vivien Malerba wrote:

On 6/8/05, Le Lain, Olivier <olivier lelain xrce xerox com> wrote:
  

Hello,

I sucessfully connect to a Microsoft SQL server through UnixODBC/FreeDTS
My .odbcini has indeed just one DSN, which name is victoire (anyway)

* "isql -v victoire name password" works
* OpenOffice works using the sdbc:odbc:victoire connection string

But I'm unable to configure it through gnome-database-properties.
I dont' know the exact syntax to put in the "connection string" (which
should normally be as simple as DSN=victoire)
I always have the "Could not open connection." message.

libgda/libgnomedb are version 1.3.3
mergeant is 0.60

Thank you for any advices.
    

>From what I gather from the ODBC's provider sources, the only required
parameter in the DSN is the STRING argument (which is the ODBC
connection string).
So your entry in the ~/.libgda/config file should be like:
<section path="/apps/libgda/Datasources/whatever_you_want">
    <entry name="DSN" type="string" value="STRING=your ODBC connection string"/>
    <entry name="Provider" type="string" value="ODBC"/>
    ...
</section>

Regards,

Vivien