SQLServer connection problem

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default SQLServer connection problem

    I am having a problem with CFMX6.1 on my laptop where SQLSERVER2K desktop is
    installed. I can get the administrator to verify the datasource, but a cfquery
    returns "[Macromedia][SQLServer JDBC Driver]No more data available to read." I
    updated my drivers, and even referenced the SQL error online. It references an
    issue with the connection being dropped. I walked through the account settings
    for the SQLSERVER account and everything seems fine. In addition, I can connect
    fine to another SQLSERVER2K datasource on a remote server using the same laptop
    Cold FUsion server. Please help!

    cfstubborn Guest

  2. Similar Questions and Discussions

    1. #39319 [NEW]: Problem to connect to SQLSERVER 2005
      From: luiscervantesjane at hotmail dot com Operating system: WINDOWS 2003 PHP version: 5.1.6 PHP Bug Type: MSSQL related Bug...
    2. [Macromedia][SQLServer JDBC Driver][SQLServer]Internal
      I'm running an export process which takes data and dumps it to a text file. The query used to build it can contain large amounts of information in...
    3. Datasource Problems - Can't Set Up Connection to SQLServer
      Greetings: windows xp home edition coldfusion mx 7 - development version sql server 2000 - development version I am trying to establish a...
    4. Problem with SQLServer connections
      I have an application that does a ridiculous number of queries -- its purpose is to extract records from one database and insert them into a...
    5. "Contribute cannot verify your connection information"- Every other problem ruled out, but still no connection
      Hi, first, please allow me to give you the background info Client OS - Windows 2000/XP Pro Version - Contribute 2.01 - I installed the patch from...
  3. #2

    Default Re: SQLServer connection problem

    OK, this was fixed by editing the login accounts database priveledges.
    Ironically, I had all of the databases checked, so it could only access the
    'Master', and by unchecking all others but the one I needed, I was allowed.
    This is an example where there actually can be 'too much permission,' I guess.

    cfstubborn Guest

Posting Permissions

  • You may not post new threads
  • You may 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