Date: Thu, 1 Feb 2001 20:47:56 +0600 (NS) From: Max Khon <fjoe@iclub.nsu.ru> To: Mike Meyer <mwm@mired.org> Cc: freebsd-database@FreeBSD.ORG Subject: Re: unixODBC help? Message-ID: <Pine.BSF.4.21.0102012041290.35759-100000@iclub.nsu.ru> In-Reply-To: <14969.13345.991875.173020@guru.mired.org>
next in thread | previous in thread | raw e-mail | index | archive | help
hi, there!
On Thu, 1 Feb 2001, Mike Meyer wrote:
> > > > > Has anyone out there managed to get the unixODBC port to work?
> > > > > Especially talking to the postgres7 port with ODBC enabled? If so, any
> > > > > pointers would be appreciated; the docs seem to refer to tools I don't
> > > > > have.
> > > > works like a charm here.
> > > > you do not have to enable ODBC in postgresql7 port because unixODBC has
> > > > its own PostgreSQL ODBC driver. There is ongoing work to merge unixODBC
> > > > driver with one PostgreSQL has in its tree.
> > > Knowing that you've got it working isn't a lot of help. Can you
> > > provide details, or pointers to documentation?
> > knowing that it does not work for you does not help much either :)
> > can you tell what is not working?
>
> Everything.
>
> I know, not much help. Let's see....
>
> Well, the user manual talks about OODBConfig and DataManager, but they
> port didn't install them :-(.
>
> Given the clue that I should be looking in the unixODBC port for
> drivers, I actually got past the previous problem (errors from
> odbcinst). That now seems to work, with template files lifted from the
> docs, except to change the database name to one I actually have):
>
> su-2.04# odbcinst -i -d -f /tmp/foobar
> [odbcinst] Driver installed. Usage count increased to 3. Target directory is /usr/lib
> su-2.04# odbcinst -i -s -f /tmp/foobaz
> [odbcinst] Sections and Entries from /tmp/foobar have been added to ODBC.INI
>
> Though the "Target directory is /usr/lib" worries me somewhat.
>
> The isql documentation doesn't actually say what string from the
> various template files should be used for the DSN. Trying the obvious
> one generates an error:
>
> guru$ isql PostgreSQL
> [ISQL]ERROR: Could not SQLConnect
>
> I don't see any sign of an sql.log file around.
>
> The eventual goal is to connect with the Applixware Office data
> application. Being able to verify that some part of it is working
> would be a nice start.
odbcinst is a bit tricky (was tricky at the time I looked at it)
basically, you should have two files in /usr/local/etc:
--- cut here (odbcinst.ini) ---
[PostgreSQL]
Description = PostgreSQL driver
Driver = /usr/local/lib/libodbcpsql.so
Setup = /usr/local/lib/libodbcpsqlS.so
FileUsage = 1
;Debug = 1
--- cut here ---
odbcinst.ini describes which drivers are installed on your system
--- cut here (odbc.ini) ---
[test]
Description = PostgreSQL
Driver = PostgreSQL
Database = test
Servername = localhost
Readonly = No
--- cut here ---
odbc.ini file describe DSNs ("test" in the example above is DSN).
You can have multiple DSNs pointing to one database.
I hope this will be sufficient for you to start
/fjoe
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0102012041290.35759-100000>