troubleshooting Question

Table List

Avatar of JoeBo747
JoeBo747 asked on
.NET ProgrammingVisual Basic.NETSQL
6 Comments3 Solutions334 ViewsLast Modified:
Hi Experts

I have an active ADODB connection, which is failing to connect to a table within the catalog. Can I return a list of available tables in the catalog?


connection:

con.ConnectionString = "Provider=MSDASQL.1;" _
            & "Password=abcde;" _
            & "Persist Security Info=True;" _
            & "User ID=CustClient;" _
            & "Data Source=TransportDB_Comp1;" _
            & "Mode=ReadWrite;" _
            & "Initial(Catalog = Abacus_Comp1);" _
            & "MARS Connection=True;"

 con.Open()
Regards,
Joe
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 6 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 3 Answers and 6 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