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

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.
--
Regards,
Sengai

""Gary Chang[MSFT]"" wrote:

> 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.
>
>
.