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 5 of 5
  1. #1
    Regular Coder
    Join Date
    May 2002
    Location
    Helsinki, Finland
    Posts
    231
    Thanks
    0
    Thanked 1 Time in 1 Post

    Unhappy ASP / SQL: Parametres on connection string

    Code:
    <%
    	dim dbConn 
    	dim resSet
    	Set dbConn		= Server.Createobject("ADODB.Connection")
    	Set resSet		= Server.Createobject("ADODB.Recordset")
    
    	dbConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db\news.mdb")
    	Set resSet	= dbConn.execute("SELECT * FROM News")
    %>
    Where and how to add User and Password information? I keep getting "No read permission on 'News'" error
    Zvona
    First Aid for
    Web Design

  • #2
    Regular Coder
    Join Date
    May 2002
    Location
    Helsinki, Finland
    Posts
    231
    Thanks
    0
    Thanked 1 Time in 1 Post
    I think I've done everything correctly, except I can't access to the db. If I try to modify security / user & group accounts, I get a dialog "Record(s) cannot be read; no read permission on 'MSysAccounts'".

    At work, we have separate Workgroup Administrator which is targetted to a system database (.mda) file. This can be the reason, why I can't access externally to a database created at work?
    Zvona
    First Aid for
    Web Design

  • #3
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Heck, the network admin at work *tries* to keep this stuff a secret, lol... although I've managed to glean some info from him a time or two.

    It definitely sounds like a network problem though... I would talk to your network admin and say "Hey, I need to read from this file!!!" - if he's cool, he'll hook you up.
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #4
    Regular Coder
    Join Date
    May 2002
    Location
    Helsinki, Finland
    Posts
    231
    Thanks
    0
    Thanked 1 Time in 1 Post
    Originally posted by whammy
    It definitely sounds like a network problem though... I would talk to your network admin and say "Hey, I need to read from this file!!!" - if he's cool, he'll hook you up.
    *g*
    I just happens to be, that I'm also the possible admins this minor company could have about computers and information techonology.

    I remember there was an easy way to allow permissions through this .mda file to modify user & group permissions in db itself. Unfortunately, the other guy (who has created this permission thingie) is on vacation .

    I'll have to build the db somewhere else to prevent permission information to be attached on it.
    Zvona
    First Aid for
    Web Design

  • #5
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I wish I could help more... but I probably have much less knowledge than Dave on this particular aspect of ASP!

    If I was you I'd go look around in IIS on the machine in question if you can, though... just to see what you can find out...
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

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