problem with SQL-Server 2005 CTP

I have received visual studio 2005 beta experience kit. My kit included a version of MS SQL-Server 2005 Developer Edition CTP ( Developer Edition printed on the surface of my DVD but I don't know it's true or not ? because I saw this page: http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx and there was not Developer Edition). I had a new and fresh Windows 2003 (without SP1) installed on one of my office PCs. So I decided to install visual studio 2005 beta 2 first and then SQL-Server 2005 CTP. But after I installed SQL-Server 2005 CTP I saw nothing in my start menu even Express Manager. My question is : how can I find SQL-Server Express Manager or Management Studio . is my problem related to installing Visual Studio 2005 Before SQL-Server like this topic: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=17309

If it is how can I fix this problem?

Excuse me for my bad English writing!

thank you!

You should try posting this question to SQL Server Setup & Upgrade forum.

Thanks,
-Vineet Rao

Problem with SQLH2

Hi all i have problem with SQLH2. SQLH2 installed on Windows XP Pro SP2
Russian.
Version SQLH2 is H2 Collector ver. V2 2.0.024.0 9/30/04 17:58
this is log
28.12.2004 15:00:16 Opening Log
28.12.2004 15:00:16 SQLH2 ver. V2 2.0.024.0 9/30/04 17:58
28.12.2004 15:00:16 Status: Init
28.12.2004 15:00:16 WARNING: There are no PerfProviders in the config file
28.12.2004 15:00:16 Status: Initializing repository: manushind
28.12.2004 15:00:16 Status: Repository Database: SQLH2Repository
28.12.2004 15:00:16 INFO: host_id = 1
28.12.2004 15:00:16 Status: Starting RUN
28.12.2004 15:00:16 Status: Registering Run
28.12.2004 15:00:16 INFO: run_id = 8
28.12.2004 15:00:16 Status: Starting Targets processing
28.12.2004 15:00:16 Status: Initializing Target: SRV-ELDDB2
28.12.2004 15:00:16 Status: registering Server
28.12.2004 15:00:16 INFO: srv_id = 2; signature =
aad193c2-d36c-4760-a312-57dc78d07944
28.12.2004 15:00:16 Status: Scanning Registry on SRV-ELDDB2
28.12.2004 15:00:16 Status: registering instance SRV-ELDDB2
28.12.2004 15:00:16 INFO: inst_id = 1
28.12.2004 15:00:16 INFO: version: 8.00.818
28.12.2004 15:00:16 Status: RUN
28.12.2004 15:00:16 Status: Initializing collector: WMI
28.12.2004 15:00:16 Status: Running WMI collector
28.12.2004 15:00:16 Status: Opening Unit 1 (OS/CS)
28.12.2004 15:00:16 Status: Collecting Win32_OperatingSystem
28.12.2004 15:00:17 Status: Closing Unit 1
28.12.2004 15:00:17 ERROR: NotFound
28.12.2004 15:00:17 WARNING: WMI Collector encountered critical error.
Abandoning Collector.
28.12.2004 15:00:17 Status: Initializing collector: EventLog
28.12.2004 15:00:17 Status: Initializing collector: SQL
28.12.2004 15:00:17 Status: Running SQL collector on SRV-ELDDB2
28.12.2004 15:00:17 Status: Opening Unit 5 (Server Properties)
28.12.2004 15:00:17 Status: Closing Unit 5
28.12.2004 15:00:17 Status: Opening Unit 1 (Databases)
28.12.2004 15:00:18 ERROR: There are fewer columns in the INSERT statement
than values specified in the VALUES clause. The number of values in the
VALUES clause must match the number of columns specified in the INSERT
statement.
28.12.2004 15:00:18 ERROR: Insert dbo.c_database
(run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eStat
,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncateL ogOnCheckpoint,oPublished,oSubscribed,oMergePublis hed,oMergeSubscribed,oFullTextEnabled,oDbChaining)
Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
28.12.2004 15:00:18 ERROR: Unit 1 failed
28.12.2004 15:00:18 Status: Closing Unit 1
28.12.2004 15:00:18 ERROR: Insert dbo.c_database
(run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eStat
,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncateL ogOnCheckpoint,oPublished,oSubscribed,oMergePublis hed,oMergeSubscribed,oFullTextEnabled,oDbChaining)
Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
28.12.2004 15:00:18 ERROR: SRV-ELDDB2: Collection failed; Error:104;
Provider Error: 110
28.12.2004 15:00:18 ERROR: Critical Repository Failure
28.12.2004 15:00:18 SQLH2 is shutting down
28.12.2004 15:00:18 Closing Log
P.S.
i have Domain admins right.
Thank you.
Dimitri,
I suspect this is a localisation issue. Is your decimal symbol a comma by
any chance?
If you look at the Appendix C of the SQLH2 Deployment Guide (this should be
in your root installation directory), you will see some useful hints on how
to get SQLH2 working on localised Windows platforms.
Looking at your log, I would also advise that your dates are not in the
expected format for SQLH2, so you will need to use the /D switch (again
please see Appendix C).
Hope this helps,
John Marsh
"dmitri" wrote:

