[unixODBC-support] unixODBC / RODBC Trouble

[Michael Wesolowski]

Thanks for your reply Nick,

You're right, I needed a different setup file. I also figured out that I
need to "su postgres" for isql or an ODBC connection to work. It works just
fine now.

Thanks again,
MW

On Sat, Jul 24, 2010 at 5:14 AM, Nick Gorham <nick at lurcher.org> wrote:

> Michael Wesolowski wrote:
>
>> Hello,
>>
>> I'm trying to get RODBC setup, and the trouble is that a connection can't
>> be established because my odbc.ini and odbcinst.ini files are not being read
>> correctly. I know I have the right template and I've filled in the driver
>> paths right (and that the driver .so files have their execute bits set).
>>
>> When I use ODBCConfig to try and sort it out, I get yet another error in
>> my terminal:
>> Session management error: None of the authentication protocols specified
>> are supported
>>
>> The GUI still pops up, but when I try to create a DSN, I get an error:
>> could not construct property list for (PostgreSQL)
>>
>>  Hi,
>
> I would ignore the GUI setup, and just edit the ini files by hand. there
> are docs about this, but for postgres something like this should work.
>
> odbcinst.ini
>
> [PostgreSQL]
> Description             = ODBC for PostgreSQL
> Driver          = /usr/lib/libodbcpsql.so
> Setup           = /usr/lib/libodbcpsqlS.so
> FileUsage               = 1
>
> odbc.ini
>
> [DSN]
> Description             = Test DB
> Driver          = PostgreSQL
> Trace           = No
> TraceFile               =
> Database                = default
> Servername              = localhost
> UserName                = postgres
> Port            = 5432
> ReadOnly                = No
> RowVersioning           = No
> ShowSystemTables                = No
> ShowOidColumn           = No
> FakeOidIndex            = No
> ConnSettings            =
>
> BTW, the driver won't work as a setup lib unless the writers made it do so.
>
> --
> Nick
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>



-- 
Michael Wesolowski
3A Pure Mathematics
Undergraduate Student
University of Waterloo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100724/9a7427c1/attachment.html>