Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Question Unanswered: Connection Through vb6

    GoodDay Everybody,

    Please help me with the following question. I have read questions regarding this issue, but still don't know how to connect !

    I have written a VB6 application to retrieve/update Sybase data. When I installed it in my client's PC it doesn't recognise the DSN that I pointed to.

    I have tried to Install the Open Client thing, and have tested OK with isql. But still when I run my app., it doesn't work !? I think I did have my dsedit

    I supposed I have to run something (which I dunno what) to trigger the DSN on.

    I have also downloaded the Direct Connection, but don't know how to use it ? Have tried installed it, but still doesn't work !?

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya jmlim,

    Here are few samples for connection strings to ASE

    Using OLE DB Provider for ASE 12/12.5:
    oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
    "Data source=myASEServer"

    Using ODBC:
    oConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
    "Srvr=myServerName;" & _
    "Uid=myUsername;" & _
    "Pwd=myPassword"

    Cheers
    Willy
    Last edited by willy_and_the_ci; 01-06-03 at 18:52.

Posting Permissions

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