-
Apr 9th, 2022, 01:02 PM
#1
Thread Starter
New Member
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
-
Apr 9th, 2022, 02:43 PM
#2
Re: VB6 Windows OS to Windows Server 2019
Originally Posted by jeffy10
it still can't connect.
Posting the error number and description might help.
-
Apr 9th, 2022, 04:01 PM
#3
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.
-
Apr 11th, 2022, 08:51 AM
#4
Addicted Member
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.
-
Apr 11th, 2022, 09:05 AM
#5
Re: VB6 Windows OS to Windows Server 2019
Originally Posted by SuperDre
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
-
Jun 17th, 2022, 12:04 AM
#6
Thread Starter
New Member
Re: VB6 Windows OS to Windows Server 2019
Originally Posted by Eduardo-
Posting the error number and description might help.
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?
-
Jun 17th, 2022, 01:05 AM
#7
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
-
Jun 17th, 2022, 06:25 AM
#8
Addicted Member
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 ?
-
Jun 17th, 2022, 06:55 AM
#9
Banned
Re: VB6 Windows OS to Windows Server 2019
-
Jun 17th, 2022, 07:12 AM
#10
Re: VB6 Windows OS to Windows Server 2019
Originally Posted by jg.sa
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.
-
Jun 17th, 2022, 07:16 AM
#11
Addicted Member
Re: VB6 Windows OS to Windows Server 2019
G'Day PD
Thanks for your insight, so helpful
Originally Posted by PlausiblyDamp
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|