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
midrange.com
