Problems Linking to Oracle Server

Has anyone successfully linked to an Linux Oracle server running 9i? We are unable to get the link working.....have installe dvarious drivers and still get connection refused. Any thoughts?

If this is a Linked Server issue I would try the SQL Server Engine forum.

Donald

Problems in executing SQL or Stored Procs with ASP

Hi experts,

I m working with MS SQL Server 2000 with ASP for my application. There're some Stored Procedures created for the new functions but seems I can't run these new SPs with my ASP pages. When I load that ASP page, it shows error message that can't find my SP. I've execute the SP alone in SQL Enterprise Manager and it works.

When I work with the SPs, I can connect with the DB with Enterprise Manager only without administrator right. As my SPs I suppose they should work with ASP but I just worry would it be the problem with my right granted in SQL server?

There are some other SPs running fine created by dbo but for my SPs not by dbo. Would there be any differences? Does it mean my SPs need to be granted by dbo instead of my current role? I m sure if I use the same ASP page then running another existing SPs, it works really smooth.

I also tried to make a SQL statement in my ASP page (e.g. an insert statement) but it seems nothing can be inserted. I got really screwed up!!!

Thanks in advance!!
Manfred

Manfred:

First, how are your ASP pages connecting to your database? Do you know they login, etc.? How do you give this login/user permissions to execute your stored procedure? Also, you might have an "owner" problem with the stored procedure object. Try running this query and posting the results:

select type,
uid,
left ([name], 40) as [name]
from sysobjects
where type = 'P'
and name = 'yourProcName'

-- - Sample Query Results: --

-- type uid name
-- - -
-- P 1 myProcName

Dave

|||

Thanks a lot for your advice Dave!

I got a dbo login name/password from my colleague and I've created a new SP under dbo login. It works! I can execute the stuff I want with the SP.

Here 's the query result

SELECT type, uid, LEFT(name, 40) AS name
FROM dbo.sysobjects
WHERE (type = 'P') AND (name = 'PROC_TESTDEPT')

-- type uid name
-- - -
-- P 1 proc_TestDept

problems in creating report (parent child hierarchy)

hello,
im working with as/rs 2005 and need help in creating a report.
my cube has a parent child hierarchy in "category".
structur is as follows:
Aa1
2b
B Cf
g10
1112
I like to have a function or something, that gives me the unique names of all children of maybe A (result should be: a,1,2,b,3,4,...)
there is a function called children, but i am not able to obtain my desired result. (in fact, i dont get any result with this fuction)
every little bit that shows me the right direction is highly appreciated ...
sincerely,
Rhapsody

If I understand you correctly, this should do the trick:

with

member [Measures].[UNMChildren]

as 'GENERATE(EXCEPT(descendants([Category].currentmember,10,SELF_BEFORE_AFTER),[Category].currentmember),

[Category].currentmember.uniquename, ","

)'

select {[Measures].[UNMChildren]}

on columns,

{[Category].members} on rows

from CubeName

Hope this helps,

Santi

|||thank you santi, but that was not it ... or i didnt apply it the right way ...
i will provide you with some more details ... maybe you can help me than...
im using the adventure works dw.
measures: fact finance
dimension: dim organization (esp. parent child hierarchy: parent organization key)
i have a query parameter "DimOrganizationParentOrganizationKey", which is a multivalue parameter and user can choose IDs (from different levels) he/she wants to see.
the structure of the IDs looks as follows:
1|||

I'm sorry, but I can't help you with Reporting Services.

As far as I know, the mdx should be able to return the uniquenames of a dimension member's descendants separated by commas.

Maybe if you have a secondary datasource in Reporting Services which returns the Unique Names of the members passed by parameter, you could be able to use that to make visible/invisible the appropriate members. Not sure though...

sql

Problems getting information out of a SQLDataSource

I'm working in Visual Studio, I've added a SQLDataSource to the webpage which links to a SQL server database via a DSN (created with the wizard) and it brings back data from a stored procedure with no problems.

I want to access the information from this SQLDataSource in my code and can't seem to get anything from it.

help would be most appreciated.

What do you want to do with the data? Put it in a Gridview? Datalist? Here is a article with a GridView accessing a datasource.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/GridViewEx02.asp

|||I actually want to put the information into a text field rather than a datagrid.|||gave up on that and did it the easy way, all code rather than using the wizards.|||

How would you want to access the information from the SqlDataSource? If you just want to access the database retrieved from database by the Select command, you can do something like this:

SqlDataSource sds = new SqlDataSource(conn.ConnectionString, cmd.CommandText);

