[nl-gebruikers] Re: Probleem met base in combinatie met postgres: tables readonly

Hugo Coolens <[email protected]> writes:

> Wat moet ik dan ingeven voor "Name of the ODBC data source on your system"
> ik heb geprobeerd met:
> postgresql://localhost/mydb

De koppeling van de PostgreSQL database met ODBC moet je met externe
tools regelen. Meestal is er een fraaie GUI tool die dat doet.

Het netto effect is date je $HOME/.odbc.ini wordt gevuld met iets als:

; begin odbc.ini
[ODBC Data Sources]
mydb = PostgreSQL ODBC Driver

[mydb]
Driver = /usr/lib/psqlodbc.so
Description = PostgreSQL Data Source
DSN = mydb
Servername = phoenix.squirrel.nl
Port = 5432
;Socket = 4096
Protocol = 7.2
UserName = 
Password = 
Database = mydb
ReadOnly = no
ServerType = Postgres
FetchBufferSize = 99
ServerOptions =
ConnectOptions =
;Options = 3
Trace = 0
TraceFile = /var/log/PostgreSQL_test_trace.log
Debug = 0
DebugFile = /var/log/PostgreSQL_test_debug.log

[Default]
Driver = /usr/lib/psqlodbc.so
Description = PostgreSQL Data Source
Server = localhost
Port = 5432
UserName = valid_user
Password = valid_passwd
;Socket = 4096
;end odbc.ini

-- 
-----------------------------------------------------------------
To unsubscribe send email to gebruikers-unsubscribe-9zHSPcKovOGBIukByRZ1s9i2O/[email protected]
For additional commands send email to sympa-9zHSPcKovOGBIukByRZ1s9i2O/[email protected]
with Subject: help