I try to connect to MS SQL Server 2012 with BDE (TTable) in old application :
{code}
tvTable := TTable.Create(NIL);
tvTable.DatabaseName := 'xxx';
tvTable.TableName := 'yyy';
tvTable.Open;
{code}
When tvTable.Open is execute (and prompt with login and password is correctly filled) I'm getting error :
"General SQL Error. Incorrect syntax near '*='.
When I'm connecting to the older version of MS SQL there is no problem
Any ideas what could be wrong ?
> {quote:title=IRON IRON wrote:}{quote}
> I try to connect to MS SQL Server 2012 with BDE (TTable) in old application :
> {code}
> tvTable := TTable.Create(NIL);
> tvTable.DatabaseName := 'xxx';
> tvTable.TableName := 'yyy';
> tvTable.Open;
> {code}
>
> When tvTable.Open is execute (and prompt with login and password is correctly filled) I'm getting error :
>
> "General SQL Error. Incorrect syntax near '*='.
> When I'm connecting to the older version of MS SQL there is no problem
>
> Any ideas what could be wrong ?
There is now a syntax issue with "*=" This was valid T-SQL 80 syntax but SS 2012 no longer supports T-SQL 80 - just 90 (SS 2005), 100 (SS 2008) and 110 (SS 2012). Replace "*=" with "OUTER JOIN" and you are good to go again.
For this and other syntax issues upgrading from 80 to 90 to work with SS 2012 you can refer to http://msdn.microsoft.com/en-us/library/bb510680.aspx for a checklist of things to look at.
I'm going through this exact exercise right now and was also tripped up on *=.
Good luck with this!