RE: "Select count(TEST) from table where (TEST=?)" will crash wit h DBD-ODBC

> my $sth = $dbh->prepare("SELECT COUNT(TEST) FROM $dbtable > WHERE (TEST=?)"); > my $rv = $sth->execute($var1); # this is line 39 I had a similar problem with a "INSERT INTO WHERE (SELECT ...)" with MSSQL. My problem though seemed to be, that a INSERT statement doesn't allow a WHERE clause with

RE: crash with nested handles

> No, it shouldn't -- but I can't see the crash message -- what does the > dialog box say?. > Please update to DBD::ODBC 1.01 as there were some problems in prior > versions with memory overwrites. > If you can, send a small sample with create tables, etc, which > reproduces this. For example sc

RE: crash with nested handles

> No, it shouldn't -- but I can't see the crash message -- what does the > dialog box say?. No dialog box at all... without trace set, I just get a "perl.exe has created an error", and with trace set, the service dies silently (it's a service created with PerlSvc)... The program worked well befo

crash with nested handles

Hi, I have a problem that my program crashes, since I added a second connect in a loop. I know that the code isn't good yet (I should use placeholders), but it shouldn't crash anyway? The trace(2) is attached, and this is the main part of the code: $db2dbh = DBI->connect("dbi:ODBC:DB2I21", "tefi

RE: [OT] SQL console for MSSQL

> 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

RE: [OT] SQL console for MSSQL

> 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

RE: [OT] SQL console for MSSQL

> 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

[OT] SQL console for MSSQL

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

Error handling with DBI

Hi, I want to write a program that acesses two databases, fetching data from one, writing to the other. The core code works fine now, but i have several thoughts left: The program shall run as WinNT Service, running every 10 minutes or so. So the program may not "die" when it can't connect, but j

RE: perl.exe crashes with 2 connects

> No, you don't, that's something else, send us the trace output. > Ilya ok, here wo go. What I already found again is, if I take out the 'print "$DBI::errstr\n";' statements the error disappears again... Maybe I only may access $DBI::errstr if there really is an error? Lars trace.log Descrip

RE: perl.exe crashes with 2 connects

> Use trace... > DBI->trace(2, "trace.log"); Tried already, though I couldn't read much from the information I got there. But I found out something else, when I do some "SELECT" statement with the second handle also, the error disappears. Seems you have to *use* the DBI handle ;) Lars

perl.exe crashes with 2 connects

Hi, I have a problem with the following code: use DBI; my $msdbh = DBI->connect("dbi:ODBC:EasyArchiv", "user", "pass", { RaiseError => 1, PrintError => 1, AutoCommit => 1 } ) or die $DBI::errstr; $mssth = $msdbh->prepare("USE REFDB") ; $mssth->execute;