3 Replies - 2383 Views - Last Post: 19 February 2013 - 04:01 AM Rate Topic: -----

#1 nethan  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 09-February 13

lan-based connection in vb 6.0

Posted 10 February 2013 - 06:24 AM

 [mysql][ odobc 5.1 driver] can't connect to mysql server
Option Explicit
Global conn  As New ADODB.Connection
Global rs As New ADODB.Recordset

Sub Main()
    Dim strclient As String
    Dim strserver As String
    conn.CursorLocation = adUseClient
    'conn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Mode=ReadWrite;Driver=MySQL ODBC 5.1 Driver;SERVER=%192.168.0.3;UID=nethan;DATABASE=dbcaltex1;PWD=nethan;SOCKET=MySQL;PORT=3306"
    conn.ConnectionString = "Driver=MySQL ODBC 5.1 Driver;SERVER=192.168.0.3;UID=nethan;PWD=nethan;DATABASE=dbcaltex1;SOCKET=MySQL;PORT=3306"
    conn.Open
    If conn.State = adStateOpen Then
    frmmenu.Show
    End If
End Sub

rhis is my module please help me to lan base my system 


Is This A Good Question/Topic? 0
  • +

Replies To: lan-based connection in vb 6.0

#2 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 5578
  • View blog
  • Posts: 11,918
  • Joined: 02-June 10

Re: lan-based connection in vb 6.0

Posted 10 February 2013 - 07:57 AM

"Please help me" doesn't tell us what problem you are running in to.


Your assignment is to do this in VB6? You're deliberately going to school to learn a language that's been dead for a decade? Should this be moved to VB.NET?

Please read: This is not the VB.NET forum
Please read: Is learning VB6 now a complete waste of time?

Q:... how to do x,y,z with a database {probably for the first time}...
A: Read this tutorial
Entire section of tutorials
Parameterizing Your SQL Queries: The RIGHT Way To Query A Database.
Using SqlDependency to monitor SQL database changes

This post has been edited by tlhIn`toq: 10 February 2013 - 07:58 AM

Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: lan-based connection in vb 6.0

Posted 10 February 2013 - 09:32 AM

Where you have your server name, just put the server name for the server. Congrats, you're "lan-based." :)
Was This Post Helpful? 0
  • +
  • -

#4 nethan  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 09-February 13

Re: lan-based connection in vb 6.0

Posted 19 February 2013 - 04:01 AM

that's right !! i want to learn VB.Net and asp.net
by my own

i do this for my subject

thank you for suggestion

i do that. . i add my server name to my module but system says"the host is not allowed to access my MYSQL Server

Please help me!!! this is my problem
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1