I am trying to use field codes to connect to my SQL Server database, but field codes resolve to "Error! Cannot open data source."
The field codes string I have is:
DATABASE \c "DSN=mySystemDSN" \s "SELECT * FROM tableName" \l "9" \b "47" \h
And I get the error:
... The cursor was not declared.... Invalid object name 'ableName'.
Trying to connect without a DSN doesn't make sense to me; I don't understand why I need to provide a connection file (I would rather include the connection details in the field code switches instead of having another file somewhere else I need to manage).
What is the field code configuration I need to connect to my SQL Server database?
Thanks for you help.