Sql-server – [Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error (SQL State: 07001; SQL Code: 0)

oraclesql server

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle
system returned this message:
[Generic Connectivity Using
ODBC][Microsoft][ODBC SQL Server Driver]
COUNT field incorrect or syntax error
(SQL State: 07001; SQL Code: 0) ORA-06512: at line 9

Anyone know this error.. pls help us.

thanks in advance.

Best Answer

Since you do not provide any type of code from where this error is generated I can only guess here. After asking Google and found this, it looks like COUNT field incorrect or syntax error could mean that you use the wrong number of parameters in your call.

If you posted the code where the error is generated from it could help a lot to understand what could go wrong.

Related Solutions

Sql-server – Getting “[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ‘Microsoft.’

The provider argument passed to OPENDATASOURCE is a string so must be quoted. Your also addressing the sheet within the OPENDATASOURCE call, which is incorrect;

     strSQL = "SELECT * INTO SalesOrders " & _
       "FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0'," & _
       "'Data Source=C:\Workbook.xlsx;" & _
       "Extended Properties=Excel 12.0')...[Sales Orders]"

Sql – How to delete using INNER JOIN with SQL Server

You need to specify what table you are deleting from. Here is a version with an alias:

DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
  ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'

Best Answer

Related Solutions

Sql-server – Getting “[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ‘Microsoft.’

Sql – How to delete using INNER JOIN with SQL Server

Related Topic