Re: Accessing unix from windows
From: Bart Lateur [EMAIL PROTECTED] To: dbi-users mailing list [EMAIL PROTECTED] Subject:Re: Accessing unix from windows Date sent: Thu, 17 May 2001 00:46:56 +0200 Organization: MediaMind On Wed, 16 May 2001 15:27:46 -0600 (MDT), Jorge L. Allen wrote: I am writing perl scripts that access an Access Database. But the actual file's content are in a unix system. How can I open a file in a unix filesystem from a windows box usin perl? the unix system is networked and you can see it in Network Neighborhood. Do perldoc DBD::ODBC and scroll down, or rather: search for the first occurrence of the word letters. It's in the middle of some quite interesting paragraphs. If you can't easily search the results of perldoc, try the HTML version at http://search.cpan.org/doc/JURL/DBD-ODBC-0.28/ODBC.pm. To be a bit more verbose: If your .mdb file is located on a UNIX System, you will be only able to access it with Access itself (msaccess.exe) on your windows machine. AFAIK, there is no Perl module to directly access .mdb files and extract and manipulate your data in there. So, confirm first that you can open your .mdb file on the remote system with Access. If this is possible, you can 'remote control' Access with DBI and DBD::ODBC or DBD::ADO on your windows machine. In fact, reading perldoc DBI and perldoc DBD::ODBC or DBD::ADO is not the worst thing to start with. HTH Bodo [EMAIL PROTECTED] Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111 Fax: ++49 251 7793-104
DBI::Proxy with ADO/Access on WinNT
Hi I'm trying to use the DBI::Proxy / ProxyServer modules in order to move some perl scripts to Unix, yet maintain a link to an access database. While I've managed to run the ProxyServer on NT and connect to it with Proxy.pm I'm getting errors when I attempt to use it. (using DBI-trace(9)) On a delete query the query executes on the database but the following call stack is returned: Carp::croak(\'Cannot restore overloading on SCALAR(0xd0a60c) (package Win32::O...\') called at (eval 7) line 4 Storable::logcroak(\'Cannot restore overloading on SCALAR(0xd0a60c) (package Win32::O...\') called at blib\\lib\\Storable.pm (autosplit into blib\\lib\\auto/Storable/thaw.al) line 343 Storable::thaw(\'^E^D^B^@^@^@^F^J$DBI::ProxyServer::st=HASH(0x168a694)^J^A0^ J^A0^E^E^T^Q^SWin32::O...\') called at c:\\perl\\site\\lib/RPC/PlServer/Comm.pm line 144 RPC::PlServer::Comm::Read(\'RPC::PlClient=HASH(0xd6ca14)\') called at c:\\perl\\site\\lib/RPC/PlClient.pm line 112 RPC::PlClient::Call(\'RPC::PlClient=HASH(0xd6ca14)\', \'CallMethod\', \'DBI::ProxyServer::db=HASH(0xd42024)\', \'prepare\', \'DELETE FROM tAqtorTrade where TradeDate = #17-May-2001# AND Sour...\', undef, \'ARRAY(0xd099ac)\') called at (eval 16) line 5 RPC::PlClient::Object::DBI::ProxyServer::db::prepare(\'RPC::PlClient::Object ::DBI::ProxyServer::db=HASH(0x1332664)\', \'DELETE FROM tAqtorTrade where TradeDate = #17-May-2001# AND Sour...\', undef, \'ARRAY(0xd099ac)\') called at c:\\perl\\site\\lib/DBD/Proxy.pm line 366 eval {...} called at c:\\perl\\site\\lib/DBD/Proxy.pm line 366 DBD::Proxy::st::execute(\'DBI::st=HASH(0xd09994)\') called at c:/Dev/AqtorExport/Source/DTS/Aqtor/PerlModules/AqtorExportDecoder.pm line 188 Then, on a second Delete statement, there are errors writing to the socket and the ProxyServer dies as follows Thu May 17 09:47:28 2001 debug, Client executes method CallMethod Thu May 17 09:47:28 2001 debug, CallMethod: = DBI::ProxyServer::db=HASH(0xd42024),prepare,DELETE FROM tIntradayTrade where TradeDate = #17-May-2001# AND Source = 'AqtorExportReader_NonIndex',,ARRAY(0x168924c) Thu May 17 09:47:28 2001 debug, CallMethod: = DBI::ProxyServer::st=HASH(0x16891a4),0,0,,,0 Thu May 17 09:47:28 2001 err, Child died: Storable binary image v92.0 more recent than I am (v2.4) at blib\lib\Storable.pm (autosplit into blib\lib\auto/Storable/thaw.al) line 342, IN chunk 1, at c:\perl\site\lib/RPC/PlServer/Comm.pm line 144 Thu May 17 09:47:28 2001 debug, Child terminating. I'm especially concerned about the version error - but I cannot find other versions of Storable (1.0.11) Has anyone had like errors and found solutions to these or is there something wrong I'm doing. The ProxyServer is running in single-connection mode but there is only one connection on it. Ans as far as I know the port I'm using should not be used elsewhere. Any hints, tips, suggestions are welcome. Thanks, Jeff Butler
Re: DBD-Oracle instalation problem on solaris 2.6
The failure you are getting in plsql.t is a known problem between DBI 1.15 and DBD::Oracle's ORA_RSET return handling. If you don't need to return cursors from PL/SQL, ignore the error and install, otherwise drop back to DBI 1.14. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: oscar perez perez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 01:27 Subject: DBD-Oracle instalation problem on solaris 2.6 I am trying to install the perl module DBD-Oracle and I've having problem in the test part of the installation. I am installing DBD-Oracle module on solaris 2.6 with Oracle 8.1.7 , perl 5.6.1 and DBI 1.15
RE: :Sybase installation error!!!
That's the exact same error I'm getting (re:Initial Install Issue), then it was pointed out that I had two perl installations on my machine, so I strongly suspected that was the issue. I haven't had a chance to pursue that as of yet, so I'd be very interested in what the determination is in your case - in the meantime I'll keep you informed as to my progress as to whether conflicting perl installations was the root of my problem. Thanks, Al Al Spohn Publishing and Media Technology Services Mayo Clinic 507-284-1666 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 7:56 PM To: [EMAIL PROTECTED] Subject: DBD::Sybase installation error!!! hello ,everyone. I have installed DBI-1.14 successfully on my linux system(Red Hat Linux release 6.1,kernel 2.2.12-20 on an i686).But I have a problem when I install DBD::Sybase-0.91 on my system.Will you be so kind as to help me?Thanks a lot. *ERROR MESSAGE*** I have no problem when I run perl Makefile.PL and make the error message of make test is following up. #make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose) ; $verbose=0; runtests @ARGV;' t/*.t t/autocommitdubious Test returned status 0 (wstat 139, 0x8b) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 ~ **ENVIROMENT #perl -V Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=linux, osvers=2.2.5-22smp, archname=i386-linux uname='linux porky.devel.redhat.com 2.2.5-22smp #1 smp wed jun 2 09:11:51 ed t 1999 i686 unknown ' hint=recommended, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include' ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include' stdchar='char', d_stdstdio=undef, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -ldl -lm -lc -lposix -lcrypt libc=, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Built under linux Compiled at Aug 30 1999 23:09:51 @INC: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .
RE: SQL Server
You can use DBD::ODBC, probably the best choice (in my opinion). You can also use DBD::Sybase. Ilya Sterin -Original Message- From: Alisa Mills To: [EMAIL PROTECTED] Sent: 05/17/2001 7:06 AM Subject: SQL Server I am trying to port an application from Unix to Windows 2000. The Unix version used Oracle, and the Windows 2000 version will use MS SQL Server 2000. I found a DBI for ODBC, ADO, and a very old one for MS SQL Server. Does anyone know of a DBI that will work with MS SQL Server 2000? Thanks in advance. Ci-Ci [EMAIL PROTECTED]
RE: DBD-Oracle instalation problem on solaris 2.6
What's the problem? Ilya -Original Message- From: oscar perez perez To: [EMAIL PROTECTED] Sent: 05/17/2001 2:27 AM Subject: DBD-Oracle instalation problem on solaris 2.6 Hello, I am trying to install the perl module DBD-Oracle and I've having problem in the test part of the installation. I am installing DBD-Oracle module on solaris 2.6 with Oracle 8.1.7 , perl 5.6.1 and DBI 1.15 Could anyone help me? Thanks in advance. The attached file is the result of executing perl Makefile.PL -v make make test make test TEST_VERBOSE=1 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. todo.log
Re: Help with INSERT INTO table VALUES @array
I think that you are having problems because you are using a reference to the array. The reference won't evaluate to the values in your array, but rather to the location of your actual array. You probably need to dereference the array before you use it in the SQL statement. However You probably don't even need to make a reference to it in the first place. Joe Grastara Project Assistant Digital Media Center The Skirball Institute Of Biomolecular Medicine New York University Medical Center 540 First Ave., New York City, NY 10016 USA [EMAIL PROTECTED] http://www.med.nyu.edu/graphics On Wed, 16 May 2001, Ray Cuzzart II wrote: Hello, What I am trying to do is insert form fields into a mySQL database table by using them in an array. I have the array setup properly it collects all the fields but when I try to insert it into the table I get and error. Below is the information on what I am running as well as the code snippet and error message. Any help would be greatly appreciated. The reason for using an array is because there is 32 fields and I would rather use it this way then to say my $field = param('field'); for 32 lines. Environment Information: mySQL Version: 3.23.33 Server Apache Version: 1.3.19 OS: Windows DBI Version: Most current DBD::mysql version: most current Script: Top: use strict; use CGI::Carp fatalsToBrowser; use CGI :all; use DBI; my $servname = localhost; my $servuser = inventory; my $servpass = inventory; my $db = inventory; my $tbl = vehicles; my ($dbh); $dbh = DBI-connect(DBI:mysql:$db,$servuser,$servpass) or die Unable to connect to inventory database: $dbh-errstr\n; my $obj = new CGI; my @values = map { $obj-param($_) } $obj-param(); my @all = join(,, @values); foreach (@all) {s/addvehicle,//;} my $all = @all; my $success = $dbh-do(INSERT INTO $tbl VALUES $all) or die Unable to write information to inventory database: $dbh-errstr\n; $dbh-disconnect; if($success != 1) { print header, start_html(Entry Added); print Sorry, the database was unable to add your entry. Please try again later.; } else { print header, start_html(Entry Added); print Information Added\n; } That is what I am using I get an error at the my $success = $dbh-do(INSERT INTO $tbl VALUES $all) or die Unable to write information to inventory database: $dbh-errstr\n; process. Error Message: Unable to write information to inventory database: DBI::db=HASH(0x1a94a1c)-errstr I have tried every way possible I can think of and I cannot get it to work at all. Any help with this would be greatly appreciated. Thanks in advance, Ray
RE: Connection is busy
Sterin, Ilya writes: I would imaging that that is either the SQLServer config or ODBD config that is not allowing multiple connections. Actually it's not allowing multiple statement handlers on the same connection. This is the default for the TDS protocol (the underlying protocol that MS-SQL and Sybase use to communicate between the client and the server.) Michael -Original Message- From: roberto l To: [EMAIL PROTECTED] Sent: 05/17/2001 10:03 AM Subject: Connection is busy We've recently ported an application from MSaccess to SQL Server 7 and now many programs are failing producing the following error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) Should I use another ODBC driver? Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt 4.0 sp 6 and sql server 7. bests -- De duobus malis, minus est semper eligendum -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
RE: :Sybase installation error!!!
In my case, the client installation. I routinely connect to various servers with isql, sqsh, etc. with no problems. The version is 11.9.2. Thanks, Al Al Spohn Publishing and Media Technology Services Mayo Clinic 507-284-1666 -Original Message- From: De Simone, Andrew (CAP, FGI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:18 AM To: 'Spohn, Albert F.'; [EMAIL PROTECTED] Subject: RE: :Sybase installation error!!! These kinds of errors seem to come about when proper connections can't be made or the driver install is flawed. Can you connect with ISQL to the server? What version of Sybase is on the machine? Is it the server or client install? -Original Message- From: Spohn, Albert F. [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 8:52 AM To: '? ?'; [EMAIL PROTECTED] Subject: RE: :Sybase installation error!!! That's the exact same error I'm getting (re:Initial Install Issue), then it was pointed out that I had two perl installations on my machine, so I strongly suspected that was the issue. I haven't had a chance to pursue that as of yet, so I'd be very interested in what the determination is in your case - in the meantime I'll keep you informed as to my progress as to whether conflicting perl installations was the root of my problem. Thanks, Al Al Spohn Publishing and Media Technology Services Mayo Clinic 507-284-1666 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 7:56 PM To: [EMAIL PROTECTED] Subject: DBD::Sybase installation error!!! hello ,everyone. I have installed DBI-1.14 successfully on my linux system(Red Hat Linux release 6.1,kernel 2.2.12-20 on an i686).But I have a problem when I install DBD::Sybase-0.91 on my system.Will you be so kind as to help me?Thanks a lot. *ERROR MESSAGE*** I have no problem when I run perl Makefile.PL and make the error message of make test is following up. #make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose) ; $verbose=0; runtests @ARGV;' t/*.t t/autocommitdubious Test returned status 0 (wstat 139, 0x8b) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 ~ **ENVIROMENT #perl -V Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=linux, osvers=2.2.5-22smp, archname=i386-linux uname='linux porky.devel.redhat.com 2.2.5-22smp #1 smp wed jun 2 09:11:51 ed t 1999 i686 unknown ' hint=recommended, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include' ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include' stdchar='char', d_stdstdio=undef, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -ldl -lm -lc -lposix -lcrypt libc=, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Built under linux Compiled at Aug 30 1999 23:09:51 @INC: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .
RE: Connection is busy
Thanks, Michael. Ilya -Original Message- From: Michael Peppler To: [EMAIL PROTECTED] Sent: 05/17/2001 10:20 AM Subject: RE: Connection is busy Sterin, Ilya writes: I would imaging that that is either the SQLServer config or ODBD config that is not allowing multiple connections. Actually it's not allowing multiple statement handlers on the same connection. This is the default for the TDS protocol (the underlying protocol that MS-SQL and Sybase use to communicate between the client and the server.) Michael -Original Message- From: roberto l To: [EMAIL PROTECTED] Sent: 05/17/2001 10:03 AM Subject: Connection is busy We've recently ported an application from MSaccess to SQL Server 7 and now many programs are failing producing the following error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) Should I use another ODBC driver? Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt 4.0 sp 6 and sql server 7. bests -- De duobus malis, minus est semper eligendum -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
Re: Connection is busy
roberto l writes: And since this is dependant on the protocol changing the odbc driver won't work. So what would be the best workaround? Depends. I think some ODBC drivers have support for this under the covers, possibly by opening a second connection for you. I don't know much about ODBC, unfortunately. DBD::Sybase gets around the problem (not very nicely) by opening a new connection for the sth if the dbh already has an active sth. Michael Michael Peppler wrote: Sterin, Ilya writes: I would imaging that that is either the SQLServer config or ODBD config that is not allowing multiple connections. Actually it's not allowing multiple statement handlers on the same connection. This is the default for the TDS protocol (the underlying protocol that MS-SQL and Sybase use to communicate between the client and the server.) Michael -Original Message- From: roberto l To: [EMAIL PROTECTED] Sent: 05/17/2001 10:03 AM Subject: Connection is busy We've recently ported an application from MSaccess to SQL Server 7 and now many programs are failing producing the following error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) Should I use another ODBC driver? Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt 4.0 sp 6 and sql server 7. bests -- De duobus malis, minus est semper eligendum -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED] -- De duobus malis, minus est semper eligendum -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
DBI-1.15 `__builtin_va_alist' undeclared plus perl -V
I am having trouble compiling DBI-1.15 on a solaris 2.6 sparc box. I get the following error: DBI.xs: In function `dbih_logmsg': DBI.(first use in this function)xs:419: `__builtin_va_alist' undeclared I am using the following (which I have recompiled all) : perl5.6.0 DBI-1.15 gcc-2.95.2 GNUmake-3.78.1 #make test TEST_VERBOSE=1 gcc -c -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\1.15\ -DXS_VERSION=\1.15\ -fPIC -I/usr/local/lib/perl5/5.6.0/sun4-solaris/CORE -DDBI_NO_THREADS DBI.c DBI.xs: In function `dbih_logmsg': DBI.(first use in this function)xs:419: `__builtin_va_alist' undeclared DBI.xs:419: (Each undeclared identifier is reported only once DBI.xs:419: for each function it appears in.) make: *** [DBI.o] Error 1 ANY HELP WOULD BE APPRECIATED. Sorry to be repetitive but here is also my perl -V output #perl -V Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration: Platform: osname=solaris, osvers=2.6, archname=sun4-solaris uname='sunos orion 5.6 generic_105181-05 sun4m sparc sunw,sparcstation-4 ' config_args='-Dcc=gcc -Dprefix=/usr/local -Uinstallusrbinperl -de' 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='gcc', optimize='-O', gccversion=2.95.2 19991024 (release) cppflags='-fno-strict-aliasing -I/usr/local/include' ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64' stdchar='unsigned char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc -lcrypt -lsec libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: USE_LARGE_FILES Built under solaris Compiled at Apr 14 2000 01:46:43 @INC: /usr/local/lib/perl5/5.6.0/sun4-solaris /usr/local/lib/perl5/5.6.0 /usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris /usr/local/lib/perl5/site_perl/5.6.0 /usr/local/lib/perl5/site_perl
Inserting/Updating to ADO (.MDB file)
Could someone potentiall help me.. I'm getting a message saying that this operation is not supported. It appears to be on the -AddNew(); method. How can I insert and update data in Access databases in my question. What syntax can be used? I've already got reading solved. = $rs-AddNew(); $rs-Fields('User')-{Value} = Bubba; $rs-Update();
DBD error
I've been getting this error while connecting to an Oracle database thro' DBI. and don't know what's happening. Can anybody help? ORA-12500: TNS:listener failed to start a dedicated server process (DBD ERROR: OCIServerAttach) at DbUtils.pm line 104. Thanks.
Re: DBD error
- Original Message - From: Theja Rajakumar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 10:34 PM Subject: DBD error I've been getting this error while connecting to an Oracle database thro' DBI. and don't know what's happening. Can anybody help? ORA-12500: TNS:listener failed to start a dedicated server process (DBD ERROR: OCIServerAttach) at DbUtils.pm line 104. For some reason the Oracle dispatcher process wasnt able to start a dedicated process for you on the server. This is an server side error. Ask your DBA to investigate this. You might wanna try to connect to a shared server process rather than a dedicated process. To do this put (SERVER = SHARED) in your tnsname.ora file on the client. See example: SOME_SID.SOMEHOST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SOMEHOST)(PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = SOME_SID) (SERVER = SHARED) ) ) maarten
connecting to postgresql
Hi all, I can't seem to make a valid DBI connection to PostgreSQL 7.1 unless my current login name matches a Postgresql user. It seems to ignore the username I'm passing it. The initial problem came up under mod_perl and HTML::Mason, but I've duplicated it in a plain script as well, narrow it down. Here's a snippet: use DBI; use DBD::Pg; my $dbh; $dbh = DBI-connect(dbi:Pg:dbname=mydb, www, secret) || die $dbh-errstr; [code to select a record follows this, but it never gets that far] The error message is: DBI-connect(dbname=mydb) failed: FATAL 1: user root does not exist at testdbi line [line number with the connect statement] In Postgresql, two users are defined: my own linux username, and www for web access. www doesn't have a unix account, just exists in Postgresql with appropriate permissions. Web clients connect as nobody. When I was testing Mason code, the error message said that nobody doesn't exist. The above snippet works fine if I'm logged in as me, since my login also exists in the database. Do I need to go into PostgreSQL and grant permissions to nobody so it will match the logged-in user, or is there a way to get it to pay attention to the connect() parms? Version info: DBI: 1.15 DBD::Pg: 0.96 PostgreSQL:7.1 Thanks for your help.
RE: Connection is busy
I've encountered this problem before while using DBD::ODBC. It usually is how I am dealing with the results of a previous query. The way to handle it is to open another connection. Works fine like that. Steve Howard -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 11:59 AM To: [EMAIL PROTECTED] Subject: Re: Connection is busy roberto l writes: And since this is dependant on the protocol changing the odbc driver won't work. So what would be the best workaround? Depends. I think some ODBC drivers have support for this under the covers, possibly by opening a second connection for you. I don't know much about ODBC, unfortunately. DBD::Sybase gets around the problem (not very nicely) by opening a new connection for the sth if the dbh already has an active sth. Michael Michael Peppler wrote: Sterin, Ilya writes: I would imaging that that is either the SQLServer config or ODBD config that is not allowing multiple connections. Actually it's not allowing multiple statement handlers on the same connection. This is the default for the TDS protocol (the underlying protocol that MS-SQL and Sybase use to communicate between the client and the server.) Michael -Original Message- From: roberto l To: [EMAIL PROTECTED] Sent: 05/17/2001 10:03 AM Subject: Connection is busy We've recently ported an application from MSaccess to SQL Server 7 and now many programs are failing producing the following error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) Should I use another ODBC driver? Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt 4.0 sp 6 and sql server 7. bests -- De duobus malis, minus est semper eligendum -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED] -- De duobus malis, minus est semper eligendum -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
RE: SQL Server
I use DBD::ODBC almost exclusively in WIN32 environments using a variety of DBMS's. It works beautifully with MS SQL 7 (which is actually my main area of focus). Have fun. Steve Howard -Original Message- From: Alisa Mills [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 8:07 AM To: [EMAIL PROTECTED] Subject: SQL Server I am trying to port an application from Unix to Windows 2000. The Unix version used Oracle, and the Windows 2000 version will use MS SQL Server 2000. I found a DBI for ODBC, ADO, and a very old one for MS SQL Server. Does anyone know of a DBI that will work with MS SQL Server 2000? Thanks in advance. Ci-Ci [EMAIL PROTECTED]
$VERSION changes in lib/DBD/ADO.pm confuse CPAN
There seems to be some version mismatches between CPAN and DBD When I install T/TI/TIMB/DBI-1.14.tar.gz and do the cpan r command it reports that there is a new version: Package namespace installedlatest in CPAN file DBD::ExampleP 10.11 10.13 T/TI/TIMB/DBI-1.15.tar.gz So I install the latest DBI-1.15.tar.gz as recomended, and then cpan r indicates that the latest version is DBI-1.14.tar.gz Package namespace installedlatest in CPAN file DBD::ADO 0.419 1.17 T/TI/TIMB/DBI-1.14.tar.gz Is this a bug in the CPAN module, or did your version numbering scheme for lib/DBD/ADO.pm change lib/DBD/ADO.pm from DBI-1.14 contained $VERSION = sprintf(%d.%02d, q$Revision: 1.17 $ =~ /(\d+)\.(\d+)/o); lib/DBD/ADO.pm from DBI-1.15 containes $VERSION = '0.4'.sprintf(%02d,substr(q$Revision: 1.19 $, 12,-1)); I can see the the RCS/CVS Revision incremented from 1.17 to 1.19, but the 'reported $VERSION seems to have dropped down from 1.17 to 0.419, which triggers CPAN to report that I should upgrade using a downgrade.