all groups > dotnet ado.net > june 2007 > threads for june 15 - 21, 2007
Filter by week: 1 2 3 4 5
ApplicationException: Error in the application in SqlConnection.Open()
Posted by Jan Obrestad at 6/21/2007 3:40:55 PM
Hello.
I'm developing an application where suddenly I get this rather generic
error, it is an ApplicationException with the message: "Error in the
application".
The problem is that it originates deep inside the .NET Framework.
Here is (part of) the stack trace:
System.ApplicationException:... more >>
Type is invalid error
Posted by william at 6/21/2007 1:05:01 PM
Hi,
I have a tableadapter which is used to access Oracle database using OLEDB
for Oracle. I have a query on this adapter which consumes a procedure, this
procedure has output parameter as Char(1) or Int. From my business layer, I
call the adapter query by passing parameter of out string. It... more >>
Error while connecting remote SQL server
Posted by at 6/21/2007 4:52:55 AM
hi all,
I trying to connect remote sql server from my machine. but
it giving me some errors
Here are few errors listed,
=EF=82=A7An error has occurred while establishing a connection to the serve=
r=2E
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the... more >>
Error in DSN
Posted by Simi at 6/21/2007 2:17:02 AM
I have Error:Could Not Install ISAM.When i use System DSN.
my code is
in app.config
<add key="dsn1" value="Provider=Microsoft.Jet.OLEDB.
4.0;DSN=EduLiteDSN"/>
and i create system DSN =EduLiteDSN and database is Ms-Access 2000
... more >>
how to save a piocture n a table
Posted by Mero at 6/20/2007 11:09:47 PM
hi to all;
i want to save a picture in column image in a database
for example,in the table "users"
i want to save the user image as when i want to select the user data from the database to show it in my site, the image selected from the table "users"
thanks you ... more >>
How To Save A Picture In a table
Posted by Mero at 6/20/2007 4:40:23 PM
hi to all;
i want to save a picture in column image in a database
for example,in the table "users"
i want to save the user image as when i want to select the user data from the database to show it in my site, the image selected from the table "users"
thanks you ... more >>
commit transaction closes connection ?
Posted by John Grandy at 6/20/2007 4:30:55 PM
Does committing a transaction close it's underlying connection ? Or must
you explicitly close the connection ?
Also, is there any reason to dispose a connection ?
My goal is to force the underlying connection to return to the connection
pool.
Thanks.
... more >>
SqlConnection.Open() Which ErrorCodes
Posted by Henrik Skak Pedersen at 6/20/2007 4:03:36 PM
Hi,
I am trying to discover which SQLException.ErrorCode SqlConnection.Open()
can throw. I have until now discovered these:
// 53 : {"An error has occurred while establishing a connection to the
server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Concurrency violation problem.
Posted by pachuts at 6/20/2007 2:18:36 PM
Hi,
Using ADO.NET Table adapter in C# , am updating a record using VS2005
generated update command by passing dataset and the assocaited table like;
this.CustomerDataSet.CustomerTable.
while updating am getting "Concurrency violation: the UpdateCommand affected
0 of the expected 1 records... more >>
DAO/VB6 Outperforms ADO.NET in VB 2005
Posted by Paul Engel at 6/20/2007 1:24:04 PM
I have an application that reads through a delimited file, breaks the values
into an array and then checks to see if the record already exists in the
database. If it does, the record is updated. If not, the record is added.
Both of these actions are based on the values of the associated array ... more >>
Error with report viewer and Oracle database access
Posted by Rusty Owens at 6/20/2007 11:41:50 AM
I am trying to connect dot net report viewer control to an Oracle
database. When I try to run it, I get the following error message:
System.Data.OracleClient requires Oracle client software version 8.1.7
or greater.
I have installed Oracle Client 9.2 on that server and have tried the
fix a... more >>
Behavior of close application during dataGrid modification
Posted by schaf NO[at]SPAM 2wire.ch at 6/20/2007 11:10:43 AM
Hi NG!
I have recognized a strange behavior of the DataGrid control.
If I'm editing the value of a cell in the DataGrid and press the close
button (of the ControlBox of the application 'X') then the application
closes but the DataGrid does not loose the Focus. I would like to save
the changes d... more >>
SQL Server 2005 installation
Posted by Steve Bugden at 6/20/2007 9:56:01 AM
Hi,
Could someone please tell me what I would need to install if anything on a
client machine to access an SQL Server 2005 database from a .Net component?
Is it sufficient just to have the database files (.mdf and .ldf) and access
them via ADO.NET?
I only have a development machine and ... more >>
Working With Tables, Please Help!
Posted by Nando_uy at 6/19/2007 4:19:01 AM
I'm a Vb.net 2005 newbie, but an Older VB6 programmer.
With a ADO I work very comfortably (many years!), with ADO Is possible to
work DIRECTLY with all the records in a Table WITHOUT the need to write ANY
sql command.
I try to make the same with ADO.NET (.Net 2.0) using sqlserver express, but ... more >>
need a reply of this question
Posted by Mero at 6/19/2007 12:27:34 AM
i use visual studio 2003 amd c#.net to make my web application
my site is about e-learning
in my site i want to set some setting in "create new lesson page" such as name, description , startdate, end date,...
i used textboxes,dropdownlist, radiobutton in the design of this page
the probl... more >>
ObjectDataSource with list of others object in an object
Posted by Ghistos at 6/18/2007 11:05:00 AM
i all,
I have a class with properties returning int, string, date... and generic
Lists of other classes.
private static string zipcode;
private static string city;
private static double? x;
private static double? y;
private static List<Proprio> pro... more >>
Contecting transactions between two stored procs
Posted by Jerry J at 6/18/2007 8:55:02 AM
I have two sql server stored procedures that use transactions. Both stored
procedures have there own begin transaction , commit and rollback.
Currently I have C# .Net code that executes both of these stored procedures
consecutively. Everything works fine unless the second stored procedure ... more >>
SQL Server 2005/.NET 2.0 - Application performance deteriorates!
Posted by Steve Barker at 6/18/2007 8:46:00 AM
Hi guys,
I’m getting a really weird problem when accessing a SQL Server 2005 database
from .NET 2.0 code. I was wondering if anyone could make any suggestions as
to what is going wrong?!
Here is the problem (names and real world equivalents have been altered!):
I have a database that ... more >>
Need help with this Error
Posted by news.microsoft.com at 6/16/2007 12:27:49 PM
I have a SQL Server database. I am using a OleDB Provider. I am getting
the following error
An unhandled exception of type 'System.InvalidOperationException' occurred
in System.Data.dll
Additional information: Command parameter[2] '' is invalid.
Command parameter[3] '' is invalid.
He... more >>
Delete the data from tabel in the database
Posted by Husam at 6/16/2007 4:48:00 AM
Hi EveryBody:
I made project by using Asp.Net 2.0 and the code behind is written by vb.net
I want to delete the old password from the database tabel and insert the new
password insted ?
My queruy for retriveing information from the data base is :
Dim cmd As SqlCommand
Dim ... more >>
ADO.Net
Posted by Steve at 6/15/2007 3:49:27 PM
Does any body have sample code to create a dbf from ado.net recordset in C#
From http://www.developmentnow.com/g/7_2004_3_0_1_0/dotnet-framework-adonet.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com... more >>
Updating a P.SQL DataSet
Posted by mitzoe NO[at]SPAM yahoo.com at 6/15/2007 1:55:04 PM
I apologize for any inappropriate cross-posting, but wasn't sure where
whether this is a Pervasive or ADO.NET issue.
I'm trying to migrate data from a propietary system that's based on
btrieve into Pervasive SQL 9.5 using a .NET application written in
C#. The main problem is that the existing... more >>
Oracle DB, Remoting and .NET
Posted by ashehu NO[at]SPAM gmail.com at 6/15/2007 4:40:24 AM
Hi all,
I am workibng on an application that will interact with an Oracle
database and this is the first time I am doin sthg with oracle. From
what I read in other posts, I will have to install the oracle Client
before I can use any of the providers (MS or Oracle) to interact with
the database.... more >>
|