Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jul 2002
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem connecting to SQLServer database

    Hi,

    I have just finished writing a asp.net application that connects to an sql database, up until now the database has been running on my local machine, however, now I have to test it with the database running on a seperate server and I have no idea how to go about it.

    Im reconing that its got something to do with this line in the code

    dim myconn as New SqlConnection("initial catalog=stes2;User Id=sa;Password=")

    the database (as you can see) is called "stes2" but now its on a machine called "IVR" anyone know how I specify the path ?

    Thanks in advance

    Steve.

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Yep, take a look here:
    http://www.connectionstrings.com/

    If you still can't get it after looking at those connection strings, give us a shout back.

    Good luck;

  • #3
    New Coder
    Join Date
    Jul 2002
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Nice one mate.

    Job sorted !

    Thanks


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •