473,506 Members | 17,000 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

parameter information is not supported by the 'Microsoft.Jet.OLEDB

Hi,
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?... The command object is well created,
and connection too.

--
Thanks
Regards.
Josema

Feb 20 '06 #1
2 2281
Hi,

R u talking about the Northwind that comes with SQL server?
If so why r u using OLEDB instead of SQLserver provider?

if not post the code in question
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Josema" <Je******@ocu.org> wrote in message
news:22**********************************@microsof t.com...
Hi,
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?... The command object is well
created,
and connection too.

--
Thanks
Regards.
Josema

Feb 20 '06 #2
If you are using Jet to connect to an Access database, then yes, it does not
support "Stored procedure parameters". Sql Server, yes.

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Josema" wrote:
Hi,
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?... The command object is well created,
and connection too.

--
Thanks
Regards.
Josema

Feb 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1780
by: N S S | last post by:
I Get the following Error ================ Error =============================== Procedure 'GetCetgoriesOrProducts' expects parameter '@CategoryID', which was not supplied. Description: An...
0
1356
by: Relaxin | last post by:
Microsoft will be doing away with the OLEDB to ODBC bridge in the near future. So anything that is using ODBC thru ADO or OLEDB, it might be time to see if a native OLEDB driver exist for the...
0
5263
by: silesius | last post by:
I've been using VS 2003 to develop a webapplication using C#. Today I exported the application to a remote webserver I begun experiencing problems. It's a simple application that retrieves some...
8
13977
by: Yusuf INCEKARA | last post by:
I have a stored procedure : CREATE PROCEDURE STP_GETSTORELIST @RETCUR CURSOR VARYING OUTPUT AS set @RETCUR = CURSOR FORWARD_ONLY STATIC FOR SELECT ID,STORE_NAME FROM T_INF_STORE ORDER BY...
0
2739
by: silesius | last post by:
I've been using VS.NET 2003 to develop a webapplication using C#. Today I exported the application to another webserver I begun experiencing problems. It's a simple application that retrieves...
7
3033
by: Britney | last post by:
Original code: this.oleDbSelectCommand1.CommandText = "SELECT TOP 100 user_id, password, nick_name, sex, age, has_picture, city, state, " + "country FROM dbo.users WHERE (has_picture = ?) AND (sex...
1
2678
by: sd | last post by:
QUESTION: How can my ASP page - which uses language="VBScript" - pass a "System.Collections.ArrayList" object - as a parameter - to a C# method in the middle-tier ??? ----- Is it possible at...
3
1508
by: Bob | last post by:
When entering some functions, when the parameter list is shown there are definintions for the items in the paramater list. For example when you enter MID( you get the definition of the first...
14
1855
by: bill | last post by:
Can someone please show me an example of passing a string value into an sql statement in vb 2005? Something like this is what I'm after: Dim sqlButton1 As String = "Select * from tblAssets where...
0
7307
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7370
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...
1
7021
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...
0
7478
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...
1
5035
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...
0
4701
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3177
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1532
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 ...
0
409
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...

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.