connect to MSDE instance using osql

Hi,

I am new and blue! Utlimately I want to connect to a database using asp.
I have created an instance named Joker using securitymode=SQL because
I foolishly created the original default server using Windows authentication
and I can't connect via asp because it keeps telling me I am not trusted. So I am testing the connection
using osql like this, and getting the error below. I created the instance with
a verbose log and the log said it was created successfully, and I see it
under services. BUT it doesn't have its own directory like the default server
does. That's kinda weird. Since my server is an instance, is there perhaps
some prefix to the name that I am missing? Thanks for any help, I REALLY
appreciate it.

osql -Usa -SJoker -Pjokerpass

error message: DNETLIB SQL Server does not exist or access denied

thanks!!
Nancy

You do need to specify the instance name

osql -Usa -S<server>/<instance> -Pjokerpass

Doug,

thanks for replying! I found the solution to my problem in Knowledge
Base article 322336. I had to go into the registry and change the
security mode from Windows to mixed. That actually fixed my default
server so I can get rid of all the experimental instances.

N.