MSSQL driver error

[Karen99]

When I try to setup MSSQL in my bde through Delphi 5, the following text appears at the Type property when I open the alias. 'MSSQL: Unknown Version: Mapping error: Bad template: SQL Server [^0-9]*([0-9]+)\.' What does that mean ?

What is the newest version of MSSQL and where can I get that. I already tried microsoft, but I didn't find it.

 

[whosrdaddy]

if you use ADO, just get latest MDAC (Microsoft Data Access Components) from microsoft.

Don't know why you get the error. are you using BDE or ADO components?

http://www.damovo.com

 

[Karen99]

I am using BDE components

 

[mvdmeij]

I guess it's the following:
On the SQL server itself it's proosible to use characters which the BDE doesn't handle (spaces, dollar signs etc.)

To handle this kind of syntax you need to use brackets [] for the tablename/quer/view

Hope this helps...

Good luck,

Mark.
PAC Greenware

http://www.pac.nl