[ic] Create a table definition from your existing database tables.

[Calgary Ecommerce Services]

I've tried to use the script you posted at
http://www.icdevgroup.org/pipermail/interchange-users/2004-June/039592.html

and I'm seeing the following:

[root at localhost Alsew]# ./createMYSQLtabledefn
------------------------------------------------------
 Extractor  -- table structure extract utility

               for Interchange table definition

------------------------------------------------------

Enter Database (mysqql:database): test_Alsew
Enter the database user: root
Enter password (root):
Enter the table to extract: zippers30invis

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
/usr/lib/perl5/site_perl/5.8.5/i686-linux/DBI
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at (eval
1) line 3, <STDIN> line 4.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Metadata, Multiplex, Proxy, Sponge.
 at ./createMYSQLtabledefn line 47

I believe I have the bundle and module installed:

[root at localhost Alsew]# find / -name mysql.pm
/root/.cpan/build/DBD-mysql-2.9004/lib/DBD/mysql.pm
/root/.cpan/build/DBD-mysql-2.9004/lib/Bundle/DBD/mysql.pm
/root/.cpan/build/DBD-mysql-2.9004/blib/lib/DBD/mysql.pm
/root/.cpan/build/DBD-mysql-2.9004/blib/lib/Bundle/DBD/mysql.pm
/root/.cpan/Bundle/DBD/mysql.pm
/usr/local/lib/perl5/site_perl/5.8.5/i686-linux/DBD/mysql.pm
/usr/local/lib/perl5/site_perl/5.8.5/i686-linux/Bundle/DBD/mysql.pm

I am able to access a mysql database elsewhere with Interchange. I created a new
mysql table, separate from products, and wanted to be able to display that table
in its entirety - I haven't figured it out, but thought that this would be a
step toward getting there.
Any suggestions here?



Stanley Major
Calgary Ecommerce Services
http://www.calgary-ecommerce-services.com
Phone: 403-255-4701