ADO Error

[Hareesh]

Hi,

I am using Access 2003. When I open the project giving all the
connection parameters, I can connect to the MS SQL server, but when I click
on any table, It comes up with "ADO error Line 1: Incorrect syntax near
'Collate' ".

When I use SQL analyzer, I can open the table and see all the records.
Any idea what could be wrong with Access 2003 tool ?.

 

[David Lloyd]

I do not have enough specific information to know if the following KB
articles are relevant to your situation, however, they deal with an error
message similar to what you seeing.

http://support.microsoft.com/default.aspx?scid=kb;en-us;295211
http://support.microsoft.com/default.aspx?scid=kb;en-us;288411

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi,

I am using Access 2003. When I open the project giving all the
connection parameters, I can connect to the MS SQL server, but when I click
on any table, It comes up with "ADO error Line 1: Incorrect syntax near
'Collate' ".

When I use SQL analyzer, I can open the table and see all the records.
Any idea what could be wrong with Access 2003 tool ?.