[unixODBC-dev] Perl, DBI, DBD::ODBC and an ODBC Driver Manager

Roderick A. Anderson raanders at tsmg.us
Thu Jul 29 18:21:38 BST 2004


Stefan Radman wrote:

>>Are there additional packages I need?
>>    
>>
>
>All you should need for running DBD::ODBC with unixODBC and FreeTDS is:
>    unixODBC
>    freetds-unixodbc
>    perl-DBI
>    perl-DBD-ODBC
>Guess you're just missing perl-DBD-ODBC.
>
>Very useful for configuration add:
>    unixODBC-gui-qt
>  
>
Server with no GUI installed.

>The Qt (KDE) GUI helps you choose the right driver parameters when
>setting up 
>DSNs and it uses the .ini files in the right location (common mistake).
>
>I usually use odbcinst (cmdline & batch) or ODBCConfig (interactive GUI)
>to configure drivers and data sources e.g.
>  
>
I seem to remember this from one of my earlier attempts.  I'll give it a
try in a bit.

># odbcinst -i -d -r
>[FreeTDS]
>Description=FreeTDS ODBC Driver for Sybase and MS-SQL
>Driver=/usr/lib/libtdsodbc.so
>Setup=/usr/lib/libtdsodbc.so
>$ odbcinst -i -s -r
>[mydsn]
>Driver      = FreeTDS
>Description = Fun and Games
>Trace       = No
>Server      = 1.2.3.4
>;TDS_Version = 7.0
>Database    = mydb
>
>"Setup" attribute gives you the ability to use the GUI
>"ServerType" attribute you have in your "mydsn" is new to me.
>  
>
Plucked out of the pile of documentation I was going through and tried
'cause it sounded like it might help.  :-)

>Stefan
>
>  
>
>>-----Original Message-----
>>From: unixodbc-dev-bounces at mail.easysoft.com 
>>[mailto:unixodbc-dev-bounces at mail.easysoft.com] On Behalf Of 
>>Roderick A. Anderson
>>Sent: Thursday, 29 July, 2004 02:26
>>To: unixodbc-dev at mail.easysoft.com
>>Subject: [unixODBC-dev] Perl, DBI, DBD::ODBC and an ODBC 
>>Driver Manager
>>
>>
>>Thanks to Nick I got unixODBC installed and I am able to 
>>connect to the
>>MS SQL Server using isql but when I try using the DBI in Perl I get an
>>error about needing DBD::ODBC.  No problem, I'm always forgetting to
>>install a module but in this case I can't get it to install.  
>>Using perl
>>-MCPAN -e Shell I get most of the way through but it stops with not
>>being able to find an ODBC Driver Manager.  I'm sure I'm 
>>confused about
>>what a Driver Manager is so every permutation I tried failed.  I have
>>FreeTDS and unixODBC installed.
>>
>>    {~}# rpm -qa | egrep -i 'freetds|odbc'
>>    freetds-devel-0.62.1-1
>>    unixODBC-drivers-2.2.9-2sr
>>    unixODBC-devel-2.2.9-2sr
>>    unixODBC-2.2.9-2sr
>>    freetds-unixodbc-0.62.1-1
>>    freetds-0.62.1-1
>>    freetds-doc-0.62.1-1
>>    unixODBC-drivers-devel-2.2.9-2sr
>>
>>Are there additional packages I need?
>>
>>Pretty simplistic setups/ini files (that I don't think I've screwed up
>>too bad.)
>>
>>odbc.ini
>>    [ODBC Data Sources]
>>    mydsn
>>
>>    [mydsn]
>>    Driver          = FreeTDS
>>    Description     = Fun and Games
>>    Trace           = No
>>    ServerType      = unixodbc
>>    Server          = 1.2.3.4
>>    Database        = mydb
>>
>>    [Default]
>>    Driver          = FreeTDS
>>
>>odbcinst.ini
>>    [FreeTDS]
>>    Driver          = /usr/lib/libtdsodbc.so.0.0.0
>>
>>Once again all suggestions and pointers are appreciated.
>>
>>
>>Rod
>>
>>-- 
>>Roderick A. Anderson
>>Project Manager (aka. Dogsbody)
>>Technology Services Management Group 
>><http://www.technologyservicesmanagementgroup.com/>
>>Spokane WA, 99202
>>
>>
>>---
>>[This E-mail scanned for viruses by Declude Virus]
>>
>>_______________________________________________
>>unixODBC-dev mailing list
>>unixODBC-dev at mail.easysoft.com
>>http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
>>
>>    
>>
>
>_______________________________________________
>unixODBC-dev mailing list
>unixODBC-dev at mail.easysoft.com
>http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
>---
>[This E-mail scanned for viruses by Declude Virus]
>
>  
>

-- 
Roderick A. Anderson
Project Manager
Technology Services Management Group <http://www.technologyservicesmanagementgroup.com/>
Spokane WA, 99202

---
[This E-mail scanned for viruses by Declude Virus]




More information about the unixODBC-dev mailing list