Results 1 to 7 of 7

Thread: [RESOLVED] Connecting to a SQLBase DB using VB6

  1. #1

    Thread Starter
    Lively Member George-LSA's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    126

    Resolved [RESOLVED] Connecting to a SQLBase DB using VB6

    hey

    can someone give me a hand with a SQLBase connection string in VB6

    cant seem to perform a connection for some unknown reason

    thank you

    regards
    Last edited by George-LSA; May 24th, 2005 at 06:48 PM.
    Kind Regards,

    George S
    LSA Australia Pty Limited
    www.lsaa.com.au

    -----------------------------------------

    CCNA and CCNP certified
    Visual Basic 6 Developer
    -----------------------------------------
    Dont forget to Rate a post that Helped you
    And mark a post [RESOLVED] when your problem has been resolved.

  2. #2
    Addicted Member BestS's Avatar
    Join Date
    Mar 2005
    Posts
    222

    Re: Connecting to a SQLBase DB using VB6


  3. #3
    Frenzied Member PilgrimPete's Avatar
    Join Date
    Feb 2002
    Posts
    1,313

    Re: Connecting to a SQLBase DB using VB6

    Or http://www.carlprothman.net/Default.aspx?tabid=81.

    VB Code:
    1. oConn.Open "Provider=SQLBaseOLEDB;" & _
    2.            "Data source=mySybaseServer;" & _
    3.            "Location=mySybaseDB;" & _
    4.            "User Id=myUserName;" & _
    5.            "Password=myUserPassword"

  4. #4
    Addicted Member BestS's Avatar
    Join Date
    Mar 2005
    Posts
    222

    Re: Connecting to a SQLBase DB using VB6

    10x for rating the posts

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Connecting to a SQLBase DB using VB6

    Quote Originally Posted by BestS
    Cool link BestS!

  6. #6

    Thread Starter
    Lively Member George-LSA's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    126

    Re: Connecting to a SQLBase DB using VB6

    Quote Originally Posted by PilgrimPete
    Or http://www.carlprothman.net/Default.aspx?tabid=81.

    VB Code:
    1. oConn.Open "Provider=SQLBaseOLEDB;" & _
    2.            "Data source=mySybaseServer;" & _
    3.            "Location=mySybaseDB;" & _
    4.            "User Id=myUserName;" & _
    5.            "Password=myUserPassword"
    hey mate

    if the data source is on another machine and not on my machine would i just put the server name or do i have to point to the path of the sql base engine???

    thanx
    Kind Regards,

    George S
    LSA Australia Pty Limited
    www.lsaa.com.au

    -----------------------------------------

    CCNA and CCNP certified
    Visual Basic 6 Developer
    -----------------------------------------
    Dont forget to Rate a post that Helped you
    And mark a post [RESOLVED] when your problem has been resolved.

  7. #7

    Thread Starter
    Lively Member George-LSA's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    126

    Re: Connecting to a SQLBase DB using VB6

    hey can someone please help me and answer my question.....

    thank you
    Kind Regards,

    George S
    LSA Australia Pty Limited
    www.lsaa.com.au

    -----------------------------------------

    CCNA and CCNP certified
    Visual Basic 6 Developer
    -----------------------------------------
    Dont forget to Rate a post that Helped you
    And mark a post [RESOLVED] when your problem has been resolved.

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