Solved

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

Posted on 1997-11-22
1
263 Views
Last Modified: 2010-04-04
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!
0
Comment
Question by:hansmtbank
1 Comment
 
LVL 3

Accepted Solution

by:
Pegasus100397 earned 30 total points
ID: 1351506
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

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question