Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Irvine, CA (originally from Toronto)

    Unanswered: Cannot connect with ODBC using TCP/IP??

    Win 2003 Small business server with IIS being used as a web server.
    Our client app can log in and run queries, but our web app when trying to log in gets the message,
    'SQL server does not exsist or access denied'
    The system DSN's are both sql drivers and the configuration is name pipes. Our recomended specs use TCP/IP, but when I try to change it, it craps out on me. He's opened up his firewall completely to this new box and his old box, a Win2k machine can connect using TCP/IP. This machine is in a work group.
    Any suggestions on what it might be???

  2. #2
    Join Date
    May 2002
    instead of dsn, try dsn-less:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts