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 identical to the syntax used elsewhere since you're just sending the SQL syntax as a string to the ODBC driver. Anyway, it does with with ODBC and we have gotten excellent results with it on a win box, and are now just getting with working from an OSX box as well. HTH Alex On 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:

    
  1. Re: SQL db type ( Stuart Tremain 2006)
  2. Re: SQL db type ( "Nitai @ ComputerOil" 2006)
  3. Re: SQL db type ( "Nitai @ ComputerOil" 2006)
  4. Re: SQL db type ( Stuart Tremain 2006)
  5. Re: SQL db type ( "Nitai @ ComputerOil" 2006)
  6. Re: SQL db type ( Stuart Tremain 2006)
  7. Re: SQL db type ( "Bess Ho" 2006)
  8. Re: SQL db type ( Jesse Proudman 2006)
  9. Re: SQL db type ( Alex McCombie 2006)
  10. Re: SQL db type ( Jesse Proudman 2006)
  11. SQL db type ( Stuart Tremain 2006)
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 identical to the syntax used elsewhere since you're just sending the SQL syntax as a string to the ODBC driver. Anyway, it does with with ODBC and we have gotten excellent results with it on a win box, and are now just getting with working from an OSX box as well. HTH Alex On 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)