ADO and MSSQL...

[Anonymous]

Hi, I have two database files, an access database(jet) and a mssql database(mssqloledb). I'm tryng to execute the query "DELETE * FROM table1", so I've created a _CommandPtr variable. When I execute the command with the access database it works fine, but when I execute the command with the mssql it throws an exception 'DB_E_ERRORSINCOMMAND'. It's a sintax error in the sql. Is there any difference in the sintax of the sql statement between this two providers ? ps: I can't use "SELECT * FROM table1" with the mssql provider either. thanks.

[Roger Wright]

There are differences in syntax, but in this case it may be that your connection is trying to use the Access (Jet) provider instead of the MSSQL provider.

"Welcome to Arizona!
Drive Nice - We're Armed..."
- Proposed Sign at CA/AZ Border

[Hesham Amin]

try to use fully qualified names : databasename.dbowner.tablename

[Kyle Chen]

Maybe you should use "DELETE FROM table1" for MSSQL. Just have a try.;) Kyle Chen