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]....
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!
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.
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.
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?
I created an asp form that connect to my access database, uding windows server 2003 64X but i am having trouble accessing the page due to the error that says provider not installed on local machine,i found some posts online that requested to make the iis allow 32Bit connection which i did; however the error now is gone but the page keep looping without displaying anything.
View 5 Repliesi m running vs 2005 +asp.net with +xp professional+ms access 2003 now problem when i run code of for opening of oledb connection it shows error The 'Microsoft.Jet.OLEDB.4.0 data source=d:website
orthwind.mdb' provider is not registered on the local machine.wht should i do if u r taliking about 32 or 63 bit provide me complete detail
I have a form wilh couple of Drop downs and text boxes and a Data Grid View which displays data from Access Table. When I hit add button on the form, I can see the data being added to the Grid View. But when I close the form and open the Access Database File (.mdb), the respective table is empty. The Access Table is not being updated. Second time if I open the form, the Grid View is also empty.I am pasting my code here.
Public Class Home
Shared OleDbConnection As System.Data.OleDb.OleDbConnection
Shared ExpensesDataAdapter As System.Data.OleDb.OleDbDataAdapter [code]....
I m new in asp.net c#.
How to declare a oledbconnection object in asp.net c#.
Means should it be declared as a static or public?
ex:- suppose the object is OleDbConnection con;
Whether it should be static OleDbConnection con;
Or public OleDbConnection con;
I'm deploying a small ASP.NET (framework 3.5) application in a Windows Server Web 2008 32 bits, IIS 7. The applications needs connection to an Oracle DB in another Server, using the tradicional DataAdapter, Oracle Connection, etc.
I´ve installed correctly the Oracle Client in the server (the server is another server´s client) and I´ve checked that this server has access to the server where the database is.
Even though my app isn´t able to connect to DataBase. The message says that Oracle components haven´t been found. It doesn´t find the OleDB Provider for Oracle or some dll.
¿Something I shluod know about permissions of the ASP.NEt users or something like this?
The attached code, the oledb part, is giving me a blank web page saying it cant connect on my local dev server. I have another app with the same code, in fact I copied it and changed the db names. The one I copied from works fine.
[Code]....
I need to set connection timeout in oledb connection string like
stringA= "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;PWD=password;Initial Catalog=DB;Data Source=127.0.0.1;Connect
Timeout=30" [code]....
How to put an OleDB Connection String in Web.Config I wrote the following code but getting error
Code:
<appSettings>
<add key="ConnectionString"
value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/App_Data/AMS.MDB")" />
</appSettings>
Getting error while concatenating a string Data Source=" & Server.MapPath
How can i read CSV file without using Oledb connection.
View 1 RepliesWhen i try to bind the data to gridview/listview from access file using oledb provider its throwing an error specifying that "The 'Microsoft.Jet.OLEDB.14.0' provider is not registered on the local machine.".
[Code]....
And by seeing some articles i changed "Enabled 32 bit applications" as True from IIS. And i have downloaded some DataContext's to work for access, but no use, its not working.
I have a simple update query to a access database. Works perfectly on my localhost but when I upload it to the server it displays this. The weird thing in the "
monstababy.MailingList.btnSubmit_Click(Object sender, EventArgs e) in C:inetpubwwwrootmonstababymonstababymonstababyMailingList.aspx.cs:26" mention of my
local host settings on the server. I have spoken to my host and they have set permissions for the data folder etc but this still prevails. I am positive it
Source Error:
[Code]....
Stack Trace:
[Code]....
i am using my sql database. what type of data connection improve the performance.oledb connection or odbc connection ? what is the theory of these architectures?
View 8 RepliesWe're converting a Classic ASP site to an ASP.NET site. One function was to upload a 'template' of data in CSV format for importing into the database. There were several different record types in there (the first field always indentifies the type of data).
The task was to get the CSV into a DataTable so it could be validated (new project is to have MUCH better validation rules)
The code seemed pretty straightforward - watered down (taking out comments, Try/Catch, etc) it is as follows:
Dim da As New System.Data.OleDb.OleDbDataAdapter
Dim cn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDirectory & ";" & "Extended Properties=""Text;HDR=No;FMT=Delimited;""")
Dim cd As New System.Data.OleDb.OleDbCommand("SELECT * FROM " & strCSVFilename, cn)
cn.Open()
da.SelectCommand = cd
da.Fill(dtData)
The DataTable (dtData) is populated, but only starting with the second line of the CSV file DESPITE the fact that "HDR=No" is in the connection string. What am I missing here?
I am Importing an excel file using oledb connection in asp.net.
but it is not working on server.
now i want to read excel file without interop.
How can i do it.
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 RepliesDescription: 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] .....
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);
}
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]...
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]....
[Code]....
View 1 Replies
