Error: File /iisHelp/common/500-100.asp Line 0 Out of memory.

Hi
i am getting the this error now a days. can help me out
because my IIS server geting very slow & also i have to
restart the IIS Server every time also when this DLHOST
coming that time My IIS server get Problem.
can help me out & give us what could be the problem it is
very urg for us i am facing very Big problem
here i am sending the error Log from eventViewr
Error: File /iisHelp/common/500-100.asp Line 0 Out of
memory. Unable to allocate required memory..
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.What does this have to do with SQL Server?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"sanjaypawar@.hotmail.com" <anonymous@.discussions.microsoft.com> wrote in
message news:731e01c47641$2a233a00$a401280a@.phx.gbl...
> Hi
> i am getting the this error now a days. can help me out
> because my IIS server geting very slow & also i have to
> restart the IIS Server every time also when this DLHOST
> coming that time My IIS server get Problem.
> can help me out & give us what could be the problem it is
> very urg for us i am facing very Big problem
> here i am sending the error Log from eventViewr
>
> Error: File /iisHelp/common/500-100.asp Line 0 Out of
> memory. Unable to allocate required memory..
> For additional information specific to this message please
> visit the Microsoft Online Support site located at:
> http://www.microsoft.com/contentredirect.asp.sql

Error: File /iisHelp/common/500-100.asp Line 0 Out of memory.

Hi
i am getting the this error now a days. can help me out
because my IIS server geting very slow & also i have to
restart the IIS Server every time also when this DLHOST
coming that time My IIS server get Problem.
can help me out & give us what could be the problem it is
very urg for us i am facing very Big problem
here i am sending the error Log from eventViewr
Error: File /iisHelp/common/500-100.asp Line 0 Out of
memory. Unable to allocate required memory..
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.What does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"sanjaypawar@.hotmail.com" <anonymous@.discussions.microsoft.com> wrote in
message news:731e01c47641$2a233a00$a401280a@.phx.gbl...
> Hi
> i am getting the this error now a days. can help me out
> because my IIS server geting very slow & also i have to
> restart the IIS Server every time also when this DLHOST
> coming that time My IIS server get Problem.
> can help me out & give us what could be the problem it is
> very urg for us i am facing very Big problem
> here i am sending the error Log from eventViewr
>
> Error: File /iisHelp/common/500-100.asp Line 0 Out of
> memory. Unable to allocate required memory..
> For additional information specific to this message please
> visit the Microsoft Online Support site located at:
> http://www.microsoft.com/contentredirect.asp.

Error: File /iisHelp/common/500-100.asp Line 0 Out of memory.

Hi
i am getting the this error now a days. can help me out
because my IIS server geting very slow & also i have to
restart the IIS Server every time also when this DLHOST
coming that time My IIS server get Problem.
can help me out & give us what could be the problem it is
very urg for us i am facing very Big problem
here i am sending the error Log from eventViewr
Error: File /iisHelp/common/500-100.asp Line 0 Out of
memory. Unable to allocate required memory..
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.
What does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"sanjaypawar@.hotmail.com" <anonymous@.discussions.microsoft.com> wrote in
message news:731e01c47641$2a233a00$a401280a@.phx.gbl...
> Hi
> i am getting the this error now a days. can help me out
> because my IIS server geting very slow & also i have to
> restart the IIS Server every time also when this DLHOST
> coming that time My IIS server get Problem.
> can help me out & give us what could be the problem it is
> very urg for us i am facing very Big problem
> here i am sending the error Log from eventViewr
>
> Error: File /iisHelp/common/500-100.asp Line 0 Out of
> memory. Unable to allocate required memory..
> For additional information specific to this message please
> visit the Microsoft Online Support site located at:
> http://www.microsoft.com/contentredirect.asp.

Error: 8646, Severity: 21, State: 1

