Normal Topic Server database not opening from desktop icon (Read 1084 times)
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Server database not opening from desktop icon
May 6th, 2010 at 2:05am
Print Post Print Post  
When desktop icons are clicked to open a Sesame database, the file does not open.  Instead we get a message that there are missing files, dat, dst, ddt, or others that are needed.  Response results in having to drill through the normal File/Open branches to get the file, Operations.db that is there, that is not missing anything.  

This is the command line:
C:\Sesame2\Program\sesame.exe -client 700dsr.company.local.:20000:20001 S:\Sesame2\Data\Company\Operations.db -ini_file C:\Sesame2\Utilities\SensibleSolutions\Ini\sesame.ini

This is the Working Directory: C:\Sesame2\

INI files are here: S:\Sesame2\Utilities\SensibleSolutions\Ini\

Server is running on a remote server named 700dsr.company.local.  Server is WIN 2000 SP4.  Workstations are XP-PRO SP3.
All db, dat, dsr, ddt files for Operations application are on that server in S:\Sesame2\Data\Company\ folder
The Server is mapped as Drive S on all workstations.
Client is installed on all workstations in C:\Sesame2\
Using Sesame 2.5.1 on Server and 3 workstations.

This looks like other network installations, but I must be missing a not so obvious typo.  
Who will be FTF (First To Find) the cause of the problem and the final fix?

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Server database not opening from desktop icon
Reply #1 - May 6th, 2010 at 2:22am
Print Post Print Post  
Does the server name really end with a period?

You mentioned that the "S" drive is mapped on all the clients, but it would need to mapped as "S" on the server for the command line to work. Is it? Also, the rootdirs file on the server would need to allow access to the drive and directory.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Server database not opening from desktop icon
Reply #2 - May 6th, 2010 at 5:39am
Print Post Print Post  
Thanks Mark.

Quote:
Does the server name really end with a period?
 YES

Hmm, will have to check the rootdirs on the server (and the local drives too.  I just remembered that all drive letters are enabled but don't want that).  

I am not sure if the Server has a mapping to Drive S.  

Thanks for the suggestions...   Grin

May be a few days before I can check/correct.  
No Remote Access yet, will need to travel 200 miles.  Do batch tasking when on site.   Cry
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Server database not opening from desktop icon
Reply #3 - May 6th, 2010 at 1:40pm
Print Post Print Post  
If I were to guess, I'd say the following would work for you.

Code
Select All
C:\Sesame2\Program\sesame.exe -client 700dsr.company.local.:20000:20001 C:\Sesame2\Data\Company\Operations.db -ini_file S:\Sesame2\Utilities\SensibleSolutions\Ini\sesame.ini  



-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Server database not opening from desktop icon
Reply #4 - May 6th, 2010 at 7:05pm
Print Post Print Post  
Bob_Hansen wrote on May 6th, 2010 at 5:39am:
No Remote Access yet, will need to travel 200 miles.


Have you ever tried LogMeIn? It's free and you can have the client install it for you, so you can get access without the drive.  (There's a Pro version that allows file transfers, etc. The Pro version is under $6/month, purchased annually.)

I have access to over 90 computers using LogMeIn. It's very reliable and has plenty of admin functions, even remotely turn on computers.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Server database not opening from icon - SOLVED
Reply #5 - May 11th, 2010 at 9:07pm
Print Post Print Post  
It looks like Mark had the solution, thanks.
I made the Server mapping to drive S, and that seems to have taken care of the problem.  Grin

The actual Sesame2 folder on the server was not on the root of C:\.  It was on C:\SharedFolders\ path.  The work station icon paths were good for Drive C:\... Server icon paths were changed to Drive S:\....

===============
For Carl: .....  I have been using Open Source UltraVNC (FREE) for years with excellent results.  No remote access was because remote client software had not been installed, and corporate router security was locked down and I needed to have some ports opened.  Remote access is now fixed and working fine.  But thanks for the suggestions.

« Last Edit: May 12th, 2010 at 1:32am by Bob_Hansen »  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged