WebDNA+unixODBC+MS SQL
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60821
interpreted = N
texte = Hello, I'm using commercial WebDNA 6.0 on solaris box and free unixODBC service for connecting to MSSQL server and freeTDS driver for it. i can connect to mssql and execute querys using isql utility but can't use this ODBC source from webdba tpl scripts. Here is a simple example: == [sql dsn=dsnname&username=user&password=qqqq&statement=select * from table] [founditems] [items] [/founditems] [/sql] === when i run it from browser i get " Error: SQL not supported". here is my configuration: WebCatalog Prefs: SQLLibraryPath /opt/unixODBC/lib/libtdsodbc.so odbc.ini [dnsname] Description = desc Driver = /opt/unixODBC/lib/libtdsodbc.so Trace = Yes TraceFile = /tmp/sql.log Server = serverIP Database = dbname odbcinst.ini [TDS] Description = v0.52 with protocol v4.2 Driver = /opt/unixODBC/lib/libtdsodbc.so What i messed in configuration? Thank you for your time. -- Regards, Alexander ------------------------------------------------------------- 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:
Hello, I'm using commercial WebDNA 6.0 on solaris box and free unixODBC service for connecting to MSSQL server and freeTDS driver for it. i can connect to mssql and execute querys using isql utility but can't use this ODBC source from webdba tpl scripts. Here is a simple example: == [sql dsn=dsnname&username=user&password=qqqq&statement=select * from table] [founditems] [items] [/founditems] [/sql] === when i run it from browser i get " Error: SQL not supported". here is my configuration: WebCatalog Prefs: SQLLibraryPath /opt/unixODBC/lib/libtdsODBC.so ODBC.ini [dnsname] Description = desc Driver = /opt/unixODBC/lib/libtdsODBC.so Trace = Yes TraceFile = /tmp/sql.log Server = serverIP Database = dbname ODBCinst.ini [TDS] Description = v0.52 with protocol v4.2 Driver = /opt/unixODBC/lib/libtdsODBC.so What i messed in configuration? Thank you for your time. -- Regards, Alexander ------------------------------------------------------------- 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 V. Butenko
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:
Protect (1997)
[OT] Graphic Art Services (2004)
[OT] Bad Hard Drive? (2003)
Almost a there but..bye bye NetCloak (1997)
Paths, relative paths, webstar server setup and security (Mac) (1997)
ShowNext (1997)
Setting up WebCatalog with Retail Pro data (1996)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
Faxing orders in place of email (1997)
[WebDNA] Web Hosting (2008)
Extended [ConvertChars] (1997)
Sorry Off Topic! (1998)
getmimeheader host on my local machine (2003)
Multi Actions (1999)
Unknown exception in WebDNA 4.5.0 (2003)
Shhh... (2006)
Setting up the server (1997)
Trouble with formula.db (1997)
Removing [showif] makes a big difference in speed (1997)
Can't use old cart file (was One more try) (1997)