DataSourceSelectArguments dssa = new DataSourceSelectArguments();

dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);

DataView dv = (DataView)sds.Select(dssa);

Problems getting 200 SPs to work in 2005...

All,
Appreciate any help in advance. I have a developer working for me who
is a pretty well-seasoned fellow. He's trying to get some scripts that
take advantage of some SPs written for SQL Server 2000 to run on 2005.
He's getting an error saying the wrong number of arguments is being
passed. He looks through the code but it looks perfectly fine.
Tracing it yields nothing either.
Any ideas? We're in a crunch (like no one else is right?) and need a
quick answer. Do we have to revert back to 2000? Or are we missing
something? Thanks.
HNM
I assume your developer is calling stored procedures and getting errors
like:
Procedure 'MyProc' expects parameter '@.MyParam', which was not supplied.
or
Procedure or function 'MyProc' has too many arguments specified.
Assuming these are user stored procedures, I wouldn't expect either of these
errors to be directly related to SQL 2000 vs. 2005. Perhaps your developer
can post a relevant code snippet so someone can help.
Hope this helps.
Dan Guzman
SQL Server MVP
"HNM74" <hnmcclain@.gmail.com> wrote in message
news:1144112777.882783.182980@.g10g2000cwb.googlegr oups.com...
> All,
> Appreciate any help in advance. I have a developer working for me who
> is a pretty well-seasoned fellow. He's trying to get some scripts that
> take advantage of some SPs written for SQL Server 2000 to run on 2005.
> He's getting an error saying the wrong number of arguments is being
> passed. He looks through the code but it looks perfectly fine.
> Tracing it yields nothing either.
> Any ideas? We're in a crunch (like no one else is right?) and need a
> quick answer. Do we have to revert back to 2000? Or are we missing
> something? Thanks.
> HNM
>
|||Hi
You don't say if you have recompiled the code in 2005 or just upgraded the
database.
John
"HNM74" wrote:

> All,
> Appreciate any help in advance. I have a developer working for me who
> is a pretty well-seasoned fellow. He's trying to get some scripts that
> take advantage of some SPs written for SQL Server 2000 to run on 2005.
> He's getting an error saying the wrong number of arguments is being
> passed. He looks through the code but it looks perfectly fine.
> Tracing it yields nothing either.
> Any ideas? We're in a crunch (like no one else is right?) and need a
> quick answer. Do we have to revert back to 2000? Or are we missing
> something? Thanks.
> HNM
>

Problems getting 200 SPs to work in 2005...

All,
Appreciate any help in advance. I have a developer working for me who
is a pretty well-seasoned fellow. He's trying to get some scripts that
take advantage of some SPs written for SQL Server 2000 to run on 2005.
He's getting an error saying the wrong number of arguments is being
passed. He looks through the code but it looks perfectly fine.
Tracing it yields nothing either.
Any ideas? We're in a crunch (like no one else is right?) and need a
quick answer. Do we have to revert back to 2000? Or are we missing
something? Thanks.
HNMI assume your developer is calling stored procedures and getting errors
like:
Procedure 'MyProc' expects parameter '@.MyParam', which was not supplied.
or
Procedure or function 'MyProc' has too many arguments specified.
Assuming these are user stored procedures, I wouldn't expect either of these
errors to be directly related to SQL 2000 vs. 2005. Perhaps your developer
can post a relevant code snippet so someone can help.
Hope this helps.
Dan Guzman
SQL Server MVP
"HNM74" <hnmcclain@.gmail.com> wrote in message
news:1144112777.882783.182980@.g10g2000cwb.googlegroups.com...
> All,
> Appreciate any help in advance. I have a developer working for me who
> is a pretty well-seasoned fellow. He's trying to get some scripts that
> take advantage of some SPs written for SQL Server 2000 to run on 2005.
> He's getting an error saying the wrong number of arguments is being
> passed. He looks through the code but it looks perfectly fine.
> Tracing it yields nothing either.
> Any ideas? We're in a crunch (like no one else is right?) and need a
> quick answer. Do we have to revert back to 2000? Or are we missing
> something? Thanks.
> HNM
>|||Hi
You don't say if you have recompiled the code in 2005 or just upgraded the
database.
John
"HNM74" wrote:

> All,
> Appreciate any help in advance. I have a developer working for me who
> is a pretty well-seasoned fellow. He's trying to get some scripts that
> take advantage of some SPs written for SQL Server 2000 to run on 2005.
> He's getting an error saying the wrong number of arguments is being
> passed. He looks through the code but it looks perfectly fine.
> Tracing it yields nothing either.
> Any ideas? We're in a crunch (like no one else is right?) and need a
> quick answer. Do we have to revert back to 2000? Or are we missing
> something? Thanks.
> HNM
>

