Error: can't load configuration file

I had VS 2005 RC installed along with the Sep CTP of SQL Server (tools only)
and it was working fine.
Then I installed VS 2003 on that same machine. Now, everytime I lauch VS
2005 I get this message:
The configuration file RSReportDesigner.config could not be loaded.
The type initializer for "Microsoft.ReportingServices.Library.Global"
threw an exception.
I don't even use reporting services. Does anyone know how to make this
error go away?
TIA,
Mike RodriguezMichael Rodriguez wrote:
> I had VS 2005 RC installed along with the Sep CTP of SQL Server (tools only)
> and it was working fine.
> Then I installed VS 2003 on that same machine. Now, everytime I lauch VS
> 2005 I get this message:
> The configuration file RSReportDesigner.config could not be loaded.
> The type initializer for "Microsoft.ReportingServices.Library.Global"
> threw an exception.
> I don't even use reporting services. Does anyone know how to make this
> error go away?
> TIA,
> Mike Rodriguez
I was using Reporting Services just fine until I've installed VS.net
2003, now I get the same error message you're getting...Can anybody
help?sql

Error: [rsMissingDataSetName] The data set name is missing in the data region ?DataSetName

This error occured under the following circumstances:
1. Had an existing report that was working with 1 DataSet.
2. Added 1 new Dataset with the same data source as the existing Dataset.
Query was very simple: Select * from TableA.
3. Tested Query. Returned correct results.
4. Selected Preview and get the following message:
[rsMissingDataSetName] The data set name is missing in the data region ?DataSetName?
THis happens no matter what dataset is added.
I tried copying the first dataset in XML format and pasting ir in and only changing the name and it still reported this error.
Any idea how to fix it?
Thanks
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comYou need to set the dataset name in the properties, of the table or chart
you are using. Just select the whole table or chart, right click, click
properties and fill in the dataset.
"Kevin" <johnnyparsons@.hotmail.com> wrote in message
news:81b00b63-35e3-473a-bb87-f1d6e178dfbd@.developmentnow.com...
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region
> 'DataSetName'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only
> changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||You have some region or table or something on the report that pointed to a
dataset that no longer exists. Or, and reading closer this might be what is
happening, you have a data region without a dataset. Go to layout and you
can click on your different regions and then in the properties set it to you
existing dataset.
One other thing that has happened to me before, I ended up with some data
region defined in the xml source (the report definition is XML) that was not
visible from the development environment. Save your report somewhere before
doing this (click on report in the report list, ctl-C, ctrl-V). Now you can
view code of the report and search for DataSetName and see where you find
it. The XML is pretty seld explanatory in most cases.
Lastly, just create a new report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kevin" <johnnyparsons@.hotmail.com> wrote in message
news:81b00b63-35e3-473a-bb87-f1d6e178dfbd@.developmentnow.com...
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region
> 'DataSetName'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only
> changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||Thanks all.The table in the Report must have automatically defaulted to
the 1 dataset I had. When I added the second one it didn't know which
one to use.
I set it to the correct one and all is working.
Thanks much!
Kevin|||Hey Kevin,
In reporting services layout, Select your table (or what ever object you're
building the report with), right click it, go to properties and select the
other data set
from the drop down box.
This should work .
Good Luck..
Scott
"Kevin" wrote:
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region â'DataSetNameâ'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

Error Working With DTS -- "Class Not Registered"

I have a DTS package (stored in a .dts file) that was created in SQL Server 2000 and I am trying to work with it in SQL 2005. When I try to import it into the Legacy > Data Transformation Services node in Management Studio, I get a window that reads "Class Not Registered (Microsoft Data Transformation Services (DTS) Package)". I get the same error if I try to just execute the package itself from a query window.

I have Legacy Support installed, and I also have Integration Services installed.

Any ideas? We have three installations of SQL 2005 and I am getting the same error on all of them.

Have you installed Microsoft SQL Server 2000 DTS Designer Components from here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

The DTS designer does not get installed with SSIS.

Thanks.

Error with ole db

I created a view refer to a visual foxpro with ole db for visual foxpro which was working fine before. But now, I received an error while select the view

Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "ORST3".

Please advise. Thanks in advance

Can you provide us with sample repro code for this issue?

Thanks

Error with connection

We are trying to move to a new server, due to problems with our current one.
Everything seems to be working, but we cannot seem to get the connection to
the SQL database. When we try to bring up the website that accesses the
database, we get the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/incfiles/MainStoreFile_Real.asp, line 73
I have checked everything that I can think of (note- that I can think of),
but cannot get past this error. Does anyone have any ideas?
RickI think that
new DataBase don't take permission to access DB
Could you check your DataBase permission
<< DataBase Property--> permission >>
cheers.|||From the Web Server, ping the SQL Server.
That error indicates that SQL cannot be contacted.
And even if you can ping SQL, see if you can access the 1433 port from the
Web Server
Thanks
"Brewhaus" <Brewhaus@.discussions.microsoft.com> wrote in message
news:2FFA9C1B-DF1E-439E-BFD6-8E89094FE503@.microsoft.com...
> We are trying to move to a new server, due to problems with our current
> one.
> Everything seems to be working, but we cannot seem to get the connection
> to
> the SQL database. When we try to bring up the website that accesses the
> database, we get the following error:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> /incfiles/MainStoreFile_Real.asp, line 73
> I have checked everything that I can think of (note- that I can think of),
> but cannot get past this error. Does anyone have any ideas?
> Rick|||Couple of things :
1. Check the firewall port ( if any ) between the App and the Database
Server is open or not .
2. Install the latest ODBC connections in your App server.
3. User Account and the Password trying to connect the Database server
having appropriater permissions and if the password is correct.
...Piku.
"Brewhaus" wrote:
> We are trying to move to a new server, due to problems with our current one.
> Everything seems to be working, but we cannot seem to get the connection to
> the SQL database. When we try to bring up the website that accesses the
> database, we get the following error:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> /incfiles/MainStoreFile_Real.asp, line 73
> I have checked everything that I can think of (note- that I can think of),
> but cannot get past this error. Does anyone have any ideas?
> Rick|||First, thank you for your responses.
I had confirmed before that the DB permissions were the same as on the
working server, but have now also checked that the permissions for the actual
file are also the same. I had considered the password issue before, so had
already very carefully re-entered it.
I am not sure how to ping the SQL server, or check the port, but the
software that is accessing the server is on the same computer as SQL server
and the DB file, so I am not sure if either of these could be the issue-
please tell me if they could, and if so, how to check them. I am actually
getting this error in a webpage on the same computer, so I cannot imagine
that it is a firewall issue.
Does anyone have any further thoughts on this?
Rick|||Change your connectionstring to use the IP address of the sql server instead
of the server name.
"Server=127.0.0.1;Database=DBname;User
ID=username;Password=password;Trusted_Connection=False"
To find the ipaddress: go to start-run-cmd-ipconfig, if that works then you
have a DNS issue.
To find out whether 1433 is open you can use the port query tool (MS has one).
HTH
--
Rakesh Ajwani
MCSD, MCSD.NET
"Brewhaus" wrote:
> First, thank you for your responses.
> I had confirmed before that the DB permissions were the same as on the
> working server, but have now also checked that the permissions for the actual
> file are also the same. I had considered the password issue before, so had
> already very carefully re-entered it.
> I am not sure how to ping the SQL server, or check the port, but the
> software that is accessing the server is on the same computer as SQL server
> and the DB file, so I am not sure if either of these could be the issue-
> please tell me if they could, and if so, how to check them. I am actually
> getting this error in a webpage on the same computer, so I cannot imagine
> that it is a firewall issue.
> Does anyone have any further thoughts on this?
> Rick
>|||I seem to be getting a little further. When I change the IP address that the
system tries to connect on I just get a licensing error on the software
(because it is set up with the other address). When I change the IP address
back, I get the connection error. Does this mean that the SQL server is
being run specifically on one of our IP addresses only? If so, is there a
way to change which address it runs on?|||All right, Now I have a feeling it's got to do with the port. Verify this for
me:
In the Enterprise manager, Right Click on the DB Server Node and hit
Properties. On the General Tab, Click Network Configuration, it should have
two protocols enabled, named pipes and TCP/IP, Highlight TCP/IP & click
properties, It will give you the default value of the port its running the
sql server on, if it is different than 1433, Include that port number in your
connectionstring and try and connect again
change your connection string like this
Data Source=VSERVER1\instancename,2433
Just curious do you have more than one instance(or a named instance) of sql
server running on this server. If you do please look at this following
article.
http://blogs.msdn.com/sql_protocols/archive/2006/02/27/539706.aspx
Rakesh Ajwani
MCSD, MCSD.NET
"Brewhaus" wrote:
> I seem to be getting a little further. When I change the IP address that the
> system tries to connect on I just get a licensing error on the software
> (because it is set up with the other address). When I change the IP address
> back, I get the connection error. Does this mean that the SQL server is
> being run specifically on one of our IP addresses only? If so, is there a
> way to change which address it runs on?|||We have only one instance of SQL Server running on the server.
I had checked the settings before, but went back and did so again, just in
case I had missed something. The port showing is 1433.
The server has multiple public IP addresses on a single NIC, though. Would
it matter which was the main one, or which is the one used when setting up
the internet connection with the Internet Connection Wizard?
What seems odd is that we are doing the testing directly on the server that
is running SQL Server. We are not coming in from another computer via the
network or internet connection. Because of that, I would not expect it to
matter which of the IP addresses we used. Obviously it does, though.
"Rakesh Ajwani" wrote:
> All right, Now I have a feeling it's got to do with the port. Verify this for
> me:
> In the Enterprise manager, Right Click on the DB Server Node and hit
> Properties. On the General Tab, Click Network Configuration, it should have
> two protocols enabled, named pipes and TCP/IP, Highlight TCP/IP & click
> properties, It will give you the default value of the port its running the
> sql server on, if it is different than 1433, Include that port number in your
> connectionstring and try and connect again
> change your connection string like this
> Data Source=VSERVER1\instancename,2433
> Just curious do you have more than one instance(or a named instance) of sql
> server running on this server. If you do please look at this following
> article.
> http://blogs.msdn.com/sql_protocols/archive/2006/02/27/539706.aspx
>
> --
> Rakesh Ajwani
> MCSD, MCSD.NET
>
> "Brewhaus" wrote:
> > I seem to be getting a little further. When I change the IP address that the
> > system tries to connect on I just get a licensing error on the software
> > (because it is set up with the other address). When I change the IP address
> > back, I get the connection error. Does this mean that the SQL server is
> > being run specifically on one of our IP addresses only? If so, is there a
> > way to change which address it runs on?

Error with connection

We are trying to move to a new server, due to problems with our current one.
Everything seems to be working, but we cannot seem to get the connection to
the SQL database. When we try to bring up the website that accesses the
database, we get the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
/incfiles/MainStoreFile_Real.asp, line 73
I have checked everything that I can think of (note- that I can think of),
but cannot get past this error. Does anyone have any ideas?
RickI think that
new DataBase don't take permission to access DB
Could you check your DataBase permission
<< DataBase Property--> permission >>
cheers.|||From the Web Server, ping the SQL Server.
That error indicates that SQL cannot be contacted.
And even if you can ping SQL, see if you can access the 1433 port from the
Web Server
Thanks
"Brewhaus" <Brewhaus@.discussions.microsoft.com> wrote in message
news:2FFA9C1B-DF1E-439E-BFD6-8E89094FE503@.microsoft.com...
> We are trying to move to a new server, due to problems with our current
> one.
> Everything seems to be working, but we cannot seem to get the connection
> to
> the SQL database. When we try to bring up the website that accesses the
> database, we get the following error:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o
r access
> denied.
> /incfiles/MainStoreFile_Real.asp, line 73
> I have checked everything that I can think of (note- that I can think of),
> but cannot get past this error. Does anyone have any ideas?
> Rick|||Couple of things :
1. Check the firewall port ( if any ) between the App and the Database
Server is open or not .
2. Install the latest ODBC connections in your App server.
3. User Account and the Password trying to connect the Database server
having appropriater permissions and if the password is correct.
...Piku.
"Brewhaus" wrote:

> We are trying to move to a new server, due to problems with our current on
e.
> Everything seems to be working, but we cannot seem to get the connection t
o
> the SQL database. When we try to bring up the website that accesses the
> database, we get the following error:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o
r access
> denied.
> /incfiles/MainStoreFile_Real.asp, line 73
> I have checked everything that I can think of (note- that I can think of),
> but cannot get past this error. Does anyone have any ideas?
> Rick|||First, thank you for your responses.
I had confirmed before that the DB permissions were the same as on the
working server, but have now also checked that the permissions for the actua
l
file are also the same. I had considered the password issue before, so had
already very carefully re-entered it.
I am not sure how to ping the SQL server, or check the port, but the
software that is accessing the server is on the same computer as SQL server
and the DB file, so I am not sure if either of these could be the issue-
please tell me if they could, and if so, how to check them. I am actually
getting this error in a webpage on the same computer, so I cannot imagine
that it is a firewall issue.
Does anyone have any further thoughts on this?
Rick|||Change your connectionstring to use the IP address of the sql server instead
of the server name.
"Server=127.0.0.1;Database=DBname;User
ID=username;Password=password;Trusted_Co
nnection=False"
To find the ipaddress: go to start-run-cmd-ipconfig, if that works then you
have a DNS issue.
To find out whether 1433 is open you can use the port query tool (MS has one
).
HTH
--
Rakesh Ajwani
MCSD, MCSD.NET
"Brewhaus" wrote:

> First, thank you for your responses.
> I had confirmed before that the DB permissions were the same as on the
> working server, but have now also checked that the permissions for the act
ual
> file are also the same. I had considered the password issue before, so ha
d
> already very carefully re-entered it.
> I am not sure how to ping the SQL server, or check the port, but the
> software that is accessing the server is on the same computer as SQL serve
r
> and the DB file, so I am not sure if either of these could be the issue-
> please tell me if they could, and if so, how to check them. I am actually
> getting this error in a webpage on the same computer, so I cannot imagine
> that it is a firewall issue.
> Does anyone have any further thoughts on this?
> Rick
>|||I seem to be getting a little further. When I change the IP address that th
e
system tries to connect on I just get a licensing error on the software
(because it is set up with the other address). When I change the IP address
back, I get the connection error. Does this mean that the SQL server is
being run specifically on one of our IP addresses only? If so, is there a
way to change which address it runs on?|||All right, Now I have a feeling it's got to do with the port. Verify this fo
r
me:
In the Enterprise manager, Right Click on the DB Server Node and hit
Properties. On the General Tab, Click Network Configuration, it should have
two protocols enabled, named pipes and TCP/IP, Highlight TCP/IP & click
properties, It will give you the default value of the port its running the
sql server on, if it is different than 1433, Include that port number in you
r
connectionstring and try and connect again
change your connection string like this
Data Source=VSERVER1\instancename,2433
Just curious do you have more than one instance(or a named instance) of sql
server running on this server. If you do please look at this following
article.
http://blogs.msdn.com/sql_protocols.../27/539706.aspx
Rakesh Ajwani
MCSD, MCSD.NET
"Brewhaus" wrote:

> I seem to be getting a little further. When I change the IP address that
the
> system tries to connect on I just get a licensing error on the software
> (because it is set up with the other address). When I change the IP addre
ss
> back, I get the connection error. Does this mean that the SQL server is
> being run specifically on one of our IP addresses only? If so, is there a
> way to change which address it runs on?|||We have only one instance of SQL Server running on the server.
I had checked the settings before, but went back and did so again, just in
case I had missed something. The port showing is 1433.
The server has multiple public IP addresses on a single NIC, though. Would
it matter which was the main one, or which is the one used when setting up
the internet connection with the Internet Connection Wizard?
What seems odd is that we are doing the testing directly on the server that
is running SQL Server. We are not coming in from another computer via the
network or internet connection. Because of that, I would not expect it to
matter which of the IP addresses we used. Obviously it does, though.
"Rakesh Ajwani" wrote:
[vbcol=seagreen]
> All right, Now I have a feeling it's got to do with the port. Verify this
for
> me:
> In the Enterprise manager, Right Click on the DB Server Node and hit
> Properties. On the General Tab, Click Network Configuration, it should hav
e
> two protocols enabled, named pipes and TCP/IP, Highlight TCP/IP & click
> properties, It will give you the default value of the port its running the
> sql server on, if it is different than 1433, Include that port number in y
our
> connectionstring and try and connect again
> change your connection string like this
> Data Source=VSERVER1\instancename,2433
> Just curious do you have more than one instance(or a named instance) of sq
l
> server running on this server. If you do please look at this following
> article.
> http://blogs.msdn.com/sql_protocols.../27/539706.aspx
>
> --
> Rakesh Ajwani
> MCSD, MCSD.NET
>
> "Brewhaus" wrote:
>

error while working with dynamic query in report

Hi all,
I am trying to add report parameter to my report.I am getting "cannot
set the command text for dataset ''dataset_name " this kind of error. I am
working with sql server 2005.I found this tutorial in Books Online->sql
server tutorials - >Reporting Services Tutorials - >Using a dynamic query in
a report.
Can u plz tell me why i am getting this kind of error.
Thnx.YOu should repost this in the Reporting Services Group. But also include the
actual Query you are using...
ie
=" Select * From titles"
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"supriya" wrote:

> Hi all,
> I am trying to add report parameter to my report.I am getting "cann
ot
> set the command text for dataset ''dataset_name " this kind of error. I am
> working with sql server 2005.I found this tutorial in Books Online->sql
> server tutorials - >Reporting Services Tutorials - >Using a dynamic query
in
> a report.
> Can u plz tell me why i am getting this kind of error.
> Thnx.
>
>

Error while trying to execute a user defined function

Hi,

I'm working on SQL SERVER 2005 Standard edition.

I created a user defined function on the dbo schema.

Is it possible to invoke a user defined function in a select clause only with the name of this function without precising the name of the schema.

if my function is called TOTO(), can i execute the command :

SELECT TOTO()

go

Actually when i try to execute this command i have the following error message :

Message 195, level 15, state 10 :

'TOTO' is not a known built-in function name option.

Can someone help me to solve this issue ?

try

select dbo.toto()

|||

I know that it works but i want to know if it's possible to execute this function without specifying the schema just like this :

SELECT toto()

go

|||

Locolito:

The response to your question is no: WIth a scalar function you must supply the "schema" qualifier -- such as dbo; however, the schema qualifier is not required with a table function.

Dave

Error While Exporting Data From a report which have SubReport. - D

Hi all,
i am facing a typical problem in SSRS.I have a report which have a
subreport.Everything working fine if i have data on my main report and my sub
report also,but if i don't have any data then report is giving a error when i
am trying to EXPORT it in some version(.xls or .xml etc).
Really i could not able to understand the reason behind this problem.
I am looking fwd for your quick reply rgd the same.
Thanks in advance.
DibakarOn Feb 26, 4:54 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> Hi all,
> i am facing a typical problem in SSRS.I have a report which have a
> subreport.Everything working fine if i have data on my main report and my sub
> report also,but if i don't have any data then report is giving a error when i
> am trying to EXPORT it in some version(.xls or .xml etc).
> Really i could not able to understand the reason behind this problem.
> I am looking fwd for your quick reply rgd the same.
> Thanks in advance.
> Dibakar
I have come across this issue when I have not had data on my subreport
before. Have you tried returning an empty row to the main report (from
the subreport) yet?
Enrique Martinez
Sr. SQL Server Developer|||Yes, i am doing it.but still the same problem remains.
I don;t know how to solve it?Pls help
"EMartinez" wrote:
> On Feb 26, 4:54 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> > Hi all,
> >
> > i am facing a typical problem in SSRS.I have a report which have a
> > subreport.Everything working fine if i have data on my main report and my sub
> > report also,but if i don't have any data then report is giving a error when i
> > am trying to EXPORT it in some version(.xls or .xml etc).
> >
> > Really i could not able to understand the reason behind this problem.
> >
> > I am looking fwd for your quick reply rgd the same.
> >
> > Thanks in advance.
> >
> > Dibakar
>
> I have come across this issue when I have not had data on my subreport
> before. Have you tried returning an empty row to the main report (from
> the subreport) yet?
> Enrique Martinez
> Sr. SQL Server Developer
>