Re: [gnome-db] Encrypted DB connection

Hi!

What I have to do is something like this?

gda_connection_open_from_string ("PostgreSQL",
                                                    "DB_NAME=crystal;
USE_SSL=true",

"USERNAME=postgres;PASSWORD=12345",

GDA_CONNECTION_OPTIONS_READ_ONLY,
                                                    &error);

Regards,
Catarina Fernandes


2010/12/15 Vivien Malerba <[email protected]>

>
>
> On 15 December 2010 15:49, Catarina Fernandes <
> [email protected]> wrote:
> > Hi!
> >
> > I'm using libgda to get some data from a postgres database.
> >
> > Is there a way of using an encrypted connection to the database?
>
> You can specify the USE_SSL=TRUE in your connection string.
>
> To know all the parameters accepted by a database provider when opening a
> connection, you can use the gda-sql-4.0.exe program, for example:
> vivien@may11:~$ gda-sql-4.0 -L PostgreSQL
>                    Provider 'PostgreSQL' description
> Attribute      │ Value
> ───────────────┼───────────────────────────────────────────────────
> Provider       │ PostgreSQL
> Description    │ Provider for PostgreSQL databases
> DSN parameters │ DB_NAME,
>                  SEARCHPATH,
>                  HOST,
>                  PORT,
>                  OPTIONS,
>                  USE_SSL
> Authentication │ USERNAME,
>                  PASSWORD
> File           │ /prefix/lib/libgda-4.0/providers/libgda-postgres.so
> (5 rows)
>
> Regards,
>
> Vivien
>

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list