> Hi all i have problem with SQLH2. SQLH2 installed on Windows XP Pro SP2
> Russian.
> Version SQLH2 is H2 Collector ver. V2 2.0.024.0 9/30/04 17:58
> this is log
> 28.12.2004 15:00:16 Opening Log
> 28.12.2004 15:00:16 SQLH2 ver. V2 2.0.024.0 9/30/04 17:58
> 28.12.2004 15:00:16 Status: Init
> 28.12.2004 15:00:16 WARNING: There are no PerfProviders in the config file
> 28.12.2004 15:00:16 Status: Initializing repository: manushind
> 28.12.2004 15:00:16 Status: Repository Database: SQLH2Repository
> 28.12.2004 15:00:16 INFO: host_id = 1
> 28.12.2004 15:00:16 Status: Starting RUN
> 28.12.2004 15:00:16 Status: Registering Run
> 28.12.2004 15:00:16 INFO: run_id = 8
> 28.12.2004 15:00:16 Status: Starting Targets processing
> 28.12.2004 15:00:16 Status: Initializing Target: SRV-ELDDB2
> 28.12.2004 15:00:16 Status: registering Server
> 28.12.2004 15:00:16 INFO: srv_id = 2; signature =
> aad193c2-d36c-4760-a312-57dc78d07944
> 28.12.2004 15:00:16 Status: Scanning Registry on SRV-ELDDB2
> 28.12.2004 15:00:16 Status: registering instance SRV-ELDDB2
> 28.12.2004 15:00:16 INFO: inst_id = 1
> 28.12.2004 15:00:16 INFO: version: 8.00.818
> 28.12.2004 15:00:16 Status: RUN
> 28.12.2004 15:00:16 Status: Initializing collector: WMI
> 28.12.2004 15:00:16 Status: Running WMI collector
> 28.12.2004 15:00:16 Status: Opening Unit 1 (OS/CS)
> 28.12.2004 15:00:16 Status: Collecting Win32_OperatingSystem
> 28.12.2004 15:00:17 Status: Closing Unit 1
> 28.12.2004 15:00:17 ERROR: NotFound
> 28.12.2004 15:00:17 WARNING: WMI Collector encountered critical error.
> Abandoning Collector.
> 28.12.2004 15:00:17 Status: Initializing collector: EventLog
> 28.12.2004 15:00:17 Status: Initializing collector: SQL
> 28.12.2004 15:00:17 Status: Running SQL collector on SRV-ELDDB2
> 28.12.2004 15:00:17 Status: Opening Unit 5 (Server Properties)
> 28.12.2004 15:00:17 Status: Closing Unit 5
> 28.12.2004 15:00:17 Status: Opening Unit 1 (Databases)
> 28.12.2004 15:00:18 ERROR: There are fewer columns in the INSERT statement
> than values specified in the VALUES clause. The number of values in the
> VALUES clause must match the number of columns specified in the INSERT
> statement.
> 28.12.2004 15:00:18 ERROR: Insert dbo.c_database
> (run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eSt
at,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncat eLogOnCheckpoint,oPublished,oSubscribed,oMergePubl ished,oMergeSubscribed,oFullTextEnabled,oDbChainin g)
> Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
> 38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
> 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
> 28.12.2004 15:00:18 ERROR: Unit 1 failed
> 28.12.2004 15:00:18 Status: Closing Unit 1
> 28.12.2004 15:00:18 ERROR: Insert dbo.c_database
> (run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eSt
at,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncat eLogOnCheckpoint,oPublished,oSubscribed,oMergePubl ished,oMergeSubscribed,oFullTextEnabled,oDbChainin g)
> Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
> 38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
> 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
> 28.12.2004 15:00:18 ERROR: SRV-ELDDB2: Collection failed; Error:104;
> Provider Error: 110
> 28.12.2004 15:00:18 ERROR: Critical Repository Failure
> 28.12.2004 15:00:18 SQLH2 is shutting down
> 28.12.2004 15:00:18 Closing Log
> P.S.
> i have Domain admins right.
> Thank you.
|||John, i see this hints but not try use it yet. I hope this help. thank you.
"John Marsh" wrote:
[vbcol=seagreen]
> Dimitri,
> I suspect this is a localisation issue. Is your decimal symbol a comma by
> any chance?
> If you look at the Appendix C of the SQLH2 Deployment Guide (this should be
> in your root installation directory), you will see some useful hints on how
> to get SQLH2 working on localised Windows platforms.
> Looking at your log, I would also advise that your dates are not in the
> expected format for SQLH2, so you will need to use the /D switch (again
> please see Appendix C).
> Hope this helps,
> John Marsh
>
> "dmitri" wrote:
Stat,oOffline,oReadOnly,oSelectIntoBulkCopy,oTrunc ateLogOnCheckpoint,oPublished,oSubscribed,oMergePu blished,oMergeSubscribed,oFullTextEnabled,oDbChain ing)[vbcol=seagreen]
Stat,oOffline,oReadOnly,oSelectIntoBulkCopy,oTrunc ateLogOnCheckpoint,oPublished,oSubscribed,oMergePu blished,oMergeSubscribed,oFullTextEnabled,oDbChain ing)[vbcol=seagreen]

Problem with SQL Service Pack 4

I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
install says it completed but after I rebooted and did a select @.@.version it
still shows SP3. I only have a default instance so I know that it installed
on the right instance. Could anyone help me out with this?You can review the setup log for any errors (file called sqlsp.log in the
windows directory). It is perfectly safe to run SP4 again to try and make it
stick (assuming you have the system database backups just in case you need
to regress)
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||I tried it several times but got the same result.
I've attached a copy of my sqlsp.log file. I looked at the sqlsp.log file
and it only listed one non-fatal error...I can't see this being the problem
considering it was nonfatal.
Jasper Smith wrote:
>You can review the setup log for any errors (file called sqlsp.log in the
>windows directory). It is perfectly safe to run SP4 again to try and make it
>stick (assuming you have the system database backups just in case you need
>to regress)
>>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
>> install says it completed but after I rebooted and did a select @.@.version
>> it
>> still shows SP3. I only have a default instance so I know that it
>> installed
>> on the right instance. Could anyone help me out with this?|||What does the following query return?
SELECT SERVERPROPERTY('ProductLevel')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||SP3....
Dan Guzman wrote:
>What does the following query return?
> SELECT SERVERPROPERTY('ProductLevel')
>>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
>> install says it completed but after I rebooted and did a select @.@.version
>> it
>> still shows SP3. I only have a default instance so I know that it
>> installed
>> on the right instance. Could anyone help me out with this?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1sql

Problem with sql server eval on Windows server 2003

Hi!
I tried to install the evaluation version of SqlServer2000 freshed download
from MS web site. the os is Windows Server 2003.
And when I try to start the SQLServer,it is impossible.
Could anyone give a help?
Thanks.
Prosper,
France
I don't think the eval version is supposed to work on Win2003.
Robert.
"Prosper" wrote:

> Hi!
> I tried to install the evaluation version of SqlServer2000 freshed download
> from MS web site. the os is Windows Server 2003.
> And when I try to start the SQLServer,it is impossible.
> Could anyone give a help?
> Thanks.
> Prosper,
> France
>
|||Robert,
Yes it does. Prosper, what error message do you get? You should also
post relevant sections from the error log.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Robert Davis wrote:[vbcol=seagreen]
> I don't think the eval version is supposed to work on Win2003.
> Robert.
> "Prosper" wrote:
>
|||Here are the error messages:
"A connection could not be established to (LOCAL)
Reasons:SQL SERVER does not exist or access denied.
ConnectionOpen(Connect())..
Please verify SQL SERVER is running and check your server registration
properties and try again." when trying to start the server from Enterprise
Manager.
Events logs:
17310 :
SqlDumpExceptionHandler: Process 1708 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
"Mark Allison" wrote:

> Robert,
> Yes it does. Prosper, what error message do you get? You should also
> post relevant sections from the error log.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Robert Davis wrote:
>
|||Every thing is ok now; I redownload SQL Server for .NET SERVER 2003, and it
works.
Thanks for your help.
Prosper
"Prosper" wrote:
[vbcol=seagreen]
> Here are the error messages:
> "A connection could not be established to (LOCAL)
> Reasons:SQL SERVER does not exist or access denied.
> ConnectionOpen(Connect())..
> Please verify SQL SERVER is running and check your server registration
> properties and try again." when trying to start the server from Enterprise
> Manager.
> Events logs:
> 17310 :
> SqlDumpExceptionHandler: Process 1708 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
>
> "Mark Allison" wrote:

