link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/default...b;en-us;280106
http://support.microsoft.com/default...b;en-us;814398
Regards
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
sql

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
--
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
--
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:
> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
Regards
"Mangesh Deshpande" wrote:
> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error mess
age
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
--
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any error
s.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error me
ssage
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/defaul...kb;en-us;280106
http://support.microsoft.com/defaul...kb;en-us;814398
Regards
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any error
s.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error me
ssage
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'

Link server problrm connecting to Oracle

I get the following error after trying to do update to an Oracle 9i table
from SQL Server 2000. :
The operation could not be performed because the OLE DB provider 'MSDAORA'
was unable to begin a distributed transaction.
Any ideas to solve this?
Check the following article:
INF: Troubleshooting Linked Server Error 7391
http://support.microsoft.com/?id=306212
-Sue
On Wed, 23 Mar 2005 12:44:06 GMT, "Mori"
<obibiman.nospam@.yahoo.com> wrote:

>I get the following error after trying to do update to an Oracle 9i table
>from SQL Server 2000. :
>The operation could not be performed because the OLE DB provider 'MSDAORA'
>was unable to begin a distributed transaction.
>Any ideas to solve this?
>

Link server problrm connecting to Oracle

I get the following error after trying to do update to an Oracle 9i table
from SQL Server 2000. :
The operation could not be performed because the OLE DB provider 'MSDAORA'
was unable to begin a distributed transaction.
Any ideas to solve this?Check the following article:
INF: Troubleshooting Linked Server Error 7391
http://support.microsoft.com/?id=306212
-Sue
On Wed, 23 Mar 2005 12:44:06 GMT, "Mori"
<obibiman.nospam@.yahoo.com> wrote:

>I get the following error after trying to do update to an Oracle 9i table
>from SQL Server 2000. :
>The operation could not be performed because the OLE DB provider 'MSDAORA'
>was unable to begin a distributed transaction.
>Any ideas to solve this?
>sql

Link Server from SQL2005 to SQL2000

I have the follwoing scenario, where the query returns an error, when we tried to upgrade oru production SQL2000 enviroment to SQL2005.

SQL2000 Env:

Microsoft SQL Server Developer Edition

Microsoft Windows NT 5.2 (3790)

8.00.2175 SP4

SQL2005 Env:

Microsoft SQL Server Developer Edition

Microsoft Windows NT 5.2 (3790)

9.00.3054.00

Notice the removal of the two RTRIMs.

Any help welcome

Gertus

Current Connection was on the SQL2005 machine:

Remote Link Server SQL2000 SP4

Working:

SELECT * FROM Entity -- on SQL2005

WHERE

(EntityRef) + Source NOT IN

(SELECT (ENTITYID) + 'EU' FROM MRIEU.MRIOB.dbo.ENTITY) --this is on sql2000

AND Source = 'EU'

Not-working:

SELECT * FROM Entity-- on SQL2005

WHERE

RTRIM(EntityRef) + Source NOT IN

(SELECT RTRIM(ENTITYID) + 'EU' FROM MRIEU.MRIOB.dbo.ENTITY)

AND Source = 'EU'

Error :: >>

OLE DB provider "SQLNCLI" for linked server "MRIEU" returned message "Cannot create new connection because in manual or distributed transaction mode.".

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "SELECT TOP 1 1 FROM "MRIOB"."dbo"."ENTITY" "Tbl1005"" against OLE DB provider "SQLNCLI" for linked server "MRIEU".

Did you try searching the MS knowledge base?

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

|||

Sorry that is not the problem, I am runnign this query in sql storedproc, it this is an error on the link server code internal of Microsoft.

Can any Microsoft person help here please?

Regards

Gert

Link Server error: Msg 7399

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.]
What to do ? What to do ??Well , this Error belongs to Distributed Queries Error Messages collection.

- Remote OLE DB Data Source : ODBC Data Source
- OLE DB Provider : Microsoft OLE DB Provider for ODBC
- Provider Name : MSDASQL

The problem you are getting with only receiving one row on a select statement can be fixed by going into the configuration of the Client Access DSN and go to the other tab and check always scrollable, this will get all the rows.

As far as the other issue getting the error
Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.]

You get this when journaling is not turned on the table on the AS400. Have one of your AS400 people turn journaling on for all the tables you need to access.

Since you noted that ..." [IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.] ".... I just could compare this error with one more familiar to Microsoft platform, and what are the reasons for getting this Error when trying to connect to MS Access DB.

1. MS Access DB is not secured Db , and there is no login : Admin with No Password .

2. The Access database is secured and :HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Sys temDB registry key is not pointing to the correct Access workgroup file.

-If you are trying to Change Data , try without : BEGIN >> COMMIT block, if possible.

-also try this link :

http://www.iseries.ibm.com/developer/db2/documents/mts/mts5.html

Hope this is something to start solving your problem.

rgds.
srdjan|||I linked two MSSQL 2000 servers by using enterprise manager. I succeeded in connecting between server 1(local) and server2 (remote). I have another remote one--server3. I used the same method to try connecting either local and server3, or server2 and server3.

I can do on local and server2 to see data from server3--

select * from server3.pubs.dbo.authors

however if I try to do this on server3

select * from server2.pubs.dbo.authors

I got following error messages:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.

So what is the problem here?

I will appreciate greatly for your help.

Cathy|||1. Check list of Linked Servers in SYSSERVERS system table ( you should have both (Server2 and Server3 ) servers listed .
2. Verify that there is a login mapping for the current user on Server3.
3. Check the rights of user you are trying to connect from your Server to Server3 . ( at least you must SELECT rights on table you are querying) ....

--Returns the list of linked servers defined in the local server
exec sp_linkedservers

--Creates a linked server
exec sp_addlinkedserver

hope this help

rgds.
srdjan|||Thanks for reply.

I checked all . I also used

CREATE Database NorthwindnDistributed
Go

Use NorthwindnDistributed
CREATE TABLE dbo.Customers
(CustomerID char(5),
CompanyName nvarchar(40))
EXEC sp_addlinkedserver @.server = 'remoteserver',
@.srvproduct ='SQLServer OLEDB Provider',
@.provider ='SQLOLEDB',
@.datasrc = 'remote server IPaddress'

IF not Exists (select 'True' From master.dbo.syslogins where Name = 'remoteUser')
EXEC sp_addlogin 'remoteUser','remotePassword'

Use NorthwindnDistributed
exec sp_adduser 'remoteUser'
exec sp_addrolemember 'db_owner', 'remoteUser'
exec sp_addlinkedsrvlogin @.rmtsrvname = GM,
@.useself = FALSE,
@.rmtuser = 'remoteUser',
@.rmtpassword ='remotePassword'

exec sp_serveroption @.server = GM,
@.OPTNAME ='lazy schema validation',
@.OPTVALUE = 'TRUE'

to create new linked servers from both of local and remote sides. It still give me the error message like

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.

I can do "select ..." from one side of server. But when I changed to other servers, I don't have any problems to connect them and work on them. If there is anything wrong when this server is set up? Why can I not get any error messages when i do the same operation on other servers but only fail on one particular server?:confused:

Thanks for any reply.

HELP!

Link Server Error: [SQLSTATE 42000] (Error 7399)

I have created a link server between SQL Server 2000 and
MS Access. If I run the job manually, the job runs fine.
But, if I schedule the job, it fails with the follwoing
error message.
Executed as user: raj. OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB
Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
I have also created a DTS package to update another Access
database, if I execute the package, it runs. If I schedule
the job, the job fails.
I have checked the permissions for the user Raj and it has
all the privilges.
Any help will be greatly appreciated!
Please suggest, how to fix this issue.
Thanks,
Raj
With what account do you use to start the sqlagent with? Does that have
necessary permissions?
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj

>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>
|||I was experiencing the exact same issue.
I solved it by using absolute paths in place of drive letters when defining the linked server
So in place of z:\folder\file.mdb I wrote \\servername\share\folder\file.mdb
this solved the issue for me

Quote:

Originally Posted by Raj

HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj

>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>

Link Server Error: [SQLSTATE 42000] (Error 7399)

I have created a link server between SQL Server 2000 and
MS Access. If I run the job manually, the job runs fine.
But, if I schedule the job, it fails with the follwoing
error message.
Executed as user: raj. OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB
Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
I have also created a DTS package to update another Access
database, if I execute the package, it runs. If I schedule
the job, the job fails.
I have checked the permissions for the user Raj and it has
all the privilges.
Any help will be greatly appreciated!
Please suggest, how to fix this issue.
Thanks,
RajWith what account do you use to start the sqlagent with? Does that have
necessary permissions?
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj

>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>

Link Server Error: [SQLSTATE 42000] (Error 7399)

I have created a link server between SQL Server 2000 and
MS Access. If I run the job manually, the job runs fine.
But, if I schedule the job, it fails with the follwoing
error message.
Executed as user: raj. OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB
Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
I have also created a DTS package to update another Access
database, if I execute the package, it runs. If I schedule
the job, the job fails.
I have checked the permissions for the user Raj and it has
all the privilges.
Any help will be greatly appreciated!
Please suggest, how to fix this issue.
Thanks,
RajWith what account do you use to start the sqlagent with? Does that have
necessary permissions?
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj
>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>sql

Link server error The provider did not give any information about the error

Hi!

We have a test server (win 2003) in which MSSQL server is installed.In my system (win XP)I installed MYSQL server ,MY sql odbc driver.Now all I want is to create a linked server on MSSQL server so that data on Both server can be in sync.When even a new record in inserted in MYSQL it should be replicated to MSSQL srvr tabl immeditely

I tried to create a linked server but every time I got this error

Error 7399:OLEDB PROVIDER'MSDASQL' reported an error.The provider did not give any information about the error.OLE DB error trace[OLE/DB provider 'MSDASQL' IDBInitilize ::Initialize returned 0x80004005: The provider did not give any information about the error.]

Here is what I have done
sp_addlinkedserver @.server = 'localhost', @.srvproduct = 'MYSQL', @.provider= 'MSDASQL', @.datasrc ='localhost',@.location ='ipadd of my sqlserver',@.provstr ='DriverDriver={MySQL ODBC 3.51 driver};Server=ip add of mysql server;Port=3306;Option=131072;Stmt=;Database=testDB;Uid=root;Pwd=1234asdf' ,@.catalog = 'testDB'
Pls suggest what to do.I am trying for past 2 week but nothing came fruitful..sigh!!

Hi,

1. sp_addlinkedserver should not be returning this error. This error should occur when you try to access the linked server.

2. Can you check the permissions on the odbc driver files and make sure that they have the right permissions?

3. Can it be that the connection information that you specified in the connection string is incorrect?

4. You can also try to create a system DSN ( test the connection ) and use it in the linked server definition using the @.datasource parameter of sp_addlinkedserver( @.datasrc = N'YOU_DATASOURCE_NAME' ).

Hope this helps.

Thanks,
Rakesh

Link Server between Oracle and SQL Server error

This message appears :
"Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
[OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
tool installed with Oracle client) it connects correcty to Oracle Database.
Unfortunatelly, when I want create a "linked server" and I click on "tables"
this message appears !?
Who can help me ?
Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
you're running 7.x?
"Olivier TACKELS" wrote:

> This message appears :
> "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> tool installed with Oracle client) it connects correcty to Oracle Database.
> Unfortunatelly, when I want create a "linked server" and I click on "tables"
> this message appears !?
> Who can help me ?
>
|||You not only have an Oracle issue, there is also an MDAC issue. I have seen
that and similar issues when upgrading from MDAC 2.2-5 to MDAC2.6-7.
MS's Oracle drivers and interfaces are based on Oracle 8.1.7.6 from MDAC 2.5
on. Your client MDAC needs to be in sync with your db server mdacs.
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
|||Additional thought:
What release is your Oracle database? The 10g ones won't even talk to
Oracle 7x (or 8.0.x). If your Oracle is 10g, then you definitely need to
look at MDAC and SQL*NET.
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:

Link Server between Oracle and SQL Server error

This message appears :
"Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
[OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005
: ]."
My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
tool installed with Oracle client) it connects correcty to Oracle Database.
Unfortunatelly, when I want create a "linked server" and I click on "tables"
this message appears !?
Who can help me ?Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
you're running 7.x?
"Olivier TACKELS" wrote:

