Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - ASP memory leak??? Disappearing fields?? plz help!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ASP memory leak??? Disappearing fields?? plz help!
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
FLATLINE View Drop Down
Groupie
Groupie
Avatar

Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142 		Post Options Post Options   Thanks (0) Thanks(0)   Quote FLATLINE Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 4:52pm
DSN ODBC...
Visit my site: DarkGreen HQ
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 5:12pm
I have found very strange and unpredictable results with recordsets before just like you mention when using the ODBC driver with SQL Server.

This is why always avoid this driver driver and use the SQL OLE DB driver instead with a DSN-less connection. Do a search on Google for Provider=SQLOLEDB to get the exact driver string you need.

The OLE DB driver is also faster, and DSN-less connections are also faster, so this combination would be faster and more stable.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 5:16pm
SQLOLEDB connection string:
"Provider=SQLOLEDB;Server=localhost;User ID=DBUsername;Password=DBPassword;Database=DBName";"
Back to Top
FLATLINE View Drop Down
Groupie
Groupie
Avatar

Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142 		Post Options Post Options   Thanks (0) Thanks(0)   Quote FLATLINE Quote  Post ReplyReply Direct Link To This Post Posted: 21 November 2007 at 7:36pm
I see. Well that's quite a bummer. I hoped I could use DSN connections for more ease and integrity... Guess it's back to the whiteboard.
 
Thanks for your help borg, you're the best Thumbs%20Up
Visit my site: DarkGreen HQ
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.