Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / General / January 2006

Tip: Looking for answers? Try searching our database.

How to: List a table in Tables holder of Server Explorer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sengai - 06 Jan 2006 07:10 GMT
Using VS2005 with the data source of .NET Framework Data Provider for ODBC,
how can you list a table in Tables holder of Server Explorer?

I added a connection to the ODBC data source with MS Access Database in
Server Explorer. Test Connection on Connection window returns succeeded but
no table is listed in Tables holder of Server Explorer.

Does anyone know how to fix this?
Signature

Regards,
Sengai

"Gary Chang[MSFT]" - 06 Jan 2006 09:38 GMT
Hi Sengal,

>I added a connection to the ODBC data source with MS Access
>Database in Server Explorer. Test Connection on Connection
>window returns succeeded but no table is listed in Tables holder
>of Server Explorer.

Based on the description, there is no table items in the Tables folder
under the corresponding ODBC data source in your VS2005's Server. Please
let me know if I have misunderstood anything.

To research this issue, I have performed some tests with the northwind.mdb
on my side, I used the connection string to build the ODBC data source, it
works OK in my machine, all the northwind's tables has been listed in the
corresponding ODBC data source's tables folder. I am not very clear how do
you build your ODBC data source, would you please give us some more
detailed info about it, and are there any valid/active items under your
ODBC data source?

Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.
Sengai - 09 Jan 2006 04:06 GMT
Hi Gray,

Thank you for your reply.
Here is the procedure I did to add a data connection to Server Explorer in
VS2005.

1.Click Connect to Database icon in Server Explorer.
2.Click Change... button in Add Connection window.
3.Select "Microsoft ODBC Data Source" from Data source list in Change Data
Source window.
4.Click "Use connection string:" radio button and click Build... button.
5.Select MS Access Database from Computer Data source.
6.Click Database...button in Login window.
7.Select the target Access file(.mdb) in the target holder.
8.Click Test Connection button and get the message of "Test connection
succeeded."
9.Click OK button in Add connection window.

The data connection of ODBC.ACCESS.C:\db\myDatabase.mdb appears in Server
Explorer. Then expand the holder and double-click Tables holder but no table
item is listed in Server Explorer.

For your information on DSN,
Dsn=MS Access
Database;dbq=C:\db\myDatabase.mdb;defaultdir=C:\db;driverid=25;fil=MS
Access;maxbuffersize=2048;pagetimeout=5;uid=admin

Incidentally, if I add a data connection for the same access file through
Microsoft Access Database File (OLE DB), all the table items are listed in
Tables holder in Server Explorer.

Did I make myself clear? How can I work around this issue?
Any information you give me is appreciated.
Signature

Regards,
Sengai

> Hi Sengal,
>
[quoted text clipped - 28 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary Chang[MSFT]" - 09 Jan 2006 07:30 GMT
Hi Sengal,

Thanks for your detailed repro steps, it seems no problem with your steps
and connection string. I used the same walkthrough to add the access
database datasource, there hasn't any problem on my side.

I have also checked our database on this issue, but did not any similar
case about it. So in this scenario, I suggest you may try to perform some
reinstallation of your machine's MDAC and Visual Studio 2005, if it is not
very inconvenient to you.

Thanks!

Best regards,

Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.
bill.gates.com@gmail.com - 23 Jan 2006 18:28 GMT
Hi,

I have same problem while I try to connect to SQL Server via ODBC
every step returns ok, but no table is listed, just tables under
"master" db of SQLServer

Thanks

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.