in reply to Win32::ODBC / IIS -- M$ SQL Server 7 on separate machine

This made me think of something. What's your connection string look like? I've had an experience where the default database was not the same one that I was attempting to connect to and I had to specify the database name. In DBI speak that looked like:

DBI->connect('dbi:ODBC:DSN;server=DBNAME', 'user', 'pass', {RaiseError => 1, AutoCommit => 1, LongTruncOk => 1});

ALL HAIL BRAK!!!

Replies are listed 'Best First'.
RE: RE: Win32::ODBC / IIS -- M$ SQL Server 7 on separate machine
by Lexicon (Chaplain) on Oct 26, 2000 at 12:43 UTC
    Here's the connection string: 
    $dbh = new Win32::ODBC("DSN=spinfire_markup;UID=spinfire_markup2;PWD=d
+dc;")
or die "<p>Couldn't open database: " . Win32::ODBC::Error() . " stoppe
+d";

    [download]
    It seems to be a lost cause. I could figure it out if the server were in English and I could tinker with it, but as it is, oh well. I'm gonna look into doing it in ASP now, which means <:sniffsniff> my short tenure in the Perl community may be comming to a close for now.

    Or more likely I'm just going to go find an excuse to keep playing with perl. "Aw mom! I'm about to gain a level! I can't quit now!"

[reply]
[d/l]

In Section Seekers of Perl Wisdom