Re: WebDNA+unixODBC+MS SQL

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60927
interpreted = N
texte = looks correct to me. Did you stop and start WebDNA? HUP is not enough as I recall. Also, I always use my standard test on all my servers when setting up unixODBC here is the archive of my howto http://search.smithmicro.com/TalkListArchive/DetailResults.tpl? command=search&db=webdna-talk.db&eqIDdata=49483&max=1 - Jim On Jan 25, 2005, at 6:34 AM, Alexander V. Butenko wrote: > 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/ > ------------------------------------------------------------- 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:

    
looks correct to me. Did you stop and start WebDNA? HUP is not enough as I recall. Also, I always use my standard test on all my servers when setting up unixODBC here is the archive of my howto http://search.smithmicro.com/TalkListArchive/DetailResults.tpl? command=search&db=webdna-talk.db&eqIDdata=49483&max=1 - Jim On Jan 25, 2005, at 6:34 AM, Alexander V. Butenko wrote: > 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/ > ------------------------------------------------------------- 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/ Jim Lanford

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:

RequiredFields template (1997) Access Denied! But why? (1997) HELP! Search finding too much! (1998) More on the email templates (1997) Huge Problem installing Secure Certs (2006) Security Issues and WebCommerce Solution (1997) WebDNA Solutions --> Date format suggestions (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebDNA-Talk Digest mode broken (1997) Re:add line item context and showitems (1998) PCS Frames-Default page is solution! (1997) File Format Validation (2005) Configuring E-mail (1997) Slightly OT - SQL- Clustering (2006) Problems with shopping cart (1997) select multiple (1997) Random Generator (2005) Looping control (1997) Date subtraction (2002) WebDNA deletes major DB data big time (2004)