Problems getting 200 SPs to work in 2005...

All,
Appreciate any help in advance. I have a developer working for me who
is a pretty well-seasoned fellow. He's trying to get some scripts that
take advantage of some SPs written for SQL Server 2000 to run on 2005.
He's getting an error saying the wrong number of arguments is being
passed. He looks through the code but it looks perfectly fine.
Tracing it yields nothing either.
Any ideas? We're in a crunch (like no one else is right?) and need a
quick answer. Do we have to revert back to 2000? Or are we missing
something? Thanks.
HNMI assume your developer is calling stored procedures and getting errors
like:
Procedure 'MyProc' expects parameter '@.MyParam', which was not supplied.
or
Procedure or function 'MyProc' has too many arguments specified.
Assuming these are user stored procedures, I wouldn't expect either of these
errors to be directly related to SQL 2000 vs. 2005. Perhaps your developer
can post a relevant code snippet so someone can help.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"HNM74" <hnmcclain@.gmail.com> wrote in message
news:1144112777.882783.182980@.g10g2000cwb.googlegroups.com...
> All,
> Appreciate any help in advance. I have a developer working for me who
> is a pretty well-seasoned fellow. He's trying to get some scripts that
> take advantage of some SPs written for SQL Server 2000 to run on 2005.
> He's getting an error saying the wrong number of arguments is being
> passed. He looks through the code but it looks perfectly fine.
> Tracing it yields nothing either.
> Any ideas? We're in a crunch (like no one else is right?) and need a
> quick answer. Do we have to revert back to 2000? Or are we missing
> something? Thanks.
> HNM
>|||Hi
You don't say if you have recompiled the code in 2005 or just upgraded the
database.
John
"HNM74" wrote:
> All,
> Appreciate any help in advance. I have a developer working for me who
> is a pretty well-seasoned fellow. He's trying to get some scripts that
> take advantage of some SPs written for SQL Server 2000 to run on 2005.
> He's getting an error saying the wrong number of arguments is being
> passed. He looks through the code but it looks perfectly fine.
> Tracing it yields nothing either.
> Any ideas? We're in a crunch (like no one else is right?) and need a
> quick answer. Do we have to revert back to 2000? Or are we missing
> something? Thanks.
> HNM
>

Problems deploying to a different server

I've been playing with Reporting Services on my computer and got it working fine. I can view the reports on my localhost with no problems. However, when I change the TargetServerURL in the report properties to the server that I want the report to go on (yes, the target server has SQL Reporting Services installed on it), I get the following error message:

Server was unable to process request. > Method ReportingService.SetExecutionOptions can not be reflected. > Unknown error - HRESULT 0x80131047

Anyone have any idea of what's going wrong here? Thanks for any help.

Just to add: I do have rights to the server I'm trying to publish to. This is assuming that SQL Reporting Services is distributing the reports under my username. It could well be that it's trying to use the generic ASPNET user that Visual Studio has a habit of using for its web publishing. Anyone know for sure?Problem solved. Silly mistake on my part. I deployed Framework 2.0 beta to that server and by default it set the folders used by Report Services to use ASP.NET 2.0 which my Visual Studio 2003 didn't like, so I set the folders to use ASP.NET 1.1 and all is good.sql

Problems Connecting to MS SQL Server

After a new installation of MS Enterprise SQL Server, i am unable to connect
to the database from a website, and i dont know if MS SQL is working at all.
All the startup services and SQL services are started.Here is the website
that im trying to access my SQL server:
http://www.techparts.org/scripts/install.php
The error message is: Warning: mysql_connect(): Can't connect to MySQL
server on '10.10.8.6' (10061)
Here are the logistics:
The database name is “master” and I just reset the password for “db_we
bsite”
to “database”
Username: db_website
Password: database
Database: master
Host: 10.10.8.6 (MAIN)
Website: http://www.techparts.org/scripts/install.php
Forwarded Ports: 1433 and 3306 to 10.10.8.6
Firewall: No firewall on server or router
Software: MS SQL enterprise server, PHP, and SBS 2003
Permissions: db_website has full permissions to the master database
Authentication: db_website has full permissions to root and subfolders for
the website.
Is there something that im missing on the intial setup of SQL, and why cant
i login?You are trying to connect to MySQL. I'm not sure what
exactly you installed but it looks like you are confusing
Microsoft SQL Server and MySQL. They are two different
products.
For mysql questions, try posting to:
comp.databases.mysql
-Sue
On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
<TechParts@.discussions.microsoft.com> wrote:

