Results 1 to 4 of 4

Thread: DSN on the server

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2000
    Posts
    44
    (* sorry about my english , i am from Israel)
    Hi
    when i make a site on my comp that access a DB , it is easy , i can create DSN...
    but if i wanna upload my site to a real host on the net.. how can i connect my DB? how can i make a DSN on the server computer? or how can i know what connection string to use?

    Thanks
    Namo.

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    shalom

    you can probably put the DSN in the same directory as your ASP page and call it with your connection string...

    I would use a DSN-less connection string and place the database and the page in the same dir (or a path that you can access relative to your page)

    DSN-less connection string example, assuming you are using a MS Access DB with ADO:

    objConnection.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=MyDB.mdb"

    that's it!

    lehitraot

  3. #3

    Thread Starter
    Member
    Join Date
    Mar 2000
    Posts
    44
    Toda

  4. #4
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    bevakasha

Posting Permissions

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



Click Here to Expand Forum to Full Width