Successful Connection to database but cant "see" tables

[MIKE333]

I just hooked up with a new host, I have worked with .asp pages in the past and been able to connect, and work with data in a database, so I am not a complete idiot when it comes to the subject.

I know its not the best way to go about it but I use MICROSOFT ACCESS for my database and do not want to move all my data to a sql database.

With this new host I am able to make a successful (dreamweaver kick back the successfully connected message) connection to my database. However when I go to create any type of recordset, I cannot "see" any tables or data for that matter in my database.


I have spent hours with their tech support online ( I cannot reach them on the phone) and have gotten 0 Help from them along with not getting the problem resolved.

Has anyone had this problem before and been able to work it out or figure out what the problem is ?????

I use the new host as my Remote connection as well as my testing server.

[Lon_Winters]

What version of Dreamweaver are you using? There is a known issue with 8 where this happens and an extension and procedure to fix it. Part of the process is to remove your connection scripts. I've also had the problem in CS3, where removing the connnection scripts and redefining the connection worked.

[MIKE333]

Hi, thanks for trying to help... I am using Dreamweaver MX 6.0 I have tried not only using a DSN created on the server ( Which I can see and get a successful connection to. Also with DSNless Connections. I have also tried deleting all my connection scripts and re- creating them. Again I get a successful connection and cannot see any tables in my database.

Could this be a permission issue with the database folder on the server ? I am pretty sure they are all set up correctly but this is very strange that I can connect but not see any tables.

Thanks again for the help


I ALSO ADDED A VIDEO THAT CAN BE VIEWED OF MY CONNECTION INFORMATION AND THE PROBLEM I AM HAVING

YOU CAN VIEW THE VIDEO HERE

[Lon_Winters · Accepted solution]

It does look like the same issue and you will have to install the extension plus the other stuff. Soo this page, and scroll down to where it talks about the issue:

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19515&sliceId=2

[MIKE333]

Lon, thank you SO much for taking the time to help me out and finding me a solution to this problem, I have spent the last 5 days looking for/ chatting with tech support/ trying to find the answer.

That was it and installing the patch did the job.

Thank you very much again

Mike

[Lon_Winters]

You're very welcome. There have been countless times where I've also asked for help and received it - so it feels good to give back.

As a side note, I know what you said about converting to SQL - I don't know if you've ever tried it or not, but it's pretty easy. Web hosts that offer Windows servers often include an SQL database for the same cost as ODBC. Plus, you can use an Access ADP file to manage the DB and import your MDB tables. (I've never tried converting queries tho, those may have to be rebuilt). And, I've also run into one web host that didn't allow a connection via the ADP file.