Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: ODBC Connect with compression=gzip

by LD2 (Curate)
on Jul 12, 2001 at 12:59 UTC ( [id://95959]=note: print w/replies, xml ) Need Help??


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", '', '')
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://95959]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (4)
As of 2024-04-19 14:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found