SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Member
    Join Date
    May 2000
    Location
    Casablanca, Morocco
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DSNless connection to MSaccess?

    Hi everybody,

    I've question for you :
    Using a DSNless connection to databeses, could it not work with some Web Hosts? i mean, is it independent as far as the host's config is concerned ?

  2. #2
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not as far as I know, or have ever experienced.

    The host does however need to have the MDAC drivers installed, if they don't it wouldn't work
    .NET Code Monkey

  3. #3
    I have an opinion...
    Join Date
    Sep 2001
    Location
    Barrie, Ontario
    Posts
    324
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are you using the JET or MSAccess driver for your DSNless connection? I know of many hosts that don't support both.
    Egotist: A person more interested in himself than in me.
    KodeKrash - Eidix - Barrie LUG

  4. #4
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    with my host, using the server.mappath() doenst seem to work, you either have to use a DSN connection or the full pyhsical path to it

  5. #5
    I have an opinion...
    Join Date
    Sep 2001
    Location
    Barrie, Ontario
    Posts
    324
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    D, knowing your code like I do, are you sure the SERVER is to blame ?
    Egotist: A person more interested in himself than in me.
    KodeKrash - Eidix - Barrie LUG

  6. #6
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Most sites (like my ISP) store your data on a drive (i.e D:\xxx.xxx.xxx.xxx\home\) where xxx is your IP address.

    COnnection string for me is shown below:
    Code:
    <%
    dim str_conn
    str_conn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source = D:\xxx.xxx.xxx.xxx\dbs\dbfile.mdb"%>
    If you can find out the physical path (your host should tell you) then you're set.

    Hope this helped. 'Till next time..
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  7. #7
    SitePoint Member
    Join Date
    May 2000
    Location
    Casablanca, Morocco
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanx for your advices guys!
    I think i'm going to use DSN, though i've read it slows down ASP scripts...!

  8. #8
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    *slaps kode around the head* my asp isnt that bad...?

  9. #9
    SitePoint Member Karnage's Avatar
    Join Date
    Jul 2001
    Location
    UK
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Normally if a host supports Access databases you can use a DSN or DSNless connection to it in your script.

    There is only a performance improvement in using a DSNless connection when you have 10+ concurrent connections. But as your number of concurrent connections increase your performance gain also increases.

    Article on DSN and DSNless connections.
    Jonathan - jon@reloadnet.com

    :[Lead Developer of newsASP]:
    - http://www.reloadnet.com/newsASP


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
  •