Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: My MSSQL query fails the second time.

by karlgoethebier (Prior)
on Apr 30, 2013 at 19:25 UTC ( #1031458=note: print w/replies, xml ) Need Help??


in reply to My MSSQL query fails the second time.

Mmh, the only idea i have about this is: try to contact Michael Peppler, the author.

He is very cooperative and helped me very much some years ago with some issues about building DBD::Sybase.

Btw, naive question: if MSSQL, why not ODBC?

Regards, Karl

«The Crux of the Biscuit is the Apostrophe»

  • Comment on Re: My MSSQL query fails the second time.

Replies are listed 'Best First'.
Re^2: My MSSQL query fails the second time.
by kyle (Abbot) on Apr 30, 2013 at 20:50 UTC

    Once I got ODBC working, that fixed it. Thanks!

    Edited to add the DSN I'm using (dbi:ODBC:DRIVER=FreeTDS;Server=xxx;Port=1433;DATABASE=xxx) and the output of the test using that connection.

    ok 1 - The object isa DBI::db ok 2 - The object isa DBI::st ok 3 - defined: '-1' ok 4 - $sth->finish ok 5 - The object isa DBI::st ok 6 - defined: '-1' ok 7 - $sth->finish 1..7
      I was receiving a very similar error message. In my case, it was because I had a FOREIGN KEY that was not satisfied (i.e. I was trying to add a child record for which I had no parent). Check your table structure, and be sure your record is complete.
        If you are doing a query, it can be because you are trying to search by a field that does not exist in that table.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1031458]
help
Chatterbox?
[Corion]: Hi all! After 13 years or so in the same room, I've now moved to a new room (one door further) - weird :-D
[moritz]: I had an office move too, two floors up
[moritz]: so far I've managed not to get into my old office by accident, but once it was close (already stopped at the wrong floor)

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (8)
As of 2017-10-17 08:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My fridge is mostly full of:

















    Results (224 votes). Check out past polls.

    Notices?