> Dear Jeff and Tim,
>
> Here's a patch which more or less got DBD::ODBC 1.01 up and
> running using Informix CLI as the ODBC driver (and driver
> manager) on Solaris.
Jonathan -- that's GREAT! FYI -- I strongly encourage people to use a
driver manager, to simplify the building process. unixO
Just an FYI:
DBD::Teradata runs on a Theraphone (which runs PocketPC)
via 3G wireless, as well as on Zaurus via WiFi. See
www.presicient.com/terapocket
for some simple screenshots
BTW: if you try porting other DBD's that work remotely, be aware that
the ARM float format is slightly different t
Just a preliminary report - thanks to Rainier Keuchel's port of perl to
winCE, I now have DBI (PurePerl) and DBD::AnyData doing database read
access on my Toshiba e740 (a palm-like handheld running pocketPC on an
xScale processor). The port also works on most other pocketPC and
winCE device (
Check out DBI::Shell or dbish. A basic version is installed with
DBI. A more advanced version is available from CPAN (requires
additional modules).
I often use it with to test DBD::ADO. (Actually I use it with
every database I work with that DBI talks with, on MS Windows,
Linux, and Solaris).
Tom
I'm running RH8.0, and my install came with DBI and DBD::Pg
(postgreSQL) installed - I'm not sure what installer choice(s)
you have to make to get those, but I chose everything language
(perl, etc.) and database related for my install.
Ron Stephan [[EMAIL PROTECTED]] wrote:
>
>
> I am still lo
I am still lost struggling with getting DBI up ona RH box.
OS = RH8.0
Perl = RH Perl 5.8.0
I am trying to get a DBI module installed (any kind of DBD would make me
happy) and am striking out.
I have downloaded from CPAN and used every web page instruction.
DBI fails in the ma
On Tue, 17 Dec 2002 13:21:52 -0600 "Ford, Andy" <[EMAIL PROTECTED]> wrote:
> I'm getting an error running DBD::Oracle:
>
> DBD::Oracle::db do failed: ORA-00906: missing left parenthesis (DBD
> ERROR:
> OCIStmtExecute/Describe) at ./trace.pl line 13.
>
> The environment is perl 5.6.1 on Solaris 8
Try "select * from device"
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 2:28 PM
To: Ford, Andy
Cc: '[EMAIL PROTECTED]'
Subject: Re: "missing left parenthesis" problem running DBD::Oracle
SQL> select * from table device;
select * from
SQL> select * from table device;
select * from table device
*
ERROR at line 1:
ORA-00906: missing left parenthesis
SQL>
On Dec 17, Ford, Andy scribed:
> I'm getting an error running DBD::Oracle:
>
> DBD::Oracle::db do failed: ORA-00906: missing left parenthesis (DBD ERROR:
>
I'm getting an error running DBD::Oracle:
DBD::Oracle::db do failed: ORA-00906: missing left parenthesis (DBD ERROR:
OCIStmtExecute/Describe) at ./trace.pl line 13.
The environment is perl 5.6.1 on Solaris 8 with DBI 1.32 and DBD-Oracle
1.12.
The script that produces the above error is just:
#!
Thanks for the help. Unfortunately I am at the following impass.
1. perl -MCPAN -e "install 'RPC::PlServer'"
>> Checking if your kit is complete...
>> Looks good
>> Writing Makefile for RPC::PlServer
>> -- OK
>> Running make test
>>test -- NOT OK
>> Running make install
>>
On Tue, 2002-12-17 at 05:16, [EMAIL PROTECTED] wrote:
> Hi,
>
> this is a bit offtopic: I don't want to run to the server each time I want
> to check contents of some table: Is there a sqlconsole where I can just
> connect to the server via ODBC and do some SQL statements?
Go to http://www.freetd
> osql comes with the client tools. If you have Enterprise
> Manager, then
> you've got it.
I thought that there should be something with it... though the enterprise
manager is on the server, can I install it also locally?
Lars
On 17 Dec 2002 08:09:25 -0500 chad kellerman <[EMAIL PROTECTED]> wrote:
> Everyone,
> thanks for the help with the script. I took everyone's input and
> rewrote it.
>
> #!/usr/bin/perl
Adding -w to this line will help spot a variety of runtime errors before
they accumulate.
> $dbh = DBI->conne
Sorry all... I got the problem straitened out. On the one machine that really matters
to me... the tnsnames has been corrupted and part of it (including the entry i need is
missing). This hasn't solved the mystery on what's going wrong on some of the other
machines... but I won't bother any of
osql comes with the client tools. If you have Enterprise Manager, then
you've got it.
H:\>osql /?
usage: osql [-U login id] [-P password]
[-S server][-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout
Hi,
--- Jonathan Leffler <[EMAIL PROTECTED]> wrote:
>
> Not being aware that there was an ActiveState
> version of Perl for any
> platform other than MS Win32, there's no way I can
> answer that.
Well, there are ActivePerls for Linux and Solaris,
though I've never made use of them. Also:
htt
By the way. Theere is a ADO out. Why using ODBC in a win2win net ??? You
will just need it if you work on a unix or mac box. ADO is more faster and
better to handle with.
I supose you can do Ado-Connections with Accsess Viwe the docs.
Kris
n 17.12.2002 15:23 Uhr, "Kris Wolff" <[EMAIL PROTEC
On Tue, Dec 17, 2002 at 09:11:22AM -0500, Chris Faust wrote:
> Hello All,
>
> This may not be a DBI problem, but I've haven't been able to turn up any
> good info so I'm giving the list a shot..
>
> The problem is with double quotes, in short I have a HTML form text box to
> take a user inputted
Not sure if this is the answer, but it might be - see below.
Chris Faust [[EMAIL PROTECTED]] wrote:
> Hello All,
>
> This may not be a DBI problem, but I've haven't been able to turn up any
> good info so I'm giving the list a shot..
>
> The problem is with double quotes, in short I have a HTML
I worked a lot on mssql but I have to say, I do not know much, because I do
not like it ! I ve I need a comercial fast sql server I buy sybase And
not this silly slow up // hard ministratiing tool.
Anyway if you just need the results from a mssql server table why not build
up a perl client ? (
Hello All,
This may not be a DBI problem, but I've haven't been able to turn up any
good info so I'm giving the list a shot..
The problem is with double quotes, in short I have a HTML form text box to
take a user inputted description which gets saved into a mySql table into
the following field.
> VNC or
> Odbc over Access.
> kris
hm, sounds like much overhead... I thought there's some easy Dosbox tool
like for DB2 for a few quick statements... cause even with vnc I'd have to
click me through that Enterprise Manager until i see some contents of a
table...
Lars
On Mon, Dec 16, 2002 at 02:54:01PM -0600, Mitchel, Jennifer (Jem) wrote:
> Hi all,
>
> I am getting the following error out of a script.
> DBI->connect(carespro) failed: ORA-12154: TNS:could not resolve service name (DBD
>ERROR: OCIServerAttach) at test.cgi line 11
> Can't call method "prepar
Ah sorry mssql ...
2 ways:
VNC or
Odbc over Access.
Or a perl client :-)))
I always done the vnc thing.
kris
On 17.12.2002 15:08 Uhr, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
>> Mysql/bin/mysql -h ipadress of host -u username
>> kris
>
> of course I do that with my Linux-Box and MySql.
> Mysql/bin/mysql -h ipadress of host -u username
> kris
of course I do that with my Linux-Box and MySql. Problem here is, that MSSQL
usually runs on Windows machines without ssh or anything else ;)
Lars
Why not direkt ??
Via ssh, or
Phpmyadmin ( webbased )
Or just
Mysql/bin/mysql -h ipadress of host -u username
kris
On 17.12.2002 14:16 Uhr, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> this is a bit offtopic: I don't want to run to the server each time I want
> to check contents of
* Mitchel, Jennifer (Jem) <[EMAIL PROTECTED]> [2002-12-17 04:19]:
> Hi all,
>
> I am getting the following error out of a script.
> DBI->connect(carespro) failed: ORA-12154: TNS:could not resolve
> service name (DBD ERROR: OCIServerAttach) at test.cgi line 11 Can't
> call method "prepare"
Hi,
this is a bit offtopic: I don't want to run to the server each time I want
to check contents of some table: Is there a sqlconsole where I can just
connect to the server via ODBC and do some SQL statements?
regards, Lars
Everyone,
thanks for the help with the script. I took everyone's input and
rewrote it.
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my( $dbname ) = "BACKUP";
my( $mysqluser ) = "bob";
my( $mysqlpasswd ) = "bobspasswd";
my( $dbh, $sth, $rc );
my( @failedCon, $var, $name, @names );
#these
Hi all,
I am getting the following error out of a script.
DBI->connect(carespro) failed: ORA-12154: TNS:could not resolve service name (DBD
ERROR: OCIServerAttach) at test.cgi line 11
Can't call method "prepare" on an undefined value at test.cgi line 16.
I am sure the tnsnames entry is cor
31 matches
Mail list logo