> This message appears :
> "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error tra
ce
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x800040
05: ]."
> My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Littl
e
> tool installed with Oracle client) it connects correcty to Oracle Database
.
> Unfortunatelly, when I want create a "linked server" and I click on "table
s"
> this message appears !?
> Who can help me ?
>|||You not only have an Oracle issue, there is also an MDAC issue. I have seen
that and similar issues when upgrading from MDAC 2.2-5 to MDAC2.6-7.
MS's Oracle drivers and interfaces are based on Oracle 8.1.7.6 from MDAC 2.5
on. Your client MDAC needs to be in sync with your db server mdacs.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>|||Additional thought:
What release is your Oracle database? The 10g ones won't even talk to
Oracle 7x (or 8.0.x). If your Oracle is 10g, then you definitely need to
look at MDAC and SQL*NET.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>

Link Server between Oracle and SQL Server error

This message appears :
"Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
[OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
tool installed with Oracle client) it connects correcty to Oracle Database.
Unfortunatelly, when I want create a "linked server" and I click on "tables"
this message appears !?
Who can help me ?Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
you're running 7.x?
"Olivier TACKELS" wrote:
> This message appears :
> "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> tool installed with Oracle client) it connects correcty to Oracle Database.
> Unfortunatelly, when I want create a "linked server" and I click on "tables"
> this message appears !?
> Who can help me ?
>|||You not only have an Oracle issue, there is also an MDAC issue. I have seen
that and similar issues when upgrading from MDAC 2.2-5 to MDAC2.6-7.
MS's Oracle drivers and interfaces are based on Oracle 8.1.7.6 from MDAC 2.5
on. Your client MDAC needs to be in sync with your db server mdacs.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
> > This message appears :
> > "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> > [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> >
> > My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> > Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> > tool installed with Oracle client) it connects correcty to Oracle Database.
> > Unfortunatelly, when I want create a "linked server" and I click on "tables"
> > this message appears !?
> >
> > Who can help me ?
> >
> >|||Additional thought:
What release is your Oracle database? The 10g ones won't even talk to
Oracle 7x (or 8.0.x). If your Oracle is 10g, then you definitely need to
look at MDAC and SQL*NET.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
> > This message appears :
> > "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> > [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> >
> > My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> > Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> > tool installed with Oracle client) it connects correcty to Oracle Database.
> > Unfortunatelly, when I want create a "linked server" and I click on "tables"
> > this message appears !?
> >
> > Who can help me ?
> >
> >

