Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 1997-11-22
1
Medium Priority
?
267 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 120 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

636 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