Confused: DBI, MySQL and utf8

2005-03-31 Thread Bas Schulte
Hi all, I know I'm not the first one who's asked about this but I fail to see the light on this topic (that's what you get when brought up in a west-european country: all your really understand is ascii). I'm working on making a fairly large system fully utf8: stuff all texts in utf8 tables

RE: Accessing MS Access through the DBI ODBC

2005-03-31 Thread Moreno, Javier
Kevin, I tried removing the user and the pwd from the ODBC connect string but I am still getting 'Unable to connect to database'. Here is my code # Include CPAN modules for DB communication use DBI; use DBD::ODBC; # Use these pragmas to code correctly use strict; # Connect to the database,

RE: [dbi] RE: Accessing MS Access through the DBI ODBC

2005-03-31 Thread Martin J. Evans
It looks as though you are running CGI under a web server. The most common reason for this issue is the mdb is on a mapped drive where the mapped driver was mapped by a different user to the one the web server is running as. However, there are loads of other reasons for this - search

Re: Re: Accessing MS Access through the DBI ODBC

2005-03-31 Thread amonotod
From: Kevin Carothers [EMAIL PROTECTED] Date: 2005/03/30 Wed PM 06:44:48 CST 1. Create an ODBC connection via %SystemRoot%\system32\odbcad32.exe Call the database connect name ODBCName 2. In your Perl code add: [---] use DBI; [---] $dbh =

Install Issues With PERL Informix::DBD On HPUX

2005-03-31 Thread Cory Cox
Basically we are trying to establish a database connection from an HPUX box running on a network. Our database server is remote on another HPUX box. We have Perl 5.8.6 installed with all the current DBI and DBD modules. We also have an SDK client installed as well. When we try to install

Re: Accessing MS Access through the DBI ODBC

2005-03-31 Thread Kevin Carothers
Hi Javier, [---] And on the log I get: [Thu Mar 31 07:12:56 2005] [error] [client 151.110.117.153] DBI connect('CLUCTR','',...) failed: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by

esoftmatic ftp down?

2005-03-31 Thread Robert
I was trying to get DBD::Oracle9, off of there but I get a connection error... Robert

string help!

2005-03-31 Thread Ron Stephan
Help -- I am lost trying figure out what occurs to me a really simple problem. CGI-Perl-MySQL. Users pounding data into a CGI-Perl web page feeding MySQL. If the user enters a special character it crashes. As in Bob's Market... Yeah - trap for special chars and escape them. This seems so

RE: string help!

2005-03-31 Thread Ronald J Kimball
Ron Stephan [mailto:[EMAIL PROTECTED] wrote: I am lost trying figure out what occurs to me a really simple problem. CGI-Perl-MySQL. Users pounding data into a CGI-Perl web page feeding MySQL. If the user enters a special character it crashes. As in Bob's Market... Yeah - trap

Re: string help!

2005-03-31 Thread Hardy Merrill
Use placeholders - all your quoting issues will go away. Read about them by doing perldoc DBI at a command prompt and searching for Placeholders. HTH. Hardy Merrill Ron Stephan [EMAIL PROTECTED] 3/31/2005 1:52 PM Help -- I am lost trying figure out what occurs to me a really simple

RE: string help!

2005-03-31 Thread Hardy Merrill
Just in case it's not clear to you, the placeholders are the question marks in the VALUES part of the sql ;-) Ronald J Kimball [EMAIL PROTECTED] 3/31/2005 2:36 PM Ron Stephan [mailto:[EMAIL PROTECTED] wrote: Placeholders? Like how? Here's a quick example: my $sth =

RE: string help!

2005-03-31 Thread Anderson, James H \(Company IT\)
Probably not the optimum solution if you're using Sybase... -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 2:11 PM To: [EMAIL PROTECTED]; dbi-users@perl.org Subject: Re: string help! Use placeholders - all your quoting issues will go

RE: string help!

2005-03-31 Thread Hardy Merrill
Really! Why not? I don't have any experience with Sybase but I haven't that comment about any other databases that *shouldn't* use placeholders. Anderson, James H (Company IT) [EMAIL PROTECTED] 3/31/2005 2:52 PM Probably not the optimum solution if you're using Sybase... -Original

RE: string help!

2005-03-31 Thread Anderson, James H \(Company IT\)
I don't remember the details, but I think they're documented in DBD::Sybase. It believe it has something to do with the way sybase supports (cobbles up may be more appropriate) placeholders. Consequently, AFAIK, almost no one in the sybase world use them. -Original Message- From: Hardy

RE: string help!

2005-03-31 Thread amonotod
From: Anderson, James H \(Company IT\) [EMAIL PROTECTED] Date: 2005/03/31 Thu PM 01:59:26 CST Consequently, AFAIK, almost no one in the sybase world use them. How sad... I already figured out that I'm a nobody, but now I'm no one at all... *sigh*... amonotod -- `\|||/

RE: string help!

2005-03-31 Thread Michael Peppler
On Thu, 2005-03-31 at 21:59, Anderson, James H (Company IT) wrote: I don't remember the details, but I think they're documented in DBD::Sybase. It believe it has something to do with the way sybase supports (cobbles up may be more appropriate) placeholders. Consequently, AFAIK, almost no one