connecting to database with vb.net

niallm · April 14th, 2004, 03:34 AM

Hi,

I've just purchased the book ASP.NET Website programming - Problem - Design
- Solution: I'm trying to set up the website that comes with the book but I'm getting an error when connecting to the database on my sql server machine. My sql server db is located on a separte machine called is-sv-killianc2, so I've changed all my config files to the following

<ConnectionString>server=ie-sv-killianc2;database=ThePhile;uid=sa;pwd=;</
ConnectionString>

I'm getting the error msg SQL Server does not exist or access denied. Am I missing something? Please advise

Thanks for your time

melvik · April 14th, 2004, 06:12 AM

If u use Web.Config it should like this in ur Web.Config

Code:

  <appSettings>


    <add key="ConnectionName.ConnectionString" value="data source=BORNA;initial catalog=NewBaz;password=power;persist security info=True;user id=empower;packet size=4096"/>
    <add key="Server" value="BORNA"/>
  </appSettings>

Then in in design time of Connection Obj. set the properties to:
Name: ConnectionName
dynamic property: Connection = ...

HTH, keep in touch.

Always:),
Hovik Melkomian.

Reeezak · April 16th, 2004, 01:02 PM

server=ie-sv-killianc2

Please confirm that your ServerName "is ie-sv-killianc2" and your SQL be Server is open .