Re: SQL db type
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67288
interpreted = N
texte = In order to use MSSQL you need to be connected via and ODBC connection.We have been doing this for quite a while with DNA 6.Honestly, I almost prefer it since the sql string being sent are identicalto the syntax used elsewhere since you're just sending the SQL syntax as astring to the ODBC driver.Anyway, it does with with ODBC and we have gotten excellent results with iton a win box, and are now just getting with working from an OSX box as well.HTHAlexOn 5/25/06 8:14 PM, "Jesse Proudman"
wrote:> On May 25, 2006, at 5:12 PM, Stuart Tremain wrote:> >> Reading the docs on SQL connect it says:>> >> dbtype (Optional) - Can be one of three reserved values - MYSQL,>> MSSQL, or ORACLE - depending on the type of RDBMS you wish to>> connect to. If 'dbType' is not given, WebDNA defaults to MYSQL. For>> WebDNA 6.0, MYSQL is the only type supported.>> >> >> Does this mean that v 6 will not connect to MSSQL or ORACLE at all?>> What version does ?> > No current version does.> > --> > Jesse Proudman> Blue Box Group, LLC> > p. +1.800.613.4305 x801> e. jesse@blueboxgrp.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/-- Alex J McCombie ~ Alex@Adventureskies.com p:315~233~9403 Adventure Skies Interactive (ASI) "You can find it all under Adventure Skies"-------------------------------------------------------------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:
In order to use MSSQL you need to be connected via and ODBC connection.We have been doing this for quite a while with DNA 6.Honestly, I almost prefer it since the sql string being sent are identicalto the syntax used elsewhere since you're just sending the SQL syntax as astring to the ODBC driver.Anyway, it does with with ODBC and we have gotten excellent results with iton a win box, and are now just getting with working from an OSX box as well.HTHAlexOn 5/25/06 8:14 PM, "Jesse Proudman" wrote:> On May 25, 2006, at 5:12 PM, Stuart Tremain wrote:> >> Reading the docs on SQL connect it says:>> >> dbtype (Optional) - Can be one of three reserved values - MYSQL,>> MSSQL, or ORACLE - depending on the type of RDBMS you wish to>> connect to. If 'dbType' is not given, WebDNA defaults to MYSQL. For>> WebDNA 6.0, MYSQL is the only type supported.>> >> >> Does this mean that v 6 will not connect to MSSQL or ORACLE at all?>> What version does ?> > No current version does.> > --> > Jesse Proudman> Blue Box Group, LLC> > p. +1.800.613.4305 x801> e. jesse@blueboxgrp.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/-- Alex J McCombie ~ Alex@Adventureskies.com p:315~233~9403 Adventure Skies Interactive (ASI) "You can find it all under Adventure Skies"-------------------------------------------------------------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/
Alex McCombie
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] Cookie behavior (2010)
small hairball -- stuck on [showif] for related db (1998)
insecuretextvars preference doesn't work (2000)
Credit card arrangement (2005)
autocommit problem (1998)
New Mac Public Beta Available (1997)
Stinkin' [Referrer] (1998)
General WebCatalog Questions (1997)
WebCatalog for Mac 2.0.1 Released (1997)
Job Posting (1998)
(1997)
Secure Server (1997)
OT - Javascript anyone? (2004)
please unsubscribe me! (2000)
Roundup (2001)
Help name our technology! I found it (1997)
SiteGuard Use Question (1997)
2.0 Beta (1997)
[WebDNA] Dynamic server feedback? (2009)
[OT] Mail Error code 573?? (2006)