Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Question Unanswered: ASP connection to ASE

    Hello,

    We just upgraded a 2 year old webserver and now have the newest drivers on it. I can't get a DSN-less connection to work though. I keep getting the following message.

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [MERANT][ODBC Sybase ASE driver]Insufficient information to connect to the data source.

    I have followed the syntax required to the letter but the connection won't connect.

    Any tips would be appreciated!

    Justin

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Why don't you use the Sybase Provider with the your DSN.

    oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
    "Data source=myASEServer"

    where myASEServer = Your system DSN

  3. #3
    Join Date
    Sep 2003
    Posts
    7
    Did you use dsedit to create the dsn??

    NOTE: From my understanding, we need to use dsedit to create the dsn connection for sybase. The dsedit is available at <sybase driver installation path>\sybase\ocs-12_0\bin

  4. #4
    Join Date
    Sep 2003
    Posts
    2
    Thanks for your input guys, the provider approach solved the problem for most aspects. It wouldn't allow an INSERT operation to perform though on a webform. Have you heard of any problems with the newer drivers in this regard?

    Thanks again,
    Justin

  5. #5
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    ASE .Net Data Provider 1.0 beta download now available
    http://www.sybase.com/asenetprovider10beta

    Originally posted by JustinMt
    Thanks for your input guys, the provider approach solved the problem for most aspects. It wouldn't allow an INSERT operation to perform though on a webform. Have you heard of any problems with the newer drivers in this regard?

    Thanks again,
    Justin

Posting Permissions

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