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"