Solved

BDE to personal MS SQL Server 2000

Posted on 2002-04-26
6
436 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi cmd execution 6 60
Adoquery sql  left join does not work 25 89
How to build JSON File in Delphi 6 3 33
Drag & Drop... Data from one grid to another 2 14
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 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