We can’t be everywhere at once we know—shocking! By continuing to browse this site, you agree to this use. To edit a data source, select one from the list in the ODBC administrator window and click Configure. I have to close the ps session. Sybase IQ also includes a cross-platform command-line utility named iqdsn to create data sources. This also means, if the DSN is changed than the application will change as well. You can change this by editing the registry or editing the code to add:
|Date Added:||18 January 2016|
|File Size:||39.44 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Listener port of the ASE. View this document as PDF. Now click the Login tab. The Microsoft Scripting Guys 1 2.
Setting Up an ODBC Data Source Connection to a Sybase Database
By continuing to browse csn site, you agree to this use. This also means, if the DSN is changed than the application will change as well. Before you create a data source, you need to know which connection parameters you want to include in it.
You will have allocation, connection, command, bind, fetch, output, and clean up.
Host where ASE resides. We can’t be everywhere at once we know—shocking!
Tivoli Decision Support for Enterprise Risk Management
You can create User and System Data Sources using the iqdsn command-line utility. You do not have to rebuild the application for this to take effect. I use this link for information on connection strings: This forum is more focused on Windows OS administrative scripting. You can change this by editing the registry or editing the code to add: If your answer is “yes,” you know what to do.
Enter an iqdsn command, specifying the connection parameters you wish to use. Click the box for the appropriate protocol and specify the options beside the box. Resources for IT Professionals.
The command must be entered on one line:. A new screen will pop up to configure the parameters. For example, the following command creates a data source for the Sybase IQ sample database.
Thursday, January 13, 4: On the General tab, enter the following information: If you receive a login error this is because the password was never sent during the connection time. Thursday, October 6, 9: The layout is very similar to CT-Lib firstapp. For example, use DBA and sql. If you cannot access the Data Source, check that you have filled out the various tabs with correct file and pathnames.
Next, click the Connection tab.
I have to close the ps session. Click OK to save your changes.
If the data source is on a remote system, click the Network tab. Type the User ID and Password for your database. Not an IT pro?