Professional Web Applications Themes

Data Query - Error Retrieving Tables - Dreamweaver AppDev

I am running win xp pro, access 2002, iss, and dreamweaver mx 2004. I am creating aspx pages to retrieve data from a database. However, when I try to make the data query, I can connect to the database sucessfully but no tables are found. I tried again and once it let me choose the table I wanted but it did not find any columns. I am not sure why this is. I thought perhaps it was because there was no data entered into the database yet and added some data to the table i was trying to retrieve. However, ...

  1. #1

    Default Data Query - Error Retrieving Tables

    I am running win xp pro, access 2002, iss, and dreamweaver mx 2004. I am
    creating aspx pages to retrieve data from a database. However, when I try to
    make the data query, I can connect to the database sucessfully but no tables
    are found. I tried again and once it let me choose the table I wanted but it
    did not find any columns. I am not sure why this is. I thought perhaps it was
    because there was no data entered into the database yet and added some data to
    the table i was trying to retrieve. However, this chaged nothing. I still get
    the same error. Help! Thanks Darren

    Hung Kuen Kung Fu Guest

  2. #2

    Default Re: Data Query - Error Retrieving Tables

    Darren

    Have a look at this technote and see if it helps

    [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515[/url]

    --
    Regards

    Paul Whitham
    Macromedia Certified Professional for Dreamweaver MX2004
    Valleybiz Internet Design
    [url]www.valleybiz.net[/url]

    Team Macromedia Volunteer for Ultradev/Dreamweaver MX
    [url]www.macromedia.com/support/forums/team_macromedia[/url]

    "Hung Kuen Kung Fu" <webforumsusermacromedia.com> wrote in message
    news:d1s9pf$4im$1forums.macromedia.com...
    > I am running win xp pro, access 2002, iss, and dreamweaver mx 2004. I am
    > creating aspx pages to retrieve data from a database. However, when I try
    to
    > make the data query, I can connect to the database sucessfully but no
    tables
    > are found. I tried again and once it let me choose the table I wanted but
    it
    > did not find any columns. I am not sure why this is. I thought perhaps
    it was
    > because there was no data entered into the database yet and added some
    data to
    > the table i was trying to retrieve. However, this chaged nothing. I
    still get
    > the same error. Help! Thanks Darren
    >

    Paul Whitham TMM Guest

  3. #3

    Default Re: Data Query - Error Retrieving Tables

    Man, I just danced a jig. I have been trying to get a secure databse site
    going for months for our school Guidance councilors to keep track of student
    records. I think your technote did the trick. Thanks so much. You just made
    my year! Darren

    Hung Kuen Kung Fu Guest

Similar Threads

  1. cfc not retrieving data in flex
    By KetanS in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: May 15th, 05:35 AM
  2. Retrieving Updated Data
    By Roshawn in forum ASP.NET Web Services
    Replies: 2
    Last Post: July 28th, 04:15 AM
  3. PHP problem retrieving data
    By Wm in forum PHP Development
    Replies: 5
    Last Post: August 11th, 01:18 PM
  4. Forms and retrieving data
    By rozdias webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 23rd, 12:56 AM
  5. Problem Retrieving data from an SQL Query in ASP
    By SriSamp in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 2nd, 12:10 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