Sharon,
The odbcinst.ini file should contain an entry like:
[FreeTDS]
Description = FreeTDS
Driver = /usr/local/freetds/lib/libtdsodbc.so
DontDLClose = 1
assuming you were using FreeTDS which was just a guess on my part.
You need to find where your ODBC driver shared object is installed
i.e. libtdsodbc.so or whatever the driver is.
Perhaps I need to review the tutorial I pointed you at. What happens
when you refer to DSN=mydsn is unixODBC looks up [mydsn] in the odbc.ini
file where it finds a Driver=FreeTDS. unixODBC then looks up [FreeTDS]
entry in odbcinst.ini where it gets a Driver=/path_to_driver then it
loads the shared object pointed to.
Martin
Smith, Sharon Michelle (OSLO) wrote:
Thanks Martin, Dan...
That would definitely explain the DSN problem I was having and makes a
lot of sense. It fixed all my DSN not found errors. However, I'm still
having difficulty pointing the odbc.ini file to the correct driver with
the DRIVER attribute. Mostly, I don't know where it got installed or
what it's called. Easysoft's documentation says something about
unixODBC talking to odbcinst.ini for this. I've tried pointing it to
the odbcinst.ini file and even just the directory that holds that file,
but I keep receiving that error: "Can't open lib path/to/odbcinst.ini"
I'm definitely doing something wrong. I thought it was supposed to be
pointing to a '.so' type file. Can anyone help me?
(Clarification for anyone who's seeing this for the first time, I'm
trying to get my connectivity tests working for a DBD::ODBC driver
module I've installed on a Linux environment.)
Thanks for any info...
~Sharon
-----Original Message-----
From: Dan Scott [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 5:00 AM
To: dbi-users@perl.org
Subject: Re: [dbi] DSN's
For the DSN-less connections, see http://www.connectionstrings.com --
great resource.
Dan
On 6/2/05, Martin J. Evans <[EMAIL PROTECTED]> wrote:
Sharon,
The string after "ODBC:" is usually a DSN name as in:
DBI->connect("dbi:ODBC:mydsn",...)
or
DBI->connect("dbi:ODBC:DSN=mydsn")
where mydsn is an entry in your unixODBC odbc.ini file defining host,
port, dbname e.g.
[mydsn]
driver = freetds
host = something.something.something
port = 1521
dbname = name
If you want to use DSN-less connections then you'll need to start with
DRIVER=freetds or whatever. Note, you should have a freetds entry in
odbcinst.ini also.
You can find your user and system odbc.ini files with odbcinst -j.
Perhaps
http://www.easysoft.com/products/9999/documentation/perl_tutorials/dbd
_odbc_tuto
rial1.html
and
http://www.easysoft.com/products/9999/documentation/perl_tutorials/dbd
_odbc_tuto
rial3.html
might help explain as they contain alot about unixODBC, DSNs etc.
Martin
On 01-Jun-2005 Smith, Sharon Michelle (OSLO) wrote:
Hi,
I'm trying to debug an install for my DBD::ODBC module, and since
this is my first experiment with the DBI, I have a question on
format/syntax. But first, here's some background info that may/not
help:
Environment is Linux
I've already installed/tested Perl5, DBI, unixODBC (manager) Now,
I'm trying to install the ODBC driver
In order to install the ODBC driver, environment variables: DBI_DSN,
DBI_USER, DBI_PASS, ODBCHOME, LD_LIBRARY_PATH, and LANG all had to
be added to .bashrc
I'm installing the DBD::ODBC module from CPAN. It comes with a
series of connectivity tests that you can run after running 'make'
by doing 'make test'. I'm trying to narrow down my list of things
that could be wrong. Almost all of the errors seem to be
complaining about my 'DSN not found or my driver not specified'.
Can someone tell me if the following syntax is ok or if any other
major no-no's jump out at you?
export
DBI_DSN='dbi:ODBC:host=something.something.something;port=1521;dbnam
e=na
me'
I'm very new to all this and would appreciate as much detailed help
as possible. Thanks for any info....
--
Martin J. Evans
Easysoft Ltd, UK
Development
