Database Connection Problem

Question

Hey, I don't really understand database connection strings so I'm having problems debugging it. Any help not only figuring out the problem but also what is going on would be really appreciated:

I have a website on my localhost and I'm trying to get a sqldatasource to populate my gridview but it gives me the error 'Data source name not found and no default driver specified'.

My page says:

<asp:gridview id="AllOrdersChart" runat="server" Width="100%" DataSourceID="SqlDataSource1">
</asp:gridview>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
ConnectionString="<%$ ConnectionStrings:lollipopDB %>"
ProviderName = "System.Data.Odbc"
SelectCommand="SELECT * FROM LollipopsDB"></asp:SqlDataSource>

and my web.config says:

<connectionStrings>
    <add name="lollipopDB" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\Lollipops\App_Data\lollipopsDB.mdb;"
        providerName="System.Data.OleDb" />
</connectionStrings>

Ideas on what is wrong?

Hiyasat · Accepted Answer · 2009-12-20 08:15:27Z

2

as you use an sql datasource you have to change your provider name

<asp:AccessDataSource ConnectionString="<%$ ConnectionStrings:lollipopDB %>"
 ProviderName = "System.Data.OleDb"
 SelectCommand="SELECT * FROM LollipopsDB"> </asp:AccessDataSource>

instead

<asp:SqlDataSource>  </asp:SqlDataSource>

answered Dec 20, 2009 at 8:15

Hiyasat

8,9667 gold badges36 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David M · Accepted Answer · 2009-12-20 08:06:24Z

0

Your provider names don't match, for starters. Try using System.Data.OleDb for both.

answered Dec 20, 2009 at 8:06

David M

73.2k13 gold badges164 silver badges187 bronze badges

Comments

Joe Internet · Accepted Answer · 2009-12-20 08:16:03Z

0

Have you already created the DSN (data source name) on the system? If not, you'll need to do so under administrative tools in the Windows control panel, before you can access it.

answered Dec 20, 2009 at 8:16

Joe Internet

5361 gold badge3 silver badges4 bronze badges

Collectives™ on Stack Overflow

Database Connection Problem

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related