Consider the following:
- SQL Task.
- MySQL Database (Native connection).
- Full rights, Test connection works fine.
This will fail with 77777
select * from schema.table where fieldstr="something" limit 1
This will run and return results no problem.
select * from schema.table where fieldnum=1 limit 1
The only difference is that the failed attempt has a string in the where clause.
I tried single quotes, double quotes, and used different fields to no avail.
I can run the query fine from a mysql client input when searching by string in the WHERE clause.
What am I doing wrong here? 😕
Update:
I switched to ODBC connection and it worked flawlessly.
Edited by moderator
2017-09-01T20:10:05Z
|
Reason: Update