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