Error SqlServer

General discussion forum about all databases other than SqlBase.
grant

Error SqlServer

Post by grant » 01 Mar 2012, 03:40

Hello,

I have a big problem.
I has TD6 and I have a successful connection with SQLServer. see picture

The problem is:
When I do a sql query like for example "select * from users;" I get the message:

"Error: Microsoft SQL Server: 208 [MICROSOFT] [ODBC SQL Server Driver] [SQL Server] 'users'"

Error: 05041 TLK NCF No command found to process

Thank you for your help

Grant
You do not have the required permissions to view the files attached to this post.

grant

Re: Error SqlServer

Post by grant » 01 Mar 2012, 21:06

nobody has an idea? or track?

Jeff Luther

Re: Error SqlServer

Post by Jeff Luther » 02 Mar 2012, 01:53

First thing I see is the ':' comment char. before the comdll-sqlws32 entry.

First, it's the semi-colon that's the comment char, but more importantly that sqlws32 must be UNcommented as well. And kept in the order you have it:
ODBC
sqlws32

Otherwise, is that "DSN=LocalServer" mean you have a local MS SS? What's the ODBC driver you have for the client called 'urbanism' ?

"select * from users;" -- you have a DB table called 'users' ? How about trying a table you know is in your DB?

User avatar
markus.essmayr
Austria
Posts: 892
Joined: 06 Mar 2017, 06:07
Location: Austria

Re: Error SqlServer

Post by markus.essmayr » 02 Mar 2012, 07:31

Hello,

do you have the semicolon included in your SQL query?
SQLs executed in TD do not need that.
It's just an end-delimiter for SQLTalk.

Max
Markus Eßmayr
teamdeveloper@t-mx.com

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests