Re: Error on DBI

2006-04-21 Thread Alexander Foken
Do you use the same username and password to connect? Perhaps the DB permissions do not allow the user account rpt_preview.plx uses to access that column or table. From my experience, DBI never falsely reports errors. The structure of your error message ([vendor][driver][server]message) is

RE: DBD::Solid or DBD::ODBC with Solid

2006-04-21 Thread Martin J. Evans
Simon, I can't tell from this why it is not working. Assuming the entries you mentioned are in the odbcinst.ini and odbc.ini files used by unixODBC (the output of odbcinst -j) and the shared object for your driver can be loaded then it should work. You haven't by any chance set the ODBCINI or

Re: last insert id

2006-04-21 Thread Ron Savage
Hi Nope. Method db_vendor() extracts the vendor's name from the connect string passed to DBI, so I don't see how it could return that :-))). And anyway, I control the config file this data comes from, so spaces won't appear there... OK, so your /(?:mysql|Pg)/ should have been more like

Re: last insert id

2006-04-21 Thread Dr.Ruud
Ron Savage schreef: [attribution repaired] Ruud: [attribution repaired] Ron: [attribution repaired] Ron: Nope. Method db_vendor() extracts the vendor's name from the connect string passed to DBI, so I don't see how it could return that :-))). And anyway, I control the config file this

RE: last insert id

2006-04-21 Thread Garrett, Philip \(MAN-Corporate\)
-Original Message- From: Dr.Ruud [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 6:37 AM To: dbi-users@perl.org Subject: Re: last insert id [snip] I did not say it extracts the colons, and I did not say it returns the connect string with the embedded colons, and I did

sv_setpvn error in DBD::Sybase

2006-04-21 Thread Hendrik Vanbelleghem
Hi, I'm experiencing some problems when trying to get DBD::Sybase to consult Micromuse Netcool ObjectServer database. I'm working on 2 solaris 64 bit machines, both running perl 5.8.0, DBI version 1.5.0, DBD::Sybase 1.07 and FreeTDS O.63. I've applied 2 patches that are provided through the

RE: last insert id

2006-04-21 Thread Ronald J Kimball
Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] wrote: Whatever anchors are there, should be used, as I already pointed at in my first reaction. Since, you haven't supplied a correction to your code. So we're back at: /\A(?:mysql|pg)\z/i /\A(?i:mysql|pg)\z/ If you

RE: last insert id

2006-04-21 Thread Garrett, Philip \(MAN-Corporate\)
-Original Message- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 10:38 AM To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org Subject: RE: last insert id Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] wrote: Whatever anchors are

Re: last insert id

2006-04-21 Thread Ron Savage
On Fri, 21 Apr 2006 12:36:43 +0200, Dr.Ruud wrote: Hi your code. So we're back at: /\A(?:mysql|pg)\z/i /\A(?i:mysql|pg)\z/ Nope. Wrong again. Notice a pattern developing here? DSNs 101: A Tutorial Based on My Crude Level of Understanding My CGI programs normally have up to 3 distinct