Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^2: My MSSQL query fails the second time.

by kyle (Abbot)
on Apr 30, 2013 at 20:50 UTC ( #1031475=note: print w/replies, xml ) Need Help??

in reply to Re: My MSSQL query fails the second time.
in thread My MSSQL query fails the second time.

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

Replies are listed 'Best First'.
Re^3: My MSSQL query fails the second time.
by Anonymous Monk on Jul 15, 2013 at 20:21 UTC
    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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1031475]
[Lady_Aleena]: This is one of my oldest accounts on the web. 8)
[Corion]: Lady_Aleena: Hehe - I think this is also my oldest active account on the web. I have an old university email address but that only gets spam nowadays :)
Discipulus arrived at work 1 hour late.. he do not noticed the clock bell
[Lady_Aleena]: My Wikipedia account is 3 years - 10 days younger.
[fux]: Hi folks:) Lady_Aleena: congrats!
vrk takes a handful of cookies from the platter on the sideboard.
Discipulus is preparing a big party for his 15th

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (8)
As of 2017-04-26 07:42 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (470 votes). Check out past polls.