Solved

Error, invalid character

Posted on 2007-11-20
9
179 Views
Last Modified: 2010-04-24
dataleser = kommando.ExecuteReader() <--- on this line i get a error saying "Oracle exeption was unhandled, invalid character" why?? i dont understand why


Dim forbindelse As New System.Data.OracleClient.OracleConnection
 
        forbindelse.ConnectionString = "user id=***;password=***;data source=oracle.*******"
        forbindelse.Open()
 
        Dim kommando As New System.Data.OracleClient.OracleCommand(setning, forbindelse)
 
        Dim dataleser As OracleClient.OracleDataReader
        dataleser = kommando.ExecuteReader()
 
        Me.Dgvstatistikk.DataSource = dataleser
        dataleser.Close()

Open in new window

0
Comment
Question by:leeds2000
  • 5
  • 3
9 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 20319325
this can only be explained by the query behind the OracleCommand.
the "invalid character" usually arises when you have data type mismatches or inconsistencies in the query/procedure
0
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20319335
What is the value stored in variable setning?
0
 
LVL 3

Author Comment

by:leeds2000
ID: 20319341
"select * from ordre;"
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 23

Assisted Solution

by:Ashish Patel
Ashish Patel earned 250 total points
ID: 20319362
Try removing the ; from the end and try once. I dont see anything specific here.
0
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20319366
And if nothing works out, try putting Try Catch Block and handle the exception to see what error message is comming up.
0
 
LVL 3

Author Comment

by:leeds2000
ID: 20319388
Seemed to work, but i dont get any information in my Datagridview

is this the correct way of getting the information from the SQL query to the datagridview?

Me.Dgvstatistikk.DataSource = dataleser
0
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20319419
You are missing the databinding
0
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20319472
I havent worked on datagridview much, but there are just two possiblities, either there are no values return by your query or either databinding ith datagridview is wrong.
0
 
LVL 3

Author Comment

by:leeds2000
ID: 20319639
ok il take this to a new question then :)

Split points between asvforce and angelIII since he was first with the problem, and asvforce with the solution :)
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question