|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
OSQL returns error code of 1 - intermittentlyI've written an program that runs OSQL to set up a database. I got a weird situation yesterday where OSQL returns an error level of 1 and didn't generate any output file at all. The command I use is: OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log Normally, this command runs OK and produces a .log file. Why would it return 1 and no log file? I call OSQL from a Borland Builder C++ program. Any ideas? Regards, Robert PS: I ran the OSQL command straight after I installed MSDE and started up SQL Server. Hi,
you are assuming some things: OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log -E are you really able to use integrated authentication, if not you have to provide a user name and a password. Perhaps you are running your program under a special account which isn´t priviledged in the database ?! -i Are you in the right folder that SOQL can find the query file while executing the file from the program ? (missing -S) If you don´t specify a server, the default behaviour is to go to the local server, the default instance, to the default port 1433. If this is not valid, you have to define the server/indtance,port e.g. Servername\instancename,Port. HTH, Jens Suessmeyer. Hi,
Thanks for your reply. OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log -E are you really able to use integrated authentication, if not you have to provide a user name and a password. Perhaps you are running your program under a special account which isn´t priviledged in the database ?! I think so. I am running as (machine) administrator when I execute OSQL -i Are you in the right folder that SOQL can find the query file while executing the file from the program ? The SetupRTEDatabase.sql script is in the same directory as the calling program. (missing -S) If you don´t specify a server, the default behaviour is to go to the local server, the default instance, to the default port 1433. If this is not valid, you have to define the server/indtance,port e.g. Servername\instancename,Port. This is OK. I run OSQL pretty much straight after I do an install of SQL Server. I don't change any of the default settings. Regards, Robert I've fixed the problem.
As it turns out, I was running the program in the wrong folder after all. OSQL was being run (indirectory) from a Setup program which ran on a network drive. I did a ChangeDirectory to the path with the SetupRTEDatabase.sql script and everything worked fine. Show quote "Robert Wheadon" <robert.whea***@monitorbm.co.nz> wrote in message news:uC$01qrTGHA.5108@TK2MSFTNGP11.phx.gbl... > Hi, > > Thanks for your reply. > > OSQL.EXE -E -b -i SetupRTEDatabase.sql -o SetupRTEDatabase.log > > -E are you really able to use integrated authentication, if not you > have to provide a user name and a password. Perhaps you are running > your program under a special account which isn´t priviledged in the > database ?! > > I think so. I am running as (machine) administrator when I execute OSQL > > -i Are you in the right folder that SOQL can find the query file while > executing the file from the program ? > > The SetupRTEDatabase.sql script is in the same directory as the calling > program. > > (missing -S) If you don´t specify a server, the default behaviour is > to go to the local server, the default instance, to the default port > 1433. If this is not valid, you have to define the server/indtance,port > e.g. Servername\instancename,Port. > > This is OK. I run OSQL pretty much straight after I do an install of SQL > Server. I don't change any of the default settings. > > Regards, > > Robert > >  |
|||||||||||||||||||||||
Other interesting topics