First, the connection string is missing information. How can it connect without a login to the database? Try something more like this:
xml Code:
<add connectionString="Server=[server name];Database=[database name];User ID=sa;Password=[database admin login]" name="[a name to use throughout the app]" providerName="Microsoft.Jet.OLEDB.4.0" />
I use entirely SQL databases, so my objects are slightly different, but the concept should be the same:
xml Code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:[name of connection string] %>"




Reply With Quote