Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2004-12-01
16
Medium Priority
?
855 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:tesupport
  • 7
  • 6
14 Comments
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12718332
What edition of sql is this ?
0
 

Author Comment

by:tesupport
ID: 12718605
7.00.91
0
 

Author Comment

by:tesupport
ID: 12718615
Check that.....7.00.961
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 18

Expert Comment

by:ShogunWade
ID: 12718778
i mean   Standard, Enterprise, MSDE, DataCentre, Developer or Desktop
0
 

Author Comment

by:tesupport
ID: 12721206
It's the Standard edition of SQL Server 7.
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12724455
Standard Edition does not run on Windows XP ,   it is a server product that must be installed on a server edition of windows
0
 

Author Comment

by:tesupport
ID: 12726377
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
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12726482
what does your connection string look like ?
0
 

Author Comment

by:tesupport
ID: 12727712
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
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12727728
Is it borland drivers you are using or is it microsoft drivers ?
0
 

Author Comment

by:tesupport
ID: 12727759
It's the native MSSQL driver in BDE which on the configuration tab appears to be SQLMSS32.DLL .
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12727976
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
 

Author Comment

by:tesupport
ID: 12919662
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
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 12938561
PAQ'd, 250 points refunded.
CetusMOD
Community Support Moderator
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

810 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