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
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,
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
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 =
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
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
I was trying to get DBD::Oracle9, off of there but I get a connection
error...
Robert
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
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
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
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 =
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
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
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
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
--
`\|||/
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
16 matches
Mail list logo