Databases :: Data Source Name Not Found And No Default Driver Specified?
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
Similar Messages:
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
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
Feb 17, 2010
System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)
[Code]...
View 5 Replies
Jun 7, 2010
does anybody have a link to download ODBC DLL connection to a Sybase database?
View 1 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
Jan 10, 2010
I'm having some really annoying issue using ADO.NET connector.
I've added reference to my project- the file "MySQL.data.dll"
Actually, i've copied the file from "MySQL Connector Net 6.2.2Assemblies" to "MyWebSitein" and then added reference.
Then, typed "using MySQL.data" and as you can guess, i've got that message:
Namespace or type specified in the Imports 'MySql.Data.MySqlClient' cannot be found.
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
Nov 19, 2010
I'm sending parameters to a stored procedure in MySQL to do an insert and I'm getting an error that I don't understand:
Parameter '?/*IN' not found in the collection.
View 1 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
