proudpaki9
asked on
Create ODBC Connection Systematically for AS400
Hi Experts:
I have in the past asked a question as to how to systematically with the module to create an ODBS connection to SQL backend but now
I need the same approach to create odbc for the as400. Current driver installed "Client Access ODBC Driver (32-bit)"
I want to be able to set the odbc connection setting through a module. Some setting are as follows that needs to be change:
1. Data srource name
2. Description
3. AS/400 System (name of the server)
4. Naming convention "SQL naming convention (*SQL)
5. SQL default library
6. Library list
7. Connection type: "read/write (all SQL statement allowed) etc.
Thanks
I have in the past asked a question as to how to systematically with the module to create an ODBS connection to SQL backend but now
I need the same approach to create odbc for the as400. Current driver installed "Client Access ODBC Driver (32-bit)"
I want to be able to set the odbc connection setting through a module. Some setting are as follows that needs to be change:
1. Data srource name
2. Description
3. AS/400 System (name of the server)
4. Naming convention "SQL naming convention (*SQL)
5. SQL default library
6. Library list
7. Connection type: "read/write (all SQL statement allowed) etc.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks