0 Replies - 1630 Views - Last Post: 20 August 2009 - 11:46 PM Rate Topic: -----

#1 mahki   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 13
  • Joined: 01-October 06

vb6 can't connect to mysql lan server

Posted 20 August 2009 - 11:46 PM

On Error GoTo errmsg
Set enr_conn = New ADODB.Connection
enr_conn.CursorLocation = adUseClient
enr_conn.CommandTimeout = 0
enr_string = "Driver={MySQL ODBC 5.1 Driver};Server=;Port=3307;Database=dbolo;User=root;Option=3;"
enr_conn.Open enr_string

so im trying to make a client connection to a server/dedicated server via router as well as PC to PC but it always say i cant connect then i get the following errors like
- I cant access this IP
- host "compname" not allowed to access this server
and other stuff like that.

I read that i should change my server port from 3306 to 3307 don't know why so i just tried it.

sometimes i try to delete my ODBC in my computer if that affects the connection. altough no luck for me

-I am trying to connect to a wifi laptop and i also try at lan ready desktops as well
-I have established their network places so pretty much they can see each other if that does affect
-I am using ODBC mysql 5.1
-I got my string at connectionstrings.com
have also tried from remote string to TCP/IP no luck

Is there a remedy for this?
are there other types/methods i can use so i can just make a client server connection using Mysql and VB6?

help please...

This post has been edited by mahki: 21 August 2009 - 10:27 AM

Is This A Good Question/Topic? 0
  • +

Page 1 of 1