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:

    
  1. 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:

Stay on Products page (2003) Something wrong with this list? (2006) SiteEdit Pro Update Announcement (1997) Plugin or CGI or both (1997) Reenter store and find cart (2003) Multiple Newcarts (1996) Help with searching dates from mysql dump & searching (2006) Almost a there but..bye bye NetCloak (1997) Re[4]: Problem with new formvariables (2000) Exists? (1997) Download URL & access on the fly ? (1997) multi-paragraph fields (1997) Help name our technology! I found it (1997) photo upload snippet (2006) Table Trouble... (2005) access denied problem (1997) Alternating colors (1997) CVS Files for databases (2000) MS Bug (2003) WC2f3 (1997)