
| email this FAQ to a colleague
Q: My ODBC database has a text field of length 7. However if the field only contains 1 character, the ODBC returns a field containing the letter followed by 6 spaces. How do I fix the problem? A: Try using varchar in SQL Server instead of char, or You can do a RTRIM on the value. - Wayne Berry | Articles | | May 31, 1997 - Connection Pooling with ASP | | Connection pooling might be the easiest way to speed up your dynamic web pages reading from SQL Server. Unfortunately, connection pooling within is turned off by default in Active Server pages. Probably because connection pooling is rarely understood in its entirety. This issue discusses connection pooling with ASP, ISAPI, IDC, and Visual Basic applications. Included is a discussion about ODBC 3.0 and the newest bug fix for ODBC. [Read This Article] [Top] |
| |
|