I keep getting an ODBC error (varies) I have SQL 7 on windows 2000 server
with all the updated service packs and patches for the OS and SQL. I also
updated MDAC to 2.8 sp2. We use a third party software program that connects
to the SQL database to store all our data. Every so often we get
disconnected with an ODBC error and have to close the client then reconnect
to the server. The frequency is pretty sparatic sometimes it can occur 5
times and hour or as little as 1 time an hour. Attached is a copy of one of
the error we get if anyone has any ideas as to what could be causing this I
would greatly appreciate it.
ConnectionWrite (WrapperWrite()).
Last SQL String:
select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
MType='M' and MDateTime<=1124822591
Last ODBC Command:
Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
MStatus='U' and MType='M' and MDateTime<=1124822591'
It's pretty hard to say from what's posted. This looks like
it's a HEAT database. If that's the case, Tracing their
sporadic errors with ODBC tracing will slow things down
quite a bit. You can but it's pretty bad on performance. Try
contacting the vendor, Front Range Solutions. That's
generally quicker.
-Sue
On Tue, 23 Aug 2005 12:33:04 -0700, "Anthony"
<Anthony@.discussions.microsoft.com> wrote:
>I keep getting an ODBC error (varies) I have SQL 7 on windows 2000 server
>with all the updated service packs and patches for the OS and SQL. I also
>updated MDAC to 2.8 sp2. We use a third party software program that connects
>to the SQL database to store all our data. Every so often we get
>disconnected with an ODBC error and have to close the client then reconnect
>to the server. The frequency is pretty sparatic sometimes it can occur 5
>times and hour or as little as 1 time an hour. Attached is a copy of one of
>the error we get if anyone has any ideas as to what could be causing this I
>would greatly appreciate it.
>ConnectionWrite (WrapperWrite()).
>Last SQL String:
>select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
>MType='M' and MDateTime<=1124822591
>Last ODBC Command:
>Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
>MStatus='U' and MType='M' and MDateTime<=1124822591'
>
|||Anthony,
Try using another ODBC tool like WinSQL
(http://www.synametrics.com/winsql) and see if you get the same behavior.
How far is your database from your client? This could also be a network
issue.
Anthony wrote:
> I keep getting an ODBC error (varies) I have SQL 7 on windows 2000 server
> with all the updated service packs and patches for the OS and SQL. I also
> updated MDAC to 2.8 sp2. We use a third party software program that connects
> to the SQL database to store all our data. Every so often we get
> disconnected with an ODBC error and have to close the client then reconnect
> to the server. The frequency is pretty sparatic sometimes it can occur 5
> times and hour or as little as 1 time an hour. Attached is a copy of one of
> the error we get if anyone has any ideas as to what could be causing this I
> would greatly appreciate it.
> ConnectionWrite (WrapperWrite()).
> Last SQL String:
> select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
> MType='M' and MDateTime<=1124822591
> Last ODBC Command:
> Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
> MStatus='U' and MType='M' and MDateTime<=1124822591'
>
|||I will look into winsql, thanks. As far as the nework goes everything is in
the same physical location. I have checked network performance and nothing
indicates that it could be a performance problem.
"Dennis Black" wrote:
> Anthony,
> Try using another ODBC tool like WinSQL
> (http://www.synametrics.com/winsql) and see if you get the same behavior.
> How far is your database from your client? This could also be a network
> issue.
>
> Anthony wrote:
>
Showing posts with label clients. Show all posts
Showing posts with label clients. Show all posts
Thursday, March 22, 2012
Error disconnecting clients with ODBC Error
I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
with all the updated service packs and patches for the OS and SQL. I also
updated MDAC to 2.8 sp2. We use a third party software program that connect
s
to the SQL database to store all our data. Every so often we get
disconnected with an ODBC error and have to close the client then reconnect
to the server. The frequency is pretty sparatic sometimes it can occur 5
times and hour or as little as 1 time an hour. Attached is a copy of one of
the error we get if anyone has any ideas as to what could be causing this I
would greatly appreciate it.
ConnectionWrite (WrapperWrite()).
Last SQL String:
select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
MType='M' and MDateTime<=1124822591
Last ODBC Command:
Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
MStatus='U' and MType='M' and MDateTime<=1124822591'It's pretty hard to say from what's posted. This looks like
it's a HEAT database. If that's the case, Tracing their
sporadic errors with ODBC tracing will slow things down
quite a bit. You can but it's pretty bad on performance. Try
contacting the vendor, Front Range Solutions. That's
generally quicker.
-Sue
On Tue, 23 Aug 2005 12:33:04 -0700, "Anthony"
<Anthony@.discussions.microsoft.com> wrote:
>I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
>with all the updated service packs and patches for the OS and SQL. I also
>updated MDAC to 2.8 sp2. We use a third party software program that connec
ts
>to the SQL database to store all our data. Every so often we get
>disconnected with an ODBC error and have to close the client then reconnect
>to the server. The frequency is pretty sparatic sometimes it can occur 5
>times and hour or as little as 1 time an hour. Attached is a copy of one o
f
>the error we get if anyone has any ideas as to what could be causing this I
>would greatly appreciate it.
>ConnectionWrite (WrapperWrite()).
>Last SQL String:
>select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
>MType='M' and MDateTime<=1124822591
>Last ODBC Command:
>Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
>MStatus='U' and MType='M' and MDateTime<=1124822591'
>|||Anthony,
Try using another ODBC tool like WinSQL
(http://www.synametrics.com/winsql) and see if you get the same behavior.
How far is your database from your client? This could also be a network
issue.
Anthony wrote:
> I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
> with all the updated service packs and patches for the OS and SQL. I also
> updated MDAC to 2.8 sp2. We use a third party software program that conne
cts
> to the SQL database to store all our data. Every so often we get
> disconnected with an ODBC error and have to close the client then reconnec
t
> to the server. The frequency is pretty sparatic sometimes it can occur 5
> times and hour or as little as 1 time an hour. Attached is a copy of one
of
> the error we get if anyone has any ideas as to what could be causing this
I
> would greatly appreciate it.
> ConnectionWrite (WrapperWrite()).
> Last SQL String:
> select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
> MType='M' and MDateTime<=1124822591
> Last ODBC Command:
> Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
> MStatus='U' and MType='M' and MDateTime<=1124822591'
>|||I will look into winsql, thanks. As far as the nework goes everything is in
the same physical location. I have checked network performance and nothing
indicates that it could be a performance problem.
"Dennis Black" wrote:
> Anthony,
> Try using another ODBC tool like WinSQL
> (http://www.synametrics.com/winsql) and see if you get the same behavior.
> How far is your database from your client? This could also be a network
> issue.
>
> Anthony wrote:
>
with all the updated service packs and patches for the OS and SQL. I also
updated MDAC to 2.8 sp2. We use a third party software program that connect
s
to the SQL database to store all our data. Every so often we get
disconnected with an ODBC error and have to close the client then reconnect
to the server. The frequency is pretty sparatic sometimes it can occur 5
times and hour or as little as 1 time an hour. Attached is a copy of one of
the error we get if anyone has any ideas as to what could be causing this I
would greatly appreciate it.
ConnectionWrite (WrapperWrite()).
Last SQL String:
select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
MType='M' and MDateTime<=1124822591
Last ODBC Command:
Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
MStatus='U' and MType='M' and MDateTime<=1124822591'It's pretty hard to say from what's posted. This looks like
it's a HEAT database. If that's the case, Tracing their
sporadic errors with ODBC tracing will slow things down
quite a bit. You can but it's pretty bad on performance. Try
contacting the vendor, Front Range Solutions. That's
generally quicker.
-Sue
On Tue, 23 Aug 2005 12:33:04 -0700, "Anthony"
<Anthony@.discussions.microsoft.com> wrote:
>I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
>with all the updated service packs and patches for the OS and SQL. I also
>updated MDAC to 2.8 sp2. We use a third party software program that connec
ts
>to the SQL database to store all our data. Every so often we get
>disconnected with an ODBC error and have to close the client then reconnect
>to the server. The frequency is pretty sparatic sometimes it can occur 5
>times and hour or as little as 1 time an hour. Attached is a copy of one o
f
>the error we get if anyone has any ideas as to what could be causing this I
>would greatly appreciate it.
>ConnectionWrite (WrapperWrite()).
>Last SQL String:
>select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
>MType='M' and MDateTime<=1124822591
>Last ODBC Command:
>Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
>MStatus='U' and MType='M' and MDateTime<=1124822591'
>|||Anthony,
Try using another ODBC tool like WinSQL
(http://www.synametrics.com/winsql) and see if you get the same behavior.
How far is your database from your client? This could also be a network
issue.
Anthony wrote:
> I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
> with all the updated service packs and patches for the OS and SQL. I also
> updated MDAC to 2.8 sp2. We use a third party software program that conne
cts
> to the SQL database to store all our data. Every so often we get
> disconnected with an ODBC error and have to close the client then reconnec
t
> to the server. The frequency is pretty sparatic sometimes it can occur 5
> times and hour or as little as 1 time an hour. Attached is a copy of one
of
> the error we get if anyone has any ideas as to what could be causing this
I
> would greatly appreciate it.
> ConnectionWrite (WrapperWrite()).
> Last SQL String:
> select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
> MType='M' and MDateTime<=1124822591
> Last ODBC Command:
> Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
> MStatus='U' and MType='M' and MDateTime<=1124822591'
>|||I will look into winsql, thanks. As far as the nework goes everything is in
the same physical location. I have checked network performance and nothing
indicates that it could be a performance problem.
"Dennis Black" wrote:
> Anthony,
> Try using another ODBC tool like WinSQL
> (http://www.synametrics.com/winsql) and see if you get the same behavior.
> How far is your database from your client? This could also be a network
> issue.
>
> Anthony wrote:
>
Sunday, February 26, 2012
error conection frm clients to the sqlserver
hi
dear members
we have a program that its database is SQLserver2000 that installed on a
computer with ' MIS' name.the type of SQLserver installation is mixed mod
e
(not Authentication ). so , 2 weeks ago the program did run on all of the
network clients without login to the SQlserver besuse the sqlserver is mixed
mod. but now our SQl server has a problem besouse for runing the program on
any client on the network, first we have to login to the SQLserver compute
r
then run the application program . but we want to run the software with
sqlserver database without login to SQLserver computer.
note: My connection from program to SQLserver is ADO Connection with mixed
mode(user name=SA , password = blank""first we have to login to the SQLserver computer
then run the application program ""
Not sure what you mean...are you saying that when you open the application,
you get a username/password prompt, or are you actually logging into the
SQL Server via remote desktop/terminal server?
What is the application? Access? VB.Net?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"ahi" <ahi@.discussions.microsoft.com> wrote in message
news:594B3C9D-D780-462E-93B7-C3CF683AA3D3@.microsoft.com...
> hi
> dear members
> we have a program that its database is SQLserver2000 that installed on a
> computer with ' MIS' name.the type of SQLserver installation is mixed
> mode
> (not Authentication ). so , 2 weeks ago the program did run on all of the
> network clients without login to the SQlserver besuse the sqlserver is
> mixed
> mod. but now our SQl server has a problem besouse for runing the program
> on
> any client on the network, first we have to login to the SQLserver
> computer
> then run the application program . but we want to run the software with
> sqlserver database without login to SQLserver computer.
> note: My connection from program to SQLserver is ADO Connection with mixed
> mode(user name=SA , password = blank
dear members
we have a program that its database is SQLserver2000 that installed on a
computer with ' MIS' name.the type of SQLserver installation is mixed mod
e
(not Authentication ). so , 2 weeks ago the program did run on all of the
network clients without login to the SQlserver besuse the sqlserver is mixed
mod. but now our SQl server has a problem besouse for runing the program on
any client on the network, first we have to login to the SQLserver compute
r
then run the application program . but we want to run the software with
sqlserver database without login to SQLserver computer.
note: My connection from program to SQLserver is ADO Connection with mixed
mode(user name=SA , password = blank""first we have to login to the SQLserver computer
then run the application program ""
Not sure what you mean...are you saying that when you open the application,
you get a username/password prompt, or are you actually logging into the
SQL Server via remote desktop/terminal server?
What is the application? Access? VB.Net?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"ahi" <ahi@.discussions.microsoft.com> wrote in message
news:594B3C9D-D780-462E-93B7-C3CF683AA3D3@.microsoft.com...
> hi
> dear members
> we have a program that its database is SQLserver2000 that installed on a
> computer with ' MIS' name.the type of SQLserver installation is mixed
> mode
> (not Authentication ). so , 2 weeks ago the program did run on all of the
> network clients without login to the SQlserver besuse the sqlserver is
> mixed
> mod. but now our SQl server has a problem besouse for runing the program
> on
> any client on the network, first we have to login to the SQLserver
> computer
> then run the application program . but we want to run the software with
> sqlserver database without login to SQLserver computer.
> note: My connection from program to SQLserver is ADO Connection with mixed
> mode(user name=SA , password = blank
error conection frm clients to the sqlserver
hi
dear members
we have a program that its database is SQLserver2000 that installed on a
computer with ' MIS' name.the type of SQLserver installation is mixed mode
(not Authentication ). so , 2 weeks ago the program did run on all of the
network clients without login to the SQlserver besuse the sqlserver is mixed
mod. but now our SQl server has a problem besouse for runing the program on
any client on the network, first we have to login to the SQLserver computer
then run the application program . but we want to run the software with
sqlserver database without login to SQLserver computer.
note: My connection from program to SQLserver is ADO Connection with mixed
mode(user name=SA , password = blank
""first we have to login to the SQLserver computer
then run the application program ""
Not sure what you mean...are you saying that when you open the application,
you get a username/password prompt, or are you actually logging into the
SQL Server via remote desktop/terminal server?
What is the application? Access? VB.Net?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"ahi" <ahi@.discussions.microsoft.com> wrote in message
news:594B3C9D-D780-462E-93B7-C3CF683AA3D3@.microsoft.com...
> hi
> dear members
> we have a program that its database is SQLserver2000 that installed on a
> computer with ' MIS' name.the type of SQLserver installation is mixed
> mode
> (not Authentication ). so , 2 weeks ago the program did run on all of the
> network clients without login to the SQlserver besuse the sqlserver is
> mixed
> mod. but now our SQl server has a problem besouse for runing the program
> on
> any client on the network, first we have to login to the SQLserver
> computer
> then run the application program . but we want to run the software with
> sqlserver database without login to SQLserver computer.
> note: My connection from program to SQLserver is ADO Connection with mixed
> mode(user name=SA , password = blank
dear members
we have a program that its database is SQLserver2000 that installed on a
computer with ' MIS' name.the type of SQLserver installation is mixed mode
(not Authentication ). so , 2 weeks ago the program did run on all of the
network clients without login to the SQlserver besuse the sqlserver is mixed
mod. but now our SQl server has a problem besouse for runing the program on
any client on the network, first we have to login to the SQLserver computer
then run the application program . but we want to run the software with
sqlserver database without login to SQLserver computer.
note: My connection from program to SQLserver is ADO Connection with mixed
mode(user name=SA , password = blank
""first we have to login to the SQLserver computer
then run the application program ""
Not sure what you mean...are you saying that when you open the application,
you get a username/password prompt, or are you actually logging into the
SQL Server via remote desktop/terminal server?
What is the application? Access? VB.Net?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"ahi" <ahi@.discussions.microsoft.com> wrote in message
news:594B3C9D-D780-462E-93B7-C3CF683AA3D3@.microsoft.com...
> hi
> dear members
> we have a program that its database is SQLserver2000 that installed on a
> computer with ' MIS' name.the type of SQLserver installation is mixed
> mode
> (not Authentication ). so , 2 weeks ago the program did run on all of the
> network clients without login to the SQlserver besuse the sqlserver is
> mixed
> mod. but now our SQl server has a problem besouse for runing the program
> on
> any client on the network, first we have to login to the SQLserver
> computer
> then run the application program . but we want to run the software with
> sqlserver database without login to SQLserver computer.
> note: My connection from program to SQLserver is ADO Connection with mixed
> mode(user name=SA , password = blank
Subscribe to:
Posts (Atom)