From: "Barry Brevik" <[EMAIL PROTECTED]> > Now that I have got this module to work, and it IS a really cool module, > I have encountered another mystery.
I said this a few times, maybe even to you, but anyway ... don't use the module. It's old and virtually unsuported anymore and even though it served a purpose back in times when the Windows Perl had problems with compatibility to some CPAN modules including DBI, now that DBI is available you should use that. You are more likely to get help and you are more likely to be supported in the future. Apart from its ability to create DSNs there's little use for Win32::ODBC anymore. > When I issue a TableList() call, I get a big array of table names like > "Parts", "Customers" etc. > > However, when I try to access those tables, I get an error that says > "unknown table/field". > > A co-worker who does not program, but uses MS Access with ODBC suggested > that I try prefixing the table names with "PUB.". When I use the prefix, > everything works as expected. I figure that the "PUB." prefix is > probably implementation specific, but I have been unable to find any > function in Win32::ODBC that returns this prefix string. I did work with Access sometime back in '99, but don't remember having to do anything like that. Can we see your code? Jenda ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
