By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

VB & MySQL

P: n/a
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.

--
Bob Hollness

-------------------------------------
I'll have a B please Bob
Nov 21 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
"Bob Hollness" <bo*@blockbuster.com> schrieb:
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.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 21 '05 #2

P: n/a
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

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...
"Bob Hollness" <bo*@blockbuster.com> schrieb:
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.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 21 '05 #3

P: n/a
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

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...
"Bob Hollness" <bo*@blockbuster.com> schrieb:
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.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>


Nov 21 '05 #4

P: n/a
"Bob Hollness" <bo*@blockbuster.com> wrote in
news:#R**************@TK2MSFTNGP09.phx.gbl:
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?
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #5

P: n/a
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

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .
"Bob Hollness" <bo*@blockbuster.com> wrote in
news:#R**************@TK2MSFTNGP09.phx.gbl:
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?
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Nov 21 '05 #6

P: n/a
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" <bo*@blockbuster.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
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.

--
Bob Hollness

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

Nov 21 '05 #7

P: n/a
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.

--
Bob Hollness

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

"Bob Hollness" <bo*@blockbuster.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
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.

--
Bob Hollness

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

Nov 21 '05 #8

P: n/a
"Bob Hollness" <bo*@blockbuster.com> wrote in
news:ue*************@TK2MSFTNGP12.phx.gbl:
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 (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #9

P: n/a
"Bob Hollness" <bo*@blockbuster.com> wrote in
news:eg**************@TK2MSFTNGP11.phx.gbl:
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 : )

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #10

P: n/a
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
Nov 21 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.