We are seeing this error. It has only happened one time. Does anyone
know what could be causing this other than a Latin1_General_BIN collation.
TIA,
-Ben
The index entry for row ID was not found in index ID 3, of table
1285579618, in database 'db'..
Error: 8646, Severity: 21, State: 1Run a DBCC CHECKDB against your database and fix any errors
"Ben" <bmilliron@.gmail.com> wrote in message
news:eiRDobEZEHA.3892@.TK2MSFTNGP09.phx.gbl...
> We are seeing this error. It has only happened one time. Does anyone
> know what could be causing this other than a Latin1_General_BIN collation.
> TIA,
> -Ben
> The index entry for row ID was not found in index ID 3, of table
> 1285579618, in database 'db'..
> Error: 8646, Severity: 21, State: 1

Error: 8646, Severity: 21, State: 1

We are seeing this error. It has only happened one time. Does anyone
know what could be causing this other than a Latin1_General_BIN collation.
TIA,
-Ben
The index entry for row ID was not found in index ID 3, of table
1285579618, in database 'db'..
Error: 8646, Severity: 21, State: 1Run a DBCC CHECKDB against your database and fix any errors
"Ben" <bmilliron@.gmail.com> wrote in message
news:eiRDobEZEHA.3892@.TK2MSFTNGP09.phx.gbl...
> We are seeing this error. It has only happened one time. Does anyone
> know what could be causing this other than a Latin1_General_BIN collation.
> TIA,
> -Ben
> The index entry for row ID was not found in index ID 3, of table
> 1285579618, in database 'db'..
> Error: 8646, Severity: 21, State: 1sql

Error: 8646, Severity: 21, State: 1

We are seeing this error. It has only happened one time. Does anyone
know what could be causing this other than a Latin1_General_BIN collation.
TIA,
-Ben
The index entry for row ID was not found in index ID 3, of table
1285579618, in database 'db'..
Error: 8646, Severity: 21, State: 1
Run a DBCC CHECKDB against your database and fix any errors
"Ben" <bmilliron@.gmail.com> wrote in message
news:eiRDobEZEHA.3892@.TK2MSFTNGP09.phx.gbl...
> We are seeing this error. It has only happened one time. Does anyone
> know what could be causing this other than a Latin1_General_BIN collation.
> TIA,
> -Ben
> The index entry for row ID was not found in index ID 3, of table
> 1285579618, in database 'db'..
> Error: 8646, Severity: 21, State: 1

Error: 18456, Severity: 14, State: 16.

I'm getting the same error trying to connect for the first time in SQL Server
2005 from a c#.NET console app. Did you figure it out?
"payyans" wrote:
[vbcol=seagreen]
> The application was able to make connections using the same credentials in
> the initial hours of run. So, I am not sure why permission is denied at a
> later point. Thanks for the response.
> -payyans
> "Russell Fields" wrote:
Not yet.
-payyans
"jt" wrote:
[vbcol=seagreen]
> I'm getting the same error trying to connect for the first time in SQL Server
> 2005 from a c#.NET console app. Did you figure it out?
> "payyans" wrote:

Error: 15457, Severity: 0, State: 1

I get this error every time that I try to email through SQL this has
stopped me from being able to use sql mail for the last month and all of
my notifications are failing. I've read the other thred on this and
didn't get much of a solution, ANY Ideas?
--
Posted via http://dbforums.comThis is what it says in the SQL Server books online
Configuration option '%ls' changed from %ld to %ld. Run
the RECONFIGURE statement to install.
Not sure if that helps or not.
>--Original Message--
>I get this error every time that I try to email through
SQL this has
>stopped me from being able to use sql mail for the last
month and all of
>my notifications are failing. I've read the other thred
on this and
>didn't get much of a solution, ANY Ideas?
>
>--
>Posted via http://dbforums.com
>.
>|||consider using xpsmtp instead of sql mail from
http://www.sqldev.net/xp/xpsmtp.htm
We decided to try this after getting frustrated by
occasional problems with sql mail, since then we never
have problems emailing from sql server.
>--Original Message--
>I get this error every time that I try to email through
SQL this has
>stopped me from being able to use sql mail for the last
month and all of
>my notifications are failing. I've read the other thred
on this and
>didn't get much of a solution, ANY Ideas?
>
>--
>Posted via http://dbforums.com
>.
>

Error: ""The transaction has exceeded the allotted time"

