Solved

BDE to personal MS SQL Server 2000

Posted on 2002-04-26
6
439 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
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…

828 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