473,573 Members | 2,760 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

OleDbCommandBui lder.DerivePara meters

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 GetScheduledGam es, and
the CommandType set to Stored procedure... Im querying against ms- access

OleDbCommandBui lder.DerivePara meters(this.ole dbcmd);

The error that i get is that :

The stored procedure 'GetScheduledGa mes' doesn't exist. But the query
GetScheduledGam es exists... What could be the cause??

--
Thanks
Regards.
Josema
--
Thanks
Regards.
Josema
Feb 20 '06 #1
2 4737
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 OleDbCommandBui lder.

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.A ccess)
{
_commoncnx=new OleDbConnection (this.Connectio nString);
this.Commoncmd= new OleDbCommand();
OleDbCommand cmd=new OleDbCommand();
}
else if(this.DbType= =DataBaseType.S qlServer)
{

//abro conexion
_commoncnx=new SqlConnection(t his.ConnectionS tring);
this.Commoncmd= new SqlCommand();
}
else //por defecto SqlServer
{
//abro conexion
_commoncnx=new SqlConnection(t his.ConnectionS tring);
this.Commoncmd= new SqlCommand();
}
this.Commoncmd. Connection=_com moncnx;
this.Commoncmd. CommandType=Com mandType.Stored Procedure;
this.Commoncmd. CommandText=thi s.ProcedureName ;
_commoncnx.Open ();

if(this.DbType= =DataBaseType.A ccess)
{
OleDbCommandBui lder.DerivePara meters((OleDbCo mmand) this.Commoncmd) ;
}
else if(this.DbType= =DataBaseType.S qlServer)
{
SqlCommandBuild er.DeriveParame ters((SqlComman d) 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
963
by: M D | last post by:
How do I do this and get a table schema instead: Oledbcommand cmd Oledbconnection conn if (sp.Checked) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = target.Text; conn.Open(); OleDbCommandBuilder.DeriveParameters(cmd); conn.Close();
1
1693
by: Robert Wang | last post by:
Hi all, this post also appears in ado.net group, anyway I appreciate any help here too. I created an sp in northwind in SQL server 2000, CREATE proc . @Count int output as
1
1931
by: johnb41 | last post by:
I have a datagrid that successfully allows editing and updating (with dataadapter.update command). I want the user to be able to edit the "text" in the datagrid, but i DON'T want the user to be able to DELETE rows. The OleDbCommandBuilder automatically creates the DELETE SQL statement. Is there any way I can disable it? If not, what...
16
1858
by: SLIMSHIM | last post by:
Hi, I"m new to c# and .net. I wrote a small program to add rows to an access table. the program goes thru the motions but the data never gets there. here is my code. I am intentionaly not using the form controls. I"m trying to do it solely thru code. You can safely assume I have an access datsabase with one table called who with three...
7
1714
by: Paul | last post by:
I'm trying to update a Microsoft Access database. I can successfully read from the database and submit a command to DELETE all records from a table. Now I'm trying to add records to the table that I just cleared. Below is the code: myConnection = New OleDb.OleDbConnection(accessConnectionStringConstant & accessMdb) ...
5
3813
by: scheidel21 | last post by:
I am writting a DB front end in VB.NET 2003 I have a form that displays employee information it has a dataset loaded from the DB that also includes tables for lookup in some comboboxes that are bound to the employees table so I load the combo boxes and then set the selectedText propertyt to bind to the Employee table as only those listed are...
2
1720
by: triffid | last post by:
Hi there, I'm trying to update my database via an UPDATE from OleDbCommandBuilder. This is the second time I've tried, and I'm still not having any luck. I've almost certainly missed something obvious, but having searched for quite a while, I don't know what it is(!) The code is here (intentionally showing source rather than having...
0
963
by: =?Utf-8?B?QTdtYWQ=?= | last post by:
Hi all, I'm using OleDbCommandBuilder to build commands for an OleDbDataAdapter automatically The problem is when using OleDbDataAdapter to retrieve data from a "View" in a SQL Express database Ex: OleDbDataAdapter("select * from ViewName", ConnectionString); The generated CommandText for generated commands is invalid, it looks like
0
1931
by: JB | last post by:
Code is taken straight from a book but i can't get it working right. Its generating an insert statement for inserting data into an excel file. //foreach (DataTable dt in ds.Tables) //private const string _excelSelect = "select * from "; excelDataAdapter = new OleDbDataAdapter(string.Format(_excelSelect, dt.TableName), excelFile);
0
7776
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7686
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8200
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7771
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8060
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5581
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
1
2197
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1297
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1038
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.