odbc in i5/OS

160 pts.
Tags:
i5/OS
ODBC
ODBC on i5
OS/400
I need to know how i can create an data source name or a odbc connection for a database in i5/OS. Kindly guide me.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Assuming that you are using Windows XP, on Configuraiton Panel select “Admin tool” Icon and then “ODBC Data source”

Then, on the “System data source” tab press the “Add” button.

A new Window would pop up to give you the existing ODBC driver list on your PC.

Assuming that you are using Client Access, Select “Client Access ODBC Driver (32 bit) .

Another Window would pop up.

On the first tab:
– Select your AS/400 in the “System” drop down list.
– Give a name to your DSN in the “Data source name” field
– If you want to specify connection option (User profile, Signon dialog prompting) press the “Connection Option button to specify information.

On the second tab:
– Specify the SQL default library. This library will be your targetted library (for example if you create table in your SQL instruction without specifying a library)
– In the library list field, specify all libraries that you want to access seperated by a space.

On the 3rd tab:
– Specify the package library (This library will eventually contain your SQL package basic objects to communicate between yous AS/400 and your PC) .QGPL (default value) is fair enough.

For all other tab, you chould leave it as it is with default values.

There you go !

Have fun !

__________________
Taz

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Leah Rosin
    575 pointsBadges:
    report
  • Jacky
    Is there any need to install odbc driver in i5/OS machine.
    160 pointsBadges:
    report
  • DanTheMan 2
    Hi Jacky ! Nop ! no need's to install anything on the 400. The only thing you have to do is to make sure QSERVER and QSYSWRK sub-system have to be active. ! _________________ Taz
    395 pointsBadges:
    report
  • TomLiotta
    Is there any need to install odbc driver in i5/OS machine. That depends on what remote database you want to connect to. Most nowadays make Type 4 JDBC drivers available that get around the need for ODBC drivers. (A Type 4 driver is written in Java itself, so it only relies upon a compliant JVM.) But various capabilities still indeed require a "driver", although they generally wouldn't be "ODBC" since that's technically a Microsoft implementation of an Open DRDA subset. Such drivers must be obtained from the vendor of the remote database, and generally they are pretty pricey. For some cases, 3rd-party suppliers may have less costly solutions; e.g., their replacement "driver" lets your RPG think it's talking to a remote database even though the 3rd-party driver is converting the conversation to and from an internal Type 4 JDBC driver or some other redirection. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following