Dreamweaver - Remote Database Connect Not Working

Author

Remote Database Connect Not Working

cctbailey

2005-09-30, 6:21 pm

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

webeebaby

2005-09-30, 6:21 pm

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
>