473,406 Members | 2,847 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

"ORA-01008: not all variables bound " occured in OLEDB provider

Hi world. I am trying to add Get method in an asp.net dataset (.xsd) file. I am using oledb provider and my select statement supplies a parameter using a colon (:).

e.g. :parameter1

It does not accept @ or ?.

It works fine when run from query builder but gives problem when i try to preview data in the dataset.

The error is: ORA-01008: not all variables bound

Please help me i am in urgent.

Thanks in advance.
Sep 12 '08 #1
0 1892

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: jp | last post by:
------=_NextPart_000_016C_01C3453B.E114CE50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i downloaded oledb provider from mysql.com, i use Delphi's...
12
by: Parking Meters | last post by:
Today I managed to get the OleDB provider to let me put datasets from an as400 using sql. Great, the provider string I used is: Provider=IBMDA400.DataSource.1;User ID=XXXXX;Password=XXXX;Data...
0
by: Charles Fineblum | last post by:
Hi: When I add a data adapter to form it bombs-out creating insert, update and delete statements. I have tried creating my own, but getting weird results. I have also used Access database in...
2
by: Martin | last post by:
Hi, I currently have an application that connects to an MS ACCESS database. This application uses an OLEDB connection string for MS ACCESS. Now, I'd like to upsize the application so I converted...
3
by: bfprog | last post by:
Using IBM iSeries client access OLEDB provider to connect to DB2 on AS/400, but cannot create connection using .NET web app. Using following code: Dim cnTest As New...
1
by: Norton | last post by:
Dear All, I have found a OLEDB Provider named "Microsoft OLE DB Provider for Outlook Search", is there anybody know how to manipulate it? I want to do some operation with outlook but don't...
0
by: alasdair.johnson | last post by:
A bug I noticed which doesn't seem to be posted on usenet, nor recognized by Oracle (who didn't want to help unless we had been using their ADO.NET provider...): We used to retrieve the sequence...
0
by: varughmi | last post by:
A unique issue has cropped up today in a .NET program I developed. It has been working fine for over an year until now. The program makes 2 connections total - one to a UNIT instance and another...
0
by: DeepthiSem | last post by:
Hi Everyone I have an issue while saving .rpt file into DB2 database using C# windows application. The provider i have used is OLEDB provider. It is not supporting to insert large amount of data...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
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...

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.