SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Hybrid View

  1. #1
    SitePoint Guru sowen's Avatar
    Join Date
    Feb 2001
    Location
    Stockport, UK
    Posts
    729
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MS SQL .. Probably a silly question

    I am in the process of moving our site and the new package comes with MS SQL (only ever used access so far).

    Now I have converted the access db and uploaded it no problem - I think, but I can only get the content to display using the SQL Server login and password supplied by the host hard coded into the connection string (DSN assigned by host). I know that the information never reaches the client but it still seems to be unsecure. I know this is probably a dead simple answer but I'm totally new to heavy duty databases

  2. #2
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,121
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    If you're connecting via your copy of Enterprise Manager to one on the host, you will be using the database username/password.

    When making the connection (via port 1433 or something, if you ever get quizzed on it) the connection is made secure for you
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  3. #3
    SitePoint Guru sowen's Avatar
    Join Date
    Feb 2001
    Location
    Stockport, UK
    Posts
    729
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks J, but I really am being thick today!

    I'm with the enterprise manager bit, my details, can add delete yada yada..

    But if I don' do this on my pages..
    [VBS]myConn.Open "DSN=myDB;" &_
    "Uid=myUserID;" &_
    "Pwd=myPassword;"
    [/VBS]

    I get a error and the page wont display

    is that right?

  4. #4
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,121
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    SQL Server Connection string

    Code:
    <%
    	Set Con = Server.CreateObject( "ADODB.Connection" )
    	Con.Open "DRIVER={SQL Server}; Server=server; Database=databasename; UID=user; PWD=pass"
    %>
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  5. #5
    SitePoint Guru sowen's Avatar
    Join Date
    Feb 2001
    Location
    Stockport, UK
    Posts
    729
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh. it is right then, thanks mate, they should make you an Advisor or something

  6. #6
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,121
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Maybe one day, but til then I'm stuck being a lowly Servant
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  7. #7
    SitePoint Guru sowen's Avatar
    Join Date
    Feb 2001
    Location
    Stockport, UK
    Posts
    729
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow this is great I can use the same DB on my local sever as I can on my host, a system DSN over the net! Makes scence now I think about it (derr) I love MSSQL

    Kid with a new toy


Bookmarks

Posting Permissions

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