I receive this error "The transaction has exceeded the allotted time" in a pop-up sometimes when I use DTS. This happens in an alleatory way, when I run a package, when I try to open a package or save it, and normally happens when the machine is very busy with another process. I'm running SQL Server 2000 with SP2, and Windows 2000 Advanced Server with SP2.

Thank you very much in advance,

XavierWas any one able to find an answer to this? I'm getting the exact same error. Thanks.

Originally posted by xfolch
I receive this error "The transaction has exceeded the allotted time" in a pop-up sometimes when I use DTS. This happens in an alleatory way, when I run a package, when I try to open a package or save it, and normally happens when the machine is very busy with another process. I'm running SQL Server 2000 with SP2, and Windows 2000 Advanced Server with SP2.

Thank you very much in advance,

Xavier|||I solve it saving the packages as Local Packages instead of Meta Data Services Package: it never happens again|||So what is the difference between the two: "Local Packages" and "Meta Data Services Packages".

Thanks.

Originally posted by xfolch
I solve it saving the packages as Local Packages instead of Meta Data Services Package: it never happens again|||It works the same, but it's store in a different format:

When you save a Data Transformation Services (DTS) package, you save all DTS connections, DTS tasks, DTS transformations, and workflow steps and preserve the graphical layout of these objects on the DTS Designer design sheet.

You can save a package to:

Microsoft SQL Server.
With this default save option, you can store a package as a SQL Server msdb table, allowing you to: store packages on any instances of SQL Server on your network; keep a convenient inventory of saved packages in SQL Server Enterprise Manager; and create, delete, and branch multiple package versions during the package development process.

SQL Server 2000 Meta Data Services.
With this save option, you can maintain historical information about the data manipulated by the package. However, Meta Data Services and the repository database must be installed and operational on your server. You can track the columns and tables that are used by the package as a source or destination. You also can use the data lineage feature to track which version of a package created a particular row. You can use these types of information for decision-support applications.

error wmi task

i have really hard time with this.it sits there showing yellow or it neither runs...

how should this be actually set?

Again, Books On-Line will help you.

http://msdn2.microsoft.com/en-us/library/ms141130.aspx|||i have look at everything but this dosent seem to work at all...|||

That doesn't help us. We don't know what your trying to accomplish, and we don't know what settings you've tried, etc... Provide more details and perhaps we can help you.

|||

ok i transfer from flat file to sql database

i want to put this task in place to check if the file had arrived.If so i want my packge execution to begin.

In my control flow i have wmi task

the file is located on shared drive.and not on my local machine.(ex t:\test\files\text.txt)

here

Connection managers:

servename=\\localhost

namespace=\root\cimv2

WMIQuerySourceTypeirectinput

WMIQuerySource:

SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE Targetinstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"t:\test\files\text.txt""

Rest of the fields i leave as they are..

Is this right?please let me know..

|||

sureshv wrote:

ok i transfer from flat file to sql database

i want to put this task in place to check if the file had arrived.If so i want my packge execution to begin.

In my control flow i have wmi task

the file is located on shared drive.and not on my local machine.(ex t:\test\files\text.txt)

I wouldn't use WMI for this. I'd probably write a script task to periodically check for the file and sleep in between. Or use the File Watcher task. http://www.sqlis.com/23.aspx

|||

I've played around with the WMI components some, but not enough to remember proper syntax...

That said, you might look at the fact that you're specifying the Win32_Directory.GroupComponent as an individual file. I believe you might want it as the PartComponent.

|||i am just going mad with this task...i try several things and read stuff on it....but i just cant get it to work....it runs and shows yellow forever....could anyone let me know how it work?
your help is appreciated....

error wmi task

i have really hard time with this.it sits there showing yellow or it neither runs...

how should this be actually set?

Again, Books On-Line will help you.

http://msdn2.microsoft.com/en-us/library/ms141130.aspx|||i have look at everything but this dosent seem to work at all...|||

That doesn't help us. We don't know what your trying to accomplish, and we don't know what settings you've tried, etc... Provide more details and perhaps we can help you.

|||

ok i transfer from flat file to sql database

i want to put this task in place to check if the file had arrived.If so i want my packge execution to begin.

In my control flow i have wmi task

the file is located on shared drive.and not on my local machine.(ex t:\test\files\text.txt)

here

Connection managers:

servename=\\localhost

namespace=\root\cimv2

WMIQuerySourceTypeirectinput

WMIQuerySource:

SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE Targetinstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"t:\test\files\text.txt""

Rest of the fields i leave as they are..

Is this right?please let me know..

|||

sureshv wrote:

ok i transfer from flat file to sql database

i want to put this task in place to check if the file had arrived.If so i want my packge execution to begin.

In my control flow i have wmi task

the file is located on shared drive.and not on my local machine.(ex t:\test\files\text.txt)

I wouldn't use WMI for this. I'd probably write a script task to periodically check for the file and sleep in between. Or use the File Watcher task. http://www.sqlis.com/23.aspx

|||

I've played around with the WMI components some, but not enough to remember proper syntax...

That said, you might look at the fact that you're specifying the Win32_Directory.GroupComponent as an individual file. I believe you might want it as the PartComponent.

|||i am just going mad with this task...i try several things and read stuff on it....but i just cant get it to work....it runs and shows yellow forever....could anyone let me know how it work?
your help is appreciated....

Error with linked Servers

I am having an extremely difficult time getting a linked server to
work. I am attempting to link to using an ODBC driver to a proprietary
database. I can create the ODBC connection and see the tables from
with Access using this connection. I can set up the linked server but
as soon as I attempt to view the tables it either gives me an error
7399 or just sits there. Any help would be appreciative and if there
are any other questions I need to answer just let me know.
Thanks,
Matt
Can you elaborate on how are you connecting via Access and how are you using
to create the linked server?
"Matt" wrote:

> I am having an extremely difficult time getting a linked server to
> work. I am attempting to link to using an ODBC driver to a proprietary
> database. I can create the ODBC connection and see the tables from
> with Access using this connection. I can set up the linked server but
> as soon as I attempt to view the tables it either gives me an error
> 7399 or just sits there. Any help would be appreciative and if there
> are any other questions I need to answer just let me know.
> Thanks,
> Matt
>

Error with Linked Servers

From time to time the linked servers we have set up cannot be accessed. When
I click on the tables node under the linked server within enterprise manager
the session hangs and no error message is displayed. When querying the data
via an openquery no error is thrown, the query simply runs until manually
aborted.
I've created a linked server OK but immediately cannot open it. The only way
around this problem we have is a reboot of the server. Does anyone know how
to resolve this problem and also what would cause this.
Thanks
MikeMikeD
Do you have ping to linked server?
"MikeD" <MikeD@.discussions.microsoft.com> wrote in message
news:ACBEC816-1EE1-46E8-9535-8E52BB7C502A@.microsoft.com...
> From time to time the linked servers we have set up cannot be accessed.
> When
> I click on the tables node under the linked server within enterprise
> manager
> the session hangs and no error message is displayed. When querying the
> data
> via an openquery no error is thrown, the query simply runs until manually
> aborted.
> I've created a linked server OK but immediately cannot open it. The only
> way
> around this problem we have is a reboot of the server. Does anyone know
> how
> to resolve this problem and also what would cause this.
> Thanks
> Mike|||I can ping the server that sql is on if that's what you mean. I can see and
create linked servers but cannot query them - see below.
"Uri Dimant" wrote:

> MikeD
> Do you have ping to linked server?
> "MikeD" <MikeD@.discussions.microsoft.com> wrote in message
> news:ACBEC816-1EE1-46E8-9535-8E52BB7C502A@.microsoft.com...
>
>|||MikeD
Do you run the query in this way?
SELECT <> FROM Server.dbname.dbo.table
"MikeD" <MikeD@.discussions.microsoft.com> wrote in message
news:2C11B49F-D1BF-48C2-9ECC-2470666F9691@.microsoft.com...[vbcol=seagreen]
>I can ping the server that sql is on if that's what you mean. I can see and
> create linked servers but cannot query them - see below.
> "Uri Dimant" wrote:
>|||No - it's an openquery so it's :
SELECT * FROM OPENQUERY[linked_server_name], 'Select * from table_name'
But the problem isn't so much in the query it's the fact that when you
select the linked server the system hangs with no error message and the only
way we have of resolving the issue is a server reboot
"Uri Dimant" wrote:

> MikeD
> Do you run the query in this way?
> SELECT <> FROM Server.dbname.dbo.table
>
>
> "MikeD" <MikeD@.discussions.microsoft.com> wrote in message
> news:2C11B49F-D1BF-48C2-9ECC-2470666F9691@.microsoft.com...
>
>|||Well, is it large set data you want to return?
exec sp_serveroption 'servername','data access','true'
"MikeD" <MikeD@.discussions.microsoft.com> wrote in message
news:6EA13818-E61B-49E7-B6E0-35F581ADAF0F@.microsoft.com...[vbcol=seagreen]
> No - it's an openquery so it's :
> SELECT * FROM OPENQUERY[linked_server_name], 'Select * from table_name
'
> But the problem isn't so much in the query it's the fact that when you
> select the linked server the system hangs with no error message and the
> only
> way we have of resolving the issue is a server reboot
> "Uri Dimant" wrote:
>|||It's nothing to do with the query or the size of data. the problem is that
the linked server cannot be accessed until a reboot is done.
"Uri Dimant" wrote:

> Well, is it large set data you want to return?
> exec sp_serveroption 'servername','data access','true'
>
> "MikeD" <MikeD@.discussions.microsoft.com> wrote in message
> news:6EA13818-E61B-49E7-B6E0-35F581ADAF0F@.microsoft.com...
>
>

Error with linked Servers

I am having an extremely difficult time getting a linked server to
work. I am attempting to link to using an ODBC driver to a proprietary
database. I can create the ODBC connection and see the tables from
with Access using this connection. I can set up the linked server but
as soon as I attempt to view the tables it either gives me an error
7399 or just sits there. Any help would be appreciative and if there
are any other questions I need to answer just let me know.
Thanks,
MattCan you elaborate on how are you connecting via Access and how are you using
to create the linked server?
"Matt" wrote:

> I am having an extremely difficult time getting a linked server to
> work. I am attempting to link to using an ODBC driver to a proprietary
> database. I can create the ODBC connection and see the tables from
> with Access using this connection. I can set up the linked server but
> as soon as I attempt to view the tables it either gives me an error
> 7399 or just sits there. Any help would be appreciative and if there
> are any other questions I need to answer just let me know.
> Thanks,
> Matt
>

Error with linked Servers

I am having an extremely difficult time getting a linked server to
work. I am attempting to link to using an ODBC driver to a proprietary
database. I can create the ODBC connection and see the tables from
with Access using this connection. I can set up the linked server but
as soon as I attempt to view the tables it either gives me an error
7399 or just sits there. Any help would be appreciative and if there
are any other questions I need to answer just let me know.
Thanks,
MattCan you elaborate on how are you connecting via Access and how are you using
to create the linked server?
"Matt" wrote:
> I am having an extremely difficult time getting a linked server to
> work. I am attempting to link to using an ODBC driver to a proprietary
> database. I can create the ODBC connection and see the tables from
> with Access using this connection. I can set up the linked server but
> as soon as I attempt to view the tables it either gives me an error
> 7399 or just sits there. Any help would be appreciative and if there
> are any other questions I need to answer just let me know.
> Thanks,
> Matt
>

Error with Execute sql task and full result set: " not been initialized before calling 'Fi

This is the first time I've tried creating an "execute sql task" with a "full result set".

I've read in the documentation that I must set the resultname to 0, which is done, and that the variable must be of type object. Also done.

[Execute SQL Task] Error: Executing the query "select * from blah" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Has anyone else had success with a full result set?

Thanks,
-Lori

Yes. I have an example doing exactly this here:

SSIS Nugget: Execute SQL Task into an object variable - Shred it with a Foreach loop
(http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx)

-Jamie

|||Jamie,

The variable *is* of type Object (i believe i mentioned that).
Since this fails, I cannot move forward with the foreach loop.

I'm using 64bit sql server but debugging in Run64BitRuntime as False.

Any other ideas?

-Lori|||

lorijean44 wrote:

Jamie,

The variable *is* of type Object (i believe i mentioned that).

Yes you did. You also asked if anyone else has had any success which I have and was giving you a downloadable example of it working which I thought might be useful to you.

lorijean44 wrote:

Since this fails, I cannot move forward with the foreach loop.

I'm using 64bit sql server but debugging in Run64BitRuntime as False.

Any other ideas?

-Lori

Afraid not. Without being there its hard to say what the problem might be.

Regards

-Jamie

|||I noticed that you said in your blog, "just update the connection to point to your sql server". I thought I should mention that I'm actually trying to run this against a mysql server, with an ADO.net connection. I don't think that should matter, but who knows?

I'll play around and see if it works against a SQL Server just to try it.|||Yep, works great against a sql server (OLE DB Connection).

I will then update my question to be:
has anyone gotten a full result set to work with an ADO.net connection?|||

lorijean44 wrote:

I noticed that you said in your blog, "just update the connection to point to your sql server". I thought I should mention that I'm actually trying to run this against a mysql server, with an ADO.net connection. I don't think that should matter, but who knows?

I'll play around and see if it works against a SQL Server just to try it.

I'd bevery surprised if that was anything to do with it but who knows - give it a try.

Also note that my example used OLE DB Connection Manager rather than ADO.Net. That could be an avenue of investigation also.

-Jamie

Error with Execute sql task and full result set: " not been initialized before calling

This is the first time I've tried creating an "execute sql task" with a "full result set".

I've read in the documentation that I must set the resultname to 0, which is done, and that the variable must be of type object. Also done.

[Execute SQL Task] Error: Executing the query "select * from blah" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Has anyone else had success with a full result set?

Thanks,
-Lori

Yes. I have an example doing exactly this here:

SSIS Nugget: Execute SQL Task into an object variable - Shred it with a Foreach loop
(http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx)

-Jamie

|||Jamie,

The variable *is* of type Object (i believe i mentioned that).
Since this fails, I cannot move forward with the foreach loop.

I'm using 64bit sql server but debugging in Run64BitRuntime as False.

Any other ideas?

-Lori|||

lorijean44 wrote:

Jamie,

The variable *is* of type Object (i believe i mentioned that).

Yes you did. You also asked if anyone else has had any success which I have and was giving you a downloadable example of it working which I thought might be useful to you.

lorijean44 wrote:

Since this fails, I cannot move forward with the foreach loop.

I'm using 64bit sql server but debugging in Run64BitRuntime as False.

Any other ideas?

-Lori

Afraid not. Without being there its hard to say what the problem might be.

Regards

-Jamie

|||I noticed that you said in your blog, "just update the connection to point to your sql server". I thought I should mention that I'm actually trying to run this against a mysql server, with an ADO.net connection. I don't think that should matter, but who knows?

I'll play around and see if it works against a SQL Server just to try it.|||Yep, works great against a sql server (OLE DB Connection).

I will then update my question to be:
has anyone gotten a full result set to work with an ADO.net connection?|||

lorijean44 wrote:

I noticed that you said in your blog, "just update the connection to point to your sql server". I thought I should mention that I'm actually trying to run this against a mysql server, with an ADO.net connection. I don't think that should matter, but who knows?

I'll play around and see if it works against a SQL Server just to try it.

I'd bevery surprised if that was anything to do with it but who knows - give it a try.

Also note that my example used OLE DB Connection Manager rather than ADO.Net. That could be an avenue of investigation also.

-Jamie

Error while using first time!

I'm trying to learn about SQL databases and use them for my asp.net app sine I cant get the hang of MySQL in ASP. Every time I go to create a new SQL Database it saids: Would you like to place it in the App_Data folder basicly and I say yes. Then the error:

Unable to find DbProivderFactory for type System.Data.SqlClient.SqlConnection

Hi Clanstyles,

Based on the error message, I think the provider factory was not installed properly on you machine. Or the configuration files might not be written correctly.

Please try the following:

1. Open machine.config file under C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG
2. Check the nodes under configuration/system.data/DbProviderFactories to see if all the provider has been installed successfully. It has to look like this.

<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</DbProviderFactories>

HTH.

Error while synchronizing merge replication for first time

I am trying to run the replication merge agent for the first time for a
replication. Several servers already replicate to the same server without
problems. I have replicated all the previous Publishers to my subscriber
with the identical setup with the exception of the user login into the
server. The user login sees the appropriate tables in the subscriber yet the
first synchronization errors with the following:
rror messages:
The process could not connect to Subscriber 'hera'. (Source: MSSQL_REPL,
Error number: MSSQL_REPL20084) Get help: http://help/MSSQL_REPL20084 Named
Pipes Provider: Could not open a connection to SQL Server [53].
(Source: MSSQLServer, Error number: 53)
Get help: http://help/53
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 SQL Server does not allow remote
connections. (Source: MSSQLServer, Error number: 53) Get help:
http://help/53 Login timeout expired (Source: MSSQLServer, Error number: 0)
Get help: http://help/0 The merge process failed to execute a query because
the query timed out.
If this failure continues, increase the query timeout for the process.
When troubleshooting, restart the synchronization with verbose history
logging and specify an output file to which to write. (Source:
MSSQLServer, Error number: 0)
Get help: http://help/0
The subscription to publication 'PUB_1' could not be verified. Ensure that
all Merge Agent command line parameters are specified correctly and that the
subscription is correctly configured. If the Publisher no longer has
information about this subscription, drop and recreate the subscription.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201019) Get help:
http://help/MSSQL_REPL-2147201019
Have any of you seen this error before? Do you know of a possible solution?
Thank you,
Pete Ocasio
Senior Software Developer
It sounds like the publisher login or the distributor login does not have
sufficient rights to pull the subscription.
Verify the subscriber can connect to the publisher - try a ping and map a
drive to the publisher from the subscriber and then verify the distributor
login assigned on the subscriber is in the dbo_role on the publisher and the
publisher login defined on the subscriber is in the pal on the publisher.
http://www.zetainteractive.com - Shift Happens!
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
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:O5cWeJ9RIHA.4888@.TK2MSFTNGP02.phx.gbl...
>I am trying to run the replication merge agent for the first time for a
>replication. Several servers already replicate to the same server without
>problems. I have replicated all the previous Publishers to my subscriber
>with the identical setup with the exception of the user login into the
>server. The user login sees the appropriate tables in the subscriber yet
>the first synchronization errors with the following:
> rror messages:
> The process could not connect to Subscriber 'hera'. (Source: MSSQL_REPL,
> Error number: MSSQL_REPL20084) Get help: http://help/MSSQL_REPL20084 Named
> Pipes Provider: Could not open a connection to SQL Server [53].
> (Source: MSSQLServer, Error number: 53)
> Get help: http://help/53
> 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 SQL Server does not allow remote
> connections. (Source: MSSQLServer, Error number: 53) Get help:
> http://help/53 Login timeout expired (Source: MSSQLServer, Error number:
> 0) Get help: http://help/0 The merge process failed to execute a query
> because the query timed out.
> If this failure continues, increase the query timeout for the process.
> When troubleshooting, restart the synchronization with verbose history
> logging and specify an output file to which to write. (Source:
> MSSQLServer, Error number: 0)
> Get help: http://help/0
> The subscription to publication 'PUB_1' could not be verified. Ensure that
> all Merge Agent command line parameters are specified correctly and that
> the subscription is correctly configured. If the Publisher no longer has
> information about this subscription, drop and recreate the subscription.
> (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201019) Get help:
> http://help/MSSQL_REPL-2147201019
> Have any of you seen this error before? Do you know of a possible
> solution?
> Thank you,
> Pete Ocasio
> Senior Software Developer
>

Error while previewing the report in Visual Studio 2005

Hi there,

The Visual Studio 2005 asks me to send an error report each time when I try to preview the reports. The reports are created in report server project in Visual Studio 2005.

Does anyone know why this is a problem?

Thanks

As a first step I would recommend to install SQL Server 2005 SP1 (http://www.microsoft.com/sql/sp1.mspx).

If you still encounter problems, you may want to try to directly publish the report to a report server and see if there are any publishing warnings or errors. Also posting the RDL file on this forum may help in further diagnosis.

-- Robert

|||

Thanks Robert, will get back if I still have any problems