.NET Provider for SAP and variables

Hi,

I am using .NET Provider for SAP to import data from SAP BW to the SQL-Server 2005.

The OLE-DB source has an sql command like this

"exec Z_SQL_EXPORT @.I_WEEK_FROM='200601', @.I_WEEK_TO='200602'

I want to make this command more flexible by using a variable strWEEK_FROM and strWEEK_TO.

How can I do this?

Thank you for yout help.

Gerd

Two methods, expressions or OLE-DB parameters.

You can use a ? as the placeholder, so like this -

exec Z_SQL_EXPORT @.I_WEEK_FROM=?, @.I_WEEK_TO=?

Then go to the parameters dialog in the source and map the variables to the placholders.

This is a better method, I think, more secure for a start, but does not always work due to what the parameter is or the OLE-DB provider.

or

Create a variable and set EvaluateAsExpression to true.

Set the expression on the variable to build the string you require, perhaps something like this, but do some proper date formatting -

"exec zsqlexport @.week = '" + (DT_WSTR, 10)@.[Varname] + "'"

Change the source query type to be SQL Command from variable.

|||

Thanks DarrenSQLIS for your answer.

I found similar informations on other web-sites.

When I try to use your first possibility and click OK in the dialog box then I receive the response

"Error in data-flow-task: An error occured...".

How can I "map the variables to the placholders"?

Then I treid the second solution, but with the oledb-data-provider for sap I found no possibibilty to change the source type to SQL command from variable.

Can you help me again?

Thanks.

Gerd.

|||

Sorry, my mistake. The SAP provider is a ADO.Net managed provider, so of course you use the DataReader Source which does not have the same options as the OLE-DB Source.

There is no parameter support, but you can use an expression. Rather than using a variable, you can set a property expression actually on the SqlCommand property for the DataReader source.

To set an expression a component property (not all component properties upport though however), you need to be in the context of the data flow. Either select the task in Control View, or just click on a clean area of the Data Flow design surface, and then look at the Properties grid, showing the properties of that task. Now select Expressions from the properties grid. You can then select the SqlCommand property for the instance of the data reader source you wish to work against.

|||

Thanks again,

this works!

For those who have a similar problem, I found an article that give a detailled description on how to work with datareader expressions and sqlcommand:

http://www.vsteamsystemcentral.com/cs/blogs/applied_team_system/archive/2006/5/7.aspx

.NET Performance - Native vs OLE DB

Using a local instance of SQL Server 2000 and .NET I have managed to insert 4000 rows across multiple tables using the OLE DB provider in 11 seconds but when using the native provider it takes 13 seconds.
I was under the impression the native provider should enhance performance not decrease it? Why is this?
Thanks, Robby
By native provider, do you mean System.Data.SqlClient? In general SqlClient
is a good deal faster than using the combination of System.Data.OleDb and
the native oledb provider for sql server. To comment further, I'd need to
know more about your scenario.
Thanks,
Dave
"Robby White" <Robby White@.discussions.microsoft.com> wrote in message
news:04E120F8-5A6E-42F9-80E9-8BBD32B887C3@.microsoft.com...
> Using a local instance of SQL Server 2000 and .NET I have managed to
insert 4000 rows across multiple tables using the OLE DB provider in 11
seconds but when using the native provider it takes 13 seconds.
> I was under the impression the native provider should enhance performance
not decrease it? Why is this?
> Thanks, Robby
|||Yes I mean the System.Data.SqlClient provider.
Inserting 4000 records into SQL Server 2000
using the System.Data.SqlClient took 14 seconds
using the System.Data.Odbc took 13 seconds
using the System.Data.OleDb took 12 seconds
I have tried running these tests in different orders also and get the same results. I realise the times are close but I am concerned about scalibility.
Robby White
"David Schleifer [MSFT]" wrote:

