Db > Db Assembly Interfaces > IOdbcDataset > IOdbcDataset.Catalog
Catalog: String;
The Catalog property determines the directory of ODBC data source.
Executing the example requires the c: \Data.xls file.
Sub UserProc;
Var
MB: IMetabase;
CrInfo: IMetabaseObjectCreateInfo;
ODBC: IOdbcDataset;
MObj: IMetabaseObject;
Begin
MB := MetabaseClass.Active;
CrInfo := MB.CreateCreateInfo;
CrInfo.ClassID := MetabaseObjectClass.KE_CLASS_ODBC_DS;
CrInfo.Id := "NewODBC";
CrInfo.Name := " New ODBC data source";
CrInfo.Parent := MB.Root;
MObj := MB.CreateObject(CrInfo).Edit;
ODBC := MObj As IOdbcDataset;
ODBC.Catalog := "c:\Data.xls";
ODBC.DataSource := "Excel files";
ODBC.DataSourceName := "[Sheet1$]";
MObj.Save;
End Sub UserProc;
After executing the example, a new ODBC data source is created in repository root. The data source accesses the Data.xls Excel file.
See also:
