Hi All

I'm running Solaris 8 and have a DB2 app developer's kit installed. I'm connecting to a DB2 db also on Solaris. From the command line, I can issue the command:

db2 connect to DB2DSN user netgty

and it actually goes out to the database, prompts for a password, and connects. Cool!

Now that I know that part is working, I get to what I REALLY want to do - connect to that database using ODBC. I've downloaded DBI and DBD::ODBC and am moving along until I get to the "make test" part of DBD::ODBC. I use "DB2DSN" as my "DBI_DSN" variable, and try to do the test, but I see no traffic generated at all towards my DB server. I've been strggling with this for a day or two, and can't but figure that there's something wrong with my environment, but I don't know what. "DB2DSN" works from the command line, but nowhere else.

Anyone have any suggestions???

TIA
Rick

Hi

From the command line issue the command

db2 catalog system odbc data source db2dsn

and it should work.

regards, Gert

Thanks for the tip, Gert. Unfortunately, I get an error:

SQL1297N This command is currently not supported on this platform

Looks like I'm S.O.L. on this one.

Tanks again
Rick

Sorry, I could have expected it.

I'm not familiar with it, but you can connect to DB2 directly from Perl with the DBD :: DB2 interface. Maybe that's an option?

Hope this helps.

regards, Gert