Professional Web Applications Themes

Error when trying to connect a SQL DB in CF MX7 - Coldfusion Database Access

Doesn't work for me, dont have ODBC installed so I have to connect direct! My DSN's were working fine until I installed SP2! Tried turning off Windows Firewall with no luck....

  1. #1

    Default Re: Error when trying to connect a SQL DB in CF MX7

    Doesn't work for me, dont have ODBC installed so I have to connect direct!

    My DSN's were working fine until I installed SP2! Tried turning off Windows Firewall with no luck.
    tee4 Guest

  2. #2

    Default Re: Error when trying to connect a SQL DB in CF MX7

    I need the SQL Server setup. My connections to dbs on other servers work fine,
    I just can't connect to those on my development machine except as ODBC Sockets
    and the application I am working with doesn't like it. What is different about
    my local setup - and I have colleagues in the same boat. Someone suggested it
    might be related to how SQL Server was set up on them.

    jschlosser Guest

  3. #3

    Default Re: Error when trying to connect a SQL DB in CF MX7

    I've spend two days to find a solution to this 'Error establishing socket.
    Connection refused: connect' error... This is seems to occur only when on
    Windows with SP 2. The solution to your problem is simple: After installing
    SQL Server and Coldfusion INSTALL SQL Server 2000 Service Pack 4 and your done!
    To save you some time searching:
    [url]http://www.microsoft.com/sql/evaluation/betanominations.asp[/url]
    [url]http://support.microsoft.com/kb/290211/EN-US/[/url] After that No ODBC Socket driver
    or any port 'opening' is required! I have not test it with SP 3, only with SP 4
    beta... perhaps it'll also works... (my congratulations to Microsoft and
    please send me a tone of aspirins...) CYA! Dimitris

    dimsis Guest

  4. #4

    Default Re: Error when trying to connect a SQL DB in CF MX7

    I am also having the same problem. I am running CF MX 6.1 with SQL Server 2000
    and Windows Server 2003 Enterprise addition in a clustered environment. I was
    able to setup DSN's using the Cold Fusion Admin page and the SQL Server driver
    included with CF. Then my servers were moved to a new data center in another
    state and the DSN's do not work anymore. I can create an ODBC DSN and point to
    it from CF but I don't want to do this because about 50 dsn' that I have to
    setup and deploy to multiple clusters and I wanted to use the deployment option
    in CF admin. Any ideas why this would stop working when the servers were moved
    to another network? I am having my IS people check to make sure that port #
    1433 is not blocked. thanks Mike

    bernsmi Guest

Similar Threads

  1. Cannot connect - unknown error
    By darthbagger in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: November 21st, 08:46 AM
  2. Error on connect to FMS
    By ynykon in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: May 15th, 12:58 PM
  3. MySql connect error
    By pogothedog1000 in forum Coldfusion Database Access
    Replies: 0
    Last Post: June 24th, 01:20 AM
  4. Error Trying to connect
    By James Jones in forum ASP Database
    Replies: 16
    Last Post: January 23rd, 10:32 AM
  5. Replies: 2
    Last Post: September 9th, 06:19 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139