Re: ODBC.ini parameter in FreeTDS
"Rajesh Akolu" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, Thanks for the response. We have tried the PacketSize option using following: Case 1 : ODBCConfig --> User DSN --> Configure --> "We entered 512 against PacketSize" Case 2 : We used following connecting string in our code (here we did not specify PacketSize using ODBCConfig): "DRIVER=FreeTDS; SERVER=ftcpu1164; DATABASE=pubs; UID=<user name>; PWD=<password>; PacketSize=512" In both the above cases we did not see any performance difference. The same result was observed when we did not specify PacketSize in both the above cases. Please suggest Thanks in Advance Thanks & best regards, Rajesh Akolu Financial Technologies (India) Ltd. [email protected] www.ftindia.com Disclaimer: The information in this E-mail (which includes any files transmitted with it) is CONFIDENTIAL and may be legally PRIVILEGED. It is intended solely for the addressee and access to this email by anyone else is unauthorized. If you have received it in error, please destroy any copies of this message, including any attachments, and delete it from your system notifying the sender immediately. Any disclosure, copying, distribution, dissemination, forwarding, printing or any action taken or omitted to be taken in reliance on it or utilising the same for any purpose other than what it is intended for, is prohibited and may be unlawful. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James K. Lowden Sent: Friday, April 25, 2008 7:06 PM To: FreeTDS Development Group Subject: Re: [freetds] ODBC.ini parameter in FreeTDS Rajesh Akolu wrote: > We are using FreeTDS 0.64 (TDS version 8.0) and unixODBC 2.2.12 on RH Linux 3.4.6 and connecting to Microsoft SQL Server 2000 from Linux. We are using > C++ on Linux. > We are looking for complete list of parameters which can be used in > "ODBC.ini" specific to freeTDS. http://www.freetds.org/userguide/odbcconnattr.htm http://freetds.cvs.sourceforge.net/freetds/freetds/src/odbc/convert_tds2 sql.c?view=log It's free software, yaar! The only option that even *might* affect performance is PacketSize. The optimal size depends on the network and the application. --jkl _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds