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 10 2763
"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/>
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/>
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/>
"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/
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/
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
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
"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/
"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/
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: AF |
last post by:
I am a real novice to php and MySQL, with about a week's worth of
reading and self tutoring. I have an urgent need to publish a
database of information and need some guidance on how to do this.
...
|
by: Sarah Tanembaum |
last post by:
Though I installed MySQL5 and PHP5, how come my phpinfo() shows as follow:
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.57 <<<<<<<<<<<<<<<
...
|
by: Raju V.K |
last post by:
I am developing a web site which requires a set og unique values be
transferred between pages and server many times. There fore i decided
to put the values in an array so that only one reference to...
|
by: Jeremy Booker |
last post by:
I installed the current stable release of MySQL from RPMs. I used the client
and server packages.
After installing the server package, the RPM printed a note saying I should
run two commands. I...
|
by: Jamie Krasnoo |
last post by:
Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in
startup.pl to load them up for multiple handlers have any bad side
effects? I noticed that when I load them via startup.pl the...
|
by: MLH |
last post by:
A programmer developed an AMP (Apache/MySQL/PHP) application
for me. When he was done, he sent me the PHP files and the MySQL
dump file. Now, when I connect to the application on my LAN using...
|
by: 21novembre |
last post by:
Hi all,
I made a question several days before to describe my strange trouble of
mysqldump. But I still can't figour it out. Well, I just want to ask
another question whether I could just backup...
|
by: zhengfish |
last post by:
Hi,All,
I try to install mysql-5.0.15 on RHEL3-U5.
But It give me a error.
MySQL-client-standard-5.0.15-0.rhel3.i386.rpm
MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm...
|
by: John Wells |
last post by:
Guys,
My boss has been keeping himself busy reading MySQL marketing pubs,
and came at me with a few questions this morning regarding PostgreSQL
features (we're currently moving to PostgreSQL).
...
|
by: subho2009 |
last post by:
Hello friends,
I have face a problem, the problem is that when i fetch data from mysql database i get '&' in the place of '&'. I am using php 5.1.2 and mysql version 5.0.11-beta.
What is the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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,...
| |