Re: Postgres 7.2, DBI DBD::Pg

2002-04-22 Thread David Wheeler
On 4/22/02 9:41 PM, "Dave K" <[EMAIL PROTECTED]> claimed: > OfCourse posting the error might help > > could not connect to server: Connection refused at ./test_pg.pl line 11. Do you have TCP/IP support enabled for your PostgreSQL database? Regards, David -- David Wheeler

Re: Postgres 7.2, DBI DBD::Pg

2002-04-22 Thread Dave K
OfCourse posting the error might help could not connect to server: Connection refused at ./test_pg.pl line 11. "Dave K" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi All, > Well, I did one of those things that makes me ask myself 'What Were You > Thin

Postgres 7.2, DBI DBD::Pg

2002-04-22 Thread Dave K
Hi All, Well, I did one of those things that makes me ask myself 'What Were You Thinking!'. A previous post complaining that a particular idiom didn't work as advertised for DBD::Pg 'inspired' me to upgrade DBI (good), DBD::Pg (good), then Postgresql itself (this required an upgrade of cygwin

RE: :ProxyServer Refusing Client

2002-04-22 Thread Sterin, Ilya
Look at the temp DBI FAQ (it will soon be a part of the main FAQ) once we get a site up. http://xmlproj.dyndns.org/cgi-bin/fom Ilya > -Original Message- > From: Chuck Tomasi [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 5:32 PM > To: [EMAIL PROTECTED] > Subject: DBI::ProxyS

Re: Resolved: Re: How to Control of Triiger on Web

2002-04-22 Thread KAWAI,Takanori
- Original Message - From: "Ryoji Watahiki" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 4:16 PM Subject: Resolved: Re: How to Control of Triiger on Web (snip) > When I checked out my source carefully many times, I found the mistake > about Description of

Re: DBD on HPUX 11i

2002-04-22 Thread Donald Dylla
Did this last year and so I do not remember all of the details but here are two things that I found I had to do when getting Oracle to work with HP11 in our environment. 1. changed Oracle.sl via chatr to look at the SHLIB_PATH when trying to resolve shared libraries. Please note that for HP

DBI::ProxyServer, Refusing Client

2002-04-22 Thread Chuck Tomasi
My mistake, the command line is: dbiproxy --configfile=/tmp/proxy.cfg --debug --localport=19000 -Original Message- From: Chuck Tomasi Sent: Monday, April 22, 2002 12:32 PM To: '[EMAIL PROTECTED]' Subject: DBI::ProxyServer, Refusing Client I'm trying to get DBI::ProxyServer (via dbipro

DBI::ProxyServer, Refusing Client

2002-04-22 Thread Chuck Tomasi
I'm trying to get DBI::ProxyServer (via dbiproxy) going. All I get is "Refusing Client" even when I set the config file to accept everyone. DBI 1.21 Perl 5.6.0 DBD::Oracle 1.12 Command run on the proxy: dbiproxy --configfile /tmp/proxy.cfg --debug --localport 19000 Config file (/tmp/proxy.cfg

RE: Transferring from Access to MySQL

2002-04-22 Thread CNjaka
The best way to transfer the data, as has been mentioned, it to dump to a flat file, then suck into the target database. Most database engines have a method for loading comma or otherwise delimited files. One caution: Since the source database has already checked the referential integrity and con

DBI::ProxyServer Refusing Client

2002-04-22 Thread Chuck Tomasi
I'm trying to get DBI::ProxyServer (via dbiproxy) going. All I get is "Refusing Client" even when I set the config file to accept everyone. I've noticed that the examples in the DBI::ProxyServer perldocs are syntactically incorrect (no closing "]" and no surrounding { }). DBI 1.21 Perl 5.6.0 DBD

RE: Transferring from Access to MySQL

2002-04-22 Thread PARLEY,JON (HP-MountainView,ex1)
Ian, I'd like to add that you may want to control the size of the files you dump (probably by limiting the rowset you dump to each file), making sure you don't create a file that can't be properly accessed by the OS. _/ Thunder Jon Parley _/ Software Engineer _/_/_/ _

