|
|
Choosing A Webhost: |
RE: new configuration settings: msg#00246db.tds.freetds
> > Thanks a lot James, > > I'll test it out the disable-iconv stuff on Monday. > > fair exchange is no robbery, as they say. I'll submit my > patch early next > week. > I got kind of absorbed with getting the > ctlib/unittests/lang_ct_param program > working against SQL Server, as someone has expressed an > interest in getting > that sorted. > > Bill About lang_ct_param: this test never worked. The simple reason is that this function use a Sybase version of TDS_LANGUAGE token. MSSQL support language only in language packet so you have to use prepared statement to use parameters (or build a string, possible but not good for performance). Current code use sp_executesql but is broken. Calling sp_executesql is a good solution but require that all parameters have a correct name. For example you can call sp_executesql with EXEC sp_executesql, N'insert into test(i) values(@i)', N'@i INT', 123 If you set parameters without names tds_submit_query_params build a parameter string (the N'@i INT' above) without names (N' INT') that's wrong... The solution should be parse query string and find parameters ('insert into test(i) values(@i)' -> @i) and set in params parameters. Also you should skip 'declare @name type' statements... freddy77
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | RE: __func__ vs. __FUNCTION__, ZIGLIO Frediano |
|---|---|
| Next by Date: | RE: new configuration settings, Thompson, Bill D (London) |
| Previous by Thread: | Re: new configuration settings, James K. Lowden |
| Next by Thread: | RE: new configuration settings, Thompson, Bill D (London) |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |