Results 1 to 11 of 11

Thread: VB6 Windows OS to Windows Server 2019

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2021
    Posts
    4

    VB6 Windows OS to Windows Server 2019

    Hi all.

    Need some help please. I'm running an old vb6 front end - access mdb back end and it's been on a local device that a few guys have logged on to over the years over our local network.

    Due to covid, I purchased a server with MS Server 2019 installed and my plan is to move the application over to it and RD from anywhere however I'm struggling.

    I've gone to install the application but it is trying to find the mdb from wherever the front end location is. Even when I open the front end in the same location as the mdb, it still can't connect.

    The system is built in dao and I'm wary that I need to re-code to ado (if someone can confirm). Any ideas please on what I need to do to successfully install on the server? I think I may need to regsvr the dao files too?

    Any help owuld be much appreciated. Can copy and paste snippets of code too.

    Regards

  2. #2
    PowerPoster
    Join Date
    Feb 2017
    Posts
    4,995

    Re: VB6 Windows OS to Windows Server 2019

    Quote Originally Posted by jeffy10 View Post
    it still can't connect.
    Posting the error number and description might help.

  3. #3
    PowerPoster yereverluvinuncleber's Avatar
    Join Date
    Feb 2014
    Location
    Norfolk UK (inbred)
    Posts
    2,235

    Re: VB6 Windows OS to Windows Server 2019

    Never buy a server with MS Server 2019 due to covid, it won't help. Use a mask instead and just go to bed.
    https://github.com/yereverluvinunclebert

    Skillset: VMS,DOS,Windows Sysadmin from 1985, fault-tolerance, VaxCluster, Alpha,Sparc. DCL,QB,VBDOS- VB6,.NET, PHP,NODE.JS, Graphic Design, Project Manager, CMS, Quad Electronics. classic cars & m'bikes. Artist in water & oils. Historian.

    By the power invested in me, all the threads I start are battle free zones - no arguing about the benefits of VB6 over .NET here please. Happiness must reign.

  4. #4
    Addicted Member
    Join Date
    Mar 2009
    Posts
    244

    Re: VB6 Windows OS to Windows Server 2019

    Ofcourse you do have to have DAO DLL's installed on the client you're running the application on. If it automatically looks in the folder of where the front end is, then it should run.
    But as Eduardo- says, without actually knowing the error you get, it's hard to tell what the problem might be. It might be something simple, as DAO, once you've got the runtimes installed (it might even come preinstalled on server 2019), shouldn't be a problem.

  5. #5
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,418

    Re: VB6 Windows OS to Windows Server 2019

    Quote Originally Posted by SuperDre View Post
    Ofcourse you do have to have DAO DLL's installed on the client you're running the application on. If it automatically looks in the folder of where the front end is, then it should run.
    But as Eduardo- says, without actually knowing the error you get, it's hard to tell what the problem might be. It might be something simple, as DAO, once you've got the runtimes installed (it might even come preinstalled on server 2019), shouldn't be a problem.
    He "RD"'s to the Server --> Remote Desktop
    That vb6-FrontEnd is executed on the Server

    And the Problem-Description sounds like hardcoded paths in the code (e.g. "c:\Program Files" vs c:\Program Files (x86)").
    Nevermind that a "writable" File (and an Access-Database is a writable File) should never be placed in Program Files
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  6. #6

    Thread Starter
    New Member
    Join Date
    Apr 2021
    Posts
    4

    Re: VB6 Windows OS to Windows Server 2019

    Quote Originally Posted by Eduardo- View Post
    Posting the error number and description might help.
    Name:  8D16A4B5-90FF-4B44-A17A-092B6386F22E.jpeg
Views: 1355
Size:  39.3 KB

    Hi. Thanks for replying and sorry for the delay. I’ve attached a pic to look at. The first part of the connection string isn’t coded into the program so I’m not sure why it’s there (the C\users\administrator\desktop part).

    As an FYI, I haven’t installed VB6 yet to the server. Do I need to? Or do I need to register the dll files? Apologies, I’ve never used vb6 and access on a server before.

    Finally, this front end will be on numerous logins with licensed user CALs, the database will be local to the server. Is that ok?

  7. #7
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,418

    Re: VB6 Windows OS to Windows Server 2019

    64-Bit drivers vs. 32-Bit-Drivers?
    And i've seen mention of mismatches/hardcoded paths in linked-through databases
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  8. #8
    Addicted Member jg.sa's Avatar
    Join Date
    Nov 2017
    Location
    South Australia ( SA )
    Posts
    198

    Re: VB6 Windows OS to Windows Server 2019

    The root folder Users is a new 'facility' in Windoze

    Does the old PC have a Users folder ?

  9. #9
    Banned
    Join Date
    Jun 2022
    Posts
    1

    Re: VB6 Windows OS to Windows Server 2019

    Access Database Keeps Getting Corrupted
    https://transferemails.com/access-da...ing-corrupted/

  10. #10
    PowerPoster PlausiblyDamp's Avatar
    Join Date
    Dec 2016
    Location
    Pontypool, Wales
    Posts
    2,458

    Re: VB6 Windows OS to Windows Server 2019

    Quote Originally Posted by jg.sa View Post
    The root folder Users is a new 'facility' in Windoze

    Does the old PC have a Users folder ?
    IIRC it was there in Windows 7,hardly a new thing.

  11. #11
    Addicted Member jg.sa's Avatar
    Join Date
    Nov 2017
    Location
    South Australia ( SA )
    Posts
    198

    Re: VB6 Windows OS to Windows Server 2019

    G'Day PD

    Thanks for your insight, so helpful

    Quote Originally Posted by PlausiblyDamp View Post
    IIRC it was there in Windows 7,hardly a new thing.
    I'm trying to help OP 'think' about the root cause !!!

Tags for this Thread

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