You can use dsn-less connection strings in lieu of creating a data source. Below is a Visual Basic example for Sybase:
Set ODBCConn = CreateObject("ADODB.Connection")ODBCConn.Provider = "DataDirect Sybase ADO Provider"ODBCConn.ConnectionString = "User ID=someUser;Password=somePassword;Server Name=someServer;Network Protocol=Winsock;Server Port Address=5000"ODBCConn.OpenMsgBox "Connected to Sybase."ODBCConn.Close
C:\>cd C:\Program Files\DataDirect\Providers
C:\Program Files\DataDirect\Providers>regsvr32 ininf09.dll
C:\Program Files\DataDirect\Providers>regsvr32 inor809.dll
C:\Program Files\DataDirect\Providers>regsvr32 inor709.dll
C:\Program Files\DataDirect\Providers>regsvr32 insyb09.dll
C:\Program Files\DataDirect\Providers>regsvr32 inxml09.dll
This is not recommended. For example, if you install Connect ADO 2.7 data providers on a machine on which the Connect ADO 2.5 data providers are already installed, you cannot create new data sources for the Connect ADO 2.5 data providers.
Related Solutions | Troubleshooting | DataDirect | ADO.NET
Connect to your application with enterprise level connectivity
Copyright © 2021 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.