Can't connect database in DreamweaverMX

[nhanle]

I use SQL Connection. I input the correct connection string as:

"Persist Security Info=False;
Data Source=NHANLE;
Initial Catalog=congvan;
User ID=sa;
Password="

When I click on Test button the dialog box display : Connection was made
successfully.
but I can see all the table in that database which I connected to.
There are no table in the database. (none)
Help me, please!
Thank you!

[Forzato]

I have the same symptom... using MS Access, OLE DB, different connection
string, tried the DB Cooper technique of local ODBC DSN system setting... did
not work. Dreamweaver MX 2004 connects to database, but shows "no tables
found" when adding a dataset query binding. Testing server is not local, but
on actual remote server.
Thanks for any ideas.

[Kalimbra]

Forzato wrote:

> I have the same symptom... using MS Access, OLE DB, different connection
> string, tried the DB Cooper technique of local ODBC DSN system setting... did
> not work. Dreamweaver MX 2004 connects to database, but shows "no tables
> found" when adding a dataset query binding. Testing server is not local, but
> on actual remote server.
> Thanks for any ideas.
>

same for me with an MySQL DB on local. work for some site, worked for
two of them and not now..

any idea appreciated (already try all MM KB)

[Forzato]

See this link for more on this thread...
[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=263&thre[/url]
adid=996081&CFID=3463774&CFTOKEN=4542b4c3f3ce902a-8E002F34-AA90-B2CC-092A45A70E8
5D667&jsessionid=483069963af21d7e2440

[sjb34]

HI. I got exact same problem, and I am going nuts!! I have a desktop at home
acting as a SQL server and IIS web server. Dreamweaver is on my laptop. Both
with XP Pro. When I run dreamweaver on desktop and use 'localhost' there is no
problem and local DSN connection fine, I can then see tables in db. When I
switch to remote DSN on the testing server, still a connection but no tables.
Then I switch back to dwMX on laptop and i cannot get it working at all. Access
denied message. I did sort that error but then I get can't find path. No
tutorials anywhere on the web to just deal with such a seemingly
straightforward task.
I have moved over from working with PHP and MySQL, beginning to wish I hadn't
bothered.
I read the reply to you on a similar earlier thread and you said you got it
working but I didn't fully undrestand what was meant by Nancy's info.
Me being inept newbie an all that!