troubleshooting Question

Dreamweaver database issue - no tables displayed?

Avatar of jayh99
jayh99 asked on
Adobe Dreamweaver
10 Comments1 Solution1047 ViewsLast Modified:
Hi Guys,
I've set up an ASP.NET C# site, i have a OLE DB Connection to my SQL 2000 Server when i go into TEST the connection is says "Connection was Made Successfully".

heres my problem,

when i go to add a DataSet i give it a name and then select my connection which is called DBConnect,
i should get back a list of tables on my server but it comes back ***NO Table Found

any ideas please??????


heres whats in my web.config file...

<configuration>
      <appSettings>
            <add key="MM_CONNECTION_HANDLER_testme" value="sqlserver.htm" />
            <add key="MM_CONNECTION_STRING_testme" value="Data Source=whsql-v12.prod.mesa1.secureserver.net;Initial Catalog=DB_104386;User ID=[myuserid];Password=[mypassword];" />
            <add key="MM_CONNECTION_DATABASETYPE_testme" value="SQLServer" />
            <add key="MM_CONNECTION_SCHEMA_testme" value="" />
            <add key="MM_CONNECTION_CATALOG_testme" value="" />      </appSettings>
</configuration>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros