Post reply

ISQL/OSQL/ISQLW

  • October 27, 2003 at 2:43 am

    #81326

    Hi

    I am using isql/osql in batch mode to unload data from an ANSI SQL Server and I want to force the unloaded data to be in code page 1252 (ANSI) rather than using the auto ANSI to OEM conversion.

    Apart from switching the auto ANSI to OEM conversion to off using the Client Network Utility, is there a way to temporarily disable the conversion for one isql unload ?

    An alternative is to use isqlw because its treated as an ANSI client, but the problem here is I am unable to determine the format of the configuration file (as specified -C configuration_file ). Any know how to specify this ?

    Thanks

    Andy

  • October 30, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • January 5, 2007 at 4:03 am

    #681430

    Hey, this question is lying in the forum for last 3 years.

    Here is the answer.

    Goto Sql Query Analyzer->Tools->Options.

    Here you need to setup all the settings that you want while executing your queries from command prompt. Once everything is set properly, Click on save button on the general tab. This will save a configuration file with extention .SQC. You can use this file as a parameter in ISQLW command line utility.

Viewing 3 posts - 1 through 2 (of 2 total)

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