>After a new installation of MS Enterprise SQL Server, i am unable to connec
t
>to the database from a website, and i dont know if MS SQL is working at all
.
>All the startup services and SQL services are started.Here is the website
>that im trying to access my SQL server:
>http://www.techparts.org/scripts/install.php
>The error message is: Warning: mysql_connect(): Can't connect to MySQL
>server on '10.10.8.6' (10061)
>Here are the logistics:
>The database name is master and I just reset the password for db_website
>to database
>Username: db_website
>Password: database
>Database: master
>Host: 10.10.8.6 (MAIN)
>Website: http://www.techparts.org/scripts/install.php
>Forwarded Ports: 1433 and 3306 to 10.10.8.6
>Firewall: No firewall on server or router
>Software: MS SQL enterprise server, PHP, and SBS 2003
>Permissions: db_website has full permissions to the master database
>Authentication: db_website has full permissions to root and subfolders for
>the website.
>Is there something that im missing on the intial setup of SQL, and why cant
>i login?|||I assume what you're doing is trying to connect to SQL Server from PHP?
Chances are the connection string will be different for SQL Server than it
is for mysql so you may want to look at the connection string that is
actually used for the connection to see if it follows the SQL Server
conventions. ODBC queries are pretty standard but the connections string
aren't always. There may be information on the php site on how to do this -
or maybe someone here has done it successfully.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:6als42do2hrecr933a16k2f22mo2iuo91b@.
4ax.com...
> You are trying to connect to MySQL. I'm not sure what
> exactly you installed but it looks like you are confusing
> Microsoft SQL Server and MySQL. They are two different
> products.
> For mysql questions, try posting to:
> comp.databases.mysql
> -Sue
> On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
> <TechParts@.discussions.microsoft.com> wrote:
>
>|||Hi,
After this is over, you may want to change the password to the database and
never give it out again in a public newsgroup.
Nathan H. Omukwenyi
"Tech Parts" <TechParts@.discussions.microsoft.com> wrote in message
news:73123C3F-FD8F-463D-9E0C-9B54A1F395F0@.microsoft.com...
> After a new installation of MS Enterprise SQL Server, i am unable to
> connect
> to the database from a website, and i dont know if MS SQL is working at
> all.
> All the startup services and SQL services are started.Here is the website
> that im trying to access my SQL server:
> http://www.techparts.org/scripts/install.php
> The error message is: Warning: mysql_connect(): Can't connect to MySQL
> server on '10.10.8.6' (10061)
> Here are the logistics:
> The database name is "master" and I just reset the password for
> "db_website"
> to "database"
> Username: db_website
> Password: database
> Database: master
> Host: 10.10.8.6 (MAIN)
> Website: http://www.techparts.org/scripts/install.php
> Forwarded Ports: 1433 and 3306 to 10.10.8.6
> Firewall: No firewall on server or router
> Software: MS SQL enterprise server, PHP, and SBS 2003
> Permissions: db_website has full permissions to the master database
> Authentication: db_website has full permissions to root and subfolders for
> the website.
> Is there something that im missing on the intial setup of SQL, and why
> cant
> i login?
>

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out thatNotificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute thenscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

Tocheck if it is properly installed, and to install it if not, you need to go toControl Panel>Add/Remove Programs, then scroll through the list till you to get toMicrosoft SQL Server 2005, then click on theChange... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install.Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

Problems after service window

This is unbelevable.. I've been struggeling a bit with getting distributed transactions to work, but yesterday I finally got it all working.

A couple of hours later (yesterday evening) there was a service window in the organisation and a couple of hotfixes etc was installed in the server (Win2k3).

This morning when I tried to launch the job (an SSIS package) I get the error message "Unable to load package". If I run the package as a cmd program I get a permission denied error. The package is stored in SSIS package store (MSDB\...\). I have added the account running the job-step in the local administrators group and also made it sys_admin of the SQL-database, but with the same result (package could not be loaded).

I have also tried to import the package again since I thought it might have been corrupted, but no success.

Any idas?

I would find out what those hotfixes were, what they do, and what problems they were meant to solve.

-Jamie

|||

It was

KB922616 - Security problem in HTML

KB917344 - Security problem in JScript

KB921398 - Windows explorer problem

