We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Win2000 Server and DB access

jd576
jd576 asked
on
Medium Priority
245 Views
Last Modified: 2010-04-19
This seemed the best forum to ask this Win2kServer question, since it is a generic server question.  

I admit ignorance about server and network issues - I am an out of date "single tier" programmer just learning new stuff.  I have a large VB6 database application using ADO2.8 and Jet4.0 with an Access db running on a hospital network, the db is on a dedicated Win2k Server (nothing else on this server).  The application has been accessing the db from each terminal by way of a mapped drive to the server db folder.  Thus with ADO I have been addressing the db on the local mapped drive with a connection string like:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=drive:\folder\dbname.mdb;Persist Security Info=False"

Problem is that the Win2k Server has a five license pack.  We now need to run the application from 20 terminals.  Mapping the server drive to 20 terminals  requires 20 licenses (apparently-this is out of my area of knowledge), and seems pretty inefficient.

I know I can address the db by IP but have not done this with ADO.  First question:  How do I address the db, how does IS set the db up to receive the call.  I supposed the address would be something like:  Data Source=\\255.255.255.255\dbname.mdb;...  Using the correct IP, that did not work when I was trying to test connection options. I am missing something in forming this address -- it is something simple, but I am uneducated.  Please educate me.

Second question.  Using an IP call to the server, there are unlikely to be 5 concurrent connections at any time. Connections always just grab data and close immediately. Assuming the win2k server license is setup properly, is there any problem with license issues having 20 different computers calling the server, as long as there are never more than 5 concurrent connections?  I assume this is just fine, reading the MS license info.

This is pretty basic, but I need basic help.  Thanks guys.
Comment
Watch Question

Fatal_ExceptionSystems Engineer
Top Expert 2005
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2005
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Fatal_ExceptionSystems Engineer
Top Expert 2005

Commented:
I hate dealing with licensing..  everytime I think about it, it gives me a headache...  :)   Now you are making me think about it again, and I stand corrected...  Think I will just stop trying to help in this area... ARGH
CERTIFIED EXPERT
Top Expert 2005

Commented:
Fatal_ExceptionSystems Engineer
Top Expert 2005

Commented:
You know I will...  I save everything..  :)

Thanks..

FE

Author

Commented:
I split this one on the server license.  DB address I needed to take to another forum.  Thanks guys.
Fatal_ExceptionSystems Engineer
Top Expert 2005

Commented:
Thanks   :)

FE
Fatal_ExceptionSystems Engineer
Top Expert 2005

Commented:
Actually, you should have given those points to Netman...   embarrassed to even get any in this TA with the answer I provided...  :)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.