• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 861
  • Last Modified:

Sybase 11 Error

I'm getting the following error (from IIS log) on one ASP in my web:
2010-01-05 16:22:40 W3SVC1765205524 209.184.199.236 POST /detail.asp |100|80004005|[INTERSOLV][ODBC_SQL_Server_driver]
[SQL_Server]ct_con_props(SET_NETIO):_user_api_layer:_external_error:_The_buflen_parameter_must_be_set_to_CS_UNUSED.
80 - 209.184.199.236 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 500 0 0

I'm not getting the error on other pages so I doubt it's a driver issue. There have been no server updates, code changes, or DB changes but app stopped funcitgoning after new year.
0
kevbob650
Asked:
kevbob650
  • 2
1 Solution
 
jlsilva01Commented:
kevbob650,

Try to update sybase client version on the Windows 2003.
The problem related does reference to client problem. (ct_con_props(SET,NETIO): user api layer: external error: The buflen parameter must be set to CS_UNUSED.)

0
 
kevbob650Author Commented:
If it's a client issue, why is it only happening on certain web pages?? That doesn't make sense to me. I was just told the database is on a Windows 2000 box but they should change anything. I think it's time to move the data to Oracle or Sql Server!
0
 
jlsilva01Commented:
I said this, because exists a case in Sybase #10872296 that tell:

CASE DESCRIPTION
Getting message from ODBC about buflen parameter must be set to cs_unused. error message: ct_con_props(SET,NETIO): user api layer: external error: The buflen parameter must be set to CS_UNUSED. (9)

TIP OR WORKAROUND
this issue was related to the setup of the path environment variable and older lib files, it appeared to be picking up library files located in the system32 directory from a previous installation, to rememedy this, move the sybase entries in the path statement to the front and test, if that resolves the issue, then search the system for prevously installed files of an older sybase client (11.1) which may have placed files in the system32 directory and remove them

RESOLUTION
search system for older lib files, and modify path statement to point to new installation of client at the front Other Sources Related to Issue TechNote.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now