Quote character change in ODBC

ml · Post by ml » Fri Jun 03, 2005 9:34 am

After we migrate an ODBC conection from sequelink to wireprotocol, the quote character in the sql statement change from "" to 000.
Is the same database (sql server), so i asume that this configuration is at driver level (?). Anybody know how to modify the default quote value in the datadirect wireprotocol driver? (without edit job by job

)

Thanks in advance!!

Matias

ray.wurlod · Post by **ray.wurlod** » Fri Jun 03, 2005 5:28 pm

Only by hacking the export file (remember to export default-valued properties) or hacking the repository directly.

ml · Post by ml » Tue Jun 07, 2005 9:02 am

Hi, thanks for your aswer.

That is what I found: In the .odbc.ini file, the SqlServer driver options contains a property called "QuotedID". I changed the default 'NO' to "" and this solve my problem.