in reply to ODBC Connect with compression=gzip

First off, you want to add use strict; to your code. I believe the reason why it's not working on Solaris is due to the missing username and password. Although Access doesn't have a username or password, you may have to pass along empty strings for it to work. Try using: 
$dbh = DBI->connect("dbi:Proxy:$proxy;$compression;dsn=$dsn", '', '')

[download]
For the above question, turn on debugging:
dbiproxy --localport 3333 --logfile "STDERR" --compression gzip --debugHopefully this will give you some helpful hints with the errors.

Replies are listed 'Best First'.
Re: Re: ODBC Connect with compression=gzip
by jlongino (Parson) on Jul 12, 2001 at 20:54 UTC
    Re: ODBC Connect with compression=gzip by LD2 First off, you want to add use strict; to your code. I believe the reason why it's not working on Solaris is due to the missing username and password. Although Access doesn't have a username or password, you may have to pass along empty strings for it to work. Try using: $dbh = DBI->connect("dbi:Proxy:$proxy;$compression;dsn=$dsn", '', '') For the above question, turn on debugging: dbiproxy --localport 3333 --logfile "STDERR" --compression gzip --debug Hopefully this will give you some helpful hints with the errors.
    Thanks for the --debug, use strict;, and username/password tips. I can see where they will be invaluable for future use. Actually I had been using the username/password empty strings during the course of my testing and since there was apparently no effect (as you mentioned) I left that out of the original snippet posted. I will include the empty strings from here on.

    Unfortunately, I still get the same basic messages on both sides. Thanks again for your input.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom