Results 1 to 13 of 13

Thread: vbscript access db not found.

  1. #1
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    Question vbscript access db not found.

    Hi, I'm trying to connect to database using the following

    objConnection.Open _
    "Provider = Microsoft.Jet.OLEDB.4.0; " & _
    "Data Source = qdbc.mdb"

    I get the error "Could not find file..." and then the path to the desktop, which is not where my .mdb file orthe page is, they are both in the same directory, and I've also tried using the full path.
    In the internets, no one can hear you sarcasm.

  2. #2
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    Re: vbscript access db not found.

    I know I should not bump, but thought someone might know this. It only works if I put the full path in.

    ie

    c:\projects\dbc\qdbc.mdb
    In the internets, no one can hear you sarcasm.

  3. #3
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: vbscript access db not found.

    which language is this?

    the default search behavour will be the active folder, that is the folder which contained the executable that started the proccess (enless the working folder has changed, or the folder with teh mdb file is in the environment PATH variable....).

    So in short, what app, and why are you trying to open a file in a totaly different folder?
    throw new ArgumentException (String, String, Exception)

  4. #4
    Large Member
    Join Date
    Apr 2004
    Posts
    3,720
    Thanks
    47
    Thanked
    99 times in 64 posts

    Re: vbscript access db not found.

    As Mr Animus said you have to figure out the working folder. I'm sure that in whatever language you are using has a means to reflect this to some kind of output, then you can go from there.
    To err is human. To really foul things up ... you need a computer.

  5. #5
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    Re: vbscript access db not found.

    Quote Originally Posted by TheAnimus View Post
    which language is this?

    the default search behavour will be the active folder, that is the folder which contained the executable that started the proccess (enless the working folder has changed, or the folder with teh mdb file is in the environment PATH variable....).

    So in short, what app, and why are you trying to open a file in a totaly different folder?
    It's an asp page, and the mdb is in the same folder.
    In the internets, no one can hear you sarcasm.

  6. #6
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: vbscript access db not found.

    You'd better have a damn compelling reason for using ASP, ASP.Net is good, ASP is a crock of crap, you might as well just use PHP.

    What environment are you hosting ASP in? The problem is that the folder which has the ASP file in, is not directly related to the proccesses working folder (ie the one it looks for things in). Beacuse ASP is a crock of VB idology ****, it won't have any concept of looking for local file dependancies.
    throw new ArgumentException (String, String, Exception)

  7. #7
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    Re: vbscript access db not found.

    Quote Originally Posted by TheAnimus View Post
    You'd better have a damn compelling reason for using ASP, ASP.Net is good, ASP is a crock of crap, you might as well just use PHP.

    What environment are you hosting ASP in? The problem is that the folder which has the ASP file in, is not directly related to the proccesses working folder (ie the one it looks for things in). Beacuse ASP is a crock of VB idology ****, it won't have any concept of looking for local file dependancies.
    Reason for using ASP, is that I've just joined the company and thats what the boss has been using, but we are moving to ASP.NET soon, more reasons I can keep giving him the sooner that shall be, so feel free to give me a brief summary of why we should move out of the dark ages

    I'm just developing this locally at moment, this machine is windows 2000, crappy old thing, a new machine is something else I'm angling for.

    They have also been using tables for layouts here instead of css, but thats a different rant altogether.
    In the internets, no one can hear you sarcasm.

  8. #8
    Large Member
    Join Date
    Apr 2004
    Posts
    3,720
    Thanks
    47
    Thanked
    99 times in 64 posts

    Re: vbscript access db not found.

    Do they know you don't know much about software development?
    To err is human. To really foul things up ... you need a computer.

  9. #9
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    Re: vbscript access db not found.

    Quote Originally Posted by yamangman View Post
    Do they know you don't know much about software development?
    My expertise is in windows dev, mainly delphi, and that's for for almost a decade, so I'd not say I dont know much about software development. For some reason when I started this job the boss decided to get me into web development instead, think this was because I've also graphic design experience. Web dev was never really the companies main aim, but more and more customers are asking for that aswell, and the boss wanted to concentrate more on the windows side, so I got shifted sidewards before I even started
    Last edited by icanhazburger; 13-01-2008 at 05:31 PM.
    In the internets, no one can hear you sarcasm.

  10. #10
    Sublime HEXUS.net
    Join Date
    Jul 2003
    Location
    The Void.. Floating
    Posts
    11,819
    Thanks
    213
    Thanked
    233 times in 160 posts
    • Stoo's system
      • Motherboard:
      • Mac Pro
      • CPU:
      • 2*Xeon 5450 @ 2.8GHz, 12MB Cache
      • Memory:
      • 32GB 1600MHz FBDIMM
      • Storage:
      • ~ 2.5TB + 4TB external array
      • Graphics card(s):
      • ATI Radeon HD 4870
      • Case:
      • Mac Pro
      • Operating System:
      • OS X 10.7
      • Monitor(s):
      • 24" Samsung 244T Black
      • Internet:
      • Zen Max Pro

    Re: vbscript access db not found.

    heh, a well-written ASP site can easily out-perform a badly written, or inefficient ASP.net website.

    ASP.net isn't automatically better by a long shot.
    (\__/)
    (='.'=)
    (")_(")

  11. #11
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS

    Re: vbscript access db not found.

    i was writing bad ASP back when i was at school.

    memories!

  12. #12
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    Re: vbscript access db not found.

    Quote Originally Posted by directhex View Post
    i was writing bad ASP back when i was at school.

    memories!
    I was writing awful code in turbo pascal back in college so old

    I remember lunch breaks going around my mates and wishing we had 25mhz 486's in college instead of 286's
    In the internets, no one can hear you sarcasm.

  13. #13
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: vbscript access db not found.

    Quote Originally Posted by Stoo View Post
    heh, a well-written ASP site can easily out-perform a badly written, or inefficient ASP.net website.

    ASP.net isn't automatically better by a long shot.
    Yes, but an ASP.Net site thats mediocorely written will outperform a well written asp.net page.

    But this is getting off topic, if you try setting up a DSN, and using that.
    throw new ArgumentException (String, String, Exception)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HEXUS.bargains - The Rules - Access, Usage and Promotion.
    By MD in forum Retail Therapy and Bargains
    Replies: 0
    Last Post: 04-01-2007, 12:31 PM
  2. Scan account not found
    By Craig321 in forum SCAN.care@HEXUS
    Replies: 2
    Last Post: 01-12-2006, 02:45 AM
  3. Microsoft Access Help
    By muddyfox470 in forum Help! Quick Relief From Tech Headaches
    Replies: 5
    Last Post: 01-09-2005, 01:42 PM
  4. FTP access via Java
    By Kezzer in forum Software
    Replies: 11
    Last Post: 11-03-2005, 08:47 AM
  5. Replies: 7
    Last Post: 05-02-2005, 03:53 PM

Posting Permissions

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