Results 1 to 10 of 10

Thread: lan based connection with mysql database

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2006
    Posts
    84

    lan based connection with mysql database

    how an i connect my system to a lanbased using a msql datbase pls help me... thank you

  2. #2
    Hyperactive Member Capp's Avatar
    Join Date
    May 2005
    Location
    Texas
    Posts
    409

    Re: lan based connection with mysql database

    This link has proved useful to me. It's pretty well written:

    http://dev.mysql.com/doc/refman/5.1/...programming-vb
    AmazingAntivirus.com
    Remote Data Backups


    Please Mark your Thread "Resolved", if the query is solved...

    If a post has helped you then Please Rate it!

  3. #3
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: lan based connection with mysql database

    See the MySQL connection strings here.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Nov 2006
    Posts
    84

    data.domain.com

    Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername;Password=myPassword;Opt ion=3
    ive got this connection what data.domain.com means....

    im running my mysql database in localhost only and i want to network it to another computer how will i do that

  5. #5
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: data.domain.com

    Server=192.168.1.5 (or whatever is the IP of the computer the database is on)
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  6. #6

    Thread Starter
    Lively Member
    Join Date
    Nov 2006
    Posts
    84

    Re: data.domain.com

    when i replace the server to the ip address i got this error message HOST 'THoTIEBOY' is not allowed to connect to this mysql server.

    what will i do

    thanks

  7. #7
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: data.domain.com help

    An address in your LAN or an address on the internet?
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  8. #8
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: data.domain.com

    Read the other thread I answered, and stop making three threads for the same problem.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  9. #9
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: lan based connection with mysql database

    Duplicate threads merged/deleted - please stop intentionally creating more work for us!

  10. #10
    New Member vbnewbier's Avatar
    Join Date
    Feb 2007
    Location
    127.0.0.1:8080
    Posts
    8

    Re: data.domain.com

    Quote Originally Posted by mheiy
    Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername;Password=myPassword;Opt ion=3
    ive got this connection what data.domain.com means....

    im running my mysql database in localhost only and i want to network it to another computer how will i do that
    Sorry 4 bad english,
    If we want to connect to the database on the Internet, what should we do? Are the host have an ODBC Connector?

    I've stuck at this...
    Pls help, thx...
    Please, feel free to visit my site at Indonesian ORPG Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width