Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > MySQL > ODBC try to connect Internet first

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-06-03, 08:39
dibap dibap is offline
Registered User
 
Join Date: Jul 2003
Location: Stuhr/germany
Posts: 4
ODBC try to connect Internet first

Hello,

I just started with MySQL. Every time when I want to start an ODBCconnection with MySQL ODBC 3.51 driver the internet connection dialog pops up first. After canceling the connection happens correct. How can I prevent this dialog? The MySQL-Server is in the same Network. The driver should find it immediate.

the database is running on an Win2K computer. The client computer is running WinME. I Set Up an Class C Network. Both computers have fixed IP-adresses with Subnetmask 255.255.255.0.

the parameters for the ODBC-Driver:
Datasourcename: MySQL
Driver: MySQL ODBC 3.51 driver
Host/Server: -IP-adress-
Database: none
User: none
PWD: none

I guess it is only a simple configuration in the Network of Win. Please give me a hint.

dibap
Reply With Quote
  #2 (permalink)  
Old 07-06-03, 11:53
bstjean bstjean is offline
Registered User
 
Join Date: Sep 2002
Location: Montreal, Canada
Posts: 219
Re: ODBC try to connect Internet first

Quote:
Originally posted by dibap
Hello,

I just started with MySQL. Every time when I want to start an ODBCconnection with MySQL ODBC 3.51 driver the internet connection dialog pops up first. After canceling the connection happens correct. How can I prevent this dialog? The MySQL-Server is in the same Network. The driver should find it immediate.

the database is running on an Win2K computer. The client computer is running WinME. I Set Up an Class C Network. Both computers have fixed IP-adresses with Subnetmask 255.255.255.0.

the parameters for the ODBC-Driver:
Datasourcename: MySQL
Driver: MySQL ODBC 3.51 driver
Host/Server: -IP-adress-
Database: none
User: none
PWD: none

I guess it is only a simple configuration in the Network of Win. Please give me a hint.

dibap


1-You are trying to connect via ODBC with what? a VB app, Access, something else?

2-Have you tried supplying a user and a password?

3-Can you connect to a MySQL database with the mysql client?
Reply With Quote
  #3 (permalink)  
Old 07-06-03, 17:31
dibap dibap is offline
Registered User
 
Join Date: Jul 2003
Location: Stuhr/germany
Posts: 4
1. I try to connect mainly via PurBasic. But it dosn't matter, the Internet connection Dialog pops up also when I connect with MySQL-Monitor. After canceling the Internet-Dialog the Database-connection is OK.

2. Yes, without User and Password it was impossible to connect.

3. If the MySQL-Monitor is a Client as You asked for, Yes ( see above ). I didn't try anything else.
Reply With Quote
  #4 (permalink)  
Old 07-06-03, 22:57
qha_vn qha_vn is offline
Registered User
 
Join Date: Jan 2003
Location: Vietnam
Posts: 188
dibap, are you using windows? if yes, may need to take a look at the network configuration. is your mysql server 's ip of the same subnet as the client pc?
__________________
qha_vn
Reply With Quote
  #5 (permalink)  
Old 07-07-03, 08:11
dibap dibap is offline
Registered User
 
Join Date: Jul 2003
Location: Stuhr/germany
Posts: 4
Yes, I am using Windows. As I mentioned in my first request, on the Server W2K and on the Client WinME. Both are in a Class C-Net ( 192.168.10.XX - Subnetmask 255.255.255.0 ).

I can reach the MySQL-Server, but the ODBC-Driver tries to reach the Internet first. I don't understand why.
Reply With Quote
  #6 (permalink)  
Old 07-07-03, 17:34
bstjean bstjean is offline
Registered User
 
Join Date: Sep 2002
Location: Montreal, Canada
Posts: 219
Quote:
Originally posted by dibap
Yes, I am using Windows. As I mentioned in my first request, on the Server W2K and on the Client WinME. Both are in a Class C-Net ( 192.168.10.XX - Subnetmask 255.255.255.0 ).

I can reach the MySQL-Server, but the ODBC-Driver tries to reach the Internet first. I don't understand why.


Have you trying specifying the computer name instead of the IP address?
Reply With Quote
  #7 (permalink)  
Old 07-07-03, 23:11
qha_vn qha_vn is offline
Registered User
 
Join Date: Jan 2003
Location: Vietnam
Posts: 188
Quote:
Originally posted by dibap
Yes, I am using Windows. As I mentioned in my first request, on the Server W2K and on the Client WinME. Both are in a Class C-Net ( 192.168.10.XX - Subnetmask 255.255.255.0 ).

I can reach the MySQL-Server, but the ODBC-Driver tries to reach the Internet first. I don't understand why.


its quite strange, have no idea now but have you tried pinging the mysql server's IP to see if windows will try to connect (dont connect to internet first) and see if it can ping the address without error like 'destination host unreachable'

second thing to do perhaps fully scan you PC with updated virus definition

hope this helps
__________________
qha_vn
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On