I am having great difficulty installing DBD::mysql on MacOSX 10.3.2
Server (panther). The full build log is below. The command I used to
install was:
perl -MCPAN -e 'install "DBD::mysql"'
I am using the recent version of mysql installed from FINK.
Any ideas?
(If there is a better forum for thi
This question isn't strictly DBI, but I wasn't sure where to ask. Is there a
preferred way to encrypt data stored in a database? I'm developing an application
that has higher security requirements than what I've done in the past and I want to
make sure the data is safe. I know that MySQL has
>
>
> I am trying to hit a MS SQL server using DBI:ODBC from an
> win2k box. I have the odbc client setup on my box, but I can
> not get the perl to hit it. Any help would be great! I use
> DB2 with no problem and am trying the MSSQL world (not by
> choice ;-). Here is what I am trying to
FYI, You should *always* try to get DBI and DBD::xxx from my site if you are
going to get it at all. Reason: the DBI has some internal versioning issues
upon which DBDs are dependant. Getting DBI Version X from one place and
DBD::Y which was not built with DBI version X, can cause issues...
Rega
Thanks for the feedback, this did the trick for me.
The next question I have is regarding a good way to archive changes.
I have already created a separate archive table. I am mainly curious as to
if there is a standard method of moving a row from one table to another. If
I were t
Peter showed me the error of my ways
my $dbh = DBI->connect('dbi:ODBC:MSSQL', 'ID','password'); if
($DBI::errstr) {print $DBI::errstr;}
And for future reference the error was:
Data source name not found and no default driver specified (SQL-IM002)
Thanks,
John W. Herbold Jr.
-
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 20, 2004 11:23 AM
> To: Hardy Merrill; [EMAIL PROTECTED]
> Subject: RE: Need some MySQL query help...
> *** OUTPUT ***
> syntax error at ./passwd2db.pl line 34, near ""Adding $key1
What's the error that's returned?
I looked at some code that I use for ODBC, and my format is
DBI->connect('dbi:ODBC:dsn','username','password'), not 'database=dsn'.
HTH,
Dave
On Jan 20, Herbold, John W. scribed:
> I am trying to hit a MS SQL server using DBI:ODBC from an win2k box. I have
>
Hello All,
I think this is is an old known problem
(http://www.mail-archive.com/[EMAIL PROTECTED]/msg18506.html), but just to
be sure:
There is a memory leak when using binding and multiply executes also in
DBD::Pg 1.31.
The following script reproduces the problem:
use DBI ;
use DBD::Pg qw/:pg
I think that should be 'dbi:ODBC:DSN=MSSQL' or 'dbi:ODBC:MSSQL' but the error
message would have helped.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 20-Jan-2004 Herbold, John W. wrote:
> I am trying to hit a MS SQL server using DBI:ODBC from an win2k box. I have
> the odbc client
I am trying to hit a MS SQL server using DBI:ODBC from an win2k box. I have
the odbc client setup on my box, but I can not get the perl to hit it. Any
help would be great! I use DB2 with no problem and am trying the MSSQL
world (not by choice ;-). Here is what I am trying to run...
# I have th
You can try a != instead of the <> for not equal.
- Forwarded by Patricia A Markiewicz/US/DNY on 01/20/2004 10:38 AM
-
"NIPP, SCOTT V
(S
Thanks for the feedback. I am getting an error during the compile.
I think my problem is in the structure of the SELECT statement. I was
taking a guess on how to test for inequality. My guess now is that the "<>"
is simply invalid, and this is where my problem is coming from. Here again
You're saying that you have a problem and that you think the problem is
in the matching logic in the SELECT, but you don't say exactly _what_ is
happening. Put some prints in so you can see the values of the
variables you are plugging into the sql - make sure those values match
what you are expect
I am working on a set of Perl scripts, along with some PHP web
pages, to help organize and automate user account creation in a large HP-UX
environment. I am currently writing a few scripts to gather all of the
existing user account data from every system and populate a couple of
database t
I encountered a very similar problem to this on a Windows XP machine. I
had ActiveState perl 5.6 installed. I upgraded to 5.8.2 and installed
DBI from the standard repository and the 5.8.2 DBD-Oracle from
ftp.esoftmatic.com/outgoing/DBI/5.8.2. I got the same error described
by the original poste
16 matches
Mail list logo