Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where is my report? (Visual Studio 6 (VB6))

    I have created a VB application that references an Access97 database. Part of the application needs to show a database report to the user. The report works fine in development mode on my machine but once it has been packaged and deployed to a client machine i get the error
    "Failed getting Rowset(s) from current data source"
    and the report is shown as a blank screen.

    Why ?

    How do i fix it ?

    the client machine does not have access loaded, is there a component that i need to include?
    i have mdac_typ.exe in the setup files and this seems to have loaded ok.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Where is my report? (Visual Studio 6 (VB6))

    Are you saying that you're trying to *run* an Access report from VB? If so, I think you may need the Access runtime as well as the VB files. Using Access as a datastore is different from using Access objects like forms and reports. It seems to me there have been a thread or two on calling Access objects from VB. You might try a Lounge Search.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is my report? (Visual Studio 6 (VB6))

    Hi Charlotte,
    no the report has been created in VB.

    I have since the post got most of the way to a fix for this and am going to put my neck out and sya that this is / will be the solution.....

    It appears that MDAC is at fault
    having looked into the VB Report object i found that it has an Error Event. placing code in here i got the error dumpoed to a text file and it was
    "3706 : Provider cannot be found. It may not be properly installed"
    It appears that MS have changed the way that MDAC offers access to Jet Engined Databases.
    In MDAC versions up to and including MDAC 2.0 the jet provider was 3.51 (Access97). From MDAC 2.1 on the Jet provider is 4.0 (Access 2000) - NOTE 3.51 is NOT included.
    i was lucky enough to find this solution from the http://www.tek-tips.com forum which i am trusting will provide the solution that i need.
    watch this space ...

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is my report? (Visual Studio 6 (VB6))

    SUCCESS , the solution above has got the VB report displayed as designed. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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