Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rpc86
Posting Yak Master
200 Posts |
 Posted - 2007-09-17 : 22:47:42
|
| Hi guys,My question is all about error when sending and receiving datafrom AS/400 to VB. Forgive me if this question is not suited for this forum. I've been posting my question to many forum sites but no replies have been yet received.Below is the list of software we use to develop our project:1. VB6 with service pack 62. MS SQL Server 2005 3. MDAC 2.74. Crystal Report version 105. Windows XP sp 26. Visual Basic 6 Installer7. AS/400 8. OS/4009. DB210. .NET Framework---------------------------------------------------------------------The Problem:Our users encounter "timeout" when printing records in an on-line environment. The VB6 interface will send messages to AS/400 then AS/400 will send result data (1KB per sending) to VB6 to be printed. Say we're expecting 20 lines of printing. After the 12th line is printed, a generic error "Timeout" is pop-up.We adjusted the connection-timeout setting to 500 or even 3000 but this did not help our problem.On my computer side, the printing runs smoothly and no errors occur. I tried to clone 1 computer (my computer is the source), and the result is good.1. Do I need to install full-versions of VB6, Crystal Report 10, MS SQL Server 2005, .NET Framework 2 to our users ??2. Is it a network concern ?Please help.Thank you. |
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2007-09-18 : 02:58:46
|
| PLEASE, PLEASE, PLEASE .... HELP Thank you !!!! |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:49:42
|
| Does sql play any role here? Did you try trace network traffic? |
|
|
|
|
|
|
AS/400 VB6 SQL 2005 Question