Solved

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

Posted on 1997-11-22
1
261 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

803 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