Authentication issue with BDE and MSSQL 7 on Windows XP SP2 machine

Hello.
I'm having difficulty with BDE 5.01 database connectivity using the native MSSQL driver connecting to a MSSQL 7 database on a Windows XP SP2 machine. It's not passing the Windows authentication user/pass credentials to MSSQL correctly. If I use an ODBC driver connection to the same SQL Server then I have no problem. I believe that the issue may have something to do with the MSSQL 7 client install on that machine not populating the ntwdblib.dll file into the C:\Windows\System32 directory (although the DB Library Options Tab of the SQL Client shows it to be there). I've manually placed the file there (tried the following versions: 2000.80.194.0 and 1998.11.13.0) and it didn't help. I've uninstalled/reinstalled the MSSQL client and still the ntwdblib.dll is not being populated on install. I've thought about reinstalling MDAC since I've read that the ntwdblib.dll file needs some of its components, but have had trouble with this in Win XP SP2 (the exact same version downloaded from the MS website will give an incompatibility error). The Windows firewall remains disabled.
Any constructive help is appreciated.
Thank you
tesupportAsked:
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.

ShogunWadeCommented:
What edition of sql is this ?
0
tesupportAuthor Commented:
7.00.91
0
tesupportAuthor Commented:
Check that.....7.00.961
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ShogunWadeCommented:
i mean   Standard, Enterprise, MSDE, DataCentre, Developer or Desktop
0
tesupportAuthor Commented:
It's the Standard edition of SQL Server 7.
0
ShogunWadeCommented:
Standard Edition does not run on Windows XP ,   it is a server product that must be installed on a server edition of windows
0
tesupportAuthor Commented:
The MSSQL 7 server is running on a server. What we're trying to do is make a BDE connection to the server from a workstation.
0
ShogunWadeCommented:
what does your connection string look like ?
0
tesupportAuthor Commented:
The same as Windows 2K/Windows XP pre SP2 workstations that connect fine. It's beginning to look like a bug here since I've found this now on additional sites besides the initial one in question. I can connect using SQL authentication in all these cases. What's the best way to contact Borland support if you don't have a contract w/them?
0
ShogunWadeCommented:
Is it borland drivers you are using or is it microsoft drivers ?
0
tesupportAuthor Commented:
It's the native MSSQL driver in BDE which on the configuration tab appears to be SQLMSS32.DLL .
0
ShogunWadeCommented:
ok,   I believe this is a microsoft DLL as opposed to written by borland.    Your best bet is to contact microsoft on there support line.   They will ask you to pay money, but tell then that this is a bug and they wont charge you.  

Before that you may want to check the microsoft website to see if there is a hot fix for it.
0
tesupportAuthor Commented:
Not wanting to leave this issue abandoned...................
Note to all: Borland does not support the BDE any longer (as per their support staff).

My fix was to have the client switch to SQL authentication which they did and is fine now.

Thanks for all posts.
0
CetusMODCommented:
PAQ'd, 250 points refunded.
CetusMOD
Community Support Moderator
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
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
Microsoft SQL Server

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.