I'm tired to be blind in MS SQL and Delphi 3

I'm only beginner in C/S programming.
Who can tell me how can I work with my MS SQL & Delphi 3 on new machine (another user and security context):
 a) what to install to this machine;
 b) what DLLs are required from BDE, SQL Linsk, MS SQL
     Client tools;
 c) what's about permissions (I add new user to my database grant all permissions to him, but my application
tells me that user name or password is not correct (login
failed) or table is not indexed);
 d) what's about problems with transactions on records with
     big size. (When I try to call MyTbl.Post in transaction
     I recieve an exception that network's possibly failed);
 e) where can I find documentation or books about
     Delphi 3 & MS SQL programming and tooltips;
 f) where can find out my fault when GPF occures in     Borland SQL Links DLL?

With best regards hansmtbank!
hansmtbankAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Pegasus100397Commented:
Whoa! Quite a few questions for 30 points but let's see if we can chip away at a few of them :)

>I'm only beginner in C/S programming.
We all were at one time or another :)

a) what to install to this machine;
You have your application (the .EXE) file and the Borland Database Engine that will need to be installed on each client computer. You will also have to configure the BDE on each computer that you install your program on (I'm still trying to work on a way to do this programmatically).

b) what DLLs are required from BDE, SQL Linsk, MS SQL, Client tools;
If you use the installation utility that comes with Delphi then it should install the BDE for you automatically when you run your setup package. Normally (and I love this about Delphi) you do not have to include extra .DLLs, etc unless they do not exist on the client machine and your program calls them specificially. If this is the case then configure the installation utility to include these files as well.

c) what's about permissions (I add new user to my database grant all permissions to him, but my application
tells me that user name or password is not correct (login
failed) or table is not indexed);
This is actually two seperate problems. First off, grant access to your tables to a GROUP. Then, as new people come and go assign them a user account, then make them a MEMBER of that GROUP. That way you don't have to assign rights to each person, they assume the rights of the GROUP

As far as the Table Not Indexed error, depending on your database, you will have to assign a unique index to each table. In MS SQL Server this is easy, simply go into SQL Enterprise Manager, locate the table, click once on it, then RIGHT click on it to define an index.

d) what's about problems with transactions on records with
big size. (When I try to call MyTbl.Post in transaction
I recieve an exception that network's possibly failed);
This sounds like the network connection was broken during the post. Check the max record size in your ODBC set (if applicable) and also make sure your table has a unique index so that the BDE doesn't get confused when posting.

e) where can I find documentation or books about
Delphi 3 & MS SQL programming and tooltips;
Although it references Delphi 2, the same techniques apply and I highly recommend "Delphi 2 Database Developer's Guide" by Ken Henderson, ISBN 0-672-30862-2  It will answer any question you have about using Delphi with most databases, plus some tips, tricks and traps about each.

f) where can find out my fault when GPF occures in Borland  SQL Links DLL?

That's a tough one. The debugger isn't much help either. What I do is usally step line-by-line through the code until the error happens again, then copy that section of code into another application and attempt to re-run. If the SQL Links can produce a log file (trace file) that might be helpful too.

Anyways, Welcome to C/S programming with Delphi. It's both a Godsend and a Nightmare all rolled into one! :)

Pegasus

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
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.