INSTALLING DATABASE WITH OSQL

  • Hi guys... this command prompt statement that is supposed to install a database with all its tables, stored procedures & triggers from a script file PBS.sql on the instance PBSTUDIO1\SQLEXPRESS (PBSTUDIO1 is the computer name)...

    C:\DATA>osql -E -S PBSTUDIO1/SQLExpress -i PBS.sql

    yields this error!

    [DBNETLIB]SQL Server does not exist or access denied.

    [DBNETLIB]ConnectionOpen (Connect()).

    What could be the problem?

  • It looks like you are using SQLExpress - if this is the case then this uses the sqlcmd.exe utility, it has a similar syntax to osql 

  • Ok thx am in a cafe right now... So I will try it out & respond...

    Thx

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

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