It could be a few things. From the error messages it looks like it can't find the SQL server matt. I'm gonna assume that the server does exist. Check that the SQL server allows Named Pipe connections. I've worked in places that only allowed tcp connections to sql servers for security reasons.

I'm not sure how to change the connection method using DBI, i've always just setup an ODBC connection, and setup the connection properties through the windows interface.

Depending on how complicated the setup is, it could be a networking issue. I've ran into this problem before at work, and the SQL servers only allowed access from certain systems, one of which wasn't mine.

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.