Problem with sql server eval on Windows server 2003

Hi!
I tried to install the evaluation version of SqlServer2000 freshed download
from MS web site. the os is Windows Server 2003.
And when I try to start the SQLServer,it is impossible.
Could anyone give a help?
Thanks.
Prosper,
FranceI don't think the eval version is supposed to work on Win2003.
Robert.
"Prosper" wrote:
> Hi!
> I tried to install the evaluation version of SqlServer2000 freshed download
> from MS web site. the os is Windows Server 2003.
> And when I try to start the SQLServer,it is impossible.
> Could anyone give a help?
> Thanks.
> Prosper,
> France
>|||Robert,
Yes it does. Prosper, what error message do you get? You should also
post relevant sections from the error log.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Robert Davis wrote:
> I don't think the eval version is supposed to work on Win2003.
> Robert.
> "Prosper" wrote:
>
>>Hi!
>>I tried to install the evaluation version of SqlServer2000 freshed download
>>from MS web site. the os is Windows Server 2003.
>>And when I try to start the SQLServer,it is impossible.
>>Could anyone give a help?
>>Thanks.
>>Prosper,
>>France|||Here are the error messages:
"A connection could not be established to (LOCAL)
Reasons:SQL SERVER does not exist or access denied.
ConnectionOpen(Connect())..
Please verify SQL SERVER is running and check your server registration
properties and try again." when trying to start the server from Enterprise
Manager.
Events logs:
17310 :
SqlDumpExceptionHandler: Process 1708 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
"Mark Allison" wrote:
> Robert,
> Yes it does. Prosper, what error message do you get? You should also
> post relevant sections from the error log.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Robert Davis wrote:
> > I don't think the eval version is supposed to work on Win2003.
> >
> > Robert.
> >
> > "Prosper" wrote:
> >
> >
> >>Hi!
> >>I tried to install the evaluation version of SqlServer2000 freshed download
> >>from MS web site. the os is Windows Server 2003.
> >>And when I try to start the SQLServer,it is impossible.
> >>
> >>Could anyone give a help?
> >>Thanks.
> >>
> >>Prosper,
> >>France
> >>
>|||Every thing is ok now; I redownload SQL Server for .NET SERVER 2003, and it
works.
Thanks for your help.
Prosper
"Prosper" wrote:
> Here are the error messages:
> "A connection could not be established to (LOCAL)
> Reasons:SQL SERVER does not exist or access denied.
> ConnectionOpen(Connect())..
> Please verify SQL SERVER is running and check your server registration
> properties and try again." when trying to start the server from Enterprise
> Manager.
> Events logs:
> 17310 :
> SqlDumpExceptionHandler: Process 1708 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
>
> "Mark Allison" wrote:
> > Robert,
> >
> > Yes it does. Prosper, what error message do you get? You should also
> > post relevant sections from the error log.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > Robert Davis wrote:
> > > I don't think the eval version is supposed to work on Win2003.
> > >
> > > Robert.
> > >
> > > "Prosper" wrote:
> > >
> > >
> > >>Hi!
> > >>I tried to install the evaluation version of SqlServer2000 freshed download
> > >>from MS web site. the os is Windows Server 2003.
> > >>And when I try to start the SQLServer,it is impossible.
> > >>
> > >>Could anyone give a help?
> > >>Thanks.
> > >>
> > >>Prosper,
> > >>France
> > >>
> >

Problem with sql server eval on Windows server 2003

Hi!
I tried to install the evaluation version of SqlServer2000 freshed download
from MS web site. the os is Windows Server 2003.
And when I try to start the SQLServer,it is impossible.
Could anyone give a help?
Thanks.
Prosper,
FranceI don't think the eval version is supposed to work on Win2003.
Robert.
"Prosper" wrote:

> Hi!
> I tried to install the evaluation version of SqlServer2000 freshed downloa
d
> from MS web site. the os is Windows Server 2003.
> And when I try to start the SQLServer,it is impossible.
> Could anyone give a help?
> Thanks.
> Prosper,
> France
>|||Robert,
Yes it does. Prosper, what error message do you get? You should also
post relevant sections from the error log.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Robert Davis wrote:[vbcol=seagreen]
> I don't think the eval version is supposed to work on Win2003.
> Robert.
> "Prosper" wrote:
>|||Here are the error messages:
"A connection could not be established to (LOCAL)
Reasons:SQL SERVER does not exist or access denied.
ConnectionOpen(Connect())..
Please verify SQL SERVER is running and check your server registration
properties and try again." when trying to start the server from Enterprise
Manager.
Events logs:
17310 :
SqlDumpExceptionHandler: Process 1708 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
"Mark Allison" wrote:

> Robert,
> Yes it does. Prosper, what error message do you get? You should also
> post relevant sections from the error log.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Robert Davis wrote:
>|||Every thing is ok now; I redownload SQL Server for .NET SERVER 2003, and it
works.
Thanks for your help.
Prosper
"Prosper" wrote:
[vbcol=seagreen]
> Here are the error messages:
> "A connection could not be established to (LOCAL)
> Reasons:SQL SERVER does not exist or access denied.
> ConnectionOpen(Connect())..
> Please verify SQL SERVER is running and check your server registration
> properties and try again." when trying to start the server from Enterprise
> Manager.
> Events logs:
> 17310 :
> SqlDumpExceptionHandler: Process 1708 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
>
> "Mark Allison" wrote:
>

Problem with SQL 2005 install. Can Microsoft.SqlServer.MSMQTask.dll be recovered?

Hello!
I am trying to install SQL Server 2005 (Developer Edition -- the version
that came with my Visual Studio 2005 Professional Edition software).
For the most part, the install went pretty smoothly. However, during the
Integration Services portion, I got the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task. Contact your system administrator for assistance.
I Googled for some solutions, and came up with a few relevant hits:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
I tried the suggestions therein, but none of them seemed to solve the
problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
in my COM+ list). I couldn't hit "Retry" during the SQL installation and
have it gracefully resume.
I eventually just hit Ignore, and the rest of the install proceeded just
fine.
I'm wondering if there's any way to recover this file and/or COM+ entry?
I'm guessing that it's necessary for Integration Services?
(BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
installed at one point, too, but uninstalled before installing the current
version.)
Thanks for any help anyone can provide!
John PetersonHi
"John Peterson" wrote:
> Hello!
> I am trying to install SQL Server 2005 (Developer Edition -- the version
> that came with my Visual Studio 2005 Professional Edition software).
> For the most part, the install went pretty smoothly. However, during the
> Integration Services portion, I got the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
> Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: You must have administrative credentials to perform this
> task. Contact your system administrator for assistance.
> I Googled for some solutions, and came up with a few relevant hits:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
> I tried the suggestions therein, but none of them seemed to solve the
> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
> in my COM+ list). I couldn't hit "Retry" during the SQL installation and
> have it gracefully resume.
> I eventually just hit Ignore, and the rest of the install proceeded just
> fine.
> I'm wondering if there's any way to recover this file and/or COM+ entry?
> I'm guessing that it's necessary for Integration Services?
> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
> installed at one point, too, but uninstalled before installing the current
> version.)
> Thanks for any help anyone can provide!
> John Peterson
Have you tried a re-install
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
John|||John,
Thanks for the reply! I've got two questions:
If I re-install, will it correctly detect the components to re-install, even
if I've already upgraded to SP2 (and the critical update for SP2)?
What exactly is Integration Services in SQL 2005? Is that sort of like the
DTS replacement? If so, is the absence of this COM+ object going to be a
hindrance?
Kind regards,
John Peterson
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
> Hi
> "John Peterson" wrote:
>> Hello!
>> I am trying to install SQL Server 2005 (Developer Edition -- the version
>> that came with my Visual Studio 2005 Professional Edition software).
>> For the most part, the install went pretty smoothly. However, during the
>> Integration Services portion, I got the following error:
>> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
>> Error: -2146233087
>> Error message: Unknown error 0x80131501
>> Error description: You must have administrative credentials to perform
>> this
>> task. Contact your system administrator for assistance.
>> I Googled for some solutions, and came up with a few relevant hits:
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
>> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
>> I tried the suggestions therein, but none of them seemed to solve the
>> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask
>> entry
>> in my COM+ list). I couldn't hit "Retry" during the SQL installation and
>> have it gracefully resume.
>> I eventually just hit Ignore, and the rest of the install proceeded just
>> fine.
>> I'm wondering if there's any way to recover this file and/or COM+ entry?
>> I'm guessing that it's necessary for Integration Services?
>> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
>> installed at one point, too, but uninstalled before installing the
>> current
>> version.)
>> Thanks for any help anyone can provide!
>> John Peterson
> Have you tried a re-install
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
> John|||Oh -- I also meant to ask whether I could expect the previous error to "go
away" if I were to try and re-install, or if it would likely pop up again?
Now that I've done a little more research on Integration Services (also
known as SSIS), it looks like it is a DTS replacement (and more). As such,
I know that I'll need to be using this component -- so if I can resolve this
installation error, I'll be a happy camper. :-)
Thanks for any additional help you (or any others) can provide!
John Peterson
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23unJK%234fHHA.1216@.TK2MSFTNGP03.phx.gbl...
> John,
> Thanks for the reply! I've got two questions:
> If I re-install, will it correctly detect the components to re-install,
> even if I've already upgraded to SP2 (and the critical update for SP2)?
> What exactly is Integration Services in SQL 2005? Is that sort of like
> the DTS replacement? If so, is the absence of this COM+ object going to
> be a hindrance?
> Kind regards,
> John Peterson
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
>> Hi
>> "John Peterson" wrote:
>> Hello!
>> I am trying to install SQL Server 2005 (Developer Edition -- the version
>> that came with my Visual Studio 2005 Professional Edition software).
>> For the most part, the install went pretty smoothly. However, during
>> the
>> Integration Services portion, I got the following error:
>> Failed to install and configure assemblies C:\Program Files\Microsoft
>> SQL
>> Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+
>> catalog.
>> Error: -2146233087
>> Error message: Unknown error 0x80131501
>> Error description: You must have administrative credentials to perform
>> this
>> task. Contact your system administrator for assistance.
>> I Googled for some solutions, and came up with a few relevant hits:
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
>> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
>> I tried the suggestions therein, but none of them seemed to solve the
>> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask
>> entry
>> in my COM+ list). I couldn't hit "Retry" during the SQL installation
>> and
>> have it gracefully resume.
>> I eventually just hit Ignore, and the rest of the install proceeded just
>> fine.
>> I'm wondering if there's any way to recover this file and/or COM+ entry?
>> I'm guessing that it's necessary for Integration Services?
>> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005
>> CTP
>> installed at one point, too, but uninstalled before installing the
>> current
>> version.)
>> Thanks for any help anyone can provide!
>> John Peterson
>> Have you tried a re-install
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
>> John
>sql

Problem with reading in packet mode

Hi,
I'm using the following environment:
OS: Windows XP professional
SQL Server ODBC driver version: 2000.85.1117.00
RDBMS: SQL Server 2000
I have a question about reading a table in packet mode
using ODBC (i.e. using SQL_ROWSET_SIZE statement option).
I performed the following scenario:
1. I created a table with one int column (e.g. CREATE TABLE [TREAD] (Field1
int NULL))
2. I populated this table with 1 million records
3. I wrote a small basic ODBC application (console application using
Microsoft Visual C++ 6) to simply
read these records with minimum overhead (i.e. no other expensive
operations, no extensive console text output, etc.),
see attached sample.
4. Within this ODBC application, I'm reading/fetching all the records using
SQL_ROWSET_SIZE with value 10 (i.e. packet mode).
The problem is the following:
The relevant code for setting the packet mode is as follows, see attached
sample:
//...
//rc = SQLSetStmtOption(StmtHandle, SQL_ROWSET_SIZE, 10);
rc = SQLExecDirect(StmtHandle, SQLStmt, SQL_NTS);
rc = SQLSetStmtOption(StmtHandle, SQL_ROWSET_SIZE, 10);
//...
If SQLSetStmtOption() is called after SQLExecDirect(), the reading is very
fast, i.e. 1 sec.
If SQLSetStmtOption() is called before SQLExecDirect(), the reading is very
slow, i.e. 49 secs.
My question: which is the right call order ? So far, from the ODBC official
docs, I understand that
SQLSetStmtOption() can be called before and/or after SQLExecDirect() and, at
least in this case, it
shouldn't make any difference. I don't try to use different rowset/packet
sizes during reading, I just
try to read all records with a certain packet size (e.g. 10) from the very
beginning to the end.
Thanks for your help,
Ovidiu
begin 666 TestReadPacket.cpp
M+R]T97-T(')E860@.<&%C:V5T#0H-"B-I;F-L=61E(#QW:6YD;W=S+F@.^#0HC
M:6YC;'5D92 \<W%L+F@.^#0HC:6YC;'5D92 \<W%L97AT+F@.^#0HC:6YC;'5D
M92 \:6]S=')E86TN:#X-"B-I;F-L=61E(#QS=')I;F<N:#X-"B-I;F-L=61E
M(#QM871H+F@.^#0HC:6YC;'5D92 \=&EM92YH/@.T*#0IC;&%S<R!/1$)#7T-L
M87-S#0I[#0H@.(" @.<'5B;&EC.@.T*(" @.(" @.("!(14Y6(" @.("!%;G9(86YD
M;&4[#0H@.(" @.(" @.($A$0D,@.(" @.($-O;DAA;F1L93L-"B @.(" @.(" @.2%-4
M350@.(" @.4W1M=$AA;F1L93L@.#0H@.(" @.(" @.(%)%5$-/1$4@.(')C.PT*#0H@.
M(" @.<'5B;&EC.@.T*(" @.(" @.("!/1$)#7T-L87-S*"D[#0H@.(" @.(" @.('Y/
M1$)#7T-L87-S*"D[#0H@.(" @.(" @.(%)%5$-/1$4@.(%-H;W=297-U;'1S*"D[
M(" -"@.D)=F]I9"!0<FEN=$5R<F]R*"D[#0I].PT*#0I/1$)#7T-L87-S.CI/
M1$)#7T-L87-S*"D-"GL-"B @.("!R8R ](%-13%]354-#15-3.PT*#0H@.(" @.
M<F,@./2!344Q!;&QO8T5N=B@.F16YV2&%N9&QE*3L-"@.T*(" @.(&EF("AR8R ]
M/2!344Q?4U5#0T534RD-"B @.(" @.(" @.<F,@./2!344Q!;&QO8T-O;FYE8W0H
M16YV2&%N9&QE+" F0V]N2&%N9&QE*3L-"GT-"@.T*3T1"0U]#;&%S<SHZ?D]$
M0D-?0VQA<W,H*0T*>PT*(" @.(&EF("A#;VY(86YD;&4@.(3T@.3E5,3"D-"B @.
M(" @.(" @.4U%,1G)E94-O;FYE8W0H0V]N2&%N9&QE*3L-"@.T*(" @.(&EF("A%
M;G9(86YD;&4@.(3T@.3E5,3"D-"B @.(" @.(" @.4U%,1G)E945N=BA%;G9(86YD
M;&4I.PT*?0T*#0I2151#3T1%($]$0D-?0VQA<W,Z.E-H;W=297-U;'1S*'9O
M:60I#0I[#0H)4D540T]$10D@.<F,@./2 P.PT*#0H)4U%,24Y414=%4B!&,5LQ
M,%T[#0H)+R]&,5LP72 ](# L($8Q6S%=(#T@.,"P@.1C%;,ET@./2 P+"!&,5LS
M72 ](# L($8Q6S1=(#T@.,"P@.1C%;-5T@./2 P+"!&,5LV72 ](# L($8Q6S==
M(#T@.,"P@.1C%;.%T@./2 P+"!&,5LY72 ](# L($8Q6S$P72 ](# [#0H-"@.EU
M;G-I9VYE9"!L;VYG(&Y2;W=&971C:&5D(#T@.,#L-"@.EI;G0@.;D)U9F9E<E-I
M>F4@./2 Q,#L-"@.EU;G-I9VYE9"!S:&]R="H@.<%)O=U-T871U<R ](&YE=R!U
M;G-I9VYE9"!S:&]R=%MN0G5F9F5R4VEZ95T[#0H)#0H@.(" @.<F,@./2!344Q"
M:6YD0V]L*%-T;71(86YD;&4L(#$L(%-13%]#7TQ/3D<L("A344Q03TE.5$52
M*2 F1C$L('-I>F5O9BA&,2DL($Y53$PI.PT*#0H):6YT(&-N=" ](# [#0H)
M=VAI;&4H,2D-"@.E[#0H)"7)C(#T@.4U%,17AT96YD961&971C:"A3=&UT2& %N
M9&QE+"!344Q?1D540TA?3D585"P@.,"P@.)FY2;W=&971C:&5D+ "!P4F]W4W1A
M='5S*3L-"@.T*"0EI9B H4U%,7TY/7T1!5$%?1D]53D0@./3T@.<F,I"0T*"0D)
M8G)E86L[#0H-"@.D)8VYT*RL[#0H)"0T*"0EI9B H*&-N=" E(#4P,# P*2 ]
M/2 P*0T*"0D)8V]U=" \/"!C;G0@./#P@.96YD;#L-"@.E]#0H-"B @.("!R971U
M<FXH<F,I.PT*?0T*#0IV;VED($]$0D-?0VQA<W,Z.E!R:6YT17)R;W(H*0T*
M>PT*"5-13%)%5%523B @.<F,[#0H)4U%,0TA!4@.D)"7-T<E-T871E6U-13%]3
M44Q35$%415]325I%("L@.,5T[#0H)4U%,24Y414=%4@.D)<W%L1&)#;V1E( D)
M/2 P.PT*"5-13$-(05()"0ES=')$8DUE<W-A9V5;4U%,7TU!6%]-15-304=%
M7TQ%3D=42%T[#0H)4U%,4TU!3$Q)3E0)"6-B97)R;W)M<V<)"3T@.,#L-"@.EC
M:&%R"0D)<W1R6S$P,%T[#0H)<W1R8W!Y*'-T<BP@.(B(I.PT*"0T*"61O#0H)
M>PT*"0ER8R ](%-13$5R<F]R*$5N=DAA;F1L92P@.0V]N2&%N9&QE+" P+"!S
M=')3=&%T92P@.)G-Q;$1B0V]D92P@.<W1R1&)-97-S86=E+"!344Q?34%87TU%
M4U-!1T5?3$5.1U1(("T@.,2 L("9C8F5R<F]R;7-G("D[#0H)"0T*"0EI9B H
M(')C(#T](%-13%]354-#15-3("D-"@.D)>PT*"0D)<W1R8V%T*'-T<BP@.*&-O
M;G-T(&-H87(J*2!S=')3=&%T92D[#0H)"0ES=')C870H<W1R+" B(" B*3L-
M"@.D)"7-T<F-A="AS='(L("AC;VYS="!C:&%R*BD@.<W1R1&)-97-S86=E*3L-
M"@.D)?0T*"7T@.=VAI;&4H(')C(#T](%-13%]354-#15-3("D[#0H)#0H)8V]U
M=" \/" B17)R;W(@.;65S<V%G93H@.(B \/"!E;F1L.PT*"6-O=70@./#P@.<W1R
M(#P\(&5N9&P[#0I]#0H-"G9O:60@.;6%I;B@.I#0I[#0H)=&EM95]T('-T87)T
M.PT*"71I;65?="!E;F0[#0H-"@.ET:6UE*"9S=&%R="D[#0H-"B @.("!2151#
M3T1%("!R8R ](%-13%]354-#15-3.PT*(" @.(%-13$-(05(@.($1"3F%M95LR
M,%T@./2 B4U%,,C P,"([#0H@.(" @.4U%,0TA!4B @.4U%,4W1M=%LR-35=.PT*
M#0H@.(" @.3T1"0U]#;&%S<R @.17AA;7!L93L-"@.T*(" @.(&EF("A%>&%M<&QE
M+D-O;DAA;F1L92 A/2!.54Q,*0T*(" @.('L-"B @.(" @.(" @.<F,@./2!344Q#
M;VYN96-T*$5X86UP;&4N0V]N2&%N9&QE+"!$0DYA;64L(%-13%].5%,L( T*
M(" @.(" @.(" @.(" @.(" @.(" H4U%,0TA!4B J*2 B<FYD9&(U(BP@.4U%,7TY4
M4RP@.*%-13$-(05(@.*BD@.(F]V:61I=2(L(%-13%].5%,I.PT*#0H@.(" @.(" @.
M(')C(#T@.4U%,06QL;V-3=&UT*$5X86UP;&4N0V]N2&%N9&QE+" F17AA;7!L
M92Y3=&UT2&%N9&QE*3L-"@.T*(" @.(" @.("!I9B H<F,@./3T@.4U%,7U-50T-%
M4U,@.?'P@.<F,@./3T@.4U%,7U-50T-%4U-?5TE42%])3D9/*0T*(" @.(" @.("![
M#0H@.(" @.(" @.(" @.("!S=')C<'DH*&-H87(@.*BD@.4U%,4W1M="P@.(E-%3$5#
M5"!&:65L9#$@.1E)/32!44D5!1"(I.PT*#0H)"0ER8R ](#HZ4U%,4V5T4W1M
M=$]P=&EO;BA%>&%M<&QE+E-T;71(86YD;&4L(%-13%]23U=3151?4TE:12P@.
M,3 I.PD-"@.D)"7)C(#T@.4U%,17AE8T1I<F5C="A%>&%M<&QE+E-T;71(86YD
M;&4L(%-13%-T;70L(%-13%].5%,I.PT*"0D)+R]R8R ](#HZ4U%,4V5T4W1M
M=$]P=&EO;BA%>&%M<&QE+E-T;71(86YD;&4L(%-13%]23U=3151?4TE:12P@.
M,3 I.PD-"@.T*(" @.(" @.(" @.(" @.:68@.*')C(#T](%-13%]354-#15-3*0T*
M(" @.(" @.(" @.(" @.(" @.($5X86UP;&4N4VAO=U)E<W5L=',H*3L-"@.T*(" @.
M(" @.(" @.(" @.:68@.*$5X86UP;&4N4W1M=$AA;F1L92 A/2!.54Q,*0T*(" @.
M(" @.(" @.(" @.(" @.(')C(#T@.4U%,1G)E95-T;70H17AA;7!L92Y3=&UT2&%N
M9&QE+"!344Q?1%)/4"D[#0H@.(" @.(" @.('T-"@.D)96QS90T*"0E[#0H)"0E%
M>&%M<&QE+E!R:6YT17)R;W(H*3L-"@.D)?0T*#0H@.(" @.(" @.(')C(#T@.4U%,
M1&ES8V]N;F5C="A%>&%M<&QE+D-O;DAA;F1L92D[#0H@.(" @.?0T*#0H)=&EM
M92@.F96YD*3L-"@.T*"6-O=70@./#P@.(G1I;64@.96QA<'-E9" ]("(@./#P@.96YD
F("T@.<W1A<G0@./#P@.(B!S96-O;F1S(B \/"!E;F1L.PT*?0T*#0H`
`
end
Hi Ovidiu,
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when you call SQLSetStmtOption() before
SQLExecDirect() the performance is quite poor. If there is any
misunderstanding, please feel free to let me know.
Yes, as you know, the SQLSetStmtOption can be called before/after
SQLExecDirect. However, from ODBC 3.x SQLSetStmtOption is deprecated. It
has been replaced by SQLSetStmtAttr. So I suggest you try to use
SQLSetStmtAttr to see if performance goes better. Please check the
following link for more information.
http://msdn.microsoft.com/library/de...us/odbc/htm/od
bcsqlsetstmtoption.asp
If that still doens't work, please feel free to reply to the post.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
|||Hi Kevin,
Thank you for your quick reply.
I did try using the new functions: SQLSetStmtAttr instead of
SQLSetStmtOption and SQLFetchScroll instead of SQLExtendedFetch
respectively,
and still the problem is absolutely the same.
I attached a revised sample.
Thanks,
Ovidiu
"Kevin Yu [MSFT]" <v-kevy@.online.microsoft.com> wrote in message
news:byomeErhFHA.940@.TK2MSFTNGXA01.phx.gbl...
> Hi Ovidiu,
> First of all, I would like to confirm my understanding of your issue. From
> your description, I understand that when you call SQLSetStmtOption()
> before
> SQLExecDirect() the performance is quite poor. If there is any
> misunderstanding, please feel free to let me know.
> Yes, as you know, the SQLSetStmtOption can be called before/after
> SQLExecDirect. However, from ODBC 3.x SQLSetStmtOption is deprecated. It
> has been replaced by SQLSetStmtAttr. So I suggest you try to use
> SQLSetStmtAttr to see if performance goes better. Please check the
> following link for more information.
> http://msdn.microsoft.com/library/de...us/odbc/htm/od
> bcsqlsetstmtoption.asp
> If that still doens't work, please feel free to reply to the post.
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
begin 666 TestReadPacketNew.cpp
M+R]T97-T(')E860@.<&%C:V5T#0H-"B-I;F-L=61E(#QW:6YD;W=S+F@.^#0HC
M:6YC;'5D92 \<W%L+F@.^#0HC:6YC;'5D92 \<W%L97AT+F@.^#0HC:6YC;'5D
M92 \:6]S=')E86TN:#X-"B-I;F-L=61E(#QS=')I;F<N:#X-"B-I;F-L=61E
M(#QM871H+F@.^#0HC:6YC;'5D92 \=&EM92YH/@.T*#0IC;&%S<R!/1$)#7T-L
M87-S#0I[#0H@.(" @.<'5B;&EC.@.T*(" @.(" @.("!(14Y6(" @.("!%;G9(86YD
M;&4[#0H@.(" @.(" @.($A$0D,@.(" @.($-O;DAA;F1L93L-"B @.(" @.(" @.2%-4
M350@.(" @.4W1M=$AA;F1L93L@.#0H@.(" @.(" @.(%)%5$-/1$4@.(')C.PT*#0H@.
M(" @.<'5B;&EC.@.T*(" @.(" @.("!/1$)#7T-L87-S*"D[#0H@.(" @.(" @.('Y/
M1$)#7T-L87-S*"D[#0H@.(" @.(" @.(%)%5$-/1$4@.(%-H;W=297-U;'1S*"D[
M(" -"@.D)=F]I9"!0<FEN=$5R<F]R*"D[#0I].PT*#0I/1$)#7T-L87-S.CI/
M1$)#7T-L87-S*"D-"GL-"B @.("!R8R ](%-13%]354-#15-3.PT*#0H@.(" @.
M<F,@./2!344Q!;&QO8T5N=B@.F16YV2&%N9&QE*3L-"@.T*(" @.(&EF("AR8R ]
M/2!344Q?4U5#0T534RD-"B @.(" @.(" @.<F,@./2!344Q!;&QO8T-O;FYE8W0H
M16YV2&%N9&QE+" F0V]N2&%N9&QE*3L-"GT-"@.T*3T1"0U]#;&%S<SHZ?D]$
M0D-?0VQA<W,H*0T*>PT*(" @.(&EF("A#;VY(86YD;&4@.(3T@.3E5,3"D-"B @.
M(" @.(" @.4U%,1G)E94-O;FYE8W0H0V]N2&%N9&QE*3L-"@.T*(" @.(&EF("A%
M;G9(86YD;&4@.(3T@.3E5,3"D-"B @.(" @.(" @.4U%,1G)E945N=BA%;G9(86YD
M;&4I.PT*?0T*#0I2151#3T1%($]$0D-?0VQA<W,Z.E-H;W=297-U;'1S*'9O
M:60I#0I[#0H)4D540T]$10D@.<F,@./2 P.PD-"B @.("!344Q)3E1%1T52(" @.
M1FQD07)R87E;,3!=.PT*"5-13$E.5$5'15(@.("!);F1!<G)A>5LQ,%T[#0H-
M"B @.("!344Q54TU!3$Q)3E0@.4F]W4W1A='5S07)R87E;,3!=.PT*(" @.(%-1
M3%5)3E1%1T52("!.=6U2;W=S1F5T8VAE9#L-"B @.(" -"@.DO+W)C(#T@.4U%,
M4V5T4W1M=$%T='(H4W1M=$AA;F1L92P@.4U%,7T%45%)?4D]77T))3D1?5%E0
M12P@.4U%,7T))3D1?0EE?0T],54U.+" P*3L-"B @.(" O+W)C(#T@.4U%,4V5T
M4W1M=$%T='(H4W1M=$AA;F1L92P@.4U%,7T%45%)?4D]77U-405154U]05%(L
M(%)O=U-T871U<T%R<F%Y+" P*3L-"B @.(" O+W)C(#T@.4U%,4V5T4W1M=$%T
M='(H4W1M=$AA;F1L92P@.4U%,7T%45%)?4D]74U]&151#2$5$7U!44BP@.)DYU
M;5)O=W-&971C:&5D+" P*3L-"@.T*"7)C(#T@.4U%,0FEN9$-O;"A3=&UT2&%N
M9&QE+" Q+"!344Q?0U],3TY'+"!&;&1!<G)A>2P@.,"P@.26YD07)R87DI.PT*
M#0H):6YT(&-N=" ](# [#0H)=VAI;&4H,2D-"@.E[#0H)"2\O<F,@./2!344Q%
M>'1E;F1E9$9E=&-H*%-T;71(86YD;&4L(%-13%]&151#2%].15A4+" P+" F
M;E)O=T9E=&-H960L('!2;W=3=&%T=7,I.PT*"0ER8R ](%-13$9E=&-H4V-R
M;VQL*%-T;71(86YD;&4L(%-13%]&151#2%].15A4+" P*3L-"@.T*"0EI9B H
M4U%,7TY/7T1!5$%?1D]53D0@./3T@.<F,I"0T*"0D)8G)E86L[#0H-"@.D)8VYT
M*RL[#0H)"0T*"0DO+VEF("@.H8VYT("4@.-3 P,# I(#T](# I#0H)"2\O"6-O
M=70@./#P@.8VYT(#P\(&5N9&P[#0H)?0T*#0H@.(" @.<F5T=7)N*')C*3L-"GT-
M"@.T*=F]I9"!/1$)#7T-L87-S.CI0<FEN=$5R<F]R*"D-"GL-"@.E344Q21515
M4DX@.(')C.PT*"5-13$-(05()"0ES=')3=&%T95M344Q?4U%,4U1!5$5?4TE:
M12 K(#%=.PT*"5-13$E.5$5'15()"7-Q;$1B0V]D92 )"3T@.,#L-"@.E344Q#
M2$%2"0D)<W1R1&)-97-S86=E6U-13%]-05A?34534T%'15],14Y'5$A=.PT*
M"5-13%--04Q,24Y4"0EC8F5R<F]R;7-G"0D](# [#0H)8VAA<@.D)"7-T<ELQ
M,#!=.PT*"7-T<F-P>2AS='(L("(B*3L-"@.D-"@.ED;PT*"7L-"@.D)<F,@./2!3
M44Q%<G)O<BA%;G9(86YD;&4L($-O;DAA;F1L92P@.,"P@.<W1R4W1A=&4L("9S
M<6Q$8D-O9&4L('-T<D1B365S<V%G92P@.4U%,7TU!6%]-15-304=%7TQ%3D=4
M2" M(#$@.+" F8V)E<G)O<FUS9R I.PT*"0D-"@.D):68@.*"!R8R ]/2!344Q?
M4U5#0T534R I#0H)"7L-"@.D)"7-T<F-A="AS='(L("AC;VYS="!C:&%R*BD@.
M<W1R4W1A=&4I.PT*"0D)<W1R8V%T*'-T<BP@.(B @.(BD[#0H)"0ES=')C870H
M<W1R+" H8V]N<W0@.8VAA<BHI('-T<D1B365S<V%G92D[#0H)"7T-"@.E]('=H
M:6QE*"!R8R ]/2!344Q?4U5#0T534R I.PT*"0T*"6-O=70@./#P@.(D5R<F]R
M(&UE<W-A9V4Z("(@./#P@.96YD;#L-"@.EC;W5T(#P\('-T<B \/"!E;F1L.PT*
M?0T*#0IV;VED(&UA:6XH*0T*>PT*"71I;65?="!S=&%R=#L-"@.ET:6UE7W0@.
M96YD.PT*#0H)=&EM92@.F<W1A<G0I.PT*#0H@.(" @.4D540T]$12 @.<F,@./2!3
M44Q?4U5#0T534SL-"B @.("!344Q#2$%2("!$0DYA;65;,C!=(#T@.(E-13#(P
M,# B.PT*(" @.(%-13$-(05(@.(%-13%-T;71;,C4U73L-"@.E344Q524Y414=%
M4B @.07)R87E3:7IE(#T@.,3 [#0H-"B @.("!/1$)#7T-L87-S("!%>&%M<&QE
M.PT*#0H@.(" @.:68@.*$5X86UP;&4N0V]N2&%N9&QE("$]($Y53$PI#0H@.(" @.
M>PT*(" @.(" @.("!R8R ](%-13$-O;FYE8W0H17AA;7!L92Y#;VY(86YD;&4L
M($1"3F%M92P@.4U%,7TY44RP@.#0H@.(" @.(" @.(" @.(" @.(" @.("A344Q#2$%2
M("HI(")R;F1D8C4B+"!344Q?3E13+" H4U%,0TA!4B J*2 B;W9I9&EU(BP@.
M4U%,7TY44RD[#0H-"B @.(" @.(" @.<F,@./2!344Q!;&QO8U-T;70H17AA;7!L
M92Y#;VY(86YD;&4L("9%>&%M<&QE+E-T;71(86YD;&4I.PT*#0H@.(" @.(" @.
M(&EF("AR8R ]/2!344Q?4U5#0T534R!\?"!R8R ]/2!344Q?4U5#0T534U]7
M251(7TE.1D\I#0H@.(" @.(" @.('L-"B @.(" @.(" @.(" @.('-T<F-P>2@.H8VAA
M<B J*2!344Q3=&UT+" B4T5,14-4($9I96QD,2!&4D]-(%1214%$(BD[#0H-
M"@.D)"7)C(#T@.4U%,4V5T4W1M=$%T='(H17AA;7!L92Y3=&UT2 &%N9&QE+"!3
M44Q?05144E]23U=?05)205E?4TE:12P@.*%-13%!/24Y415(I($%R<F%Y4VEZ
M92P@.,"D[#0H-"@.D)"2\O<F,@./2 Z.E-13%-E=%-T;71/<'1I;VXH17AA;7!L
M92Y3=&UT2&%N9&QE+"!344Q?4D]74T547U-)6D4L(#$P*3L)#0H)"0ER8R ]
M(%-13$5X96-$:7)E8W0H17AA;7!L92Y3=&UT2&%N9&QE+"!344Q3=&UT+"!3
M44Q?3E13*3L-"@.D)"2\O<F,@./2 Z.E-13%-E=%-T;71/<'1I;VXH17AA;7!L
M92Y3=&UT2&%N9&QE+"!344Q?4D]74T547U-)6D4L(#$P*3L)#0H-"@.D)"2\O
M<F,@./2!344Q39713=&UT071T<BA%>&%M<&QE+E-T;71(86YD;&4L(%-13%]!
M5%127U)/5U]!4E)!65]325I%+" H4U%,4$])3E1%4BD@.07)R87E3:7IE+" P
M*3L-"@.T*(" @.(" @.(" @.(" @.:68@.*')C(#T](%-13%]354-#15-3*0T*(" @.
M(" @.(" @.(" @.(" @.($5X86UP;&4N4VAO=U)E<W5L=',H*3L-"@.T*(" @.(" @.
M(" @.(" @.:68@.*$5X86UP;&4N4W1M=$AA;F1L92 A/2!.54Q,*0T*(" @.(" @.
M(" @.(" @.(" @.(')C(#T@.4U%,1G)E95-T;70H17AA;7!L92Y3=&UT2&%N9&QE
M+"!344Q?1%)/4"D[#0H@.(" @.(" @.('T-"@.D)96QS90T*"0E[#0H)"0E%>&%M
M<&QE+E!R:6YT17)R;W(H*3L-"@.D)?0T*#0H@.(" @.(" @.(')C(#T@.4U%,1&ES
M8V]N;F5C="A%>&%M<&QE+D-O;DAA;F1L92D[#0H@.(" @.?0T*#0H)=&EM92@.F
M96YD*3L-"@.T*"6-O=70@./#P@.(G1I;64@.96QA<'-E9" ]("(@./#P@.96YD("T@.
C<W1A<G0@./#P@.(B!S96-O;F1S(B \/"!E;F1L.PT*?0T*#0H`
`
end
|||Hi Ovidiu,
What is the version of MDAC on your machine? Please try to upgrade to the
latest version MDAC 2.8 sp1 from the following link to see if it can
resolved the problem.
http://www.microsoft.com/downloads/d...895-efc2-4f8e-
a9e0-3a1afbd5922e&DisplayLang=en
Also I suggest you try to set to a larger packet size (e.g. 512).
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
|||Hi Kevin,
Yes, I have the latest MDAC version: MDAC 2.8 SP1 on WINDOWS XP SP2.
It's true, the performance gets much better when we increase the packet size
(we already knew that), as follows:
- for packet size 512 I get aprox. 7 secs (compared to 49 secs)
- increasing packet size over 512 won't improve performance anymore
The bottom line is: even when using larger values for the packet size,
performance is still poor compared
to the case when SQLSetStmtOption is called after SQLExecDirect (7 secs vs.
1 sec). Why is that happening ?
So, increasing packet size is a good workaround but up to a point.
There is the following bussiness impact: the customers using our application
are asking questions about this (strange) behaviour. Is there any
Microsoft doc, release note, etc. that refers to it ?
Could this issue be escalated such that, at least, we could get an official
answer from Microsoft regarding this behaviour. This would prove at
least that we are not misusing the ODBC API in any way (this was our main
concern in the first place because, actually, the order of ODBC
calls causes this strange behaviour).
Your help is appreciated.
Regards,
Ovidiu
"Kevin Yu [MSFT]" <v-kevy@.online.microsoft.com> wrote in message
news:hYsGn42hFHA.944@.TK2MSFTNGXA01.phx.gbl...
> Hi Ovidiu,
> What is the version of MDAC on your machine? Please try to upgrade to the
> latest version MDAC 2.8 sp1 from the following link to see if it can
> resolved the problem.
> http://www.microsoft.com/downloads/d...895-efc2-4f8e-
> a9e0-3a1afbd5922e&DisplayLang=en
> Also I suggest you try to set to a larger packet size (e.g. 512).
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
|||Hi Ovidiu,
Here, I suggest you try to use 4096 as the packet size to see if there is
any performance increment.. To get an official answer from Microsoft, you
need to contact PSS for professional support. You can find the contact
information from the following link:
http://support.microsoft.com/common/...gp;en-us;offer
prophone
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
|||Hi Kevin,
As I already specified in my previous reply, increasing packet size over a
certain limit won't improve performance anymore.
Thanks for your help. I will try to escalate this issue through PSS.
Regards,
Ovidiu
"Kevin Yu [MSFT]" <v-kevy@.online.microsoft.com> wrote in message
news:clVPgQDiFHA.3120@.TK2MSFTNGXA01.phx.gbl...
> Hi Ovidiu,
> Here, I suggest you try to use 4096 as the packet size to see if there is
> any performance increment.. To get an official answer from Microsoft, you
> need to contact PSS for professional support. You can find the contact
> information from the following link:
> http://support.microsoft.com/common/...gp;en-us;offer
> prophone
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
|||Hi Ovidiu,
Sorry that I could not provide further assistance on this issue. Good luck!
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."