Error in make ( When install the DBD-Oracle 1.12)

2002-04-22 Thread aulloa
Hi: I have the next problem when i do the make: The make can't look the next variables: `OCI_HTYPE_SUBSCRIPTION' `OCI_DTYPE_LOCATOR' Where are they? I have Solaris 8, Oracle 8.0.6, DBI 1.20 Regards and Thanks in advance. AUlloa This is the result for the commnd make: # make cp oraperl.ph bl

Re: Transferring from Access to MySQL

2002-04-22 Thread Ronald J Kimball
On Mon, Apr 22, 2002 at 02:55:38PM -0600, Ian Harisay wrote: > The other question is how often will you do this? Is it a one time shot? > If so, do what is easiest to implement. If you know how do it using > inserts, then do it. Don't debate it. The amount of time you might have > saved will b

Re: Transferring from Access to MySQL

2002-04-22 Thread Ian Harisay
The other question is how often will you do this? Is it a one time shot? If so, do what is easiest to implement. If you know how do it using inserts, then do it. Don't debate it. The amount of time you might have saved will be long gone if you don't just act now. Once again, if this is a one

RE: Transferring from Access to MySQL

2002-04-22 Thread Herbold, John W.
Mark, Try your hardest to use the LOAD procedure. Though I have not done it in MYSQL yet, I have found with other databases, that the load procedures are always faster than doing an insert a record at a time. I have taken a DB2 database and used inserts to insert the records one at a time into

problem retrieving a ResultSet...

2002-04-22 Thread Gajjala, Bhushan
I am having a problem retrieving a ResultSet from an Oracle stored function. The function is called from a script that connects to an Oracle DB via the DBD::Proxy driver. Here's my sample code: my $sth1 = $DB->prepare(q{BEGIN ? := f_get_a_cursor();

Re: problems compiling DBD-InterBase-0.30

2002-04-22 Thread Marco Schlünß
is the interbase client library installed on your system? marco

Re: Transferring from Access to MySQL

2002-04-22 Thread Michael A Chase
On Mon, 22 Apr 2002 12:23:22 -0400 Mark Riehl <[EMAIL PROTECTED]> wrote: > All - We've got several Access databases that have ~2 million records and > each record has ~20 fields. > > Looking for the most efficient way to do this. As far as I can tell, I > have > two options: > 1. Open a connec

Re: DBI DBD-Oracle-1.12 download

2002-04-22 Thread Michael A Chase
On 20 Apr 2002 00:17:45 -0400 Harvey Cary <[EMAIL PROTECTED]> wrote: > I have not been able to download DBD-Oracle-1.12 from CPAN. Is their > another location I can download it from? > http://mirror.cpan.org/ -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** As

Transferring from Access to MySQL

2002-04-22 Thread Mark Riehl
All - We've got several Access databases that have ~2 million records and each record has ~20 fields. Looking for the most efficient way to do this. As far as I can tell, I have two options: 1. Open a connection to each database, select * from the Access table, then push each row into MySQL. 2.

problems compiling DBD-InterBase-0.30

2002-04-22 Thread Grosmann, Ruud
hi all, I have been trying to compile and install a recent DBI-module and a DBD-Interbase module. The first went OK, the latter gave me problems which I cannot solve. Can anybody give me a hint? I work on a Solaris platform, I use perl-5.6.0 I have already installed DBI-1.21 The first try, afte

Re: DBI and Sybase opening multiple connections.

2002-04-22 Thread Michael Peppler
On Fri, 2002-04-19 at 23:07, Michael Eales wrote: > Hi, > > I have a perl script that talks to a Sybase database through DBI to > DBD::Sybase. > The insert or update queries seems to open up an new TCP connection for each > update or insert that the script has to perform. > Once the stateme

DBI DBD-Oracle-1.12 download

2002-04-22 Thread Harvey Cary
I have not been able to download DBD-Oracle-1.12 from CPAN. Is their another location I can download it from? -- Thanks, Harvey Cary CISSP, MCSE+I INS-USA [EMAIL PROTECTED] (919)264-6310 signature.asc Description: This is a digitally signed message part