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



Ahhhh
Let me try that

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: Steinmetz, Paul [mailto:PSteinmetz@xxxxxxxxxx]
Sent: Monday, September 23, 2019 2:42 PM
To: Alan Shore <ashore@xxxxxxxx>; 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] RE: ODBC Data Source Administartion

You must type it manually if it does not appear in the drop down.

Paul

-----Original Message-----
From: Alan Shore <ashore@xxxxxxxx>
Sent: Monday, September 23, 2019 2:36 PM
To: Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>; 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ODBC Data Source Administartion

Thanks for your reply Paul
I have already tried this
The system name is a drop down box - and the development system name does NOT appear here Only the production name

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: Steinmetz, Paul [mailto:PSteinmetz@xxxxxxxxxx]
Sent: Monday, September 23, 2019 2:26 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Alan Shore <ashore@xxxxxxxx>
Subject: [EXTERNAL] RE: ODBC Data Source Administartion

Add a 2nd user or system DSN pointing to your R&D LPAR.
If you have EIM configured, use the system name, not IP, and set your data source to use Kerberos.

Control Panel
Administrative Tools
ODBC Data Sources (64-bit)
System DSN
Add
iSeries Access ODBC Driver
Data Source Name - R&D LPAR name
System - LPAR name
Connection Options
Default User ID
Use Kerberos principal
Signon Dialog Prompting
Prompt for SQL Connect if needed
Security
Use Secured Sockets Layer (SSL)
Server
SQL Default Library - Name of your library.
Apply
Ok

Paul

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Alan Shore via MIDRANGE-L
Sent: Monday, September 23, 2019 2:00 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Alan Shore <ashore@xxxxxxxx>
Subject: ODBC Data Source Administartion

Hi everyone
Apologies for being somewhat disjointed in the following information

My new pc is Windows 10
I have just installed the latest iACS and as far as I can see - everything is okay We have 2 systems - development and production When I look into the ODBC Data Source Administrator, File DSN tab, I only see the production system I do not see the development system How can/do I get the development system into the file dsn of the ODBC Data Source Administrator?

I need this so that I can set up my Universal SQL editor session

I hope that this makes sense

As always - all responses gratefully accepted

Alan Shore
E-mail : ASHORE@xxxxxxxx<mailto:ASHORE@xxxxxxxx>
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

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


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.