"Remo" <renjum@healthasyst.com> wrote in message
news:OMeTKtkZHHA.1240@TK2MSFTNGP04.phx.gbl...
> Hi All,
> I need to create a batch that generates the output of a query into a text
> file.The batch file I created goes like this, but it is thrwing login
> error.Please help me.try to give me a complete bacth file.
>
> @echo off
> echo Hello this is a test batch file
> set mysqlcommand=select * from employee
> osql /U rmk /P reallove /d Love /S DBheaven /Q "%mysqlcommand%" -o
> "C:\Me\new.txt"
> exit
>
> Thanks,
> Remo
>

"Immy" <therealasianbabe@hotmail.com> wrote in message
news:uZjpiClZHHA.4832@TK2MSFTNGP02.phx.gbl...
> Your syntax is correct and works for me when executed.
> I can only assume that it's a problem with your credentials!
>
> "Remo" <renjum@healthasyst.com> wrote in message
> news:OMeTKtkZHHA.1240@TK2MSFTNGP04.phx.gbl...
>> Hi All,
>> I need to create a batch that generates the output of a query into a text
>> file.The batch file I created goes like this, but it is thrwing login
>> error.Please help me.try to give me a complete bacth file.
>>
>> @echo off
>> echo Hello this is a test batch file
>> set mysqlcommand=select * from employee
>> osql /U rmk /P reallove /d Love /S DBheaven /Q "%mysqlcommand%" -o
>> "C:\Me\new.txt"
>> exit
>>
>> Thanks,
>> Remo
>>
>
>

"Remo" <renjum@healthasyst.com> wrote in message
news:ObdeVgsZHHA.1388@TK2MSFTNGP05.phx.gbl...
> Thanks Immy for your prompt update.By credentials, you mean the permissoin
> to execute osql , or my login ID and password.Please clarify
>
> Thanks,
>
> "Immy" <therealasianbabe@hotmail.com> wrote in message
> news:uZjpiClZHHA.4832@TK2MSFTNGP02.phx.gbl...
>> Your syntax is correct and works for me when executed.
>> I can only assume that it's a problem with your credentials!
>>
>> "Remo" <renjum@healthasyst.com> wrote in message
>> news:OMeTKtkZHHA.1240@TK2MSFTNGP04.phx.gbl...
>>> Hi All,
>>> I need to create a batch that generates the output of a query into a
>>> text file.The batch file I created goes like this, but it is thrwing
>>> login error.Please help me.try to give me a complete bacth file.
>>>
>>> @echo off
>>> echo Hello this is a test batch file
>>> set mysqlcommand=select * from employee
>>> osql /U rmk /P reallove /d Love /S DBheaven /Q "%mysqlcommand%" -o
>>> "C:\Me\new.txt"
>>> exit
>>>
>>> Thanks,
>>> Remo
>>>
>>
>>
>
>

"Immy" <therealasianbabe@hotmail.com> wrote in message
news:uqTO4quZHHA.4888@TK2MSFTNGP06.phx.gbl...
>I mean by your login username or password.
> Can you paste the exact error you are getting when you execute the batch?
> Thanks
>
> "Remo" <renjum@healthasyst.com> wrote in message
> news:ObdeVgsZHHA.1388@TK2MSFTNGP05.phx.gbl...
>> Thanks Immy for your prompt update.By credentials, you mean the
>> permissoin to execute osql , or my login ID and password.Please clarify
>>
>> Thanks,
>>
>> "Immy" <therealasianbabe@hotmail.com> wrote in message
>> news:uZjpiClZHHA.4832@TK2MSFTNGP02.phx.gbl...
>>> Your syntax is correct and works for me when executed.
>>> I can only assume that it's a problem with your credentials!
>>>
>>> "Remo" <renjum@healthasyst.com> wrote in message
>>> news:OMeTKtkZHHA.1240@TK2MSFTNGP04.phx.gbl...
>>>> Hi All,
>>>> I need to create a batch that generates the output of a query into a
>>>> text file.The batch file I created goes like this, but it is thrwing
>>>> login error.Please help me.try to give me a complete bacth file.
>>>>
>>>> @echo off
>>>> echo Hello this is a test batch file
>>>> set mysqlcommand=select * from employee
>>>> osql /U rmk /P reallove /d Love /S DBheaven /Q "%mysqlcommand%" -o
>>>> "C:\Me\new.txt"
>>>> exit
>>>>
>>>> Thanks,
>>>> Remo
>>>>
>>>
>>>
>>
>>
>
>