Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
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.
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?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (11)
As of 2015-07-28 23:04 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 (260 votes), past polls