By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,905 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,905 IT Pros & Developers. It's quick & easy.

DB2 Configuration Assistant and ODBC System DSN

P: n/a
Do I have to use the DB2 Configuration Assistant in order to create an ODBC
System DSN?

I had a windows computer with no IBM DB2 installed. I downloaded the IBM DB2
client i think which after the installation i saw the ODBC Driver added for
IBM DB2.
However i couldn't create a system dsn that worked when i tried to connect
to an IBM
DB2 database.

I ended up installing the DB2 Client Administration (or something called
like that) where
i had the DB2 Configuration Assistant program installed. I used it to create
an ODBC
System DSN which in turn I managed to connect to the database using an ASP
application.

My question is I can not only install the DB2 Client that installs the IBM
DB2 driver and
not resort to the DB2 Configuration Assistant?

Thank you
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"serge" <se****@nospam.ehmail.com> wrote in message
news:Re******************@news20.bellglobal.com...
Do I have to use the DB2 Configuration Assistant in order to create an ODBC System DSN?

I had a windows computer with no IBM DB2 installed. I downloaded the IBM DB2 client i think which after the installation i saw the ODBC Driver added for IBM DB2.
However i couldn't create a system dsn that worked when i tried to connect
to an IBM
DB2 database.

I ended up installing the DB2 Client Administration (or something called
like that) where
i had the DB2 Configuration Assistant program installed. I used it to create an ODBC
System DSN which in turn I managed to connect to the database using an ASP
application.

My question is I can not only install the DB2 Client that installs the IBM
DB2 driver and
not resort to the DB2 Configuration Assistant?

Thank you

Yes you can. You can use the commands from the db2 command line in the
client:

catalog tcpip node ...
catalog remote database ...

See the Command Reference manual.
Nov 12 '05 #2

P: n/a
Ian
Mark A wrote:
"serge" <se****@nospam.ehmail.com> wrote in message
news:Re******************@news20.bellglobal.com...
Do I have to use the DB2 Configuration Assistant in order to create an
ODBC System DSN?


Yes you can. You can use the commands from the db2 command line in the
client:

catalog tcpip node ...
catalog remote database ...


and "catalog system odbc data source <yourdb>"
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.