Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

java - ODBC Error: Invalid String or Buffer Length--Microsoft Server 2008 32bit vs 2008 R2 64bit -


attempting connect java 6 console app microsoft sql server 2008 r2 on microsoft windows server 2008 r2 64bit system via odbc system dsn using sql server native client 10.0. following source code:

        try         {             class.forname("sun.jdbc.odbc.jdbcodbcdriver");             string srcurl = "jdbc:odbc:foo";             if (dbc == null)             {                 dbc = drivermanager.getconnection(srcurl);                 dbc.settransactionisolation(connection.transaction_read_uncommitted);             }             else             {                 dbc.close();                 dbc = drivermanager.getconnection(srcurl);                 dbc.settransactionisolation(connection.transaction_read_uncommitted);             }         }         catch (classnotfoundexception cx)         {             system.out.println("class not found");         }         catch (sqlexception sx)         {             system.out.println("sql exception: " + sx);             log.info("sql exception: " + sx);     } 

throws error

java.sql.exception [microsoft] [odbc driver manager] invalid string buffer length

maddeningly, same code, , odbc system dsn configured in exact same way, works ms server 2008 32bit (non-r2) , ms sql server 2008 r2. microsoft odbc driver dlls between 2 systems different versions, 6.0.xxxx vs 6.1.xxxx, suspect culprit.

yeah odbc manager version should problem. below problem ran , solution thought of, hope might of else too.

when trying run query against system odbc dsn (ms access .mdb file) app deployed jboss 4.x, same error: "sql state [s1090]; error code [0]; [microsoft][odbc driver manager] invalid string or buffer length" in windows server r2.

i reproduced same error on 2 different windows server r2 machines. on windows server standard (i guess r1) , windows 7 professional x64 problem not reproducible.

further more, on same windows server r2 when trying connect directly (from standalone app), don't problem. if application won't connect/detect data source, you'd error saying there no such dsn name or it's not found. same error message thrown when trying send empty query odbc data source (registered data source name - dsn). guess odbc gets empty query tries execute against ds , result is: invalid string or buffer length.

since can read .mdb file registered odbc ds given dsn, , don't error when querying standalone app, i'm going make standalone app read .mdb file through odbc , write content .csv file, jboss apps read.

if finds better solution, please let me know.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -