Re: DBD-Oracle

2005-04-12 Thread Christian Braeuner
Hi Jeff, Thanks for the quick response! Christian Jeff Urlwin wrote: Please, temporarily, change ftp.esoftmatic.com to 24.249.249.7. I'm still working on resolving the DNS issues since moving ISPs and my current ISP is relatively deaf. I probably have to bit the bullett and put DNS on my

dbi on a web server

2005-04-12 Thread Bruce Martin
Hello all, Well after I finally got DBI installed on Mac OS X I made a quick test script. I then tested it out from the terminal and debugged it. It works! I then tried it on my Apache server, same system same database. This time, however I get a 500 error. In the error log I see this line:

Re: db or file access?

2005-04-12 Thread Christian Merz
another point is: how do you get a consistent snapshot (i.e. for backup)? if you store things inside and outside the database neither database backup nor filesystem backup will achieve this. one solution would be to shut down the database and take a cold backup of the database and the file system

Re: dbi on a web server

2005-04-12 Thread Thilo Planz
Well after I finally got DBI installed on Mac OS X I made a quick test script. I then tested it out from the terminal and debugged it. It works! I then tried it on my Apache server, same system same database. This time, however I get a 500 error. In the error log I see this line: [Tue Apr 12

Re: dbi on a web server

2005-04-12 Thread Bruce Martin
Of course! I don't know what I was thinking. Thank you for your quick response. On Apr 12, 2005, at 5:54 AM, Thilo Planz wrote: Well after I finally got DBI installed on Mac OS X I made a quick test script. I then tested it out from the terminal and debugged it. It works! I then tried it on my

Re: t/05threadclone.t fails

2005-04-12 Thread Tim Bunce
On Mon, Apr 11, 2005 at 07:35:58PM -0400, Philip M. Gollucci wrote: Philip M. Gollucci wrote: So it happens like 90% of the time with 5.8.6-ithreads w/libpthread on FBSD-current, (pthread.txt attachment) So next I got more endeverous and linked in libc_r I ran it 10,000 times. worked

Re: return parameter value if query does't match

2005-04-12 Thread xaver biton
I think that was the second possibility I mentioned. If the inner query doesn't find any rows, you want to do something else. many thks. It works like I wished. cheers. Xaver

RE: Errors while inserting into long data type

2005-04-12 Thread Andy Hassall
I am using oracle database and I have column of long data type. I insert the data into this column thru perl script. If the inserted data exceeds 4000 chars, it is giving me the following error. DBD::Oracle::st execute failed: ORA-01704: string literal too long (DBD ERROR:

DBD::ODBC and SQL Server Drivers on UNIX.

2005-04-12 Thread Mark F. nettleingham
I'm trying to find an open source version of an ODBC driver for Windows SQL Server. I have spent a lot of time looking around and there simply doesn't seem to be anything. I have located, downloaded and installed iODBC (which is a driver manager) but then realized that I don't have any

Re: DBD::ODBC and SQL Server Drivers on UNIX.

2005-04-12 Thread Ron Savage
On Tue, 12 Apr 2005 16:28:18 -0400, Mark F. nettleingham wrote: Hi Mark Have you considered using DBD::ProxyServer? -- Cheers Ron Savage, [EMAIL PROTECTED] on 13/04/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company

RE: :ODBC and SQL Server Drivers on UNIX.

2005-04-12 Thread Jeff Urlwin
Have you tried FreeTDS and their ODBC driver? Jeff -Original Message- From: Mark F. nettleingham [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 12, 2005 4:28 PM To: dbi-users@perl.org Subject: DBD::ODBC and SQL Server Drivers on UNIX. I'm trying to find an open source