Data Source Name Not Found And No Default Driver Specified?
Jul 20, 2010
The Error
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The Story
I've written a page outside of Visual Web Developer 2010 that uses a SqlDataSource object along with a FormView object that works perfect. Building upon those awesome skills I obtained I started to build a project within Visual Web Developer, this time creating an Empty Web Application and went along my happy way building my new site. I used the same techniques and almost the same code as before - just pointing to a different table but I was met with the aforementioned error message.
The Confusing part
Here's the puzzling part - if I take my page I wrote outside of Visual Web Developer, again - it works perfect - no complaints, and add it as a page to the project I've built it now presents the same error message and I have no idea why.
The Tests Completed
I've backed off of targeting .NET 4.0 framework and went to 2.0 as I am not using any specific 4.0 controls or methods at this time. I've taken my page that originally gave me issue and recreated it outside of a Visual Web Developer project and instead as a stand alone page and the exact same code - copy, cut, paste - works perfect!
View 2 Replies
Similar Messages:
Jan 19, 2010
I get this error message when I connect to the data source on localhostERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedthe connection string is
connectionString="Data Source=DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;PORT=3306; DATABASE=database;UID=xxx;PWD=xxx;OPTION=3;pooling=false;"
providerName="System.Data.SqlClient"
it must be some kind of problem in the environment since the connection string works on a remote server. I downloaded the driver and added it with the Data source (ODBC) application in the control panel.
View 2 Replies
Jan 3, 2011
I have a ASP.NET webapplication where I use ODBCConnection to connect a MySQL server, it will take the connectionstring from the web.config file and this works grate.
But when I put the same code in a WPF application and hardcode the same connection string I get the followin exception when runnint ODBCConnection.Open() :
Data source name not found and no default driver specified
I have checked the ODBCConnection orbject and its instansiated with the exact same connectionstring as in the webapplication.
The connection string looks like this :
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=X.X.X.X;DATABASE=X;USER=X;PASSWORD=X;OPTION=3"
The X is set to propert values
I am running both from the same computer so the MYSQL ODBC connection is installed correct.
View 1 Replies
Jul 21, 2010
I am trying to retreive data from the Access Database from my ASP.Net application.
It works when I access one table for an ExecuteScalar.
but in the following code I get this error;
Data source name not found and no default driver specified
[code]....
View 2 Replies
Jan 25, 2010
i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"
i need to change that to -
"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"
when i just change the text it gives this error -
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
View 2 Replies
May 3, 2010
I am displaying a table into a gridview for which I've a SQL query written which uses IF-ELSE condition. In one of the conditions, if the condition stands TRUE then one of the coloms should be eliminated from the table. But I constantly get an error:"A field or property with the name 'IXC_Vendor_Circuit_ID' was not found on the selected data source."
View 6 Replies
May 7, 2015
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: A field or property with the name 'ID' was not found on the selected data source.Source Error: An unhandled exception was generated during the execution of the current web request.
[Code] ....
My code:
Page Title="Log In" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeBehind="Login.aspx.cs" Inherits="WebApp.Account.Login" %>
<script runat="server">
protected void LoginButton_Click(object sender, EventArgs e) {
[Code] .....
View 1 Replies
Oct 3, 2010
I'm attempting to load a GridView dynamically on a button is pressed.The gridview has AutoGenerateColumns="True" (set in skin definition) and has a declarative column definitions as follows:
<asp:GridView runat="server"
SkinID="GridViewDetail" ID="gvReport"
DataKeyNames="dateofcompletion">
<Columns>
[code]...
This all works fine the first time, but as soon as I select a different ddlCampaign item, it throws the"A field or property with the name 'FieldName' was not found on the selected data source" ERRORI kinda understand that it has retained the column mappings from the previous datasource assignment/binding and because the new datasource has different column headings it is throwing the error. What I can't seem to achieve is a clear or reset of defined gridview columns before adding the new columns. I cannot clear all columns because part of the GV defn is declarative.e.g.
gvReport.Columns.Clear();
gvReport.AutoGenerateColumns = true;
I have also tried clearing the previously added columns before new assignment/binding but it gives the same error.e.g.
for (int i = 2; i < gvReport.Columns.Count; i++)
{
gvReport.Columns.RemoveAt(i);
}
View 18 Replies
Oct 22, 2010
I am trying to bind the XML data to a datagrid from an XML file. I don't know why I am getting the message: "A field or property with the name 'User_x0020_Name' was not found on the selected data source."
The "User_x0020_Name" field does exist in the XML file. This is a portion of the XML file.
<?xml version="1.0" encoding="utf-8" ?>
<DataSet xmlns="http://www.----------.com">
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-[code]...
View 3 Replies
Feb 23, 2011
this is the error: A field or property with the name 'idcode' was not found on the selected data source.and what i am trying to do is this... i don't understand that. i never used DataSet before.
[Code]....
View 15 Replies
Oct 1, 2010
[Code]....
View 1 Replies
Jan 11, 2010
I have created a gridview at runtime. its working fine when i load the grid first time. after when i am selecting next value from ddl to load grid according to that option(selecting from dropdown list and coresponding values showing in grid) showing error that "A field or property with the name 'datafield name' was not found on the selected data source." might be i am getting this error becuze the privious value is not being cleared" can anybody help me with this problem.
View 2 Replies
Jul 8, 2010
I put a sql statement into the textbox,then the result will be bound to the gridview in the page. first time,sql statement is "selecte * from A(B)",and the gridview is ok. second time,sql statement is "selecte * from B(A)",then the gridview will throw a exception the exception is "A field or property with the name 'aa' was not found on the selected data source. i have two tables A and B."
View 5 Replies
Apr 9, 2012
I am using two gridviews with one datasourse. I am getting one error
A field or property with the name 'Empid' was not found on the selected data source. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: A field or property with the name 'Empid' was not found on the selected data source. Source Error:
My code is
<asp:GridViewid="gridview"
runat="server" DataSourceID = "SqlDataSource1"
PageSize="30" EmptyDataText = "No Records Found" EmptyDataRowStyle-HorizontalAlign ="Center"
AllowPaging="true"
[Code]....
View 1 Replies
Apr 9, 2010
[Code]....
[Code]....
[Code]....
View 3 Replies
Nov 12, 2010
I have a textbox quering a DB and showing the results in a gridview. If no records are found, instead of the present blank response, how can I put up a default message saying no records were found.
View 15 Replies
Aug 19, 2010
I know that you can use exclamation sign to bind array of simple types (like string) to GridView like this
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField HeaderText="Array Field" DataField="!" />
</Columns>
</asp:GridView>
But this doesn't seem to be the case with DataNavigateUrlFields
<asp:HyperLinkField DataNavigateUrlFields="!" DataNavigateUrlFormatString="RoleInformation.aspx?role={0}" Text="Manage users" />
and I get following error:A field or property with the name '!' was not found on the selected data source.
View 1 Replies
Aug 13, 2010
I'm trying to retrieve selected DataKeyValue and I'm getting this error.
[Code]....
View 2 Replies
Sep 16, 2010
I am binding SQL data to a GridView. The GridView's DataKeyNames property is set to the SQL column called "utID"
I know that within the SQL results, some of the utID values are NULL. After databinding to the GridView, I need to enumerate through the GridViewRows an read the DataKey values. However, when I try this I get the following error:
No default member found for type 'DBNull'. I am using the code below.
What object types are stored within DataKeys (I thought it was just integers or strings)
How to handle a NULL datakey value to prevent this error occurring?
I don't want to use Try Catch because it's too much of a 'hack'
[Code]....
View 6 Replies
May 18, 2010
I have an ASP.NET web app. I reference an external .dll, made by another team member.When first stepping through my code (which calls this dll's class and method), I get an error (runtime of course) stating that the source cannot be found and if I want to step through disassembly.
What causes this? Also, is it possible to add .pdb files to a project's references?
View 2 Replies
Mar 26, 2010
I have a page which displays details and a pictures of employees. The details are stored in a SQL database and the images are on the server. How can I set a default Image to display (e.g. an Image saying "Awaiting Image") if an employee picture is missing?
I can't use NullImageUrl as the Images are not stored in the database. I can't use the solution found on [URL] as an ImageField does not accept an ID attribute.
[Code]....
View 7 Replies
Mar 8, 2010
Default Role Provider could not be found.
<roleManager enabled="true"/>
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider"
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
siteMapFile="web.sitemap"
securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
View 1 Replies
Aug 11, 2010
I created a VB.NET/ASP.NET app, which runs fine on my local pc, from VS2008.
Now I tried to publish it on the server of my hoster, and I am getting the error:
Default role provider could not be found
I'm trying to adjust the web.config file, by replacing the name of the SQL server of my local machine with the name of the sql server of my hoster's server, but so far no luck.
View 2 Replies
Oct 26, 2010
This is probably a lame question, but I know little of web development. I inherited a web project that I'm trying to get running locally. I get the mentioned error on line 46.
Line 44: </authentication>
Line 45: <membership defaultProvider="AD_MyCompanyName" />
Line 46: <roleManager enabled="true" defaultProvider="ADRP_MyCompanyName_Readonly" cacheRolesInCookie="true" cookieName="MyCompanyName.ROLES" createPersistentCookie="true" cookieSlidingExpiration="true" cookieTimeout="240" />
Line 47: <profile enabled="false"/>
Line 48: <customErrors mode="Off"/>
This code works on the old developer's box, but not on mine. I've been working through some TFS checkout issues on his box, assuming it was simply files left checked out. I can't figure out where the providers are added. I don't see them being added in the config file above. In fact, if I search for "AD_MyCompanyName" and "ADRP_MyCompanyName_Readonly", I get no hits in the entire solution. I can't figure out what they are. Not sure why it works on that box if I can't even find the providers being added.
View 2 Replies
Jun 17, 2010
how to change the default event source for any particular application. So for example, forms authentication writes certain events by default like if authorization or authentication fails. The source for those on my machine is ASP.NET 2.0... I'd like to change the source to the application name. Now, I can do this on events I write code for myself, but I'd like all events that the application records to have the same source name. The reason I want to do this is so that I can create a seperate event file under the event viewer and filter in only events from that particular application. Is this possible?
View 3 Replies
