SQL Server Problem

fadil1977

22y2.8k.NET

Hi there! I have probelm and i hope you can help. I have installed a SQL Server personal edition on my machine. I want to create a database with tables as i have been given the files to excute. but i have the following error message when i run it in the MS-Dos C:\CSE506\RESETD~1>osql -i CreateOtters.sql -U sa -P [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen (Connect()). Can you please tell me what would be the probelm? I appreciate your help and thank you for your time.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

fadil197722y ago
Hi Ashishs!! Thank you for your response. I solved that problem but i have another one if you can help.I installed a SQL Server in my machine and I create a simple user "fadila" and SQL Server Authentication and the password is "fadil1977" and as you know the database is otters. I used the method provided in the code so i only change the connStr in one place rather than in 20 places and this is my code. Can you please advise me what to do and how to solve it as i try to do some changes but still not working. i really..really will appreciate it if you help me to solve it as it causeing me a big head-ache and still get the error message "SQL Server does not exist or access denied" .. please help!!!! Friend Shared ReadOnly Property connStr() As String Get Return String.Format( _ "Data Source={0};Initial Catalog=Otters;User ID=fadila;Password=fadil1977", _ DatabaseMachine) End Get End Property
get_me_200422y ago
Hi, osql -S. -Usa -P -ic:\CreateOtters.sql -n