[plt-scheme] Advise debugging my srpersist connection (w/ postgres)

On Tue, 2002-09-10 at 18:04, Brent Fulgham wrote:
> I would love to see an "odbc.ini" and "odbcinst.ini" file from someone who has managed to get ODBC working with PostgreSQL.  I have spent a few fruitless hours trying to connect to the database, and can't do so (even using the odbctest program from iODBC.)
>  
> Here's what I have in my file:
>  
> ;
> ;  odbc.ini
> ;
> [ODBC Data Sources]
> Test = A test database

Don't think you need this

> [MainPostgreSQL]
> Description = PostgreSQL-template1
> Driver = /usr/lib/postgresql/lib/libodbcpsql.so.0.27
> Trace = No
> TraceFile = /var/log/odbc.log
> Database = template1
> Servername = localhost
> UserName =
> Password =
> Port = 5432
> Protocol = 6.4
> ReadOnly = Yes
> RowVersioning = No
> ShowSystemTables = No
> ShowOidColumn = No
> FakeOidIndex = No
> ConnSettings =
>  
> [Test]
> Driver = /usr/lib/postgresql/lib/libodbcpsql.so.0.27
> Database = test1

Make this a copy of the [MainPostgreSQL] entry, except for "Database".
You may add UserName and Password if you want.