Link Server

Can u have a link server from SQL 7 to SQL 2000. I keep getting login error but I can connect successfully using query analyzer
thx
In the security tab in the linked server select the option: Be made using
this security context and put in the sa account and password. If that works
you can configure a standard SQL login to use.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||that is how I have it but I get 'login failed for sa' and I know the passwd is right

Link Server

Can u have a link server from SQL 7 to SQL 2000. I keep getting login error
but I can connect successfully using query analyzer
thxIn the security tab in the linked server select the option: Be made using
this security context and put in the sa account and password. If that works
you can configure a standard SQL login to use.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||that is how I have it but I get 'login failed for sa' and I know the passwd
is rightsql

link from sql2005 (64-bit) to sql 7 (32-bit).

Hi: I'm trying to link from sql2005 (64-bit) SP1 to sql 7 (32-bit) SP4.
I get the following error:
OLE DB provider "SQLNCLI" for linked server "sql7" returned message
"Unspecified error".
OLE DB provider "SQLNCLI" for linked server "sql7" returned message "The
stored procedure required to complete this operation could not be found on
the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider
"SQLNCLI" for linked server "sql7". The provider supports the interface, but
returns a failure code when it is used.
How can I get these servers linked?
Regards,I just ran into a similar problem, but from 64 bit SQL 2005 trying to link
to 32 bit SQL 2000. What I did on the 2000 server was run the instcat.sql
from the latest service pack installation I did on the 2000 server. In my
case it was SP3a. There are instructions to change the last insert statement
to the table to reflect the version of SQL Server (select @.@.version) that
you are running. In my case it was .977. That fixed my problems.
Jackie
"José" <josedc@.starmedia.com> wrote in message
news:OE2iT1GlGHA.3720@.TK2MSFTNGP03.phx.gbl...
> Hi: I'm trying to link from sql2005 (64-bit) SP1 to sql 7 (32-bit) SP4.
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "sql7" returned message
> "Unspecified error".
> OLE DB provider "SQLNCLI" for linked server "sql7" returned message "The
> stored procedure required to complete this operation could not be found on
> the server. Please contact your system administrator.".
> Msg 7311, Level 16, State 2, Line 1
> Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider
> "SQLNCLI" for linked server "sql7". The provider supports the interface,
> but
> returns a failure code when it is used.
> How can I get these servers linked?
> Regards,
>sql

