What do I have that my user doesn't?

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.
PummelAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

emadatCommented:
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.
0
BAlexandrovCommented:
<quote>
We also have the same SQL Server dll version.
</quote>

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


Bojidar Alexandrov
0
da-vinciCommented:
Install MadExcept; then you will have more information about the error. Very useful in these situations:

http://help.madshi.net/madExcept.htm
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

PummelAuthor Commented:
emadat:
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)

da-vinci:
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.
0
emadatCommented:
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.
0
PummelAuthor Commented:
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.
0
emadatCommented:
I'm glad you got it solved.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PummelAuthor Commented:
"That's the way you do it.  Get your money for nothin' and your chicks for free."

Thank you for your input.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.