> By native provider, do you mean System.Data.SqlClient? In general SqlClient
> is a good deal faster than using the combination of System.Data.OleDb and
> the native oledb provider for sql server. To comment further, I'd need to
> know more about your scenario.
> Thanks,
> Dave
> "Robby White" <Robby White@.discussions.microsoft.com> wrote in message
> news:04E120F8-5A6E-42F9-80E9-8BBD32B887C3@.microsoft.com...
> insert 4000 rows across multiple tables using the OLE DB provider in 11
> seconds but when using the native provider it takes 13 seconds.
> not decrease it? Why is this?
>
>
|||The insert operation is a fairly simple one, compared to other provider
operations such as reading data, so it's hard for any one provider to exceed
another once it's been reasonbly optimized. If you want to compare overall
provider performance, whatever benchmark you choose would have to include a
fair measure of read operations, which is one of the areas where SqlClient
really outperforms the oledb managed provider.
That said, when I tried a simple test with 16000 distinct insert operations
(i.e. seperate round trip for each), I got results for SqlClient that were
1-2% better than the OleDb provider. I think it's fair to say that the two
providers are basically equivalent for many types of insert operations, but
overall for best performance you will be better off with SqlClient.
If you are only interested in insert performance, you will probably want to
check out the Whidbey release of .NET, where SqlClient supports a bulk load
api.
"Robby White" <RobbyWhite@.discussions.microsoft.com> wrote in message
news:8A9CA873-B3B5-44B7-B2D9-296FFE988FC5@.microsoft.com...
> Yes I mean the System.Data.SqlClient provider.
> Inserting 4000 records into SQL Server 2000
> using the System.Data.SqlClient took 14 seconds
> using the System.Data.Odbc took 13 seconds
> using the System.Data.OleDb took 12 seconds
> I have tried running these tests in different orders also and get the same
results. I realise the times are close but I am concerned about
scalibility.[vbcol=seagreen]
> Robby White
> "David Schleifer [MSFT]" wrote:
SqlClient[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
performance[vbcol=seagreen]
|||Thanks for your help...
"David Schleifer [MSFT]" wrote:

> The insert operation is a fairly simple one, compared to other provider
> operations such as reading data, so it's hard for any one provider to exceed
> another once it's been reasonbly optimized. If you want to compare overall
> provider performance, whatever benchmark you choose would have to include a
> fair measure of read operations, which is one of the areas where SqlClient
> really outperforms the oledb managed provider.
> That said, when I tried a simple test with 16000 distinct insert operations
> (i.e. seperate round trip for each), I got results for SqlClient that were
> 1-2% better than the OleDb provider. I think it's fair to say that the two
> providers are basically equivalent for many types of insert operations, but
> overall for best performance you will be better off with SqlClient.
> If you are only interested in insert performance, you will probably want to
> check out the Whidbey release of .NET, where SqlClient supports a bulk load
> api.
>
> "Robby White" <RobbyWhite@.discussions.microsoft.com> wrote in message
> news:8A9CA873-B3B5-44B7-B2D9-296FFE988FC5@.microsoft.com...
> results. I realise the times are close but I am concerned about
> scalibility.
> SqlClient
> and
> to
> performance
>
>

.NET Performance - Native vs OLE DB

Using a local instance of SQL Server 2000 and .NET I have managed to insert
4000 rows across multiple tables using the OLE DB provider in 11 seconds but
when using the native provider it takes 13 seconds.
I was under the impression the native provider should enhance performance no
t decrease it? Why is this?
Thanks, RobbyBy native provider, do you mean System.Data.SqlClient? In general SqlClient
is a good deal faster than using the combination of System.Data.OleDb and
the native oledb provider for sql server. To comment further, I'd need to
know more about your scenario.
Thanks,
Dave
"Robby White" <Robby White@.discussions.microsoft.com> wrote in message
news:04E120F8-5A6E-42F9-80E9-8BBD32B887C3@.microsoft.com...
> Using a local instance of SQL Server 2000 and .NET I have managed to
insert 4000 rows across multiple tables using the OLE DB provider in 11
seconds but when using the native provider it takes 13 seconds.
> I was under the impression the native provider should enhance performance
not decrease it? Why is this?
> Thanks, Robby|||Yes I mean the System.Data.SqlClient provider.
Inserting 4000 records into SQL Server 2000
using the System.Data.SqlClient took 14 seconds
using the System.Data.Odbc took 13 seconds
using the System.Data.OleDb took 12 seconds
I have tried running these tests in different orders also and get the same r
esults. I realise the times are close but I am concerned about scalibility.
Robby White
"David Schleifer [MSFT]" wrote:

> By native provider, do you mean System.Data.SqlClient? In general SqlClien
t
> is a good deal faster than using the combination of System.Data.OleDb and
> the native oledb provider for sql server. To comment further, I'd need to
> know more about your scenario.
> Thanks,
> Dave
> "Robby White" <Robby White@.discussions.microsoft.com> wrote in message
> news:04E120F8-5A6E-42F9-80E9-8BBD32B887C3@.microsoft.com...
> insert 4000 rows across multiple tables using the OLE DB provider in 11
> seconds but when using the native provider it takes 13 seconds.
> not decrease it? Why is this?
>
>|||The insert operation is a fairly simple one, compared to other provider
operations such as reading data, so it's hard for any one provider to exceed
another once it's been reasonbly optimized. If you want to compare overall
provider performance, whatever benchmark you choose would have to include a
fair measure of read operations, which is one of the areas where SqlClient
really outperforms the oledb managed provider.
That said, when I tried a simple test with 16000 distinct insert operations
(i.e. seperate round trip for each), I got results for SqlClient that were
1-2% better than the OleDb provider. I think it's fair to say that the two
providers are basically equivalent for many types of insert operations, but
overall for best performance you will be better off with SqlClient.
If you are only interested in insert performance, you will probably want to
check out the Whidbey release of .NET, where SqlClient supports a bulk load
api.
"Robby White" <RobbyWhite@.discussions.microsoft.com> wrote in message
news:8A9CA873-B3B5-44B7-B2D9-296FFE988FC5@.microsoft.com...
> Yes I mean the System.Data.SqlClient provider.
> Inserting 4000 records into SQL Server 2000
> using the System.Data.SqlClient took 14 seconds
> using the System.Data.Odbc took 13 seconds
> using the System.Data.OleDb took 12 seconds
> I have tried running these tests in different orders also and get the same
results. I realise the times are close but I am concerned about
scalibility.[vbcol=seagreen]
> Robby White
> "David Schleifer [MSFT]" wrote:
>
SqlClient[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
performance[vbcol=seagreen]|||Thanks for your help...
"David Schleifer [MSFT]" wrote:

> The insert operation is a fairly simple one, compared to other provider
> operations such as reading data, so it's hard for any one provider to exce
ed
> another once it's been reasonbly optimized. If you want to compare overall
> provider performance, whatever benchmark you choose would have to include
a
> fair measure of read operations, which is one of the areas where SqlClient
> really outperforms the oledb managed provider.
> That said, when I tried a simple test with 16000 distinct insert operation
s
> (i.e. seperate round trip for each), I got results for SqlClient that were
> 1-2% better than the OleDb provider. I think it's fair to say that the two
> providers are basically equivalent for many types of insert operations, bu
t
> overall for best performance you will be better off with SqlClient.
> If you are only interested in insert performance, you will probably want t
o
> check out the Whidbey release of .NET, where SqlClient supports a bulk loa
d
> api.
>
> "Robby White" <RobbyWhite@.discussions.microsoft.com> wrote in message
> news:8A9CA873-B3B5-44B7-B2D9-296FFE988FC5@.microsoft.com...
> results. I realise the times are close but I am concerned about
> scalibility.
> SqlClient
> and
> to
> performance
>
>

.Net Framework Data Provider for SQL Server

If I try to create a database reference in VS 2008 B2 I get an error with "This server version is not supported. Only serves up to Microsoft SQL Server 2005 are supported."

Is this a problem with the SqlClient provider? Or is this a problem with VS integration with Katmai?

? VS Integration with Katmai. The designers don't support this yet. There will be a fix for this in a later release. Cheers, Bob Beauchemin SQLskills ""Scott Sharpe"@.discussions.microsoft.com" <"=?UTF-8?B?U2NvdHQgU2hhcnBl?="@.discussions.microsoft.com> wrote in message news:9c9cb3d8-3d35-448c-858c-644b593f2e16@.discussions.microsoft.com... If I try to create a database reference in VS 2008 B2 I get an error with "This server version is not supported. Only serves up to Microsoft SQL Server 2005 are supported." Is this a problem with the SqlClient provider? Or is this a problem with VS integration with Katmai?

.Net Data Provider for Teradata

Does the .net data provider for Teradata work the same way as the ole db provider for Teradata? I have created a data source using the .net provider and verified the connection to Teradata but when I go through the data source view wizard it will not bring back a list of tables/views and appears to just sit idle.

Thanks.

I experienced the same problem with a self-developed .NET provider for

another

database while creating a data source view in BI Development

Studio:

A connection to the database is established without any problems. Then the

application just queries the provider's data source information table and that's all.

It does not even try to query the tables in the database.

Is this a known bug in SSAS 2005?|||

I also found this where the tables/views were not shown.

If you click Next to accept an empty Data Source View screen I found that you can then add tables/view by right-click on the DSV screen and click on 'New Named Query'. Name the table and add you SQL to extract from the Teradata table (you can click the small arrow icon to run the query or click OK to return to the DSV and then use 'Explore Data'.

I have used this as a workaround until someone comes up with a better answer.

.Net Data Provider for Teradata

Does the .net data provider for Teradata work the same way as the ole db provider for Teradata? I have created a data source using the .net provider and verified the connection to Teradata but when I go through the data source view wizard it will not bring back a list of tables/views and appears to just sit idle.

Thanks.

I experienced the same problem with a self-developed .NET provider for another
database while creating a data source view in BI Development Studio:
A connection to the database is established without any problems. Then the
application just queries the provider's data source information table and that's all.
It does not even try to query the tables in the database.
Is this a known bug in SSAS 2005?|||

I also found this where the tables/views were not shown.

If you click Next to accept an empty Data Source View screen I found that you can then add tables/view by right-click on the DSV screen and click on 'New Named Query'. Name the table and add you SQL to extract from the Teradata table (you can click the small arrow icon to run the query or click OK to return to the DSV and then use 'Explore Data'.

I have used this as a workaround until someone comes up with a better answer.

.Net Data Provider for Teradata

Does the .net data provider for Teradata work the same way as the ole db provider for Teradata? I have created a data source using the .net provider and verified the connection to Teradata but when I go through the data source view wizard it will not bring back a list of tables/views and appears to just sit idle.

Thanks.

I experienced the same problem with a self-developed .NET provider for

another

database while creating a data source view in BI Development

Studio:

A connection to the database is established without any problems. Then the

application just queries the provider's data source information table and that's all.

It does not even try to query the tables in the database.

Is this a known bug in SSAS 2005?|||

I also found this where the tables/views were not shown.

If you click Next to accept an empty Data Source View screen I found that you can then add tables/view by right-click on the DSV screen and click on 'New Named Query'. Name the table and add you SQL to extract from the Teradata table (you can click the small arrow icon to run the query or click OK to return to the DSV and then use 'Explore Data'.

I have used this as a workaround until someone comes up with a better answer.

.net data provider / Data processing extention

Is there somewhere a real usable sample application for this?
I found some samples, but I'm unable to do anything with it.
There are some source code files in the knowledge base. But I don't know how
to apply the Instruction on compile them.
I need realy step by step instructions for a novice. A hint for a good book
would be ok too.
(I'm wonder about the jumbs between gradients in all the documentation and
articles. Example: Open Visual Studio, select ..., to add a class do..., then
implement correct marshaling, use all the named pipes correct, find and
implement Windows APIs and thats realy all, just doit! References: Blind link
Nr 1; Blind link Nr 2; ...)There is a section in msdn describing process of creating a data extension:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
There is also a sample that is shipped with RS:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
I will work with you thru the steps. Let's start with trying to compile and
run the sample.
Let me know where you get the first problem.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> Is there somewhere a real usable sample application for this?
> I found some samples, but I'm unable to do anything with it.
> There are some source code files in the knowledge base. But I don't know
how
> to apply the Instruction on compile them.
> I need realy step by step instructions for a novice. A hint for a good
book
> would be ok too.
> (I'm wonder about the jumbs between gradients in all the documentation and
> articles. Example: Open Visual Studio, select ..., to add a class do...,
then
> implement correct marshaling, use all the named pipes correct, find and
> implement Windows APIs and thats realy all, just doit! References: Blind
link
> Nr 1; Blind link Nr 2; ...)|||Thank you very much!!!
This seems to be a good tip. I try it on monday and post a feedback.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Now I know the steps required to deploy the assembly. That's an part of the
whole way.
It is still to much for me to get this transfered so I can create a
Dataprovider for a connection to a Oracle database.
I found an article about .net dataprovider with sample files for all classes
(it's called DotNetDataProviderTemplate). I found no way to get this sample
compiled and runing. Although I'm not try to implement the reporting services
interface.
I created a new Project and added all the sample .vb files. But compile this
seems to be imposible, what ever I'm doing. Error are "Type '...' not
defiened and classes are ambiguous. But the Types are defined and the
classenames are unique.
If I would overcome all immediate barriers, I don't know how to set
permission to access a oracle database. I recognized that it is necessary to
set permission. But documented is only SQL Server, not oracle.
I'm using allways VB, a VB Sample would be great. But if the sample is
complete enough C# will be ok too. It seems, that C# is easy to understand.
If no oracle sample is available a complete sample to access a SQL Server
database will be also good.
Thank you for your effort.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
interfaces defined in System.Data.
The "type not found" errors are probably coming for RS interfaces. You need
to copy two dlls from reportserver/bin:
Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
need to add references to both of the dlls to your project
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> Now I know the steps required to deploy the assembly. That's an part of
the
> whole way.
> It is still to much for me to get this transfered so I can create a
> Dataprovider for a connection to a Oracle database.
> I found an article about .net dataprovider with sample files for all
classes
> (it's called DotNetDataProviderTemplate). I found no way to get this
sample
> compiled and runing. Although I'm not try to implement the reporting
services
> interface.
> I created a new Project and added all the sample .vb files. But compile
this
> seems to be imposible, what ever I'm doing. Error are "Type '...' not
> defiened and classes are ambiguous. But the Types are defined and the
> classenames are unique.
> If I would overcome all immediate barriers, I don't know how to set
> permission to access a oracle database. I recognized that it is necessary
to
> set permission. But documented is only SQL Server, not oracle.
> I'm using allways VB, a VB Sample would be great. But if the sample is
> complete enough C# will be ok too. It seems, that C# is easy to
understand.
> If no oracle sample is available a complete sample to access a SQL Server
> database will be also good.
> Thank you for your effort.
>
> "Alexandre Mineev [MSFT]" wrote:
> > There is a section in msdn describing process of creating a data
extension:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> >
> > There is also a sample that is shipped with RS:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> >
> > I will work with you thru the steps. Let's start with trying to compile
and
> > run the sample.
> > Let me know where you get the first problem.
> >
> > --
> > Alex Mineev
> > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > SQE.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > Is there somewhere a real usable sample application for this?
> > > I found some samples, but I'm unable to do anything with it.
> > >
> > > There are some source code files in the knowledge base. But I don't
know
> > how
> > > to apply the Instruction on compile them.
> > >
> > > I need realy step by step instructions for a novice. A hint for a good
> > book
> > > would be ok too.
> > >
> > > (I'm wonder about the jumbs between gradients in all the documentation
and
> > > articles. Example: Open Visual Studio, select ..., to add a class
do...,
> > then
> > > implement correct marshaling, use all the named pipes correct, find
and
> > > implement Windows APIs and thats realy all, just doit! References:
Blind
> > link
> > > Nr 1; Blind link Nr 2; ...)
> >
> >
> >|||Thank you, but somehow it doesn't work, wath ever I try.
What exactly must be written in:
Public Sub Open() Implements IDbConnection.Open
to open the connection to database?
As mentioned in my first post I'm a novice in .net and reporting services
too. Something very simple must be wrong. And I only find help like you must
implement ...Interface. But I can't find how to do this exactly.
"Alexandre Mineev [MSFT]" wrote:
> Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
> interfaces defined in System.Data.
> The "type not found" errors are probably coming for RS interfaces. You need
> to copy two dlls from reportserver/bin:
> Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
> need to add references to both of the dlls to your project
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> > Now I know the steps required to deploy the assembly. That's an part of
> the
> > whole way.
> >
> > It is still to much for me to get this transfered so I can create a
> > Dataprovider for a connection to a Oracle database.
> >
> > I found an article about .net dataprovider with sample files for all
> classes
> > (it's called DotNetDataProviderTemplate). I found no way to get this
> sample
> > compiled and runing. Although I'm not try to implement the reporting
> services
> > interface.
> > I created a new Project and added all the sample .vb files. But compile
> this
> > seems to be imposible, what ever I'm doing. Error are "Type '...' not
> > defiened and classes are ambiguous. But the Types are defined and the
> > classenames are unique.
> >
> > If I would overcome all immediate barriers, I don't know how to set
> > permission to access a oracle database. I recognized that it is necessary
> to
> > set permission. But documented is only SQL Server, not oracle.
> >
> > I'm using allways VB, a VB Sample would be great. But if the sample is
> > complete enough C# will be ok too. It seems, that C# is easy to
> understand.
> > If no oracle sample is available a complete sample to access a SQL Server
> > database will be also good.
> >
> > Thank you for your effort.
> >
> >
> > "Alexandre Mineev [MSFT]" wrote:
> >
> > > There is a section in msdn describing process of creating a data
> extension:
> > >
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> > >
> > > There is also a sample that is shipped with RS:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> > >
> > > I will work with you thru the steps. Let's start with trying to compile
> and
> > > run the sample.
> > > Let me know where you get the first problem.
> > >
> > > --
> > > Alex Mineev
> > > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > > SQE.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > > Is there somewhere a real usable sample application for this?
> > > > I found some samples, but I'm unable to do anything with it.
> > > >
> > > > There are some source code files in the knowledge base. But I don't
> know
> > > how
> > > > to apply the Instruction on compile them.
> > > >
> > > > I need realy step by step instructions for a novice. A hint for a good
> > > book
> > > > would be ok too.
> > > >
> > > > (I'm wonder about the jumbs between gradients in all the documentation
> and
> > > > articles. Example: Open Visual Studio, select ..., to add a class
> do...,
> > > then
> > > > implement correct marshaling, use all the named pipes correct, find
> and
> > > > implement Windows APIs and thats realy all, just doit! References:
> Blind
> > > link
> > > > Nr 1; Blind link Nr 2; ...)
> > >
> > >
> > >
>
>

.net Data Provider (YOU can help)

I don't get a Data Provider to access my oracle database.
Can somebody send me his Data Provider?
If you have a Provider accessing the SQL-Server you can send also this
Provider.
E-Mail: Data.Prov@.Freenet.de
I'm a novice in Report Services and Data Provider and search for days now
for a solution. All I find doesn't help, I guess something simple and very
basic is missing.
Please help!You will need Reporting Services SP1 installed.
How to use Oracle in RS:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
provider for Oracle, which indeed allows for named parameters.
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> I don't get a Data Provider to access my oracle database.
> Can somebody send me his Data Provider?
> If you have a Provider accessing the SQL-Server you can send also this
> Provider.
> E-Mail: Data.Prov@.Freenet.de
> I'm a novice in Report Services and Data Provider and search for days now
> for a solution. All I find doesn't help, I guess something simple and very
> basic is missing.
> Please help!|||I have SP1 installed and I still create reports with the oracle database. I'm
using in depth stored procedures for this reports, the SPs encapsulate comlex
applications.
I'm programming with VB since 10 years, so I have some general knowledge.
But I'm a novice in reporting services and .Net Data Providers. I wrote
application using ADO .net, so I have a basic understanding of ADO.Net.
But it is absolut impossible for me to get this Data Provider for reporting
services running. I'm realy annoyed about the documentation and the news
group posts about this. There is a huge amount of descriptions like
"implement interface A, B, C ..." instate of publishing somewhere a usefull
sample application.
The FSI... Sample is a joke. How many people will list files from the
filesystem in a report and how many will access a real database to create
reports? This are all "doghouse" samples. For a doghouse you need a hammer
and some nails but for a real building used by people there is something more
required.
"Alexandre Mineev [MSFT]" wrote:
> You will need Reporting Services SP1 installed.
> How to use Oracle in RS:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
> OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
> provider for Oracle, which indeed allows for named parameters.
>
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> > I don't get a Data Provider to access my oracle database.
> >
> > Can somebody send me his Data Provider?
> > If you have a Provider accessing the SQL-Server you can send also this
> > Provider.
> > E-Mail: Data.Prov@.Freenet.de
> >
> > I'm a novice in Report Services and Data Provider and search for days now
> > for a solution. All I find doesn't help, I guess something simple and very
> > basic is missing.
> >
> > Please help!
>
>|||No answer is a answer too!
"Dev Main" wrote:
> I have SP1 installed and I still create reports with the oracle database. I'm
> using in depth stored procedures for this reports, the SPs encapsulate comlex
> applications.
> I'm programming with VB since 10 years, so I have some general knowledge.
> But I'm a novice in reporting services and .Net Data Providers. I wrote
> application using ADO .net, so I have a basic understanding of ADO.Net.
> But it is absolut impossible for me to get this Data Provider for reporting
> services running. I'm realy annoyed about the documentation and the news
> group posts about this. There is a huge amount of descriptions like
> "implement interface A, B, C ..." instate of publishing somewhere a usefull
> sample application.
> The FSI... Sample is a joke. How many people will list files from the
> filesystem in a report and how many will access a real database to create
> reports? This are all "doghouse" samples. For a doghouse you need a hammer
> and some nails but for a real building used by people there is something more
> required.
> "Alexandre Mineev [MSFT]" wrote:
> > You will need Reporting Services SP1 installed.
> >
> > How to use Oracle in RS:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> >
> > Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
> > OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
> > provider for Oracle, which indeed allows for named parameters.
> >
> >
> > --
> > Alex Mineev
> > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > SQE.
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights
> >
> > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> > > I don't get a Data Provider to access my oracle database.
> > >
> > > Can somebody send me his Data Provider?
> > > If you have a Provider accessing the SQL-Server you can send also this
> > > Provider.
> > > E-Mail: Data.Prov@.Freenet.de
> > >
> > > I'm a novice in Report Services and Data Provider and search for days now
> > > for a solution. All I find doesn't help, I guess something simple and very
> > > basic is missing.
> > >
> > > Please help!
> >
> >
> >|||Two things. Unless it is a managed newsgroup posting you are not guaranteed
a MS response. This is peer response with MS people jumping in from time to
time.
Second, are you trying to create your own data processing extension or is
the issue that you are having trouble using stored procedures in Oracle?
First you asked for people to send you a data provider for SQL Server or
Oracle which I didn't answer because it didn't make sense to me. If the
issue is using Oracle people are successfully using Oracle. What
specifically is your problem using Oracle with Reporting Services?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:64B97405-AECC-45DA-8A93-551BBAE82FA2@.microsoft.com...
> No answer is a answer too!
> "Dev Main" wrote:
> > I have SP1 installed and I still create reports with the oracle
database. I'm
> > using in depth stored procedures for this reports, the SPs encapsulate
comlex
> > applications.
> >
> > I'm programming with VB since 10 years, so I have some general
knowledge.
> >
> > But I'm a novice in reporting services and .Net Data Providers. I wrote
> > application using ADO .net, so I have a basic understanding of ADO.Net.
> >
> > But it is absolut impossible for me to get this Data Provider for
reporting
> > services running. I'm realy annoyed about the documentation and the news
> > group posts about this. There is a huge amount of descriptions like
> > "implement interface A, B, C ..." instate of publishing somewhere a
usefull
> > sample application.
> >
> > The FSI... Sample is a joke. How many people will list files from the
> > filesystem in a report and how many will access a real database to
create
> > reports? This are all "doghouse" samples. For a doghouse you need a
hammer
> > and some nails but for a real building used by people there is something
more
> > required.
> >
> > "Alexandre Mineev [MSFT]" wrote:
> >
> > > You will need Reporting Services SP1 installed.
> > >
> > > How to use Oracle in RS:
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> > >
> > > Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y
uses
> > > OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e
.NET
> > > provider for Oracle, which indeed allows for named parameters.
> > >
> > >
> > > --
> > > Alex Mineev
> > > Software Design Engineer. Report expressions; Code Access Security;
Xml;
> > > SQE.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
rights
> > >
> > > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > > news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> > > > I don't get a Data Provider to access my oracle database.
> > > >
> > > > Can somebody send me his Data Provider?
> > > > If you have a Provider accessing the SQL-Server you can send also
this
> > > > Provider.
> > > > E-Mail: Data.Prov@.Freenet.de
> > > >
> > > > I'm a novice in Report Services and Data Provider and search for
days now
> > > > for a solution. All I find doesn't help, I guess something simple
and very
> > > > basic is missing.
> > > >
> > > > Please help!
> > >
> > >
> > >|||Make you use RS SP1.
How to use Oracle in RS:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
provider for Oracle, which indeed allows for named parameters.
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> I don't get a Data Provider to access my oracle database.
> Can somebody send me his Data Provider?
> If you have a Provider accessing the SQL-Server you can send also this
> Provider.
> E-Mail: Data.Prov@.Freenet.de
> I'm a novice in Report Services and Data Provider and search for days now
> for a solution. All I find doesn't help, I guess something simple and very
> basic is missing.
> Please help!|||@.Bruce: Thank you for the answer and sory for my last comment.
I don't have problems with oracle. I build reports using oracle data. I have
no problem with stored procedures, packages and everything else. Everything
works.
I'm unable to get a data provider for RS running and access the oracle
database. I'm familare with VB, with VB.net, ADO.net, Databases, Stored
Procedures etc. But it seems I don't know the right syntax to use in this
dataprovider. I like to complete the FSI... Example that it fullfills my
requirements. I read all documentation and spend many hours on it.
If I would implement a application using ado.net I would create a object for
the connection and refer to them. This seems to be not the right aproach in
this Data Provider. All the Implement interface blabla doesn't help me,
becouse I simply don't know how to do this exactly.
A simple real sample would save the hundrets of hours I'm waste on this.
The reason why I like to implement the data provider is, that im must
execute several stored procedures and return the result from a temporary
table. I can't use the stored procedure to query the result, becouse Oracle
(7.3) requires that I specify the amount of expected records, before I'm send
this stored procedure. If the dataprovider is running, I like to change them
in a way, that I can do something else before I execute the query. Returning
a dataset with a stored procedure from oracle (even if I know the expected
amount of returned records) is not efficient and results in bad performance.
Inside the dataprovider I like to create datasets and return them to
Reporting Services.
Thanks in advance!
"Dev Main" wrote:
> I don't get a Data Provider to access my oracle database.
> Can somebody send me his Data Provider?
> If you have a Provider accessing the SQL-Server you can send also this
> Provider.
> E-Mail: Data.Prov@.Freenet.de
> I'm a novice in Report Services and Data Provider and search for days now
> for a solution. All I find doesn't help, I guess something simple and very
> basic is missing.
> Please help!|||Ouch, 7.3. Everyone I have seen use Oracle has been on at least 8i.
One possible solution for you would be to use the controls coming out with
the next beta of Yukon and Widbey. These will work the way you are
expecting. It depends on when you have to go into production. There might be
a go live license for the next beta of Widbey but I don't know if that
includes the new controls or not. These new controls are really going to be
a help.
Although similar what it sounds like you are wanting to do is to create a
data processing extension. I suggest posting asking if anyone has additional
examples of data processing extensions (which is different from have a data
provider, similar but different).
I have two books which I suggest buying that between the two of them would
really get you going writing your own data processing extension: Microsoft
Reporting Services In Action by Teo Lachev (an MVP) and Hitchhiker's Guide
to SQL Server 2000 Reporting Services by Peter Blackburn and Willam Vaughn.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:AE9B3520-233F-4D6D-8EBC-746A29D68FF3@.microsoft.com...
> @.Bruce: Thank you for the answer and sory for my last comment.
> I don't have problems with oracle. I build reports using oracle data. I
have
> no problem with stored procedures, packages and everything else.
Everything
> works.
> I'm unable to get a data provider for RS running and access the oracle
> database. I'm familare with VB, with VB.net, ADO.net, Databases, Stored
> Procedures etc. But it seems I don't know the right syntax to use in this
> dataprovider. I like to complete the FSI... Example that it fullfills my
> requirements. I read all documentation and spend many hours on it.
> If I would implement a application using ado.net I would create a object
for
> the connection and refer to them. This seems to be not the right aproach
in
> this Data Provider. All the Implement interface blabla doesn't help me,
> becouse I simply don't know how to do this exactly.
> A simple real sample would save the hundrets of hours I'm waste on this.
> The reason why I like to implement the data provider is, that im must
> execute several stored procedures and return the result from a temporary
> table. I can't use the stored procedure to query the result, becouse
Oracle
> (7.3) requires that I specify the amount of expected records, before I'm
send
> this stored procedure. If the dataprovider is running, I like to change
them
> in a way, that I can do something else before I execute the query.
Returning
> a dataset with a stored procedure from oracle (even if I know the expected
> amount of returned records) is not efficient and results in bad
performance.
> Inside the dataprovider I like to create datasets and return them to
> Reporting Services.
> Thanks in advance!
> "Dev Main" wrote:
> > I don't get a Data Provider to access my oracle database.
> >
> > Can somebody send me his Data Provider?
> > If you have a Provider accessing the SQL-Server you can send also this
> > Provider.
> > E-Mail: Data.Prov@.Freenet.de
> >
> > I'm a novice in Report Services and Data Provider and search for days
now
> > for a solution. All I find doesn't help, I guess something simple and
very
> > basic is missing.
> >
> > Please help!|||Thank you!
I will order the recomended books today.
I have to go productive with one single report in 2 weeks.
The oracle version is in the scope from the customer and I have no influence
on it. It seems I'm living in a different world then other developers. My
customers are in most cases not uptodate. Wether with OS nor with Databases,
Exchange, Office etc. They say: "why should we change a running system, new
version new troubles". And if I see the ripeness of Reporting Services or the
ESH (Exchange Server Hell), I can understand them.
"Bruce L-C [MVP]" wrote:
> Ouch, 7.3. Everyone I have seen use Oracle has been on at least 8i.
> One possible solution for you would be to use the controls coming out with
> the next beta of Yukon and Widbey. These will work the way you are
> expecting. It depends on when you have to go into production. There might be
> a go live license for the next beta of Widbey but I don't know if that
> includes the new controls or not. These new controls are really going to be
> a help.
> Although similar what it sounds like you are wanting to do is to create a
> data processing extension. I suggest posting asking if anyone has additional
> examples of data processing extensions (which is different from have a data
> provider, similar but different).
> I have two books which I suggest buying that between the two of them would
> really get you going writing your own data processing extension: Microsoft
> Reporting Services In Action by Teo Lachev (an MVP) and Hitchhiker's Guide
> to SQL Server 2000 Reporting Services by Peter Blackburn and Willam Vaughn.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:AE9B3520-233F-4D6D-8EBC-746A29D68FF3@.microsoft.com...
> > @.Bruce: Thank you for the answer and sory for my last comment.
> >
> > I don't have problems with oracle. I build reports using oracle data. I
> have
> > no problem with stored procedures, packages and everything else.
> Everything
> > works.
> >
> > I'm unable to get a data provider for RS running and access the oracle
> > database. I'm familare with VB, with VB.net, ADO.net, Databases, Stored
> > Procedures etc. But it seems I don't know the right syntax to use in this
> > dataprovider. I like to complete the FSI... Example that it fullfills my
> > requirements. I read all documentation and spend many hours on it.
> >
> > If I would implement a application using ado.net I would create a object
> for
> > the connection and refer to them. This seems to be not the right aproach
> in
> > this Data Provider. All the Implement interface blabla doesn't help me,
> > becouse I simply don't know how to do this exactly.
> > A simple real sample would save the hundrets of hours I'm waste on this.
> >
> > The reason why I like to implement the data provider is, that im must
> > execute several stored procedures and return the result from a temporary
> > table. I can't use the stored procedure to query the result, becouse
> Oracle
> > (7.3) requires that I specify the amount of expected records, before I'm
> send
> > this stored procedure. If the dataprovider is running, I like to change
> them
> > in a way, that I can do something else before I execute the query.
> Returning
> > a dataset with a stored procedure from oracle (even if I know the expected
> > amount of returned records) is not efficient and results in bad
> performance.
> > Inside the dataprovider I like to create datasets and return them to
> > Reporting Services.
> >
> > Thanks in advance!
> >
> > "Dev Main" wrote:
> >
> > > I don't get a Data Provider to access my oracle database.
> > >
> > > Can somebody send me his Data Provider?
> > > If you have a Provider accessing the SQL-Server you can send also this
> > > Provider.
> > > E-Mail: Data.Prov@.Freenet.de
> > >
> > > I'm a novice in Report Services and Data Provider and search for days
> now
> > > for a solution. All I find doesn't help, I guess something simple and
> very
> > > basic is missing.
> > >
> > > Please help!
>
>

.NET config file for Custom event Provider?

Hello all,

I'm creating a custom event provider for SSNS 2005 using .NET. My custom provider needs to get configuration info from a file (e.g. app.config).

Is there any (acceptable?) way of making my config file data available to my provider if I'd like my provider to be hosted by SSNS? Perhaps I could hack it by making or adding to an app.config for some part of SSNS (the instance service executable perhaps?) but that doesn't sound appetizing.

The only thing I can think of is to force my event provider to run as a standalone EXE (which means a standard app.config should work).

Help?

OK, I found that it is quite simple to use a specific config file for my DLL (especially using EntLib).

However, issues with codebases and so forth for dependent assemblies has turned me to switch. I'm now using a standalone event provider because it avoids all these issues around config files, dependencies, and so forth (everyhing is simply in one standard bin folder).

.NET config file for Custom event Provider?

Hello all,

I'm creating a custom event provider for SSNS 2005 using .NET. My custom provider needs to get configuration info from a file (e.g. app.config).

Is there any (acceptable?) way of making my config file data available to my provider if I'd like my provider to be hosted by SSNS? Perhaps I could hack it by making or adding to an app.config for some part of SSNS (the instance service executable perhaps?) but that doesn't sound appetizing.

The only thing I can think of is to force my event provider to run as a standalone EXE (which means a standard app.config should work).

Help?

OK, I found that it is quite simple to use a specific config file for my DLL (especially using EntLib).

However, issues with codebases and so forth for dependent assemblies has turned me to switch. I'm now using a standalone event provider because it avoids all these issues around config files, dependencies, and so forth (everyhing is simply in one standard bin folder).

.NET 2.0/SQL 2000 Named Pipes Provider, error: 40

I have an app that I've written in .NET 2.0 using SQL 2000 as the back end. It works fine in development but when I move it out to our QA server I get the following error.

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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

One of the odd things I notice is that the error message references SQL Server 2005 when that's not installed on our QA box, only SQL 2000 is on it.

I've checked the server and TCP/IP and Named Pipes are enabled.

Here is my connection string

<add name="myConnectionString" connectionString="Data Source=(local);Integrated Security=false;Initial Catalog=TestDatabase;User Id=myUsername;Password=myPassword;" providerName="System.Data.SqlClient"/>

There's at least one other .NET 2.0 application running on this server that accesses the database so I know that it can work! However, have access to the source code for that application so it's not any help with my troubleshooting.

Any thoughts or ideas?

Is the SqlServer 2000 service running on the same machine? You connection configuration is pointed to a (local) copy of SqlServer. Also, make sure that the myUsername exists on the QA server.

|||

Yes. Sql 2000 is on the same box.

And I double checked that myUsername exists in that QA SQL server and has rights to my database.

Thanks though.

I'll post back when I figure it out.

If anyone else wants to weigh in I'm all ears.

|||

Hi,

I had the same problem.

Check this Registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo.

Are there any entries that reference the SQL server you want to use (DBMPNTW = named pipes)? If so remove them.

Regards,

Thierry

**linked server**

Hi
I'm working with MS sql server 2000 and I want to add a linked server. but
there is an empty "provider name" combo box, with following message at the
bottom "Provider Name is one of the providers installed on the server"
what programs should I install in order to get a complete names of
providers and be able to continue?
(I have no problem on my personal client(WinXP) in our LAN, but this is a
problem in our server.)
my second question:
Is it possible to have a remote server throught VPN by a linked server?
(now I have the remote SQL server through a new SQL server registration
but I want to have it in a linked server in order to easily join its table
with my local network tables and ...)
Any help would be greatly appreciated.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/1) Do you try to create a linked server to another SQL Server? Check SQL
Server under Server Type option
2) I think it is permission issue, I have never tried it. Have you tried to
create a linked server?
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tk5uxesen9ig5y@.system109.parskhazar.net...
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/|||Hi
Try adding the linked server through T-SQL using something like:
EXEC sp_addlinkedserver @.server='RemoteSQLServer', @.srvproduct='',
@.provider='SQLOLEDB',
@.datasrc='RemoteSvr\SQLInstance'
If you can register the remote server you should be ok to define it as a
linked server. Response over the VPN may be quite slow.
John
"M" wrote:
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>

(Provider:Named Pipes Provider, error:40-could not open a connection to SQL server)(Microsoft SQ

Following error is displayed while registering the Win2K5 Standard Edition Server.

(Provider:Named Pipes Provider, error:40-could not open a connection to SQL server)(Microsoft SQL Server, Error:53)

Server is Standard Edition and surface area configuration done to access local/Remote connection through named pipe or TCP/IP

From client node ping is successful. Client is trying to connect to the server over internet through a VPN.

What could be the reason for not able to connect?

Check whether the SQL listening port is enabled on your firewall and accepts connections on VPN.

Might check this http://blogs.msdn.com/sql_protocols/archive/2005/12/07/500820.aspx blog in this case.|||

Satya,

Is this MS SQL listening port is 1433 at firewall?

(Provider:Named Pipes Provider, error:40-could not open a connection to SQL server)(Microsof

Following error is displayed while registering the Win2K5 Standard Edition Server.

(Provider:Named Pipes Provider, error:40-could not open a connection to SQL server)(Microsoft SQL Server, Error:53)

Server is Standard Edition and surface area configuration done to access local/Remote connection through named pipe or TCP/IP

From client node ping is successful. Client is trying to connect to the server over internet through a VPN.

What could be the reason for not able to connect?

Check whether the SQL listening port is enabled on your firewall and accepts connections on VPN.

Might check this http://blogs.msdn.com/sql_protocols/archive/2005/12/07/500820.aspx blog in this case.|||

Satya,

Is this MS SQL listening port is 1433 at firewall?

(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

ASP v2.0

I am getting this error when attempting to sign in to my site once uploaded to the server. Can anyone help me to resolve this error?

Server Error in '/' Application.

---

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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: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 SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091
 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
 System.Data.SqlClient.SqlConnection.Open() +111
 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
 System.Web.UI.WebControls.Login.AttemptLogin() +105
 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

First, this stack trace is really useless for diagnosing your problem. Here's some questions to get you started.

What's your connection string? Are you using integrated security?

Does the SQL Server sit on the same machine as the web server? Is it part of the same domain?

Is the sql server behind a firewall? Can the web server "see" the SQL Server?

Does this work on your machine with the same username/password?

Can you log into the Web Server via remote desktop? If so can you ping the SQL Server? Can you connect using Query Analyzer?

|||I'm using the integrated security within ASPv2.0.

The issue comes up with the login on the server.

I can sign in on the development PC and everything runs fine, but I receive this error when I attempt to log on after I upload the site to the server.

I am not sure where the connection string is for v2.0 integrated security. I have just recently moved from v1.1 and am still discovering new things as I go.

I use Godaddy.com web hosting. So the server and the development PCs are separate. I have been using the Publish Web Site tool in VS2005 and then CuteFTP Pro to transfer the files. I have configured my godaddy account to accept v2.0 framework and activated the SQL server schema.

I have found that a test non-member page is having difficulty connecting to the access database I am using. It gives me an error stating "c:\access_db\Survey.mdb is not a valid location..." <-- something of that nature. Using the following connection string for this:
strConn = New OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\access_db\Survey.mdb"))

I am not sure if that is caused by the same issue or if it is because of my connection string. I assume it is a connection string issue. It works fine on my development pc even though my hard drive is e: not c:, so I don't know what's up with that really. still working on it.|||

OK. Let's back up. Are you using Access, or MS SQL Server? If you're using Access, why are you posting to a SQL Server forum?

|||I apologize I am not trying to be confusing.

My issue that I posted here for is for the SQLSever database: ASPNETDB.MDF

This is where I am getting the issue from. The Access DB is an issue I think I can handle on my own at this time. I shouldn't have mentioned it.|||

So you're trying to mount this file, which is sitting on the same computer as the web server, right? And you're using integrated security, right? I believe that integrated security requires that the user have a Windows login to the box/domain that the app's running on. I'm not sure how you're doing that with your web app.

If you're developing using VS 2005, there's a lot that your app can do (because it's running under your credentials) that it can't do on a production server.

If you have a MSDN subscription, you might want to build a test Windows 2003 server using VirtualPC, and try deploying your app there. That'll give you a better feel for what's going on with the GDaddy box.(I did that last week to diagnose problems with a web service on a server running multiple web servers. It turns out using localhost doesn't always work.)

|||The web server is a completely different PC than my development. I am uploading the files to the server using CuteFTP Pro.GoDaddy.com owns the server.

I have setup my application to use internet secruity (see jpg). It should not require a Windows login. I do not have an MSDN subscription, so I cannot use a test server using VirtualPC.

|||Does the application require the user to log in? If so, how are you passing the user id/pw to the database?|||I am using the Login control in ASP.NET v2.0

I am not sure how it passes the username/password to the database. It all happens behind the scenes.|||Well, we've pretty much hit the limits of how I can help you. If you figure it out, try to post the answer in case someone else has a similar problem.|||I appreciate your attempt. Thank you for using your time to help me.

If anyone else has discovered a solution please reply. I will do the same.

Thank you|||

I have the EXACT same problem...Godaddy hosting trying to use SQLEXPRESS database file that is included with visual web designer.

Problem is... it won't work. According to Microsoft. (If Godaddy hostsmultiple sites that do not trust each other) The note below was taken from the msdn site.I underlined what I believe is the cause of your problem.

The resolution is to use plain old connection strings to plain old SQL server database instances.

good luck

Note

If you are deploying your SQL Server Express Edition database to a Web server that hosts multiple sites that do not trust each other, then you cannot use file-based connections or user instances to help ensure that your data is not exposed to other applications on the server. In this case, it is recommended that you migrate the contents your SQL Server Express Edition database to another version of SQL Server 2005 that your deployed ASP.NET application can access.

http://msdn2.microsoft.com/en-us/library/ms247257.aspx|||One solution I am curious about is this:

With Godaddy, you must use your host manager in order to set up the site to use Framework v2.0 and to use SQL Server. When it sets this up it creates a few files--
(2) Folder -- "_private" and "_vti_log"
(1) HTML File -- "_vti_inf.html"
(1) Asp file -- "gdform.asp"

-- I am not sure why these files are created or what they are used for. They may have something to do with this issue.

-- When you set up the server to enable using an MS Access Db, it creates a folder called "access_db." I think what it is doing is creating virtual folders to run off of. If you create your own folder on the server usinf FTP and place an access db file inside, you are not able to access the db. But if you place the db inside the "access_db" folder that GoDaddy creates, everything works fine.

-- The solution may be in figuring out the setup here. I am going to give GoDaddy a call and see if they are familiar with this issue and have a solution.

-- If there is a way to change the connection string that v2.0 uses to connect to that user db, then it may be ab easier solution. So far I have not found a way to change the connection string for the user db within v2.0.

(provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I am getting the following error when i try to connect to the my web site using froma different server.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

i am using sql express and i attach the database through the connection string in the web config.

Any ideas

The error indicates the connection was eatablished but then closed for some reason, this can happen if the SQL2005 instance is out of the available connections when the instance is configured to use a nonzero maximum number of concurrent connections. Check the SQL ERRORLOGs for detailed information, which you can get by executing xp_readerrorlog in Management Studio. If you find something like "Could not connect because the maximum number of '5' user connections has already been reached.", you can execute such command:

sp_configure 'user connections',0

(provider: Named Pipes Provider,error: 40 - Could not open a connection to SQL Server)

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.

I am getting this error and using this connection string

Data Source=192.168.0.100;Network Library=DBMSSOCN;Initial Catalog=ENet;User ID=eonline;Password=eonline;

What can be solution for this.

you check if its firewall issue?|||see thing is that it is working gud but when my application connects to orcale and then when it come backs to connect sql it is giving error did it possible that oracle connection gives problem|||

Hi,

Since the error message contains "Could not open a connection to SQL Server", I think this error occurs when your app connects to a SQL Server. Based on the fact in your first post, have you checked if you have enabled remote connection on the server? Please following this KB article to achieve this.

http://support.microsoft.com/kb/914277/en-us

Currently, you're connecting to the database server using TCP/IP. You can also try to use Network Library=dbnmpntw to perform a named pipe connection.

|||I think I got a solution...

the error is in the connection string and in the configuration... if you'll use the IP instead of (loca), localhost, <machinename>\SQLEXPRESS, it will work. So use 127.0.0.1... the server will love it... and one more thing... at Protocols (SQL Server Configuration) at TCP/IP, set at IPAll - TCP Dymanic ports 1433 and one more... of course... set trusted connection to true... (you should allow remote connections too)..

So, the connection string is :

"Provider=SQLNCLI;Server=127.0.0.1;Database=database;Trusted_Connection=yes;"

Hope this helps someone..

P.S. : from my point of view.. I think this solution is a stupid one as long as local = localhost = 127.0.0.1... I guess for the SQLExpress... local = localhost != 127.0.0.1