Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Time Out Expires in VB

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  Problem with Network  
Author Message
Robert95

External


Since: Aug 25, 2004
Posts: 28



(Msg. 1) Posted: Mon Jan 16, 2006 2:00 pm
Post subject: Time Out Expires in VB
Archived from groups: microsoft>public>vb>database>odbc (more info?)

Hello,

I have a program written in vb 6 that gets data from SQL Server 2000 through
a stored procedure. SQL Server is contained on a seperate server. On a
client machine, connected by ODBC driver, the stored procedure executes very
slow and causes a time out error. I ran the program on my development
machine which is close to the server, and it ran without the time out error,
but still ran slow. I tried running the stored procedure from query analyzer
and the results are returned in less than a second. Can anyone tell me why
it runs so slow on the vb client side? Any help would be greatly appreciated.

Thanks.

 >> Stay informed about: Time Out Expires in VB 
Back to top
Login to vote
Jay Taplin

External


Since: Jan 16, 2006
Posts: 1



(Msg. 2) Posted: Mon Jan 16, 2006 2:25 pm
Post subject: Re: Time Out Expires in VB [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Just for the fun of it, can you change your connect type to something
more
direct, rather than ODBC, just to see if that's the problem?

Jay Taplin MCP

 >> Stay informed about: Time Out Expires in VB 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
HOWTO: Clone SQL db ? - Hi all, I'm having a SQL Server database called X. For testing and training, I would like to make a copy of the entire DB to Y. This copy should include all data, properties, indexes, views, etc. Unfortunately, all my attempts to automate this..

Change connect string for Excel Queries using an ODBC Driver - Reference: ODBC Connection for MAS90 MAS200 In Excel we have an ODBC Connection String with a physical (hard coded) path to the data. We have changed the servers. We do not want to recreate all of the queries. How can we edit the ODBC path inside of..

ISA 2006 with My sql Connection - Hi, Please help me,acutually I am facing problem with ISA 2006.It does not connect Mysql data base. It is giving error"Can't connect to Mysql server on "IP" 10060."

Compile Error - Can anyone please help me to solve this problem I have when I tried to compile and run my program written in VB 6.0? Problem: I used variable declaration such as db as Database and ws as Workspace. I use ODBC way to connect my VB form interface with....

ISAM driver query - Hi, I am developer in Visual Basic 6.0 and SP4 application development and database use MS Access XP and SQL 7.0. This field last 6years and I am use Clipper 5.3, 5.2(Compiler) and Foxpro 2.6, Dbase IV(Database). At now I am totaly convert in VB so I am...
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]