Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 2.0: sqldatasource & objectdatasourc with acces DB

Author  Topic 

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-07-22 : 17:51:25
PB: using sqldatasource and objectdatasource with access database

Hi, two little questions pls:
1/ Can I use sqldatasource when using Access database?
2/ They say in a microsoft lab:
"In the Add New Item dialog, select DataSet as the template type and enter
MyComics.xsd as the file name. Then click the Add button.
d. After a brief pause, the TableAdapter Configuration Wizard appears."

The problem when I place a sqldatasource linked to Access database, then I go to add an xsd file based on a dataset schema, the TableAdapter Configuration Wizard never shows up. any idea please.

3/ also if I ever add a tableadapter manually based on access database in the xsd designer ,Then when I go back to my page to add : an objectdatasource, I never find the method: myTableAdapter.... in the list, is there any problem for Access databases?

Thanks a lot.

bonekrusher
Starting Member

44 Posts

Posted - 2007-07-23 : 20:04:23
Hi,

You can use sqldatasource and objectdatasource with an access database. For example, you can have all three referenced in your web config.

As for # 2, I restart Visual Studio and usually works.
Go to Top of Page
   

- Advertisement -