Results 1 to 4 of 4

Thread: connecting to PostgresSQL or MySQL

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2000
    Posts
    70

    Question

    Hi,
    I want to *conncect* to a PostgresSQL or MySQL server which is running on another machine, which is easier to do, and is there a standard kind of method to use? I Have MySQLX and havent tried of yet.. Any ideas/tips/pointers/previous experience welcomed..
    Daniel Rose
    VB 5.0 Enterprise.
    irc:irc2.dynam.ac

    If TheCodeInTheSig() Is Not Lame() Then IDontKnowWhatIs()

  2. #2
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    You can use ODBC, which is very hard with mySQL. Alternatively, you can attempt to use the C API, which is a bit of a chore and really not recommended. I'd say you've got the best situation at the moment.
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Apr 2000
    Posts
    70
    hmmm, am i best to use this control then? or can you tell/show me a url on how to use ODBC to connect to it? or as a last resort i could connect to it with winsock which would be a pain in the ass..........
    Daniel Rose
    VB 5.0 Enterprise.
    irc:irc2.dynam.ac

    If TheCodeInTheSig() Is Not Lame() Then IDontKnowWhatIs()

  4. #4
    Lively Member
    Join Date
    May 1999
    Location
    Singapore
    Posts
    116
    go planetsourcecode and search for mysql in the vb section, they teach you how to use myodbc, to connect to mysql databases
    YC Sim
    Teenage Programmer
    UIN 37903254



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