Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the URL syntax supported by aveConnect Drivers?

April 26, 2017aveconnect Drivers supported syntax URL

0

Posted

What are the URL syntax supported by aveConnect Drivers?

1 Answer

0

Posted

Jdbc:subprotocol:subname jdbc means that the protocol is JDBC, the subprotocol field is the name of the JDBC driver to be used, the subname is a parameter string that is dependent on the subprotocol The aveConnect JDBC driver protocol is shown as follows. jdbc:AvenirDriver://www.atinav.com:1433/master (this is jdbc specific) jdbc:AvenirDriver://www.atinav.com:1433/master;uid=userid;pwd=password jdbc:AvenirDriverNamedPipe://www.atinav.com/pipe/sql/query In this case, the subprotocol is called AvenirDriver or AvenirDriverNamedPipe if NamedPipe protocol is to be used. The database engine is running on www.atinav.com host (subname field), the TCP/IP port that should be used is 1433 and master is the name of the database to be accessed. The port name and the database name are optional. If the port number is not specified the default port is set (i.e. 1433), if the database name is not specified then the default database (master) is taken.