Visual Studio Incorrect Syntax Near The Keyword Default Information

[JMUApache]

Hi,

I have got a error message while I run a sample OLEDB program. It
says "Incorrect Syntax Near The Keyword Default Information".

platform: Windows XP + Visual Studio 2005 Beta 2 + SQL Server 2000

I goole it, somebody says the reason is the database file size up
to its limit, and set the Maximum File Size to Unrestricted File
Growth. But it's not suite my case.

I was not sure why it be, any help would be appriciate!

thanks

//chen

[Octavio Hernandez]

Hi,

I believe there should be a problem with the SQL syntax your application
sends to SQL Server.
This thread might help you:

http://www.eggheadcafe.com/ng/micros...st23463083.asp

Regards - Octavio

"JMUApache" <ma********@163.com> escribió en el mensaje
news:me********************************@4ax.com...

Hi,

I have got a error message while I run a sample OLEDB program. It
says "Incorrect Syntax Near The Keyword Default Information".

platform: Windows XP + Visual Studio 2005 Beta 2 + SQL Server 2000

I goole it, somebody says the reason is the database file size up
to its limit, and set the Maximum File Size to Unrestricted File
Growth. But it's not suite my case.

I was not sure why it be, any help would be appriciate!

thanks

//chen

[JMUApache]

Hi

Thanks for both of your reply. As you say, there are some mistakes
with the sql statement, and I have find it out. The program work now.

Thanks for help.

//bow
On Sun, 04 Sep 2005 10:03:30 +0800, JMUApache <ma********@163.com>
wrote:

Hi,

I have got a error message while I run a sample OLEDB program. It
says "Incorrect Syntax Near The Keyword Default Information".

platform: Windows XP + Visual Studio 2005 Beta 2 + SQL Server 2000

I goole it, somebody says the reason is the database file size up
to its limit, and set the Maximum File Size to Unrestricted File
Growth. But it's not suite my case.

I was not sure why it be, any help would be appriciate!

thanks

//chen