In the main DbVisualizer window, click Connect on the Connection tab for the newly created connection. Note: After you successfully create a database connection for Sybase you should set the "Database Type" property to "Generic". Database Password: Enter the password for authentication to Sybase, if needed.Database UserId: Enter the username for authentication to Sybase, if needed.The syntax of the JDBC URL is jdbc:cdata:sybase: followed by the connection properties in a semicolon-separated list of name-value pairs.Ī typical connection string is below: jdbc:cdata:sybase:user=myuser password=mypassword Server=localhost Database=Northwind Database URL: Enter the full JDBC URL.See Establishing a Connection for a guide. In the following fields, enter the JDBC URL and provide authentication. Select the driver definition you created.In the main DbVisualizer window, select Tools > Connection Wizard. In the Driver Class menu, select the SybaseDriver class, .Ĭomplete the following steps to select the Sybase driver and build the JDBC URL to create the JDBC data source:.lic file in this folder must be located in the same folder as the. By default, this is located in the lib subfolder of the installation directory. In the Driver JAR Files section, click the folder icon and browse to the driver.Enter the following in the URL Format box: jdbc:cdata:sybase:.In DbVisualizer, select Tools > Driver Manager and then select Driver > Create Driver.This section shows how to establish a connection to data in DbVisualizer, use the table editor to edit and save data, and execute SQL.Ĭomplete the following steps to add the driver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |