Re: [dbi] DSN's and DRIVER attribute

2005-06-02 Thread Martin J. Evans
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 s

RE: [dbi] DSN's and DRIVER attribute

2005-06-02 Thread Smith, Sharon Michelle (OSLO)
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 ins

Re: Seeking advice on DBI,DBD on Windows for multiple RDBMS

2005-06-02 Thread Gav....
| --downloading activeperl, which then requires that I | install MS C runtime libraries. Does it, I have never had to do that. http://minitutorials.com/apache/stats11.shtml Gav... -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 267.5

Re: Seeking advice on DBI,DBD on Windows for multiple RDBMS

2005-06-02 Thread Michael A Chase
Quoting David Goodman <[EMAIL PROTECTED]>: > As I understand it, I have choices of: > > --building under cygwin, which then requires me to run under cygwin. Cygwin also tends to be a bit slow. That may or may not matter in your target environment. On the other hand, it gets you the closest to a

Seeking advice on DBI,DBD on Windows for multiple RDBMS

2005-06-02 Thread David Goodman
I have been poring over various web sites and postings trying to figure out a reliable, simple approach to setting up a perl/dbi/dbd environment in which I can connect to sybase, oracle, ms sqlserver, and udb. Some considerations are: 1. Minimal impact to the target environment. By this I mean th

Seeking advice on DBI,DBD on Windows for multiple RDBMS

2005-06-02 Thread David Goodman

Re: [dbi] DSN's

2005-06-02 Thread Dan Scott
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=myds

Re: Retrieving data from Oracle

2005-06-02 Thread Tim Bunce
FYI, the fetchrow_hashref docs now say By default a reference to a new hash is returned for each row. It is likely that a future version of the DBI will support an attribute which will enable the same hash to be reused for each row. This will give a significant perf

RE: [dbi] DSN's

2005-06-02 Thread Martin J. Evans
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 = 1