Professional Web Applications Themes

Connecting to MSDE - Coldfusion Database Access

I have just upgrade to CF MX 7 on my development laptop where I have MSDE installed. When I am in Cold Fusion Administrator it cannot verify the connections for any of my datasources to my MSDE databases. I found in the doentation that Trusted connections are no longer used but when I change the server from (local) to 127.0.0.1 it did not connect I have also tried localhost to no avail. I checked the port number of 1433 and that is correct. Any help would be appreciated....

  1. #1

    Default Connecting to MSDE

    I have just upgrade to CF MX 7 on my development laptop where I have MSDE
    installed. When I am in Cold Fusion Administrator it cannot verify the
    connections for any of my datasources to my MSDE databases. I found in the
    doentation that Trusted connections are no longer used but when I change the
    server from (local) to 127.0.0.1 it did not connect I have also tried localhost
    to no avail. I checked the port number of 1433 and that is correct.

    Any help would be appreciated.

    RenWeb Bob Guest

  2. #2

    Default Re: Connecting to MSDE

    RenWeb Bob wrote:
    > I have just upgrade to CF MX 7 on my development laptop where I have MSDE
    > installed. When I am in Cold Fusion Administrator it cannot verify the
    > connections for any of my datasources to my MSDE databases. I found in the
    > doentation that Trusted connections are no longer used but when I change the
    > server from (local) to 127.0.0.1 it did not connect I have also tried localhost
    > to no avail. I checked the port number of 1433 and that is correct.
    if i recall correctly, msde default installs using windows
    authentication. you need to reset it to use both (windows & sql)as
    that's what cf's JDBC driver uses. sorry i don't know the details
    concerning hwo to make this switch.
    PaulH *TMM* Guest

Similar Threads

  1. Connecting ColdFusion to SQL Server 2000 (MSDE)
    By David Brim in forum Coldfusion Database Access
    Replies: 3
    Last Post: November 24th, 02:27 PM
  2. Dreamweaver MX and MSDE
    By mystical_shwanky in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 15th, 02:13 PM
  3. Use MSDE in application
    By Grey in forum ASP Database
    Replies: 4
    Last Post: December 24th, 12:22 AM
  4. MSDE and SQL Server
    By Mark A. Sam in forum Microsoft Access
    Replies: 7
    Last Post: August 4th, 02:01 PM
  5. MSDE/SP3 MemoryLeakage
    By Mike John in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 03:23 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