X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2D7D4D1B511 for ; Tue, 17 Feb 2004 09:40:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76629-03 for ; Tue, 17 Feb 2004 05:40:00 -0400 (AST) Received: from mail2.uklinux.net (s4.uklinux.net [80.84.72.14]) by svr1.postgresql.org (Postfix) with ESMTP id 9D409D1B4C5 for ; Tue, 17 Feb 2004 05:39:57 -0400 (AST) Received: from bristolreccc.co.uk (bts-0491.dialup.zetnet.co.uk [194.247.49.235]) by mail2.uklinux.net (Postfix) with ESMTP id 664E1409FBE for ; Tue, 17 Feb 2004 09:39:43 +0000 (UTC) Received: from mike by bristolreccc.co.uk with local (Exim 4.30 #3 (Red Hat Linux)) id 1At1fN-0003tc-UE for ; Tue, 17 Feb 2004 09:37:21 +0000 Subject: Help with setting up postgres and odbc From: mike To: pgsql-interfaces@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1077010641.16755.26.camel@datacc> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 17 Feb 2004 09:37:21 +0000 X-SA-Exim-Scanned: No; Exit with error (see exim mainlog) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/43 X-Sequence-Number: 4736 I seem to be hitting a bit of a wall here. This is what I have got /etc/odbc.ini [PostgreSQL] Description = Datacc Driver = PostgreSQL Trace = Yes TraceFile = sql.log Database = data_cc Servername = localhost Host = localhost UserName = Password = Port = 5432 Servertype = postgres Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = [Default] Driver = /usr/lib/psqlodbc.so [ODBC] InstallDir = /usr/lib/libodbc.so /etc/odbcinst.ini # Example driver definitinions # # # Included in the unixODBC package [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/psqlodbc.so Setup = /usr/lib/libodbcpsqlS.so.1 FileUsage = 1 # From the MyODBC package #[MySQL] #Description = ODBC for MySQL #Driver = /usr/lib/libmyodbc.so #FileUsage = 1 using odbctest I get this when I try to connect using full connect SQLConnect() failed Diag(hdbc 0x82bd1b0):IM002:201:[unixODBC]Missing server name, port, or database name in call to CC_connect. Any help appreciated