Connect Delphi5 app to Sql Server 7

I have Delphi 5 enterprise and would like to know if it is possible to write a app that connects to sql server 7 that doesn't require the enduser to purchase a sql license to connect to the database.  If so, how (dsn,bde...)?
jfreisenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kretzschmarCommented:
hi jfreisen,

i don't think that this is possible,
because sql-licenses are independent from
any app which will use the sql-server.

your client must have a sql-server and the amount of client-access-licences which will connect at one time.

it doesn't matter which app use these access-licenses.

meikl
0
dejawareCommented:
Actually the comment posted is right and wrong.  Right - every client must have a sql-server and the amount of client-access-licenses which will connect at one time.  Wrong - actually there is a way :)

It's the new trend in application delivery - host it on your server, and "rent" your application.  This trend is becoming very popular since your client does not need to invest in tools that make your application shine.  They use your service - via network protocols, where it is just your application - and possibly others that need individual client licenses.  Works very well (depending on what the application is used for), and keeps clients happy, and best of all keeps you collecting all the potential revenue  that could have been lost with piracy.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jfreisenAuthor Commented:
Can you supply any more information on how this is done? The client is ok to buy the sql server on there site but I need to know if I can get around the enduser licenses.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

kretzschmarCommented:
yup, inform me too ;-)
0
dejawareCommented:
Jfreisen, unfortunately this is a decision that needs to be made before your application is designed.  It sounds as if you have planned/began work on the software.  Basically the architechture for a served application would be a fat server with typically a browser front-end.  You would have the server processes communicating with the SQL server database.  And because you are hosting your application, the only SQL licenses that you would need is on your machine.  Configuration is this:
CLIENT   CLIENT
   |        |
YOUR WEBSERVER
     |
YOUR APPLICATION ON YOUR SERVER
     |
SQL SERVER

0
Fatman121898Commented:
Hey, dejaware, it's time for Sammy :-))).
Guess who.
0
dejawareCommented:
who who??? who tha hack is samy?  8-(
0
accman99Commented:
I don't hink this is correct if you read the M$ EULA. Appservers are
specifically noted in this doc.

Using an appserver component does not get around the client license req.
0
fkmfkmCommented:
You can try using MSDE. It provides all the features of SQl Sever.and freely distributable.

check it out at
http://www.msdn.microsoft.com/vstudio/msde/

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.