471,350 Members | 1,943 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

OleDbCommandBuilder.DeriveParameters

Hi to all,

Im getting an error that in theory is simple but i dont understand...

This is the line when i get the error, and the oledbcmd is well created,
with the connection opened, the command text set to GetScheduledGames, and
the CommandType set to Stored procedure... Im querying against ms- access

OleDbCommandBuilder.DeriveParameters(this.oledbcmd );

The error that i get is that :

The stored procedure 'GetScheduledGames' doesn't exist. But the query
GetScheduledGames exists... What could be the cause??

--
Thanks
Regards.
Josema
--
Thanks
Regards.
Josema
Feb 20 '06 #1
2 4599
Hi
please post your code snippet.it's not enough to understanding your
problem!!
Thanks
A.Hadi

Feb 20 '06 #2
Hi Hadi,

I already solve my last post, but i have a new one problem...

Im getting this error

Retrieving procedure parameter information is not supported by the
'Microsoft.Jet.OLEDB.4.0' provider

Im using the DeriveParameter method of the OleDbCommandBuilder.

Im trying to execute the "Employee Sales by Country" procedure in the
Northwind database.

What could i do to solve this error?... I dont have any idea..

here some code:

if(this.DbType==DataBaseType.Access)
{
_commoncnx=new OleDbConnection(this.ConnectionString);
this.Commoncmd=new OleDbCommand();
OleDbCommand cmd=new OleDbCommand();
}
else if(this.DbType==DataBaseType.SqlServer)
{

//abro conexion
_commoncnx=new SqlConnection(this.ConnectionString);
this.Commoncmd=new SqlCommand();
}
else //por defecto SqlServer
{
//abro conexion
_commoncnx=new SqlConnection(this.ConnectionString);
this.Commoncmd=new SqlCommand();
}
this.Commoncmd.Connection=_commoncnx;
this.Commoncmd.CommandType=CommandType.StoredProce dure;
this.Commoncmd.CommandText=this.ProcedureName;
_commoncnx.Open();

if(this.DbType==DataBaseType.Access)
{
OleDbCommandBuilder.DeriveParameters((OleDbCommand ) this.Commoncmd);
}
else if(this.DbType==DataBaseType.SqlServer)
{
SqlCommandBuilder.DeriveParameters((SqlCommand) this.Commoncmd);
}

--
Thanks
Regards.
Josema
"Aboulfazl Hadi" wrote:
Hi
please post your code snippet.it's not enough to understanding your
problem!!
Thanks
A.Hadi

Feb 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by M D | last post: by
1 post views Thread by Robert Wang | last post: by
16 posts views Thread by SLIMSHIM | last post: by
2 posts views Thread by triffid | last post: by
reply views Thread by =?Utf-8?B?QTdtYWQ=?= | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.