Altova XMLSpy 2024 Enterprise Edition

Property: ADOConnection as String



The property ADOConnection contains a connection string. Either use this property or ODBCConnection or File to refer to a database.



No error codes are returned.




 Dim objSpyConn As DatabaseConnection

 Set objSpyConn = objSpy.GetDatabaseSettings


 Dim objADO As DataLinks

 Set objADO = CreateObject("DataLinks")


 If Not (objADO Is Nothing) Then

         Dim objConn As Connection

         Set objConn = objADO.PromptNew

         objSpyConn.ADOConnection = objConn.ConnectionString

 End If

© 2018-2024 Altova GmbH