I know the guru's can give you the specifics of how to fix it. My cheap
and dirty method is to install the Configuration Assistant on the
workstation and let it add the ODBC Data Source. The Configuration
Assistant has ALWAYS worked for me, although it is a pain in the neck to
have to install it on each PC that we want to connect.



Bill Kraft
Database Administrator
Ameritas Life Insurance Corp.

(402) 467-7241



"Buscemi Bob "
<db2udbdba-ezmlms
hield-x17371743.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
09/27/2005 09:26
AM Subject
ODBC connection to DB2 database










I have a server that is running DB2 8.1 on Windows 2000 Server. I'm trying
to create an ODBC connection to the database from another machine running
Windows XP Pro. It should be pretty simple, but for some reason the XP
machine won't recognize the database. When I create the ODBC connection
and
then try the test the connection through the wizard, I get an error
(SQL3008IN SQLSTATE 08001). Also, when I try to test the connection using
Excel, I get an error (SQL1013N SQLSTATE 42705). It says that it doesn't
recognize the alias of the database. I'm not sure, but I don't think it
sees the database machine. I'm not even getting prompted to provide a user
id or password. Any suggestions would be greatly appreciated.

Thanks...Bob



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


****
This message may contain confidential information intended only for the use of the
addressee(s) named above and may contain information that is legally privileged.
If you are not the addressee, or the person responsible for delivering it to the
addressee, you are hereby notified that reading, disseminating, distributing or
copying this message is strictly prohibited. If you have received this message
by mistake, please immediately notify us by replying to the message and delete
the original message immediately thereafter. Thank you.
****

DB2 & UDB email list listserv db2-l LazyDBA home page