The ado.net tag has no wiki summary.
2
votes
0answers
31 views
Failover only working for Classic ASP, not ASP.net
Setup:
All machines run Windows Server 2008 Enterprise
SQL Server 2012 Standard (Primary)
SQL Server 2012 Standard (Mirror)
SQL Server 2012 Express (Witness)
Root issue: Our ASP.NET application is ...
1
vote
0answers
34 views
Application using DB2 not launching due to Win 8
My application uses DB2. It is working fine in Win 7, but not launching in Win 8.
Giving error
System.Configuration.ConfigurationErrorsException:
Failed to find or load the registered .Net ...
0
votes
2answers
93 views
Understanding the use of Sql command parameters
I am using MySql database and I have a stored procedure to insert data, like this-
CREATE DEFINER=`root`@`localhost` PROCEDURE `adduser`(
IN id varchar(10),
IN pwd varchar(10),
IN fname ...
7
votes
1answer
1k views
What is the “Chaos” Isolation level and when should it be used?
ADO.NET documentation shows the possibility of setting the transaction level for a SQL transaction to Chaos. It sounds unpleasant, but if the feature is there, presumably it has some legitimate use.
...
0
votes
1answer
211 views
Creating a bar chart from datatable
I'm writing a console application that fetches data from database (SQL) and writes to an excel sheet. Now I want to add a chart in the workbook according to the datatable values. How can I create ...
0
votes
3answers
381 views
SSIS 2008 painfully slow to import CSV
I am using SSIS to import a 25,000 row CSV to an empty table. The table has a primary key that is populated as the data is inserted. I am using an ADO.Net destination.
What reasons are there why ...
0
votes
1answer
505 views
32-bit versus 64-bit ODP.NET to Oracle connection
I seem to be having an issue connecting a 32-bit .NET application to a 64-bit server, without a full Oracle client.
If I build a 64-bit application, using the 64-bit ODP.NET dll's or a 64-bit instant ...
4
votes
2answers
2k views
Will these two queries result in a deadlock if executed in sequence?
This is almost certainly the cause of my other question, but I thought it was worth separating the two as I have a hypothesis based on the following log that I would love to have falsified or ...
13
votes
3answers
2k views
Why is `SELECT @@IDENTITY` returning a decimal?
I'm using Dapper to execute the following query against a SQL Server 2008 R2 Express instance from a ASP.NET MVC 3 (.NET 4.0) application.
INSERT INTO Customers (
Type, Name, Address, ...
6
votes
2answers
2k views
Trouble deciphering a deadlock in an innodb status log
We are accessing MySQL from the Microsoft ADO.NET connector.
Occasionally we are seeing the following deadlock in our innodb status and haven't been able to identify the cause of the problem. It ...
1
vote
1answer
851 views
What is the purpose of sqlbulkcopy's useinternaltransaction property?
I'm just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases.
When the destination is Oracle, than I can monitor the progress by by executing
select ...
1
vote
0answers
224 views
Which are the Oracle basics required for advanced Oracle.DataAccess usage? [closed]
Successful use of [Oracle.DataAccess.Client] is based on proper understanding of three separate parts of Oracle:
SQL
PL/SQL
sql*plus
Here on dba.exchange the following questions target this topic:
...
2
votes
2answers
1k views
How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?
In my oracle Database if have the following table:
Create table Test_call_count (
count number(10)
);
insert into Test_call_count values (0);
Now I can run the following PowerShell script
if ...
4
votes
3answers
808 views
Is the ADO.NET Entity Framework known for generating poorly performing queries?
This question is inspired by the comment posted to the latest ServerFault blog post:
Are you guys still using LINQ to SQL?
I know I can use SQL Server Profiler and/or the ToTraceString method to ...
