Hello,
I am trying to get access to an MySql-Server over CSharp. As I am not sure
whether it is an csharp or sql driver problem, i am posting it here.
I got the following error:
PM Exception: Object reference not set to an instance of an object.
6/27/2006 12:23:25 PM Stack trace:
at MySql.Data.MySqlClient.PacketWriter.WriteStringNoN ull(String v)
at MySql.Data.MySqlClient.MySqlCommand.PrepareSqlBuff ers(String sql)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior
behavior)
at
MySql.Data.MySqlClient.MySqlCommand.System.Data.ID bCommand.ExecuteReader(Com
mandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable)
at Fact.TestConnect.connect2DB() in
c:\Inetpub\wwwroot\Fact\TestConnect.cs:line 114
Cycle finished
while I am executing the following code:
DataSet milestones = new DataSet();
foreach(string sl in serviceLevelList) {
Console.WriteLine(sl);
MySqlDataAdapter adapter = new MySqlDataAdapter(
"SELECT From Table ", dest.Connection);
adapter.Fill(milestones, sl); <- here is where the error
occurs!!!
}
Has anybody an idea how to solve the problem?
thank u very much in advance!
best regards,
dennis 1 1777
I think adapter.Fill method normally is String as the second parameter.
Maybe take a look.
chanmm
"Dennis Kuntzemann" <dk****@web.com> wrote in message
news:e7**********@daniel-new.mch.sbs.de... Hello,
I am trying to get access to an MySql-Server over CSharp. As I am not sure whether it is an csharp or sql driver problem, i am posting it here.
I got the following error:
PM Exception: Object reference not set to an instance of an object. 6/27/2006 12:23:25 PM Stack trace: at MySql.Data.MySqlClient.PacketWriter.WriteStringNoN ull(String v) at MySql.Data.MySqlClient.MySqlCommand.PrepareSqlBuff ers(String sql) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.System.Data.ID bCommand.ExecuteReader(Com mandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at Fact.TestConnect.connect2DB() in c:\Inetpub\wwwroot\Fact\TestConnect.cs:line 114 Cycle finished
while I am executing the following code:
DataSet milestones = new DataSet();
foreach(string sl in serviceLevelList) { Console.WriteLine(sl); MySqlDataAdapter adapter = new MySqlDataAdapter( "SELECT From Table ", dest.Connection); adapter.Fill(milestones, sl); <- here is where the error occurs!!! }
Has anybody an idea how to solve the problem?
thank u very much in advance!
best regards,
dennis
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
Hello.
I am currently working through a book on Dreamweaver and using PHP. I
am having a little trouble with setting up the database though. I
have php 4.2.3 and MySQL 4.0.20a. I am running...
|
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no...
|
by: Morten Gulbrandsen |
last post by:
Hi programmers, Good morning ;-)
I think something is wrong,
Running windows I believe first I have to set some password,
Which creates some user,
Then I can grant the required privileges, for...
|
by: chicha |
last post by:
Hey people,
I have to convert MS Access 2000 database into mysql database, the whole
thing being part of this project I'm doing for one of my faculty
classes. My professor somehow presumed I...
|
by: Murphy |
last post by:
I am new to Linux and am migrating a SQL Server DB with an Access front end
to MySQL and ?
What options are available under Linux for development of a client front end
without copious amounts of...
|
by: ktosiek |
last post by:
hello
how to upload files to mysql database
thanks for help
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: B1ackwater |
last post by:
We've fooled around with Access a bit, but only using the
single-user store-bought version. It seems to be a good
database - versatile and infinitely programmable - and
can apparently be used as a...
|
by: Vanessa |
last post by:
Hi there
I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
| |