CDaodatabase
-
In my program, i m using CDaodatabase for database connectivity. i then use CDaorecordset to entry/modify data in the database. My question is:: I do not use DSN anywhere in my program. Does CDaodatabase handle DSN internally. Wat is the better implementation - using DSN or using CDaoDatabase implementation? and wat is the main diff between the two?
-
In my program, i m using CDaodatabase for database connectivity. i then use CDaorecordset to entry/modify data in the database. My question is:: I do not use DSN anywhere in my program. Does CDaodatabase handle DSN internally. Wat is the better implementation - using DSN or using CDaoDatabase implementation? and wat is the main diff between the two?
CDaoDatabase constructs a CDaoDatabase object. The path to the database will have to be provided and connection can be opened with Open() method.
-
CDaoDatabase constructs a CDaoDatabase object. The path to the database will have to be provided and connection can be opened with Open() method.
-
can u point out the difference between connecting vis CDaodatabase and connecting via DSN?
DSN stands for Data Source Name. Data Source can be a database, spreadsheet, text file etc. We assign DSN to a data source so that irrespective of the data source details and location, we can use that data source; add, modify or delete records, just by knowing it's DSN. From the application use CDatabase class to connect to a data source. Where as in CDaodatabase, full path to the database needs to be provided to connect. If the path of the data source changes, if a DSN exists, then changing path in the settings is all that is needed. Code doesnt have to be changed.