what''s wrong with isql.exe syntax???

Question

what''s wrong with isql.exe syntax???

Terry-380449

Default port

Points: 1458
More actions
August 28, 2007 at 8:23 am

#76763

Hello
I need to executer a .sql procedure from DOS using isql, but i keep on getting a syntax error:
isql.exe -Smyserver -Usa -Ppassword -ic:\export_login.sql -oD:\backup\export.out -n
isql: unknown option ûS
any idea?
Tks!!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

The above parameters should work, but one possible reason for this problem is a simple path setting. You may not actually be executing SQL Server's isql.exe. For example, Firebird has an isql.exe, and if your path is not set properly, the wrong isql can get called.

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Terry-380449 Default port Points: 1458 More actions · Answer 2

well, seems that the error is due to a wrong export path

D:\backup does not exist , didn't notice that! But i wish i got a more meaningful error message

Thanks!!

sqldba-294117 Hall of Fame Points: 3486 More actions · Answer 3

sqldba-294117

Hall of Fame

Points: 3486

August 28, 2007 at 5:04 pm

#729950

Try to run this command from \Binn folder

Thx

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 4

Why? The path should take care of things just fine.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 5

Uh, Terry... if you think that's bad, wait until the world of hurt you run across when you try to do something a bit sophisticated in ISQL... ISQL is severly depracated when it comes to T-SQL... don't use ISQL... use OSQL, instead, which has no such limitations.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Terry-380449 Default port Points: 1458 More actions · Answer 6

Terry-380449

Default port

Points: 1458

August 29, 2007 at 1:31 am

#729993

Thx all for the tips!

osql works great!

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 7

You bet... thanks, for the feedback.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)