Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re^2: windows sybase error messages

by martymart (Deacon)
on Aug 26, 2004 at 15:28 UTC ( [id://386051]=note: print w/replies, xml ) Need Help??


in reply to Re: windows sybase error messages
in thread windows sybase error messages

Thanks for the quick response,
I did in fact install the Open Client and ODBC drivers for Sybase 12.0. Is this what you mean?
Plus I was able to connect to this database from the same windows machine using some db client software. As for an interfaces file, I don't really know about that, although I did have to make an entry into the file: C:\sybase\ini\sql.ini to get the client software to work. So yes, I can logon to the database.

Replies are listed 'Best First'.
Re^3: windows sybase error messages
by VSarkiss (Monsignor) on Aug 26, 2004 at 15:40 UTC

    Yes, I did mean the Open Client (you don't need ODBC for DBD::Sybase) and sql.ini. It's just that sql.ini is called interfaces on Unix-like systems.

    If you can connect with any SQL client on that box, then your parameter to DBI->connect is probably incorrect. If you have the server name registered, try not including the host and port, just use the name:

    my $dbh = DBI->connect('dbi:Sybase:server=the_server', $user, $passwor +d); $dbh->do("use Reportingdb"); # guessing from your error message
    And see if that does the trick.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2024-04-16 08:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found