What do I have that my user doesn't?

Posted on 2003-03-20
Medium Priority
Last Modified: 2010-04-04
I created this program for another guy in my organization.  We can both see our organization's SQL server.  The program uses an SQL database that he set up.  I created an ODBC link to that database (in the System DSN tab) and gave it a name.  I also logged in using his username and password.

My Delphi 6 program uses a TDatabase, a few TTables and corresponding TDataSources to access the data.  There are no TQueries, TUpdateSQLs, or anything else than what I've mentioned.  The finished executable runs fine on my Windows 2000, but crashes on his Windows XP, offering to send the error to Microsoft.  The error gives no additional information.

Thinking the problem was XP, I set up the same SQL connection (same name, properties, and login information) on two other developers' machines and it ran without a hitch.  They have XP so it was ruled out as being the problem.  I made absolutely sure that this guy's SQL connection had the same name, properties, and login information that I did.

I figured it must be something that us Delphi developers have that he doesn't.  The only difference I could think of was BDE.  Well, he has BDE installed already.

What could our developer computers have that he doesn't?  The program doesn't use run-time packages or any third-party or custom components.  We also have the same SQL Server dll version.
Question by:Pummel
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

Expert Comment

ID: 8175883
From the "Drivers" tab in the ODBC Data Source Administrator, check the versions of the drivers he has and the ones you have. There might be a version conflict.

Also try to install the SQL Query Analyzer on his PC and see if you can connect to the SQL server of questin using the same credentials your program is using.

Expert Comment

ID: 8176027
We also have the same SQL Server dll version.

I hope you have speak about version of sql client, if not - install sql server client.

Bojidar Alexandrov

Expert Comment

ID: 8176031
Install MadExcept; then you will have more information about the error. Very useful in these situations:

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 8177515
What is SQL Query Analyzer?

Bojidar Alexandrov:
That's what I meant.  We have the same SQL Server .dll, or rather, the same client version.  I said "SQL Server" because that's how it's listed in ODBC -> Drivers tab.  (SQLSRV32.DLL)

Cool tool, and I may use it for future projects.  But this time I know the exception's being thrown in some procedure like TDatabase.Open.  I'm pretty sure that the low-level API error that gets returned would be incomprehensible to me, and it's in a place where I can't fix it since my code's already simplified.

Expert Comment

ID: 8177591
SQL Query Analyzer is one of the client utilities that comes on Microsoft SQL CD. It allows you to connnect to a local or remote SQL server, and run queries on that server.

When you install it and attempt to connect to the server in question; you might come to know what the problem is.

Author Comment

ID: 8196684
No one really hit the nail on the head, but this is what ended up working.

I made a Borland Install that included, of course, the executable.  I also made it come with a BDE_PRO Merge Module.  Figuring out the configuration file was confusing, but I got it.

The install works so well that I don't even have to go into the ODBC Program and manually configure the SQL Connection.  The configuration file must have had what it needed to connect.

All of you had good ideas but no one nailed it on the head.  Because I hate having EE points in escrow, I'll give the points to the next person that responds to this question.

Accepted Solution

emadat earned 616 total points
ID: 8196901
I'm glad you got it solved.

Author Comment

ID: 8196938
"That's the way you do it.  Get your money for nothin' and your chicks for free."

Thank you for your input.

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month11 days, 13 hours left to enroll

752 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