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:
Max Record length (1997)
[OT] mozilla / Seamonkey (2007)
Auto Submit (2000)
Help! (2000)
no shopping cart (2000)
Protect vs Authenicate (1997)
Open Databases on Restart (1999)
Re:Signal Raised (1997)
creating a ShipCosts database (1997)
HTTP upload (2000)
WebCatalog 4.0.1b2 is now available (2000)
Multiple Replaces? (1997)
# fields limited? (1997)
Where's Cart Created ? (1997)
NetForms for email (1998)
X Server (1999)
Price Change (2000)
[OT] - Credit card processing company fees (2004)
Still having problems with Authen (1997)
Limiting user access to .tmpl files (1997)