May 25, 2005 at 9:45 am
Hello and thank you all for your reply's,
I am having problems with using SQL. I was able to install it and get the latest MDAC updates and all that. I don't know how to use it though. I just set up our server about a month ago and it has been running sql since then. I am now trying to install a dos based program onto the server and share it to all the computers so that we can go to any computer and use the program and it is all stored on the server. So any help on how to set up a shared DOS program through SQL would be very much appreciated.
Joe
May 25, 2005 at 9:52 am
SQL Server isn't intended to be used to "share" other executables. It manages and provides shared access to data which is stored in tables. The data can be used by many applications and/or direct users, but it isn't an application server. BTW I am unaware of any app servers that are designed to serve up DOS applications, they typically are used for web applications.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
May 25, 2005 at 12:57 pm
Joe,
Why don't you tell us a little bit more about your goal and we will be able to answer you better. What do you mean by running DOS program?
I have one installation where the client program is stored on the server and users have their drives mapped to the executable on the share that connects to SQL Server on the same server. BUT... If you map a drive (the share) the process still runs on the client computer and you need SQL Server Connectivity tools on the client. But (second one) if you client computers are Windows 2000 or XP, connectivity tools are there by default or else you can use sqlredis.exe redistributable file to install SQL connectivity tools.
Another option is to use your company's Terminal Server, install the application there and your users connect to application and SQL Server using Terminal Services Client (Remote Desktop, whatever it is called)
Yelena
Regards,Yelena Varsha
May 26, 2005 at 7:51 am
Hi Yelena,
Thank you for your help in this situation. Well I am trying to share this program by mapping the drives to the executable batch file. It worked to an extent and then said that it was looking for a folder on the C: Drive but it could not find the program. It must have been looking for the folder on the client computers C: drive instead of the servers C: drive. Is there any way I can fix this so that it looks for the C: drive on the Server instead of the client? And Also when the program is running on the client computers is it still saving to the server being a mapped drive and all or is it going to save to the client. I don't know if u can fully answer that question because of the fact that you can't see the actual program. But it is an accounting program created by Levinson and Lyon or somethin like that. Thanks for any help.
Joe
May 26, 2005 at 10:15 am
Joe,
Do you have the access to code in the batch file? If yes then do the following:
Suppose the name of your folder is YourFolder. insted of specifying C:\YourFolder path that the program is trying to find specify the full path:
\\YourServer\YourShare\YourFolder
Please, note that if the program is trying to write to a file in this folder for a current user then If all users will write to the same file, it is not good. In this case I would create folders on the clients.
It is difficult to answer the question where exactly the program is saving without actually looking at the code. Do you have vendor' s support for this application?
The other question is: how the program is licensed? Does it allow multi-user usage?
Yelena
Regards,Yelena Varsha
May 26, 2005 at 10:29 am
For applications that need to be shared we generally use CITRIX to deploy. Another optionas Yelena mentioned is Terminal Services see http://www.microsoft.com/windowsserver2003/technologies/terminalservices/default.mspx
Trying to do this via shared drives could lead to other issues with scalibility or even printing.
Francis
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply