Using MSDE 2000 SP3
Sql Server 2000 SP3
Win XP Pro SP1
Microsoft.Jet.OLEDB.4.0
We have recently upgraded field laptops from Windows 2000 to XP Pro. One of our applications which was developed with Visual C++ 6.0 and using MSDE will just drop it's connection to our consolidated Sql Server 2000. This works on Windows 2000 machines.
I have ran the profiler, monitored Sql Processes for locks, checked Event logs and I am unable to find any type of error. Our sync process just drops off. I am uncertain if it is MSDE, Sql Server or XP.
I even set the application's compatiability settings to Windows 2000 but still same result. I am uncertain as to how to do anymore troubleshooting.
Any ideas would be much appreciated.
Thanks,
Vannie Keever
SQL Server (including the MSDE edition) cannot close a connection by itself
except when shutting down. The client, the OS, or the network has to tell
SQL Server to drop the connection. Try a netmon trace to get more details.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Showing posts with label jet. Show all posts
Showing posts with label jet. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
msde slower than Jet?
I have an VBA application which queries data from an msde server. Then
converts the data into an array and passes the array to a com server which
does computations.
This procedure worked failry fast under Jet (on the local client), but it is
noticeably slower with msde server residing on another machine.
During this process I see that the CPU on the client PC (which runs the VBA
and later the com-dll) is very busy while the data is retrieved.
Could it be that recordset-to-array conversion is the culprit?
or is the network transfer of a few Mb of data the problem?
If the latter, why is the client so busy dyring data retrieval?
If the former, is there a better way of transferring the data to a DLL
written in a C-like compiled/optmiized language?
Thanks in advance for any hints.
To perform a fair test, put MSDE local and compare Access local, or put
Access on the remote machine and test that way. Comparing one database over
the network to one that is on the local machine is not a fair test at all.
http://www.aspfaq.com/
(Reverse address to reply.)
"Ernesto" <tsh@.mathematicuslabs.com> wrote in message
news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
>I have an VBA application which queries data from an msde server. Then
> converts the data into an array and passes the array to a com server which
> does computations.
> This procedure worked failry fast under Jet (on the local client), but it
> is
> noticeably slower with msde server residing on another machine.
> During this process I see that the CPU on the client PC (which runs the
> VBA
> and later the com-dll) is very busy while the data is retrieved.
> Could it be that recordset-to-array conversion is the culprit?
> or is the network transfer of a few Mb of data the problem?
> If the latter, why is the client so busy dyring data retrieval?
> If the former, is there a better way of transferring the data to a DLL
> written in a C-like compiled/optmiized language?
> Thanks in advance for any hints.
>
>
|||Hi Ernesto,
In addition to what Aaron mentioned, I've found jet to be faster in
applications that involve significant amounts of data accessed sequentially.
However, as soon as any sort of random access (or multiple users) gets
involved, the MSDE usually wins every time, often by a large mark.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Ernesto" <tsh@.mathematicuslabs.com> wrote in message
news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
> I have an VBA application which queries data from an msde server. Then
> converts the data into an array and passes the array to a com server which
> does computations.
> This procedure worked failry fast under Jet (on the local client), but it
is
> noticeably slower with msde server residing on another machine.
> During this process I see that the CPU on the client PC (which runs the
VBA
> and later the com-dll) is very busy while the data is retrieved.
> Could it be that recordset-to-array conversion is the culprit?
> or is the network transfer of a few Mb of data the problem?
> If the latter, why is the client so busy dyring data retrieval?
> If the former, is there a better way of transferring the data to a DLL
> written in a C-like compiled/optmiized language?
> Thanks in advance for any hints.
>
>
|||Actually my questions did not have anything to do with the comparison, per
se.
As it turns out Jet does run faster on the same computer, but I"m not too
concerned about it since the setup is not of interest.
I did want to know if anyone had any suggestions on where the "bottlenecks"
may be, and if there are any ways to do this faster.
Even a "No, it-can't -be-done" answer would be useful.
Greg's comment about sequential access does give the possible reason since
that is roughly all I ever do, as the data are all time series and retrieved
one whole series at a time.
Still if there is a better way (like somehow skipping the recordset to array
conversion, assuming that IS the slow part) would be most appreciated.
|||Perhaps when Access talks to Jet, it knows how to get "pages" of data at a
time.
But when talking to SQL Server/MSDE, it instead tries to query for
everything - which is not very optimal.
Access is not the ideal tool for a database front-end. You need to write
queries yourself to get good design (No use a query builder, and controls
that show everything).
"Ernesto" <tsh@.mathematicuslabs.com> wrote in message
news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
> I have an VBA application which queries data from an msde server. Then
> converts the data into an array and passes the array to a com server which
> does computations.
> This procedure worked failry fast under Jet (on the local client), but it
is
> noticeably slower with msde server residing on another machine.
> During this process I see that the CPU on the client PC (which runs the
VBA
> and later the com-dll) is very busy while the data is retrieved.
> Could it be that recordset-to-array conversion is the culprit?
> or is the network transfer of a few Mb of data the problem?
> If the latter, why is the client so busy dyring data retrieval?
> If the former, is there a better way of transferring the data to a DLL
> written in a C-like compiled/optmiized language?
> Thanks in advance for any hints.
>
>
|||If not written correctly, Access treats SQL Server like a file server.
Access/JET does all of the physical IO against the local MDB file which
helps in some cases, but when you try to stretch this approach to multiple
users, the model falls apart quickly.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:%23$KOg7ZaEHA.2364@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Perhaps when Access talks to Jet, it knows how to get "pages" of data at a
> time.
> But when talking to SQL Server/MSDE, it instead tries to query for
> everything - which is not very optimal.
> Access is not the ideal tool for a database front-end. You need to write
> queries yourself to get good design (No use a query builder, and controls
> that show everything).
>
> "Ernesto" <tsh@.mathematicuslabs.com> wrote in message
> news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
which[vbcol=seagreen]
it
> is
> VBA
>
converts the data into an array and passes the array to a com server which
does computations.
This procedure worked failry fast under Jet (on the local client), but it is
noticeably slower with msde server residing on another machine.
During this process I see that the CPU on the client PC (which runs the VBA
and later the com-dll) is very busy while the data is retrieved.
Could it be that recordset-to-array conversion is the culprit?
or is the network transfer of a few Mb of data the problem?
If the latter, why is the client so busy dyring data retrieval?
If the former, is there a better way of transferring the data to a DLL
written in a C-like compiled/optmiized language?
Thanks in advance for any hints.
To perform a fair test, put MSDE local and compare Access local, or put
Access on the remote machine and test that way. Comparing one database over
the network to one that is on the local machine is not a fair test at all.
http://www.aspfaq.com/
(Reverse address to reply.)
"Ernesto" <tsh@.mathematicuslabs.com> wrote in message
news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
>I have an VBA application which queries data from an msde server. Then
> converts the data into an array and passes the array to a com server which
> does computations.
> This procedure worked failry fast under Jet (on the local client), but it
> is
> noticeably slower with msde server residing on another machine.
> During this process I see that the CPU on the client PC (which runs the
> VBA
> and later the com-dll) is very busy while the data is retrieved.
> Could it be that recordset-to-array conversion is the culprit?
> or is the network transfer of a few Mb of data the problem?
> If the latter, why is the client so busy dyring data retrieval?
> If the former, is there a better way of transferring the data to a DLL
> written in a C-like compiled/optmiized language?
> Thanks in advance for any hints.
>
>
|||Hi Ernesto,
In addition to what Aaron mentioned, I've found jet to be faster in
applications that involve significant amounts of data accessed sequentially.
However, as soon as any sort of random access (or multiple users) gets
involved, the MSDE usually wins every time, often by a large mark.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Ernesto" <tsh@.mathematicuslabs.com> wrote in message
news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
> I have an VBA application which queries data from an msde server. Then
> converts the data into an array and passes the array to a com server which
> does computations.
> This procedure worked failry fast under Jet (on the local client), but it
is
> noticeably slower with msde server residing on another machine.
> During this process I see that the CPU on the client PC (which runs the
VBA
> and later the com-dll) is very busy while the data is retrieved.
> Could it be that recordset-to-array conversion is the culprit?
> or is the network transfer of a few Mb of data the problem?
> If the latter, why is the client so busy dyring data retrieval?
> If the former, is there a better way of transferring the data to a DLL
> written in a C-like compiled/optmiized language?
> Thanks in advance for any hints.
>
>
|||Actually my questions did not have anything to do with the comparison, per
se.
As it turns out Jet does run faster on the same computer, but I"m not too
concerned about it since the setup is not of interest.
I did want to know if anyone had any suggestions on where the "bottlenecks"
may be, and if there are any ways to do this faster.
Even a "No, it-can't -be-done" answer would be useful.
Greg's comment about sequential access does give the possible reason since
that is roughly all I ever do, as the data are all time series and retrieved
one whole series at a time.
Still if there is a better way (like somehow skipping the recordset to array
conversion, assuming that IS the slow part) would be most appreciated.
|||Perhaps when Access talks to Jet, it knows how to get "pages" of data at a
time.
But when talking to SQL Server/MSDE, it instead tries to query for
everything - which is not very optimal.
Access is not the ideal tool for a database front-end. You need to write
queries yourself to get good design (No use a query builder, and controls
that show everything).
"Ernesto" <tsh@.mathematicuslabs.com> wrote in message
news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
> I have an VBA application which queries data from an msde server. Then
> converts the data into an array and passes the array to a com server which
> does computations.
> This procedure worked failry fast under Jet (on the local client), but it
is
> noticeably slower with msde server residing on another machine.
> During this process I see that the CPU on the client PC (which runs the
VBA
> and later the com-dll) is very busy while the data is retrieved.
> Could it be that recordset-to-array conversion is the culprit?
> or is the network transfer of a few Mb of data the problem?
> If the latter, why is the client so busy dyring data retrieval?
> If the former, is there a better way of transferring the data to a DLL
> written in a C-like compiled/optmiized language?
> Thanks in advance for any hints.
>
>
|||If not written correctly, Access treats SQL Server like a file server.
Access/JET does all of the physical IO against the local MDB file which
helps in some cases, but when you try to stretch this approach to multiple
users, the model falls apart quickly.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:%23$KOg7ZaEHA.2364@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Perhaps when Access talks to Jet, it knows how to get "pages" of data at a
> time.
> But when talking to SQL Server/MSDE, it instead tries to query for
> everything - which is not very optimal.
> Access is not the ideal tool for a database front-end. You need to write
> queries yourself to get good design (No use a query builder, and controls
> that show everything).
>
> "Ernesto" <tsh@.mathematicuslabs.com> wrote in message
> news:W4qdnZ3DZKHbbW_dRVn-gg@.speakeasy.net...
which[vbcol=seagreen]
it
> is
> VBA
>
Wednesday, March 7, 2012
MSDE install problem
I've been using Jet databases for my websites for quite some time. I was
going to try MSDE a year or so ago but there were some limitations to it
back then that prevented me from using it.
After subscribing to the newsgroup yesterday and reading some of the posts I
saw the limitations had been removed in the recent release. So I decised to
download and install it.
I am now trying to install, but I get this error each time...
"The instance name specified is invalid"
I havent specified any instance name, so I don't know what to do.
I'm using WinXP-Pro.
Any ideas what the problem is ?
Thanks,
PW
On Sat, 17 Apr 2004 06:41:11 +0800, "PW" <pwa@.NObigSPAMpond.net.au>
wrote:
>I've been using Jet databases for my websites for quite some time. I was
>going to try MSDE a year or so ago but there were some limitations to it
>back then that prevented me from using it.
>After subscribing to the newsgroup yesterday and reading some of the posts I
>saw the limitations had been removed in the recent release. So I decised to
>download and install it.
>I am now trying to install, but I get this error each time...
>"The instance name specified is invalid"
>I havent specified any instance name, so I don't know what to do.
>I'm using WinXP-Pro.
>Any ideas what the problem is ?
Do you already have SQL server installed? If you don't specify an
instance name, it uses the default which is the same as SQLServer.
Also, check your registry key,'HKLM\Software\Microsoft\Microsoft SQL
Server', value 'InstalledInstances'.
going to try MSDE a year or so ago but there were some limitations to it
back then that prevented me from using it.
After subscribing to the newsgroup yesterday and reading some of the posts I
saw the limitations had been removed in the recent release. So I decised to
download and install it.
I am now trying to install, but I get this error each time...
"The instance name specified is invalid"
I havent specified any instance name, so I don't know what to do.
I'm using WinXP-Pro.
Any ideas what the problem is ?
Thanks,
PW
On Sat, 17 Apr 2004 06:41:11 +0800, "PW" <pwa@.NObigSPAMpond.net.au>
wrote:
>I've been using Jet databases for my websites for quite some time. I was
>going to try MSDE a year or so ago but there were some limitations to it
>back then that prevented me from using it.
>After subscribing to the newsgroup yesterday and reading some of the posts I
>saw the limitations had been removed in the recent release. So I decised to
>download and install it.
>I am now trying to install, but I get this error each time...
>"The instance name specified is invalid"
>I havent specified any instance name, so I don't know what to do.
>I'm using WinXP-Pro.
>Any ideas what the problem is ?
Do you already have SQL server installed? If you don't specify an
instance name, it uses the default which is the same as SQLServer.
Also, check your registry key,'HKLM\Software\Microsoft\Microsoft SQL
Server', value 'InstalledInstances'.
Subscribe to:
Posts (Atom)