Connection problem OSQL - MSDE

Hello All
I have recently installed MSDE to use with
a trial version of Visual Studio .NET 2003
I installed MSDE 2000 release A with the following command:
Setup.exe /qb+ INSTANCENAME=3D"NetSDK" DISABLENETWORKPROTOCOLS=3D1
SAPWD=3D"notthisone"
I now have to install a database to be used in exercises
that is installed through a bat file:
rem The following command line installs the Contact SQL database
osql -E -i InstContacts.Sql
osql.exe refused to connect with sqlserver. It should communicate
using shared memory but that fails.I have enabled tcp/ip and named
pipes (which are disabled by default) using the Server Network Utility
but that did not work either. It usually fails with the following
messages:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
With tcpip enabled it gives the messages
[Shared Memory]Invalid connection.
[Shared Memory]ConnectionOpen (Invalid Instance()).
after running ther TDIMON utility (www.sysinternals.org)
I get the first error message,
TDIMON seems to screw up some tcpip related settings as I encounter
other problems connecting with ADSL with a ethernet card.
(Could this be causing confusion for OSQL?)
The messages suggest to me that it is using shared memory also
when TCPIP is available.
I have no control over the communications by OSQL,
there seem to be no switches to control it.
I tried several solutions I found in this group and on
a Microsoft site, but none worked so far.
I have one named instance NETSDK of SQL server (desktop engine)
I am running Windows 2000 with
Norton Internet Security 2002
computer/instance=3DSTARSHIP\NETSDK
instance name=3DMSSQL$NETSDK
some version info: 'SSNETLIB.DLL' version '8.0.766'.
I think I have MDAC 2.7 when looking in the registry
Does anyone has an idea what is wrong?
Martin Kramer
mkramer@.wxs.nl
http://home.wxs.nl/~mkramer/
hi Martin,
Martin Kramer wrote:
> rem The following command line installs the Contact SQL database
> osql -E -i InstContacts.Sql
please add the full instance name ...
osql -E -S(Local)\NetSDK -i InstContacts.Sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote:

>hi Martin,
>Martin Kramer wrote:
>please add the full instance name ...
>osql -E -S(Local)\NetSDK -i InstContacts.Sql
Thanks a lot
It certainly worked much bettert than anything I tried
There is a database created. I only have doubts about the
access rights for the ASPNET user that the selfstudy samples use.
But this was syntax from microsoft. It should have worked
as it came with the samples. Or has anything gone wrong
initially when osql searches for a database server?
There is only one on my system.
I copied the original bat file to a new one,
adding a pause statement to see the feedback,
because the original flashed away before I could have a look at it.
It seems the problem was not with TCPIP after all,
However, I can not get osql into a command promt mode with
the same syntax. Is that possible and if so, how.
Oracle and DB2 had similar functions.
Or is osql not intended/suitable for such use?
Martin Kramer
mkramer@.wxs.nl
http://home.wxs.nl/~mkramer/
|||hi Martin,
Martin Kramer wrote:
> But this was syntax from microsoft. It should have worked
> as it came with the samples. Or has anything gone wrong
> initially when osql searches for a database server?
> There is only one on my system.
without specifying the destination server, the (Local) server is assumed,
but as long you installed a named instance you have to full qualify it..

> I copied the original bat file to a new one,
> adding a pause statement to see the feedback,
> because the original flashed away before I could have a look at it.
> It seems the problem was not with TCPIP after all,
Shared Memory is used instead of network protocol(s) to connect to local
server..

> However, I can not get osql into a command promt mode with
> the same syntax. Is that possible and if so, how.
> Oracle and DB2 had similar functions.
> Or is osql not intended/suitable for such use?
are you using the one I proposed?
http://msdn.microsoft.com/library/de..._osql_1wxl.asp
http://support.microsoft.com/default...;EN-US;q325003
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote:

>hi Martin,
>Martin Kramer wrote:
>without specifying the destination server, the (Local) server is =
assumed,=20
>but as long you installed a named instance you have to full qualify it..
I understand. Having a named instance requires specifying it.
>
>Shared Memory is used instead of network protocol(s) to connect to local=
=20
>server..
OK. Seems logical as it should be efficient.
>
>are you using the one I proposed?
>http://msdn.microsoft.com/library/de...y/en-us/copro=
mpt/cp_osql_1wxl.asp
>http://support.microsoft.com/default...;EN-US;q325003
I don't understand this question, as you are proposing it only now,
but I found the links very helpful and now have osql.exe running in
command promt mode so I can try all kinds of commands.
This was what I was looking for.
You have been very helpful
Thank you.
Martin Kramer