ODBC SQL Server Driver

  • Thread starter Thread starter REDD0721
  • Start date Start date
R

REDD0721

I am a novice at this. I recieved this message and did
not know what it meant. Microsoft (ODBC SQL Server
Driver) (SQL Server) Line 1 : Incorrect syntax near "='. I
don't know what it means. I tired looking in help and
support but, to avail. I just didn't understand it. I
don't know what or where the access is.
 
Hi Redd,

Which program was running when you got this error? "SQL Server" is a
Microsoft database application used for entering, storing, and retrieving
data. "ODBC" (Open Database Connectivity) is a piece of middleware that
allows a program such as one written with Visual Basic to talk to the SQL
Server database. Usually SQL commands are written as a text string such as:

strSQLCommand = "Select * From SomeTable Where SomeValue = 42"

Do you know what the command string is that you're (your program) is using?
It sounds like there's a typing error near the "=" sign in the command
string. A lot will depend on which program was running when you got the
error. If it's a 3rd-party application then you will need to take the issue
up with whoever supports it.
 
Back
Top