| dbDSN | dbmdb | dbDat |
Define datasource connect string. These three properties streamline the parameter definition. dbDSN is a pass through and it a "catch all" property. dbmdb defines ACCESS as the source and should be only used for accessing ACCESS. dbdat defines the MS-SQL data source and should be only used with MS-SQL only.
| Property Syntax |
Obj.dbDSN="Connect
string"
Obj.dbmdb="Physical path of the ACCESS mdb file"
Obj.dbdat="MS-SQL server name, database name, UID, PWD"
| Parameters |
|
Parameters |
Description |
| Connect string | Any Valid connection string. |
| Physical Path of mdb | Location of mdb file |
| server name | SQL server name |
| database name | SQl database name |
| UID | SQL User ID |
| PWD | SQL database password |
| Example |
| X.dbDSN="provider=Microsoft.Jet.OLEDB.3.51; data source=e:\vData\NWIND\NorthWind.mdb" |
| X.dbDSN="provider=Microsoft.Jet.OLEDB.4.0; data source=e:\vData\hotel\hotel.mdb" |
| X.dbDSN="Driver={Microsoft Access Driver (*.mdb)}; Server=dell500; Dbq=e:\vData\hotel\hotel.mdb; UID=sa; PWD=" |
| X.dbDSN="File Name=e:\vData\NWIND.UDL" |
| X.dbDSN="HOTEL_ACCESS" |
| X.dbDSN="Provider=MS Remote; Remote Server=http://208.199.180.115; Remote Provider=Microsoft.Jet.OLEDB.3.51; data source=d:\www\aspdb\nwind\nwind_0216.mdb" |
| X.dbDSN="Driver={Microsoft ODBC for Oracle}; Server=dell500; UID=HOTEL; PWD=hotel" X.dbDBTYpe="ORACLE" |
| X.dbDSN="Provider=MSDAORA; data source=dell500; user id=scott; password=tiger" X.dbDBTYpe="ORACLE" |
| X.dbDSN="provider=SQLOLEDB; data source=dell500; initial catalog=Northwind; user id=sa; password=" X.dbDBTYpe="SQL" |
| X.dbDSN="Driver={SQL Server}; Server=dell500; Database=hotelSQL; UID=sa; PWD=" X.dbDBTYpe="SQL" |
| X.dbDSN="DSN=pubs; UID=sa; PWD=" |
| X.dbMDB="E:\Vdata\CARDB\CAR.MDB" |
| X.dbMDB = Server.MapPath("Lookupbig.mdb") |
| X.dbdat="servername,pubs,sa" |