how have you guys dealt with client stations disconnecting due to odbc
timeouts???
is there anything on the server side that can help the problem?? or is it
just the vb coder's responsibility?
thanx
by GT Jeff Chere » Wed, 10 Jun 1998 04:00:00
how have you guys dealt with client stations disconnecting due to odbc
timeouts???
is there anything on the server side that can help the problem?? or is it
just the vb coder's responsibility?
thanx
by Mark Tomlins » Fri, 12 Jun 1998 04:00:00
If it is an ODBC timeout, then you fix it on the client.
by Thor » Fri, 12 Jun 1998 04:00:00
This is a newbie question but, what do you mean by a ODBC timeout? I have
an application that uses ODBC to update an oracle database on a RS/6000 and
I have problems with inconsistant updates to the database.
Quote:> If it is an ODBC timeout, then you fix it on the client.
by Phil Britto » Sat, 13 Jun 1998 04:00:00
> how have you guys dealt with client stations disconnecting due to odbc
> timeouts???
> is there anything on the server side that can help the problem?? or is it
> just the vb coder's responsibility?
> thanx
Default is 10 secs maybe you need longer? Setting to 0 means it never
time out
HtH
Phil
--
=====================================================================
Phil Britton (Senior Consultant)
"The opinions here are mine, I thought of them, they are my opinions"
http://www.prismtechnologies.com 5th Avenue Business Park
Tel. +44 (0)191 4979900 Gateshead NE11 0NB
FAX. +44 (0)191 4979901 United Kingdom
1. ADO thinks DBMS is done, but DBMS ain't done
I have 2 Recordsets on 2 different applications communicating with the same
database
-=The first Recordset is opened with=-
m_pGlobal_RS->Open(adCmd, m_pConnection.GetInterfacePtr(), adOpenKeyset,
adLockPessimistic, adCmdText);
-=The second Recordset is opened with=-
local_RS->Open(adCmd, m_pConnection.GetInterfacePtr(), adOpenKeyset,
adLockReadOnly, adCmdText);
* adCmd is a simple SELECT statement that is the SAME for both recordsets.
The code order is roughly this
Open m_pGlobal_RS
...
...
Change fields on m_pGlobal_RS
...
...
MoveNext on all rows of m_pGlobal_RS until EOF then MoveFirst // since
pessimistic every row op sends update
..
..
I then fire an event to another application which opens local_RS.
It is random whether the data opened by the second RS is the pre-update data
or the post-update data. How can this be? I opened the connection
with the default synchronous option, isn't this asynchronous behavior?
Thanks for the help,
-=Adog
2. Does UDB use transactions by default?
3. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file
5. Caché from InterSystems - doing wh at other MV vendors should be doing
6. Possibility of Internet as a Wide Area Network fo
7. ODBC+Drivers distribution - anyone done it?
8. JDBC Driver issues for Access 97
9. Using TOP in a Select done with ODBC through MFC RecordSet class
10. Problem in doing bulk inserts thru ODBC API calls
11. Anyone done D2->ODBC->Personal Oracle?
12. Error doing ResultSet.getString(int) with JDBC/ODBC bridge