Solved

BDE to personal MS SQL Server 2000

Posted on 2002-04-26
6
444 Views
Last Modified: 2013-11-23
hi experts, l'm using Personal MS-SQL Server 2000. using Borland BDE MSSQL driver (SQLMSS32.DLL) version 5.0.1.23(0), when tried to connect using this driver, it was connected but very slow when connecting and the property "Type" in BDE stated "MSSQL: Unknown Version: Mapping error: Bad template: SQL Server [^0-9]*([0-9]+)\."
why ? please help. thanks.
0
Comment
Question by:Explorer060599
[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
  • 4
6 Comments
 
LVL 6

Expert Comment

by:Stuart_Johnson
ID: 6971500
Hi Explorer,

If you're using the BDE, create a new BDE Alias of type "SQL Server".  Set the ODBC DSN property to your ODBC driver, set your default USER NAME and you should be set.

Hope this helps,

Stu
0
 
LVL 6

Expert Comment

by:Stuart_Johnson
ID: 6971547
Further:

I just tried exactly the same thing as you did and got the same error message "MSSQL: Unknown Version: Mapping error: Bad template: SQL Server [^0-9]*([0-9]+)\.".  I'm wondering if it maybe a version issue with SQL Server 2000.  Perhaps this driver only likes SQL Server 7+????

Stu
0
 
LVL 6

Expert Comment

by:Stuart_Johnson
ID: 6971552
I've had a look on the net and in Borland's support site and I can't find anything at all about this error message with regards to SQL Server.  There is references to Sybase, but I doubt changing anything in that line will make a difference.  I'll keep looking and post back if I find anything.

Stu
0
Industry Leaders: 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

by:Explorer060599
ID: 6973672
ok..i will be waiting
0
 
LVL 6

Expert Comment

by:Stuart_Johnson
ID: 6974430
Did you try using it the way I suggested above?  I don't get any errors like that at all.

There is nothing that I can see on Borland's website.

Stu
0
 
LVL 44

Accepted Solution

by:
bruintje earned 50 total points
ID: 6974517
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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 a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 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