Solved

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

Posted on 1997-11-22
1
265 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

688 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