Today I ran into a very strange problem with one of my web app’s. After migrating it to a new server, a ODBC link stopped working. The only differences between the two servers were the OS: XP on one and 2003 R2 on the other. <\/p>\n
The error’s weren’t telling me much:<\/p>\n
ERROR [HYC00] [MERANT][ODBC SQLBase driver]Optional feature not implemented. After trying a lot of different things, the solution was quite simple. Because IIS uses app pools under 2003, the application was running under the “Network Service” account. This account didn’t have enough rights to read the ODBC files\u00a0(sql.ini and some dll’s). You can solve this by granting the account rights to the files needed (depends on your database manufacturer which you need) or using a\u00a0dedicated\u00a0application account to run your application (which I prefer) which has read-only rights to your filesystem (or at least the folders where your config \/ dll files reside). Today I ran into a very strange problem with one of my web app’s. After migrating it to a new server, a ODBC link stopped working. The only differences between the two servers were the OS: XP on one and 2003 R2 on the other.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[34],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3KFR1-K","_links":{"self":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/46"}],"collection":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":0,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/46\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/media?parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/categories?post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/tags?post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nERROR [HY000] [MERANT][ODBC SQLBase driver][SQLBase]00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 09293
\nERROR [IM006] [MERANT][ODBC SQLBase driver]Driver’s SQLSetConnectAttr failed.
\nERROR [HYC00] [MERANT][ODBC SQLBase driver]Optional feature not implemented.
\nERROR [HY000] [MERANT][ODBC SQLBase driver][SQLBase]00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 09293
\nERROR [IM006] [MERANT][ODBC SQLBase driver]Driver’s SQLSetConnectAttr failed.<\/span><\/em><\/span><\/span><\/p>\n
\nBe carefull granting rights to a web application which is available through the Internet! Less is more!<\/p>\n","protected":false},"excerpt":{"rendered":"