>Ben,
>
>As Borislav said, you need to specify the database in the connection string. Here it is in .NET syntax:
>
>
>"server=(local);database=MyDataBase;uid=sa;pwd=MyPassword"
>
>
>~~Bonnie
I see what you mean Bonnie, I misunderstood what Borislav meant. I didn't have the Initial Catalog set because I was doing a "Create Database" command where if I had the Catalog in the Connection String, it would crash. But apparently I forgot to remodify the connection string
after the Create Database command to include the Database name.
Thanks for your help!!!
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook