Error when trying to run database engine tuning advisor

Hi,

I am getting "R6031- Attempt

to initialize the CRT more than once. This indicates a bug in your

application." when I am trying to database engine tuning advisor. I already followed the workaround from http://support.microsoft.com/default.aspx/kb/913395 but it did not help as I did not have any explorer.exe or any file in that registry folder.

I am using windows XP Sp2, using SQL server developer edition. I am wondering if anyone else has experienced this issue and can help me.

Thanks.

Have you tried attempted to invoke using the DTA on another machine?

I believe this could be the issue with Client tools, try to reinstall the Developer edition on this machine.

|||I will give it a try. I did try to reinstall on this machine but it did not help.

Error when trying to delete user

I created many test users in my application while trying to get a custom registration process to work, and now I would like to delete those users so they don't use up space in my database. When I go into the aspnet_Users table and try to delete a user, it gives me the following error:

----------

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__aspnet_Me__UserI__0F975522'. The conflict occurred in database 'DB_83996', table 'aspnet_Membership', column 'UserId'.

DELETE FROM [DB_83996].[dbo].[aspnet_Users] WHERE 1=0 OR ( [UserId] = '{7E864A07-6FE8-46EF-A2B8-354646D57C76}' )

----------

I don't know much about SQL statements, so is that statement it gave me the statement I need to use to delete that particular user? If not, how would I go about deleting these users I don't need anymore?

Thanks so much. :)

your table "aspnet_Membership" contains records that reference the user record you are trying to delete.

you will need to delete those records first.

|||Thanks. I could have sworn I tried that before because I knew those two tables were linked. Maybe it was something else I tried. Oh well. Thanks!!

error when sqlce application uses two publications

I′m developing an pocket pc application, I need replicate using two
publications.
My main form has two button, first button to obtain data from a publication
and the second button to obtain data from the other.
I delete my local PDA DB, and I can only obtain data from one of the
publication associated with the first button I push. When I push the other
one, I get
the "typical" error "Inicializing SQL reconciler has failed...".
Can I have only one DB publication associated with the PDA?
Any help would be appreciated.
Inma
SQL 2000 CE only supports a single publication per database. SQL 2005
CE/Mobile supports more than 1.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"inma" <inma@.discussions.microsoft.com> wrote in message
news:304E1356-B953-486E-866B-48F01B923D98@.microsoft.com...
> Im developing an pocket pc application, I need replicate using two
> publications.
> My main form has two button, first button to obtain data from a
publication
> and the second button to obtain data from the other.
> I delete my local PDA DB, and I can only obtain data from one of the
> publication associated with the first button I push. When I push the other
> one, I get
> the "typical" error "Inicializing SQL reconciler has failed...".
> Can I have only one DB publication associated with the PDA?
> Any help would be appreciated.
> Inma

error when running the DTSRUN command

Hi
We're using SqlServer 2000.

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:

[ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.

Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.

Has anyone got any idea what the problem is and ghow to solve it.

Thanks !

David GreenbergDavid Greenberg (davidgr@.iba.org.il) writes:

Quote:

Originally Posted by

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:
>
[ConnectionOpen (Connect()).]SQL Server does not exist or access denied
>
I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.
>
Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.
>
Has anyone got any idea what the problem is and ghow to solve it.

You can't accuse me to know too much about DTS, but I see that a
DTS package has connection properties. I would assume that you can
have a package on server A, and run it against server B.

So I would check the connection properties of the package (or the step,
as different task surely must be able to connect to different servers).

The error message simply means that you are trying to connect to a
server that is not available. (Not running, misspelled, a firewall
in the way etc.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
Q
Hi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler
,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profil
er,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK t
o
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Qsql

Error when replication to PDA

Dear all,
I am a new comer in replication with Pocket PC.
When I run with sample NorthwindCe application and replication with my SQL server. The following error have been occur:
Error Code :80072F76
Message : Header information is either corrupted or missing.
[,,,Header name,,]
Minor Err.: 28035
Source Microsft SQL Server 2000 Windows CE Edition
Would any one plese tell me that what's wrong has been happen in my application or setting?
Thank a lot!
Headless
What happens when you browse to your Web Server SQLCe directory?
Ie http://PublisherName/SQLCE/SSCESA10.dll or http://PublisherName/SQLCE/SSCESA20.dll
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Headless" wrote:

> Dear all,
> I am a new comer in replication with Pocket PC.
> When I run with sample NorthwindCe application and replication with my SQL server. The following error have been occur:
> Error Code :80072F76
> Message : Header information is either corrupted or missing.
> [,,,Header name,,]
> Minor Err.: 28035
> Source Microsft SQL Server 2000 Windows CE Edition
> Would any one plese tell me that what's wrong has been happen in my application or setting?
> Thank a lot!
> Headless
|||msg has been appear :
SQL Server CE Server Agent
Headless
"Hilary Cotter" wrote:
[vbcol=seagreen]
> What happens when you browse to your Web Server SQLCe directory?
> Ie http://PublisherName/SQLCE/SSCESA10.dll or http://PublisherName/SQLCE/SSCESA20.dll
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Headless" wrote:

Error when deleting

I have a msde back end for my application.
I also have an Access data file with linked tables to the SQL one.
My app accesses the data through the Access one through ODBC.

I have a data control and when try to delete a record as so:
DataControl.Recordset.Delete
I get a 'ODBC Call Failed' error.

Any ideas why?
The recordset's updateable property is true.

Thanks,THAT is the reason why I hate bound controls! Throw them away, replace dynamic calls with sp's, and live happily ever after! You think you have problems now while developing? Try putting it into prod, with more than 1 user, and you'll see what I mean (this is not an attack, just my heart screaming "WATCH OUT! THIS IS NOT A LIGHT AT THE END OF THE TUNNEL! IT IS A TRAIN!")|||Have you posted this on the Access forum for input?

Have you considered changing your Access interface to an Access Data Project? It synchronizes with SQL Server much better.

Have you checked to make sure that each of your linked tables has an enforced unique key and that Access was aware of this key when your table was linked?

Have you checked that your login has permission to delete those records?

Have you checked to be sure that the records in the table are participating in non-cascading relationships with other tables?|||...Have you checked it's plugged in?

Have you checked its pulse?

Have you checked your pulse?

...Have you checked if the neiborhood bar has started the happy hour? Go check it! It helps me!|||Here is my ms_sql_dba approved response:

OBVIOUSLY it is plugged in, or he wouldn't be getting an error message! But you didn't THINK about that, did you? And computers don't HAVE pulses, which you'd know if you bothered to read the manual!|||...?...|||...That was a joke...though I know I was accused of making my jokes somewhat untranslateable at times...But hey, that's what made me what I am, so there you have it!|||Originally posted by blindman
Here is my ms_sql_dba approved response:

OBVIOUSLY it is plugged in, or he wouldn't be getting an error message! But you didn't THINK about that, did you? And computers don't HAVE pulses, which you'd know if you bothered to read the manual!

Incorrigible

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshzt
Hi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to Windows XP and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshztHi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to Windows XP and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshztHi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

Error when connecting to sql 2000

I am trying to connect to a sql 2k database using a Microsoft Application block. I get the following error. It is saying about 2005, I verified that SQL 2K is running on the server.

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings

Any help will be appreciated.

Hi,

1. Verify the firewall have open the port of SQL 2K,

2. the Service pack versión I have some problems with versions under sp4

greetings.

|||

Hi jijo_robert,

That's a common issue. If you perform a search through google for the error message you are getting, you will find many valuable solutions.

The first thing for you to do is to check your connection string, make sure you have used the correct server name, database name , authentication mode,,.etc

If you still cannot figure it out, open up your query analyzer and connect to your database manually, see if you can login this way(there is a possibility that there maybe some problem in the server side)

Hope my suggestion helps

|||I could connect using sql query analyzer. I can also connect during design time (Gridview --> SQLDatasource --> and see the records with a connection string) but when I run it it gives this error.|||Make sure that you don't have any other program using the database other than Visual Web Developer if that is what u're using, or having the connection open. What mostly cause this kind of problem is when you have your database open in the database explorer of your VWD or VS.Hope this works.Please give me the appropriate make if this works for this is my first post on the forums|||

No other program is using SQL server databsae

error when connect to sqlserver from another machine

hi ..

i install sqlserver and make app with vb6 using ADO to connect to the database and successfully

i put that application on another pc on the network
when i open it it says "can't login computername\guest" ?!!

any help

thanks in advance.any answers|||Are both of your pcs on a domain or a workgroup? If it's not domain, you need to create a same account/password pair on both machines and use that account to login.|||thanks

Xinwei Hong for reply

the two machines on a workgroup so .. could you explain pcs under domain in few lines ?
now i will create two users on the two machines and tell you later

thanks in advance.
|||By "pcs under domain", I mean whether your PC is under a domain which is usually used in median/large company. In this case, domain controller will help you do a lot of things.|||thanks for reply

you says i can do a lot of things if i'm under domain like what ?and what is the domain controler ? could you explain ?

and if you have short time i can talk to you in messanger it will be kind from you

thanks|||i make 2 users with same name but ..
the same problem occurs ?|||It's hard to describe "domain controller" and related stuff in short words. I recommend you find some documents related to Windows Networks to read.

Are you sure your client is running under the user account you created and you used that account to login to the server? It means you may need to login the client Windows system and run your client app under that account. If you user Administrator or even logon the computer without a user/password, it won't work.|||is this means that i need a password for administrator user to login to the database server ?|||Not necessary. SQL server runs as a service under various account(e.g. network service, local system, administrator account, etc.).

ERROR TIMEOUT EXPIRED

HELLO ALL

IM AM DEVELOPING WINDOWS APPLICATION (VB.NET2005).

I HAVE BACK END SQL SERVER 2000.

MY OS IS WINDOWS XP.

NOW I HAVE A ANOTHER MACHINE , IN THAT I INSTALLED MY APPLICATION.

NOW WHEN I LOGIN INTO MY APPLPICATION, IT DISPLAYS AN ERROR

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

WHAT WILL BE PROBLEM IN THIS

PLEASE HELP ME.

ANOTHER THING IF I CHANGE DATA SOURCE NAME AS SERVERSYSTEM(IT IS THE NAME OF OUR SERVER 2003) IT WORKS FINE

THANKS IN ADVCANCE

This error is frequently caused by an incorrect server name or instance name in your connection string. Check that.

By the way, this forum is dedicated to SQL Server Notification Services. You'll find better / more answers in a forum that more appropriate for your issue.

HTH...

Joe

Error selecting text from a SQL database

Hello,
I have an application that used an access database and I am currently
migrating to SQL Server. The software is designed to use Odbc object
found in the .Net framework version 1.1. I have a simple select
statement that is driving me nuts. It works fine with the Access
databases but dies under SQL Server.
The statement is:
SELECT
settingValue
FROM
tblSettings
WHERE ( owner=@.owner and setting=@.setting )
settingValue is an ntext field and owner and setting are varchar fields.
When I try to execute the query I get an error:
ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
ntext, and image data types cannot be compared or sorted, except when
using IS NULL, or LIKE operator.
There are no indexes on any of the fields so I cannot figure out what
the problem is.
Mageos
Try this to see if you still get an error:
SELECT
owner,
setting,
settingValue
FROM
tblSettings
WHERE owner = @.owner
and setting=@.setting
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mageos" <matt.dot.osborne@.cox.dot.com> wrote in message
news:vbGyd.2281$wZ2.581@.newssvr13.news.prodigy.com ...
> Hello,
> I have an application that used an access database and I am currently
> migrating to SQL Server. The software is designed to use Odbc object
> found in the .Net framework version 1.1. I have a simple select
> statement that is driving me nuts. It works fine with the Access
> databases but dies under SQL Server.
> The statement is:
> SELECT
> settingValue
> FROM
> tblSettings
> WHERE ( owner=@.owner and setting=@.setting )
> settingValue is an ntext field and owner and setting are varchar fields.
> When I try to execute the query I get an error:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
> ntext, and image data types cannot be compared or sorted, except when
> using IS NULL, or LIKE operator.
> There are no indexes on any of the fields so I cannot figure out what
> the problem is.
> Mageos
|||> settingValue is an ntext field and owner and setting are varchar fields.
> When I try to execute the query I get an error:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
> ntext, and image data types cannot be compared or sorted, except when
> using IS NULL, or LIKE operator.
The error tells you exactly where the problem is. You are trying to do a
compare on an ntext field. Double check your create table statement. I think
you will find that either owner or setting is not of the datatype you
expected. What method of creating the tables in SQL did you use. I find that
often when I let SQL help me out converting data from an outside source, it
comes up with insane assumptions about what the datatype needs to be.
I tried reproducing the error with the script below and it works fine for
me.
create table test(
settingvalue ntext,
owner varchar(5),
setting varchar(5)
)
insert test (settingvalue, owner, setting)
values ('jgdfkjgiugsv8ohyohfef mne hevbe vmnerv', '1', '2')
declare @.owner varchar(5)
declare @.setting varchar(5)
set @.owner = '1'
set @.setting ='2'
select * from test where owner = @.owner and setting = @.setting