ODBC integration question
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62306
interpreted = N
texte = Hello, We've setup WebDNA from WebCatalog-6.0-1.i386.rpm on a 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". Any assistance is appreciated. :) Thank you! -Pete ------------------------------------------------------------- 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 integration question ( "Peter J. DiCostanzo Jr." 2005)
|
Hello, We've setup WebDNA from WebCatalog-6.0-1.i386.rpm on a 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". Any assistance is appreciated. :) Thank you! -Pete ------------------------------------------------------------- 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/
"Peter J. DiCostanzo Jr."
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:
WebDNA 5 - Privacy Issue (Built in sniffer) (2003)
Sorting by date (1997)
WebCat hosting providers? (1997)
The Top Ten (2002)
Pithy questions on webcommerce & siteedit (1997)
[format xs] freeze (1997)
fieldType=num (1997)
OT: Unknown Webstar Error ruining presentation?! (2001)
Loop code problem (2000)
carriage returns in data (1997)
Question on TABLES (2003)
Limiting user access to .tmpl files (1997)
where to put code (1998)
WC1.6 to WC2 date formatting (1997)
Nesting format tags (1997)
Frames and WebCat (1997)
sorting... (2003)
Fun with dates (1997)
Alternating colors (1997)
Summary search -- speed (1997)