Error connecting to anywhere 12 as client

[former_SQLA_member1694915]

Dear Sir,

I have more than 10 databases running under anywhere 12 on windows server 2012, is there any way to connect to any database as client from a pc on the domain without specify port number.

Regards

[MarkCulp]

To connect to a specific database running on your server use the DatabaseName (DBN) connection parameter. Example: To connect to database "MyDatabaseFoo" running on server "myServer" you would use:

-c "ServerName=myServer;DatabaseName=MyDatabaseFoo"

Refer to the documentation for more information. HTH

[former_SQLA_member1694915]

thank you,but where i put : -c "ServerName=myServer;DatabaseName=MyDatabaseFoo" ??

[Breck_Carter]

That is a connection string parameter for various utility programs like dbisql, as in

"%SQLANY12%\\bin64\\dbisql"^
  -c "ServerName=myServer;DatabaseName=MyDatabaseFoo"

For client applications, put the string wherever the interface requires it; e.g., for PowerBuilder:

SQLCA.DBParm &
= "ConnectString='ServerName=myServer;DatabaseName=MyDatabaseFoo;" &
+ "UID=DBA;PWD=SQL;'"

[chris_keating]

Since this is a client application, you will want the quoted values "ServerName=myServer;DatabaseName=MyDatabaseFoo" in your connection string or map them to the ODBC DSN properties. If using jConnect, please refer to http://dcx.sap.com/index.html#1201/en/dbprogramming/dbname-jconnect-jdbc.html.

[Former Member]

If you have more than one service you can skip the port, and with more than 2 services you have to do port assignment to optimize the response times of the databases, the way to designate the ports is in the tcpip connection inside the service.

-x tcpip(serverport = 2638)

[former_SQLA_member1694915]

Sorry i didn't understand.

[VolkerBarth]

Me, too...

If all your databases run on the same database engine, they will use the same port. It would be different if some of the databases run on another database engine on the same machine - then you would have to use a different port for the second database engine...

That being said, IMHO I don't feel isvahe1's answer will help you further.

[Former Member]

I work when I have more than one database and more than 1gb in size, so each service has its own resources and not shared and before windows has a direct address by the designated port.