Re: Error connecting external database from RPG

Good afternoon Scott

This is the configuration that I use to access a microsoft sql server
database.

when it is a test environment the configuration is

prop = JDBC_Properties();
JDBC_setProp(prop: 'user' : 'GEpicor');
JDBC_setProp(prop: 'password' : '1wer@25a);
JDBC_setProp(prop: 'databaseName' : 'dbEpiTests');
conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'
:'jdbc:jtds:sqlserver://SRVWINDLLO:1433'
: prop );
where the server is SRVWINDLLO. the process works correctly. OK

when it is a production environment the configuration is

prop = JDBC_Properties();
JDBC_setProp(prop: 'user' : 'GEpicor');
JDBC_setProp(prop: 'password' : 'xuu1$45@');
JDBC_setProp(prop: 'databaseName' : 'dbEpiProduction');
conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'
:'jdbc:jtds:sqlserver://SQLSRVPRO\PDN:1433'
: prop );

In production the server is SQLSRVPRO\PDN. Here the process interprets the
last part of the server path as the database and marks the error PDN
database does not exist.

I appreciate any guidance you can give me

Orlando Misas
omisas@xxxxxxxxx







El vie., 13 nov. 2020 a las 19:17, Scott Klement (<rpg400-l@xxxxxxxxxxxxxxxx>)
escribió:

Hi Orlando,

What is a PDN? (Not a public data network?) Why would it be in your
connection string? Can you give us an example?

-SK

On 11/13/2020 5:47 PM, orlando misas wrote:

Good evening:
I am using jdbcr4 to connect to microsoft sql server database through

Scott

Klement's software. The connection string has the following
characteristics: servername \ PDN, where PDN is part of the connection
string. When I try to connect, the system interprets PDN as the database
and returns the error: PDN database does not exist. Anyone have any idea
how to solve this problem. Thank you

Orlando Misas
omisas@xxxxxxxxx

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com