need help with FreeIPdb Install
Hello All: I need help with DBI/DBD. After installing DBI, I try to install DBD::Pg but I get an error when running make, that it cannot find the target (see below). Also if anyone has installed FreeIPdb, why does the website say to install DBD::Pg.1.39 or better, and then direct you to a site that has up to version 1.01? Any help would be greatly appreciated. I have thus far installed: * A perl interpreter PostgreSQL 7.0 with Perl interface installed Math::BigInt-1.42 Net::IP-1.0 DBI-1.14 or better. Apache Webserver My OS is OpenBSD outpost 2.8 MYKERN#1 i386 outpost/opt/DBD-Pg-1.01$ perl -V Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration: Platform: osname=openbsd, osvers=2.8, archname=i386-openbsd uname='openbsd' config_args='-Dopenbsd_distribution=defined -dsE' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef Compiler: cc='cc', optimize='-O2', gccversion=2.95.3 19991030 (prerelease) cppflags='-fno-strict-aliasing -I/usr/local/include' ccflags ='-fno-strict-aliasing -I/usr/local/include' stdchar='char', d_stdstdio=undef, usevfork=true intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=4, usemymalloc=n, prototype=define outpost/opt/DBD-Pg-1.01$ perl Makefile.PL Configuring Pg Remember to actually read the README file ! please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB ! outpost/opt/DBD-Pg-1.01$ make make: no target to make. outpost/opt/DBD-Pg-1.01$ make test make: don't know how to make test. Stop
DBIx::MSSQLReporter
Sorry if this is off-topic (not directly DBI), but I can't seem to figure out what's going on... I've never used the MSSQLReporter module before, and can't seem to get anything to work! When I call $reporter - get_fieldNames($fieldname) with any variable I get a prepare failed error on the table name: DBD::ODBC::db prepare failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near 'billcodes'. (SQL-37000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) at C:/Perl/site/lib/DBIx/MSSQLReporter.pm line 116. You can see that the variable looks to be working, as my table name is in the error. By replacing the variable with the table name (in single or double quotes) I don't have this problem. I've tried quoting or not quoting the variable, but it just doesn't seem to work! I'm using Activestate Perl 5.6.1 build 626 on Win2k with the latest MSSQLReporter (1.00) from Activestate's PPM repository against a MS-SQL 7.0 database. Thanks in advance for any help, Scott Phelps [EMAIL PROTECTED] Webkorner Internet Services --- [ This E-mail scanned for viruses by www.WebKorner.com ]
RE: whats da error?
What is the SQL you are running? For me looks like you are getting error message in your PL/SQL block. --Raju -Original Message- From: Marius Keraitis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:27 AM To: DBI Perl Subject: whats da error? when i trying to select some data from oracle db, i have this weird error: DBD::Oracle::st execute failed: ORA-06550: line 3, column 17: PLS-00103: Encountered the symbol when expecting one of the following: ( an identifier a double-quoted delimited-identifier table the The symbol an identifier was inserted before to continue. (DBD ERROR: OCIStmtExecute) at /usr/local/apache/htdocs/klasif/tabled.pl line 67. At the line 67 in tabled.pl is: $sth-execute; Any ideas about it? MarioDaPL. :@}--}-
Re: SQL Protocol Spec
Flowers, Jay wrote: I am not sure if this is the right place to be asking such a question? I am writing a sniffer in perl and would like to be able to decode data in TCP packets from SQL clients and servers. I was wondering if there was part of the DBI that I could use to decode the raw data, or if someone could point me to the protocol specs for SQL. I'm not sure what you are wanting to do when you say decode data, but if it involves parsing the SQL statements, SQL::Parser (part of the newest SQL::Statement distribution) will do that for a limited subset of SQL. If it involves parsing the data rather than SQL statements, then DBD::AnyData may be able to help. As for the SQL specs, the full ones cost money and are available for download at http://www.ansi.com/. *Draft* specs for SQL3 can be found at http://194.109.245.185/sql/sqltmprl.pdf My favorite is the hyperlinked, browsable version of the BNF for SQL92 at http://cui.unige.ch/db-research/Enseignement/analyseinfo/SQL92/BNFindex.html -- Jeff