I can't see any of them should affect this... I don't think they were ment to solve any spesific problem(s). I guess more or less all security patches for the servers are installed here (I'm not responsible for the server patching).

However, I'm not so sure the hotfixes are responsible. Perhaps the reboot triggered something, some policy, some settings that were changed but didn't take effect until the reboot or whatever...

Guess I could try to remove the patches and see if it helps.

|||

COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\msisip.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\dllcache\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\dllcache\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\dllcache\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\dllcache\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\dllcache\msisip.dll"

C:\WINDOWS\$MSI31Uninstall_KB893803v2$(2

Problems after service window

This is unbelevable.. I've been struggeling a bit with getting distributed transactions to work, but yesterday I finally got it all working.

A couple of hours later (yesterday evening) there was a service window in the organisation and a couple of hotfixes etc was installed in the server (Win2k3).

This morning when I tried to launch the job (an SSIS package) I get the error message "Unable to load package". If I run the package as a cmd program I get a permission denied error. The package is stored in SSIS package store (MSDB\...\). I have added the account running the job-step in the local administrators group and also made it sys_admin of the SQL-database, but with the same result (package could not be loaded).

I have also tried to import the package again since I thought it might have been corrupted, but no success.

Any idas?

I would find out what those hotfixes were, what they do, and what problems they were meant to solve.

-Jamie

|||

It was

KB922616 - Security problem in HTML

KB917344 - Security problem in JScript

KB921398 - Windows explorer problem

I can't see any of them should affect this... I don't think they were ment to solve any spesific problem(s). I guess more or less all security patches for the servers are installed here (I'm not responsible for the server patching).

However, I'm not so sure the hotfixes are responsible. Perhaps the reboot triggered something, some policy, some settings that were changed but didn't take effect until the reboot or whatever...

Guess I could try to remove the patches and see if it helps.

|||

COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\msisip.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\dllcache\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\dllcache\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\dllcache\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\dllcache\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\dllcache\msisip.dll"

C:\WINDOWS\$MSI31Uninstall_KB893803v2$(2

Problem: SSIS, ODBC and Progress Database

Hi,

The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.

But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Anyone can help ?

DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.

Thanks

Wenyang

|||

Wenyang,

Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.

But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Appreciate your attencion.

[ ]′s

|||

um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.

If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...

Thanks

Wenyang

|||

were you able to slove this problem..

I am also facing similar problems.

|||

Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.

When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,

"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."

Can any body help me ?

Regards,

Chetan

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

Hi, I am facing problem to connect to progress db in .net,

Would you please let me know of the connection string and other settings ,

I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.

but then i get error when i try set anything else.

Thanking you.

|||

Problem solved

|||

Hi,

Could you please share your experience with us?

Thanks

Problem: SSIS, ODBC and Progress Database

Hi,

The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.

But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Anyone can help ?

DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.

Thanks

Wenyang

|||

Wenyang,

Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.

But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Appreciate your attencion.

[ ]′s

|||

um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.

If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...

Thanks

Wenyang

|||

were you able to slove this problem..

I am also facing similar problems.

|||

Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.

When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,

"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."

Can any body help me ?

Regards,

Chetan

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

Hi, I am facing problem to connect to progress db in .net,

Would you please let me know of the connection string and other settings ,

I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.

but then i get error when i try set anything else.

Thanking you.

|||

Problem solved

|||

Hi,

Could you please share your experience with us?

Thanks

Problem: SSIS, ODBC and Progress Database

Hi,

The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.

But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Anyone can help ?

DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.

Thanks

Wenyang

|||

Wenyang,

Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.

But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Appreciate your attencion.

[ ]′s

|||

um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.

If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...

Thanks

Wenyang

|||

were you able to slove this problem..

I am also facing similar problems.

|||

Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.

When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,

"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."

Can any body help me ?

Regards,

Chetan

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

Hi, I am facing problem to connect to progress db in .net,

Would you please let me know of the connection string and other settings ,

I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.

but then i get error when i try set anything else.

Thanking you.

|||

Problem solved

|||

Hi,

Could you please share your experience with us?

Thanks

Problem: SSIS, ODBC and Progress Database

Hi,

The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.

But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Anyone can help ?

DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.

Thanks

Wenyang

|||

Wenyang,

Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.

But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:

“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

Appreciate your attencion.

[ ]′s

|||

um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.

If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...

Thanks

Wenyang

|||

were you able to slove this problem..

I am also facing similar problems.

|||

Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.

When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,

"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."

Can any body help me ?

Regards,

Chetan

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

I had a similar issue, the error I was getting:

"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

|||

Hi, I am facing problem to connect to progress db in .net,

Would you please let me know of the connection string and other settings ,

I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.

but then i get error when i try set anything else.

Thanking you.

|||

Problem solved

|||

Hi,

Could you please share your experience with us?

Thanks