Lineage ID Errors

I am running an SSIS package and I keep getting this error when it gets to a the dataflow task. I have a bit of an idea of what it means, but I can't figure out how to fix it. IF anybody could explain this error and fixes for it that would be of immense help. Thank you.

Error: 0xC004701C at Load Server Security, DTS.Pipeline: input column "Server" (1434) has lineage ID 1421 that was not previously used in the Data Flow task.
Error: 0xC004706B at Load Server Security, DTS.Pipeline: "component "OLE DB Destination 1" (1420)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
Error: 0xC004700C at Load Server Security, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Load Server Security: There were errors during task validation.The first error simply says that you have a column in the data flow, Server, that isn't used.

The second error looks to me like there were database changes to that table and now the OLE DB destination needs to be updated. Double click on the OLE DB destination and select the mappings tab. If no changes need to be made, simply click OK.|||

Possible reason could be if your destination table structure or the column data type changed.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=102011&SiteID=1

Thanks

|||You should have a triangle with an exclaimation mark on it. Double click on that component and then mappings, if applicable, to fix it.

Line Number

Hello,
I am getting an error in my .NET app and the error comes from a SQL
Server sproc. I am able to capture the line number. My question is how
to find that line? Do I start counting from CREATE PROCEDURE or from
the AS statement? Or elsewhere?
Frank,
Execute the sproc in Query Analyzer. When the error message appears in the
result pane, double-click it - should highlight the line or general location
of the error.
HTH
Jerry
"Frank Rizzo" <none@.none.com> wrote in message
news:O5ChPem1FHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I am getting an error in my .NET app and the error comes from a SQL Server
> sproc. I am able to capture the line number. My question is how to find
> that line? Do I start counting from CREATE PROCEDURE or from the AS
> statement? Or elsewhere?
>
|||Jerry Spivey wrote:

>Frank,
>Execute the sproc in Query Analyzer. When the error message appears in the
>result pane, double-click it - should highlight the line or general location
>of the error.
>
Unfortunately, this is not something that happens all the time. It
happens very rarely. When it does happen, the application captures and
writes out to a log all the info it can. This is where the line number
is found as well. Thus I am trying to troubleshoot a sproc based on a
line number.
So, that said, do I start counting from CREATE PROCEDURE or from the AS
statement?

>HTH
>Jerry
>"Frank Rizzo" <none@.none.com> wrote in message
>news:O5ChPem1FHA.3188@.TK2MSFTNGP14.phx.gbl...
>
>
>

Line Number

Hello,
I am getting an error in my .NET app and the error comes from a SQL
Server sproc. I am able to capture the line number. My question is how
to find that line? Do I start counting from CREATE PROCEDURE or from
the AS statement? Or elsewhere?Frank,
Execute the sproc in Query Analyzer. When the error message appears in the
result pane, double-click it - should highlight the line or general location
of the error.
HTH
Jerry
"Frank Rizzo" <none@.none.com> wrote in message
news:O5ChPem1FHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I am getting an error in my .NET app and the error comes from a SQL Server
> sproc. I am able to capture the line number. My question is how to find
> that line? Do I start counting from CREATE PROCEDURE or from the AS
> statement? Or elsewhere?
>|||Jerry Spivey wrote:
>Frank,
>Execute the sproc in Query Analyzer. When the error message appears in the
>result pane, double-click it - should highlight the line or general location
>of the error.
>
Unfortunately, this is not something that happens all the time. It
happens very rarely. When it does happen, the application captures and
writes out to a log all the info it can. This is where the line number
is found as well. Thus I am trying to troubleshoot a sproc based on a
line number.
So, that said, do I start counting from CREATE PROCEDURE or from the AS
statement?
>HTH
>Jerry
>"Frank Rizzo" <none@.none.com> wrote in message
>news:O5ChPem1FHA.3188@.TK2MSFTNGP14.phx.gbl...
>
>>Hello,
>>I am getting an error in my .NET app and the error comes from a SQL Server
>>sproc. I am able to capture the line number. My question is how to find
>>that line? Do I start counting from CREATE PROCEDURE or from the AS
>>statement? Or elsewhere?
>>
>
>