Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    2

    Wink Unanswered: ADO & Sybase connection

    Hello:
    I'm new in sybase.

    The Condition:
    I have create Database in Sybase Adaptive Server using the "sa" username.my database name is "tms" and also create table inside it.I have seen a power builder sample that connect to odbc using *.db file. When I open Power builder under File|connect|setup my Database is in "SYC Sybase SQL Server 10.X&11.X" where by the other database *.db file is at ODBC.

    My problem is:
    I need to establish Ado data connection for the ASP web application. I need it badly.
    e.gome sort like this "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Elpunco.mdb;Persist Security Info=False"

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _
    "Srvr=myASEServer,5000;" & _
    "Catalog=myDBName;" & _
    "User Id=myUserName;" & _
    "Password=myUserPassword"

  3. #3
    Join Date
    Sep 2003
    Location
    Malaysia
    Posts
    2
    Thank you Willy.. I'll try soon.

Posting Permissions

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