Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: My MSSQL query fails the second time.

by karlgoethebier (Vicar)
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.
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?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2015-07-04 10:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (59 votes), past polls