Re: Error connecting external database from RPG

Hi Orlando,

Sorry, I do not understand. What is \PDN in your URL? What does it
mean? Why is it there?

Please navigate to the following link, it is the documentation for the
JTDS driver that you are using. There is a section in the document
titled "What is the URL format used by jTDS?" that explains the format
of the URL and what may be in it.

http://jtds.sourceforge.net/faq.html

I do not see anything similar to the "\PDN" that you have in your URL.

Also, your post contained passwords. These are now publicly visible on
the Internet. Please consider changing them.

-SK

On 11/14/2020 12:23 PM, orlando misas wrote:

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

--
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