kevbob650
asked on
Sybase Error
I have an asp site with Sybase 11 db. I'm getting an error "buflen must be cs_unused" when I attempt to open a page and when I refresh, the error goes to "catastrophic failure". Not sure where to update the buflen value?? The Sybase db is working okay, able to query via the sql advantage tool.
set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "DSN=SERVER;UID=id;PWD=pwd"
conn.open
SQL_Nodes = "SELECT * from node Order by sortkey(Node,'altnocsp')"
set Nodes = conn.Execute(SQL_Nodes,,adCmdText)
ASKER
Bill,
Sorry, I'm not a Sybase guy, never worked with it! The db is Sybase System 11 with ODBC Driver v 11.1. This is an issue where I'm moving old code to a new server, both boxes are windows 2003 with IIS 6.0.
I think I just found an issue, the Sybase client is showing sybase odbc drive for win95 - ouch. It's the only driver I cound find. OS is Windows 2003. Where can I find more current drivers?
thanks,
Kevin
Sorry, I'm not a Sybase guy, never worked with it! The db is Sybase System 11 with ODBC Driver v 11.1. This is an issue where I'm moving old code to a new server, both boxes are windows 2003 with IIS 6.0.
I think I just found an issue, the Sybase client is showing sybase odbc drive for win95 - ouch. It's the only driver I cound find. OS is Windows 2003. Where can I find more current drivers?
thanks,
Kevin
O.K., You still have no clarified which product; Adaptive Server Enterprise or SQL Anywhere (Adaptive Server Anywhere). You also have not told me whether you are having problems with "the old server" or "the new server".
By moving code, are you simply trying to pick up the whole system, database server and all, and move it to a newer system/OS?
Please be specific out platforms, O/S (client and server), and Database.
You can use the query tool and issue the query...
SELECT @@version
go
and it will return detailed product and version information.
Regards,
Bill
By moving code, are you simply trying to pick up the whole system, database server and all, and move it to a newer system/OS?
Please be specific out platforms, O/S (client and server), and Database.
You can use the query tool and issue the query...
SELECT @@version
go
and it will return detailed product and version information.
Regards,
Bill
ASKER
Well the whole thing crashed. Here is the spec on the version of Sybase running on my old server where it works. Can I get this one anywhere?
Adaptive Server Enterprise/11.9.2.1/1108/P /SWR 8741 ESD 4/NT (IX86)/OS 3.51,4.0/FBU/Wed Dec 01 12:01:38 1999
Adaptive Server Enterprise/11.9.2.1/1108/P
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
- Is this all new code?
- Does this table/query return more rows that what I am typically doing on the site?
- Did versions of anything change? Tell us that you do not have Automatic Updates enabled
What Sybase product and version are you using? Sybase 11 is, at best, ambiguous. It could be the brand spanking new version of ASA or an old broken down version of ASE.
Unless you are building an entirely new application, (seems unlikely on a ASE 11 but probably on ASA 11), some of this kind of thing has been working. You can look at the various ODBC parameters to see if there are any options that might be affecting this. Again, they will be different between the two products.
Finally, if this infrastructure is new, you may have a mismatch in versions, particularly ODBC drivers. Use the ones supplied with the client installation for the version of the database you are using, not the ones supplied by Microsoft.
Regards,
Bill