I have a website that was connected to a Microsoft Access database, and I
changed it to connect to a sql database.  On my aspx pages, I am having trou
ble
with the connection.  I can create the connection, and when I click "Test", 
I
get the message "Connection was made successfully."  However, when I click o
n
"Tables", I get "None" listed.  The interesting thing is that if I create a
Dataset in the Advanced window and create my own sql statement, I can test i
t
and it will connect and display the data.  However, when I upload the files 
and
try to view the webpage, no data is displayed.  Also, if I view the remote
files and try to test the same dataset, I get no data.  I have other sites w
ith
aspx pages that connect to databases with no problems.  Any suggestions woul
d
be greatly appreciated.

Thanks,
Christy

Hi Christy,
You may want to check and see what path is being used by DW. Sometimes it
gets changed and
doesn't point to the right place.


"cctbailey" <webforumsuser@macromedia.com> wrote in message
news:dhjoeg$qa0$1@forums.macromedia.com...
> I have a website that was connected to a Microsoft Access database, and I
> changed it to connect to a sql database.  On my aspx pages, I am having
trouble
> with the connection.  I can create the connection, and when I click
"Test", I
> get the message "Connection was made successfully."  However, when I click
on
> "Tables", I get "None" listed.  The interesting thing is that if I create
a
> Dataset in the Advanced window and create my own sql statement, I can test
it
> and it will connect and display the data.  However, when I upload the
files and
> try to view the webpage, no data is displayed.  Also, if I view the remote
> files and try to test the same dataset, I get no data.  I have other sites
with
> aspx pages that connect to databases with no problems.  Any suggestions
would
> be greatly appreciated.
>
>  Thanks,
>  Christy
>