VB & MySQL

[Bob Hollness]

AAARRRGHHH!!! I fix my server, well, I rebuilt it actually. It runs Suse
9.2 and MySQL 4.0.21


When I try to do a Recordset.Update I get the following error.

Error Number = -2147217871
Error Message = [MySQL][ODBC 3.51 Driver][mysqld-4.0.21]Can't create TCP/IP
socket (10093)

This happens whether it is an update or a MoveNext.

The code used to work and I have not changed anything (AFAIK) so, any ideas?
It is not a firewall issue as far as I can tell, nor a problem with
permissions.

 

[Herfried K. Wagner [MVP]]

AAARRRGHHH!!! I fix my server, well, I rebuilt it actually. It runs Suse
9.2 and MySQL 4.0.21


When I try to do a Recordset.Update I get the following error.

Error Number = -2147217871
Error Message = [MySQL][ODBC 3.51 Driver][mysqld-4.0.21]Can't create
TCP/IP socket (10093)

This happens whether it is an update or a MoveNext.

What's the relation to VB.NET?! I suggest to post this question to a
standard ADO/MySQL group.

 

[Bob Hollness]

Because I am using VB.Net to make the connection and I was wondering if
anyone else here had had the same problem.

--
Bob Hollness

-------------------------------------
I'll have a B please Bob

AAARRRGHHH!!! I fix my server, well, I rebuilt it actually. It runs
Suse 9.2 and MySQL 4.0.21


When I try to do a Recordset.Update I get the following error.

Error Number = -2147217871
Error Message = [MySQL][ODBC 3.51 Driver][mysqld-4.0.21]Can't create
TCP/IP socket (10093)

This happens whether it is an update or a MoveNext.

What's the relation to VB.NET?! I suggest to post this question to a
standard ADO/MySQL group.

 

[Cor Ligthert]

Bob,

Because I am using VB.Net to make the connection and I was wondering if
anyone else here had had the same problem.

The change is very low
Using MySQL with VBNet I have the idea it is most Access and than SQL and
than Oracle
Using ODBC with VBNet I know that it is most OleDb and dan SQLClient and
than OracleClient
Using AdoDB with VBNet I know that it is most ADONET

So a very low change in my opinion, however you never know.

Using this text of yours you can find forever a reason to post to this
newsgroup, however I think than that there are a lot more that fit the
sentence. "I am using". Maybe do you have a LCD screen, than you can sent
this question to a newsgroup for LCD's as well.

However just my idea. Feel free to post here.

Cor

--
Bob Hollness

-------------------------------------
I'll have a B please Bob

AAARRRGHHH!!! I fix my server, well, I rebuilt it actually. It runs
Suse 9.2 and MySQL 4.0.21


When I try to do a Recordset.Update I get the following error.

Error Number = -2147217871
Error Message = [MySQL][ODBC 3.51 Driver][mysqld-4.0.21]Can't create
TCP/IP socket (10093)

This happens whether it is an update or a MoveNext.

What's the relation to VB.NET?! I suggest to post this question to a
standard ADO/MySQL group.

 

[Lucas Tam]

AAARRRGHHH!!! I fix my server, well, I rebuilt it actually. It runs
Suse 9.2 and MySQL 4.0.21


When I try to do a Recordset.Update I get the following error.

Error Number = -2147217871
Error Message = [MySQL][ODBC 3.51 Driver][mysqld-4.0.21]Can't create
TCP/IP socket (10093)

This happens whether it is an update or a MoveNext.

But the select/login works fine?

Perhaps go into the debugger and see if there is any data in the recordset
at all?

 

[Bob Hollness]

Lucas, thanks again! The recordset is populated and i can update it but
when i go to write the changes back to the DB using .Update it doesn't like
it. I was up for hours working on this problem and i think i am gonna give
up. :-(

--
Bob Hollness

-------------------------------------
I'll have a B please Bob

AAARRRGHHH!!! I fix my server, well, I rebuilt it actually. It runs
Suse 9.2 and MySQL 4.0.21


When I try to do a Recordset.Update I get the following error.

Error Number = -2147217871
Error Message = [MySQL][ODBC 3.51 Driver][mysqld-4.0.21]Can't create
TCP/IP socket (10093)

This happens whether it is an update or a MoveNext.

But the select/login works fine?

Perhaps go into the debugger and see if there is any data in the recordset
at all?

 

[chanmmn]

Don't rush to VB.NET first. Try to test your ODBC from the Control Panel ->
Administration Tools -> Data Source (ODBC). If you cannot connect from there
then it could be the configuration of your MySQL or ODBC.

I suggest you post the ADO.NET code to ADO.NET newsgroup after you try you
ODBC.

chanmm

 

[Bob Hollness]

Thanks Lucas and Chanmmn. I just solved it. I had opened a connection
previously and had commented out the close statement. As soon as i removed
the comment mark it all worked.

 

[Lucas Tam]

Lucas, thanks again! The recordset is populated and i can update it
but when i go to write the changes back to the DB using .Update it
doesn't like it. I was up for hours working on this problem and i
think i am gonna give up. :-(

Did you set the UpdateCommand in the DataAdapter?

Wild Guess: Do you have write permissions set properly on the directory
hosting MySQL's data files?


Last idea: Maybe try another driver? Are you using the .NET driver?

 

[Lucas Tam]

Thanks Lucas and Chanmmn. I just solved it. I had opened a
connection previously and had commented out the close statement. As
soon as i removed the comment mark it all worked.

I hate errors like that... drives you nuts : )

 

[Cor Ligthert]

Lucas,

This is about ADODB see the "recordset" and the "MOVENEXT" in the question.

There can be a dataadapter, because there is one overloaded version which
"reads" a recordset, however you cannot update than that "recordset".

Cor