× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2017

RE: Accesssing External Databases

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/13/2017
04:23:53 PM:
Thanks for your reply Charles
However - a different question as I may know what my problem is
My code is

prop = JDBC_Properties();
JDBC_setProp(prop: 'userName' : 'As400_login');
JDBC_setProp(prop: 'password' : 'alanshoreiscool');
JDBC_setProp(prop: 'databaseName' : 'DirectResponseAdmin');

conn = JDBC_ConnProp('com.microsoft.sqlserver.jdbc.SQLServerDriver'
:'jdbc:sqlserver://WBOHQECDB01:1433'
: prop );
JDBC_freeProp(prop);

Where the server name is WBOHQECDB01

Here is my question
Should this server name be in the Host Table entry, with its ip address

Or - for this process - that's not a requirement


What I found is that this driver doesn't work for us. I don't
know why.

com.microsoft.sqlserver.jdbc.SQLServerDriver

So, we had to use this driver:

net.sourceforge.jtds.jdbc.Driver

Sincerely,

Dave Clark

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.