Use the driver name exactly as it appears in the list (including any suffix, like "(*.mdb)" that may appear in the name.)Īs I said, the above worked for ASA, but there may be other parameters that you will need to add to the connectstring for MS Access. Look in the list for one that says something like "MS Access Driver" or "Microsoft Access Driver". To find the proper driver name, open the ODBC Administrator and select the Drivers tab. To connect to an MS Access database, you will need to change the Driver name to the MS Access ODBC driver name on your PC. SQLCA.DBParm = "ConnectString='" + ls_connectstring + "'"
Ls_connectstring = "Driver=Adaptive Server Anywhere 7.0 " + & Cache Usage, Temp.I have not tried to make a DSN-less connection to an MS Access database, but following is a sample of some code I use to make a DSN-less connection to an ASA database. Message: The required data collectors Framework, Error Log, Deadlocks and Lock-Timeouts, Proc. DB Activity, File Systems, Data Cache Usage, Tables, Indexes, Statement Cache Usage, Statement Cache, System Waits, System Load, Threads, ASE Instance, Spinlocks, Devices, ASE Resources, I/O Controllers, Memory Usage, Transaction Log Usage, HA/DR Paths, HA/DR Resources, HA/DR Replication Agents, HA/DR Error Log, Data Cache Objects, Resource Limits, Configuration Check, Database Dump, Transaction Dump, Reorganisation, Update Statistics are not properly set upĮxception CX_DBA_DBH_SETUP in program SAPMHTTP line 0 The required data collectors Framework, Error Log, Deadlocks and Lock-Timeouts, Proc. SQL Message: There is already an index on table 'DBH_CONFIG' named '"DBH_CONFIG~0"' SQL statement: CREATE UNIQUE NONCLUSTERED INDEX "DBH_CONFIG~0" ON saptools.DBH_CONFIG( "KEY" ) WITH FILLFACTOR = 90, STATISTICS HASHINGĮxception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY
Message: Unable to create index 'DBH_CONFIG~0'!Įxception CX_DBA_ADBC in program SAPMHTTP line 0 Message: Error in RDI setup back-end occuredĮxception CX_DBA_RDI_SETUP in class CL_SYB_RDI_DBO_INDEX method IF_DBA_RDI_DBO~CREATE line 70 You follow the Solution in SAP Note 1593987, set up the database connection and add it through System Configuration in DBA Cockpit.Īfter that click ' Database ' -> Configuration -> DBA Cockpit Framework -> Data Collectors and Admin Procedures,īut find the Setup column of Data Collector is Red LED, so you click Impletement Template or Repair All to fix it, but error 1913 is raised:Įxception CX_DBA_DBH_SETUP in class CL_SYB_DBH_SETUP method INSTALL_INTERNAL line 38 You want to monitor and administer SAP ASE databases remotely using DBA Cockpit, the databases are not running any SAP applications.
0 kommentar(er)
