SCM

[#1000339] Unable to load the Dataset

View Trackers | Bugs | Download .csv | Monitor

Date:
2005-06-27 09:56
Priority:
3
State:
Open
Submitted by:
Raja Vikrama (vikrama)
Assigned to:
Nobody (None)
Category:
Crash
Group:
v1.0.0.19
Resolution:
None
 
Summary:
Unable to load the Dataset

Detailed description
I have the following code

string ConnString = "Provider=PostgreSQL;Data Source=192.168.168.177;location=vikram;User ID=vikram;password=vikram;";

OleDbConnection myConnection = new OleDbConnection(ConnString);
myConnection.Open();


string myInsertQuery = "select * from temptable where username = ?";

DataSet dataSet = new DataSet("MyDataSet");

OleDbDataAdapter oleDataAdapter = new OleDbDataAdapter(myInsertQuery, myConnection);


OleDbParameter myNewParameter2 = oleDataAdapter.SelectCommand.Parameters.Add("username", OleDbType.VarChar);

myNewParameter2.Value = "Vikram";

oleDataAdapter.Fill(dataSet);

dataSet.WriteXml(Console.Out);

The program failes in the line oleDataAdapter.Fill(dataSet); with the following error.

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll



Followup

Message
Date: 2006-09-14 11:30
Sender: Nobody

Is there a hotfix/update for this issue??
Date: 2006-09-14 11:29
Sender: Nobody

IS there an hotfix/update for this issue..
Date: 2006-01-04 19:11
Sender: Dmitriy Bagmet

I encounter the same issue of not being able to fill the DataSet while using the pgOleDb driver. The problem occurs when passing parameters (adding parameters to the OleDb Parameter Collection) to the SQL statement or stored procedure.

But, I am able to fill the DataSet when supllying fixed parameters, not through the Parameters.Add method but hard coding them in the OleDbCommand.CommandText Property, which in turm sets the SQL statement or stored procedure to execute at the data source.

It seems to me that the underlying problem is in suppplying the varying parameters.

Attached Files:

Attachments:
posgre.log

Changes:

Field Old Value Date By
assigned_toshachar2005-12-01 12:55shachar
File Added49: posgre.log2005-06-27 09:56vikrama
Powered By FusionForge