Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: DBD::Sybase + MS SQL server problem

by screamingeagle (Curate)
on Aug 30, 2002 at 14:46 UTC ( #194123=note: print w/ replies, xml ) Need Help??


in reply to DBD::Sybase + MS SQL server problem

a) You're firing the first 3 statements without a "GO" in between. try this :

set TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; GO set quoted_identifier on GO use smdb GO

b) You dont need to use double quotes in the : use "master" line
c) try running the sql without any semi-colons. i dont think u need to add any semi-colons when you're executing the sql from a perl script.

And </code> and lastly, i would suggest testing the sql with just a simpler sql ,and if that works, go on adding to the sql stmt , one small step at a time, testing each time to see what addition is causing the sql to fail.... hth


Comment on Re: DBD::Sybase + MS SQL server problem
Select or Download Code
Re: Re: DBD::Sybase + MS SQL server problem
by Preceptor (Chaplain) on Sep 02, 2002 at 08:49 UTC
    OK thanks, after some experimentation, it a) doesn't seem to like compound statements (ie multi line bit, so I have to run those separately). And b) it seems to fail if I use the semi-colon. Sigh. Figured it would be something simple :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://194123]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (12)
As of 2015-07-07 12:45 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 (88 votes), past polls