Hello,
I using a "SQL Server 2008" runing on a "Windows Server 2008 Standard" operating system.
If I connect the first time to the SQL-Server with SQL-Talk using a ODBC-Connection the connection is fast. Also the following SELECT statements are fast. But if I made a disconnect and after that a connect. Then the connection is more then 10 time slower. The only what helps is to close SQLTalk and start again.
If i using a other Machine to connect to this Server, i do not have this problems.
I have also the same configuration on a other Plant, there I also do not have this Problems. So i believe that there is a Problem in the Windows setup on this particular computer. Because all other Setting are the same in compare to the other Plant (ODBC-Driver, ODBC-Settings, SQL.INI settings, Unify drivers).
I do not believe there is a Problem with the SQL-Sever, because other computer can connect without Problems. All computer use the same login to the SQL-Server.
Does anybody have an idea, where the problem is?
(you can answer in german or english)
Thanks and best regards
Andre
Second connection to SQL Server 2008 slow
General discussion forum about all databases other than SqlBase.
1 post
• Page 1 of 1
Second connection to SQL Server 2008 slow
Post by Andre Sperling » 21 Mar 2011, 07:17
1 post
• Page 1 of 1
Return to “General Discussion”
Jump to
- General
- ↳ OpenText Gupta Announcements & News
- ↳ General Discussion
- ↳ Forum Discussion
- ↳ Tools, libraries, Samples & Tips
- ↳ M!Table & M!Image
- ↳ TDAppTools
- ↳ Enhancement suggestions
- ↳ Jobs, Promotions & Marketing
- ↳ Polls & Surveys
- Team Developer 7.x
- ↳ General Discussion TD 7.x
- ↳ Bug Reports
- Team Developer 5.x and 6.x
- ↳ General Discussion TD 5.x and 6.x
- ↳ Bug Reports
- Version independent Q & A (and older ANSI versions up to v4.2)
- ↳ General Discussion (TD version independent, non specific)
- ↳ Bug Reports (TD 4.2 and older)
- SqlBase & Connectivity
- ↳ SqlBase General Discussion
- ↳ SqlBase Bug Reports
- ↳ Other databases (Oracle, Sybase, SQL Server, MySql, PostgreSQL etc)
- ↳ General Discussion
- ↳ Bug Reports
- Report Builder
- ↳ General Discussion Report Builder
- ↳ Bug Reports
- TD Mobile
- ↳ General Discussion TD Mobile
- ↳ Tools & Samples
- ↳ Bug Reports
- Newsgroups ( newsgroup.guptaworldwide.com & talkto.guptaworldwide.com )
- ↳ Gupta newsgroups/usenet (years 1995-2010)
- ↳ comp.databases.gupta
- ↳ advanced.programming
- ↳ gupta.bugreport
- ↳ gupta.faq
- ↳ gupta.jobnet
- ↳ gupta.marketing
- ↳ gupta.wishlist
- ↳ forum.sqlbase
- ↳ forum.sqlhost
- ↳ forum.sqlwindows
- ↳ td.cdk
- ↳ td.connectivity
- ↳ td.development
- ↳ td.reportbuilder
- ↳ td.sourcecode
- ↳ td.tom
- ↳ td.web
- ↳ 3rdparty.tools
- ↳ TekTips
- Community Links
- ↳ Team Developer WIKI
- ↳ Team Developer Sample Vault
- ↳ OpenText Forum
- ↳ Other web resources
- ↳ LinkedIn Networking Group
- ↳ Thomas Uttendorfers blog
- ↳ MICSTO
- ↳ Narod
- ↳ Christian Schubert
- ↳ Ivano Osti
- ↳ CMH.Tools
- ↳ YouTube channel: TD Wiki
- ↳ YouTube channel: OpenText Gupta
- ↳ Facebook: OpenText Gupta
- ↳ Tek-Tips - SqlBase
- ↳ Tek-Tips - Centura solutions (discontinued)
Who is online
Users browsing this forum: [Ccbot] and 2 guests