Solved

BDE to personal MS SQL Server 2000

Posted on 2002-04-26
6
450 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
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 

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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

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 I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month10 days, 7 hours left to enroll

628 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