Tornado API Library - V12.30.08

z.dbType Property

Specify the Datasource type for DSN and SQL related setup. Mandatory for MS-SQL data source.

Product Version

All
[VisualBasic]
PublicPropertydbTypeAsString
[C#]
publicstringdbType{set;}

Property Value

Obj.dbType = "ACCESS(Def)| SQL| MYSQL| ORACLE| EXCEL| TXT| CUSTOM"

KeywordDescription
ACCESS#[MM/DD/YYYY HH:MM:SS]#
SQL'[MM/DD/YY HH:MM:SS]'
MYSQL'[YYYY-MM-DD HH:MM:SS]'
ORACLE'TO_DATE('[DD-MMM-YYYY HH:MM:SS]','DD-MON-YYYY HH24:MI:SS')'
EXCEL, TEXT, TXT, CSVMM/DD/YY
CUSTOMType=CUSTOM| LeftDateWrap| RightDateWrap| LeftOdd| RightOdd

Left/RightDateWrap=Custom date wrapper; Left/RightOdd=Customer Odd field name wrapper.

QuickProp Keyword Abbreviation

dt

Example

 X.dbType="SQL"
 X.dbDSN = "Server;Database;Uid;Pwd
 
Y.dbType="ACCESS"
Y.dbDSN="NWIND"

See Also

z Class | Tornado Namespace | dbLongDate | dbProvider | dbSQLDateFormat | dbEditDateFormat | Special Topic - Data Type