ODBC Error: SQL not supported
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62301
interpreted = N
texte = Hello. We've setup WebDNA from WebCatalog-6.0-1.i386.rpm on SuSE Linux server. WebDNA works good except for ODBC. We've setup unixODBC with FreeTDS driver for accessing an MSSQL database. We can successfully execute the SQL queries by both sqsh tool and unixODBC's isql tool: server:/opt/unixodbc # bin/isql -v OURDSN user 'pass' +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> SQL> EXEC sp_tables @table_type= "'TABLE'" | TABLE_QUALIFIER | TABLE_OWNER | TABLE_NAME | TABLE_TYPE | REMARKS .... SQLRowCount returns -1 SQL> WebDNA is configured according to http://webdna.smithmicro.com/ref/UNIXODBCSetup.html - string SQLLibraryPath /opt/unixodbc/lib/libodbc.so^M (here is our unixODBC installation) is added to WebCatalog Prefs file. When executing the same statement with WebDNA: SQL dsn=OURDSN&username=user&password=pass&statement=EXEC sp_tables @table_type= "'TABLE'" - we got "Error: SQL not supported". What can be the trouble? -- Alexander Kulak ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- ODBC Error: SQL not supported ( Alexander Kulak 2005)
|
Hello. We've setup WebDNA from WebCatalog-6.0-1.i386.rpm on SuSE Linux server. WebDNA works good except for ODBC. We've setup unixODBC with FreeTDS driver for accessing an MSSQL database. We can successfully execute the SQL queries by both sqsh tool and unixODBC's isql tool: server:/opt/unixODBC # bin/isql -v OURDSN user 'pass' +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> SQL> EXEC sp_tables @table_type= "'TABLE'" | TABLE_QUALIFIER | TABLE_OWNER | TABLE_NAME | TABLE_TYPE | REMARKS .... SQLRowCount returns -1 SQL> WebDNA is configured according to http://webdna.smithmicro.com/ref/UNIXODBCSetup.html - string SQLLibraryPath /opt/unixODBC/lib/libODBC.so^M (here is our unixODBC installation) is added to WebCatalog Prefs file. When executing the same statement with WebDNA: SQL dsn=OURDSN&username=user&password=pass&statement=EXEC sp_tables @table_type= "'TABLE'" - we got "Error: SQL not supported". What can be the trouble? -- Alexander Kulak ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Alexander Kulak
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Merging databases (1997)
Further tests with the infamous shipCost (1997)
error (2000)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
2.0 Info (1997)
quitting (1997)
[WebDNA] Error: Can't open order file. Ignoring [OrderFile] (2011)
[Fwd: can we get string variables?] (1998)
WebCat2 beta 11 - new prefs ... (1997)
Re:WebMerchant 3.0 for Mac shipping now (1998)
Navigator 4.01 (1997)
syntax question, not in online refernce (1997)
PIXO support (1997)
Is there an alternative to emailer? (1999)
getchars broken? (1997)
Hiding HTML and page breaks (1997)
shipCost -vs- shippingtotal ? (2000)
Process SSI and WebCatalog.acgi (1998)
SiteGuard Admin Feature ? (1997)
Ampersand (1997)