new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more
Where do I go to next?Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:

> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored t
he
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
>|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more
Where do I go to next?
Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>
|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:

> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored the
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
>
|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>
|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more :(
Where do I go to next?Do you have mixed authentication mode on that server?
right click the server-->properties-->security and take a look, is
windows only checked?|||Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more :(
> Where do I go to next?
>
>|||Seems that your are not using mixed authentication. Try to set the
server to mixed authentication.
HTH, jens Suessmeyer.|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
>> a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1136471412.242368.94270@.f14g2000cwb.googlegroups.com...
> Do you have mixed authentication mode on that server?
> right click the server-->properties-->security and take a look, is
> windows only checked?
>|||Thanks
I wasn't using mixed authentication as well as confusing * with " on a fuzzy
server monitor!!
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1136471757.457363.194350@.g14g2000cwa.googlegroups.com...
> Seems that your are not using mixed authentication. Try to set the
> server to mixed authentication.
> HTH, jens Suessmeyer.
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
>> a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1136471412.242368.94270@.f14g2000cwb.googlegroups.com...
> Do you have mixed authentication mode on that server?
> right click the server-->properties-->security and take a look, is
> windows only checked?
>|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Please check out what is sql server's authentication.
>> Probably you have "windows only" authentication , try to change it to
>> "mixed"
>>
>> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
>> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated
>> with a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>>
>|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored the
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more :(
> Where do I go to next?
>
>
>|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>> Thanks, correct that new box was set as Win only. that has been changed
>> to mixed. DTS package still fails after stop & start of service.
>> Any other ideas?
>> I see the UserID in the actual db for the serve and I see the userid in
>> the security login for that server for all dbs.
>> Stephen
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Please check out what is sql server's authentication.
>> Probably you have "windows only" authentication , try to change it to
>> "mixed"
>>
>> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
>> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated
>> with a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one,
>> restored the data from the old one, and done a DTS for transfer of
>> users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in
>> the status, and nothing more :(
>> Where do I go to next?
>>
>>
>>
>>
>|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

New Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20 failure.

Oracle recently released Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20. It happened on August 1, 2006. Oracle claims that its software is compliant with Microsoft ADO.NET 2.0 and “…more flexible, faster, and more stable….”. On top of it Oracle introduced many new features “… not available from other .NET drivers…”.

http://www.oracle.com/technology/tech/windows/odpnet/index.html

I decided to give it a shot and try in SSIS.

I installed ODP.NET on my machine and it works just fine in PL/SQL Developer

Next, I opened Data Source Wizard in BIDS for SSIS project.

I see Oracle Data Provider for .NET option is enlisted under .NET Providers node on a tree. But when I select it, I am getting an error dialog:

Failed to find or load the registered .Net Framework Data Provider.

So what could be done in such scenario?

Regards,

Yitzhak

The message seems to say the provider just cannot be found. These seems a bit extreme, but you could find out what has been registered, and try and see if the assembly is then available.

Managed providers are registered in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config. There will be a section that looks a bit like this -

<system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</DbProviderFactories>
</system.data>

This shows that I have 5 managed providers, and it also gives the strong name for each. They should then be available in the GAC. A simple application that loads an assembly by it's string name could be use dto check that it really is available.

This seems somewhat excessive, and there should be simpler explanation, but the documentation didn't make too much sense to me.

|||

I checked machine.config file on my machine.
Here is what it has:

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

I also checked c:\winnt\assembly directory (GAC)
Oracle.DataAccess version 2.102.2.20 is there.

Regards,
Yitzhak

|||

There is some new development on the subject.

Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20 comes with the sample projects for Visual Studio 2005. I decided to try one of them - DSPopulate. It issues a single SQL statement and populates a data grid for Win Form app. Long story short, the sample application complies and works. References node in VS2005 shows a reference to Oracle Data provider.

I reopened my SSIS project and went through the same steps to create a new Data Source. I picked Oracle Data Provider for .NET. And here is some new behavior. Connection tab shows the following message:

Connection page is not available. Please switch to use ‘All’ properties tab page to set the properties of connection string.

So I switched to All tab and was able to set needed parameters and successfully test the connection.

I tested Oracle ODP.NET based connection with the Data Reader Source task. It works.

Regards,

Yitzhak

|||

Hi,

We also installed ODP.Net in my system however after the installation our usual oracle providers didnt worked. Started showing error when we used other oracle providers(Oracle Provider, Microsoft oracle provider).

Whether we can use ODP.NET as destination? If so, how can we use it?

Please help me in this regarding

Thanks

New Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20 failure.

Oracle recently released Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20. It happened on August 1, 2006. Oracle claims that its software is compliant with Microsoft ADO.NET 2.0 and “…more flexible, faster, and more stable….”. On top of it Oracle introduced many new features “… not available from other .NET drivers…”.

http://www.oracle.com/technology/tech/windows/odpnet/index.html

I decided to give it a shot and try in SSIS.

I installed ODP.NET on my machine and it works just fine in PL/SQL Developer

Next, I opened Data Source Wizard in BIDS for SSIS project.

I see Oracle Data Provider for .NET option is enlisted under .NET Providers node on a tree. But when I select it, I am getting an error dialog:

Failed to find or load the registered .Net Framework Data Provider.

So what could be done in such scenario?

Regards,

Yitzhak

The message seems to say the provider just cannot be found. These seems a bit extreme, but you could find out what has been registered, and try and see if the assembly is then available.

Managed providers are registered in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config. There will be a section that looks a bit like this -

<system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</DbProviderFactories>
</system.data>

This shows that I have 5 managed providers, and it also gives the strong name for each. They should then be available in the GAC. A simple application that loads an assembly by it's string name could be use dto check that it really is available.

This seems somewhat excessive, and there should be simpler explanation, but the documentation didn't make too much sense to me.

|||

I checked machine.config file on my machine.
Here is what it has:

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

I also checked c:\winnt\assembly directory (GAC)
Oracle.DataAccess version 2.102.2.20 is there.

Regards,
Yitzhak

|||

There is some new development on the subject.

Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20 comes with the sample projects for Visual Studio 2005. I decided to try one of them - DSPopulate. It issues a single SQL statement and populates a data grid for Win Form app. Long story short, the sample application complies and works. References node in VS2005 shows a reference to Oracle Data provider.

I reopened my SSIS project and went through the same steps to create a new Data Source. I picked Oracle Data Provider for .NET. And here is some new behavior. Connection tab shows the following message:

Connection page is not available. Please switch to use ‘All’ properties tab page to set the properties of connection string.

So I switched to All tab and was able to set needed parameters and successfully test the connection.

I tested Oracle ODP.NET based connection with the Data Reader Source task. It works.

Regards,

Yitzhak

New Install can't view data

I installed MSSQL 2000 Dev version. It appeared to work. I am now
trying to open any table in Enterprise manager and I get "Provider
cannot be found. It may not be properly installed." I don't see any
errors in Event Viewer.
I'm running it on XP Pro.
Thanks.
--
_________________________________________
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
_________________________________________Don Gollahon wrote:
> I installed MSSQL 2000 Dev version. It appeared to work. I am now
> trying to open any table in Enterprise manager and I get "Provider
> cannot be found. It may not be properly installed." I don't see any
> errors in Event Viewer.
> I'm running it on XP Pro.
> Thanks.
Have you installed SP3a or SP4 yet? The problem you describe is not one
I know of with the RTM version, but applying the service pack may
address any problems.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> Don Gollahon wrote:
> > I installed MSSQL 2000 Dev version. It appeared to work. I am now
> > trying to open any table in Enterprise manager and I get "Provider
> > cannot be found. It may not be properly installed." I don't see
> > any errors in Event Viewer.
> >
> > I'm running it on XP Pro.
> >
> > Thanks.
> Have you installed SP3a or SP4 yet? The problem you describe is not
> one I know of with the RTM version, but applying the service pack may
> address any problems.
I just installed SP3a and have the same result.
--
_________________________________________
Don Gollahon
dlgllhn@.InHisStepsSoftware.com
ICQ#: 115831669
MSN Msgr: dlgllhn@.theinter.com
"What in Eternity does it matter?"
_________________________________________