how to connect sql server to oracle

ha
i am facing the problem that
i am unable to connect sql server to oracle
i have sqlserver in my system and oracle server is in remote
i want to access that database with using DTS
so that ,mmy memory will bw save
could any one please help for this
please yaar i am waitinf fro urs reply
Configure it as a linked server. To create linked server , open
EM->Security->Linked Server.
vinu
"dev" <dev@.discussions.microsoft.com> wrote in message
news:50B38365-9030-4810-9753-D58C5FAD591E@.microsoft.com...
> ha
> i am facing the problem that
> i am unable to connect sql server to oracle
> i have sqlserver in my system and oracle server is in remote
> i want to access that database with using DTS
> so that ,mmy memory will bw save
> could any one please help for this
>
> please yaar i am waitinf fro urs reply
>
|||hi
vinu
i did that
EM->Security->Linked Server.
but when ever i am trying to acess the table it gives a message that
ERROR 7399:OLEDB provider 'MSDAORA' reported an error
could u please clarify about this
"vinu" wrote:

> Configure it as a linked server. To create linked server , open
> EM->Security->Linked Server.
> vinu
>
> "dev" <dev@.discussions.microsoft.com> wrote in message
> news:50B38365-9030-4810-9753-D58C5FAD591E@.microsoft.com...
>
>
|||This might be helpful
http://support.microsoft.com/kb/280106
vinu
"dev" <dev@.discussions.microsoft.com> wrote in message
news:4A97A14E-04C8-4460-9688-2A4FAD4697FB@.microsoft.com...[vbcol=seagreen]
> hi
> vinu
> i did that
> EM->Security->Linked Server.
> but when ever i am trying to acess the table it gives a message that
> ERROR 7399:OLEDB provider 'MSDAORA' reported an error
> could u please clarify about this
>
> "vinu" wrote:
|||hi vinu
let me try this it will take some time it has some work with registry
fro that it s late
thanks fro giviing this suggestion
if nothing i will get back to you
thanks yaar
"vt" wrote:

> This might be helpful
> http://support.microsoft.com/kb/280106
>
> vinu
>
> "dev" <dev@.discussions.microsoft.com> wrote in message
> news:4A97A14E-04C8-4460-9688-2A4FAD4697FB@.microsoft.com...
>
>
|||Can you connect using the native Oracle tools? net Configuration Assistant
provides a means of testing the connection, and SQL+ will also do the same.
This is the first step and the most often missed step - to check that you
have a valid TNS entry and the firewall is correctly configured.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
sql

How to Connect remote Access database to SQL server

Hai,
I want to Convert remote Ms access data to sqlserver data.
Here i am using FTP Task in DTS for downloading Ms Access database to local machine.
After that, I convert it to sql data.
But, most of time, With download the mdb file, the message 'Opreation sucessfully' display.
Please give solution for this.
With regards,
dharmaprakash.
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...Please do not post separately in different groups.
Whats the matter if its performed successfully.
Jens Süßmeyer.

How to Combine IN & LIKE

Hai All,
Could some one help me how to combine IN & LIKE in the query selection,
i'v try many syntac and i just have no find the way out

this is what I would like to write:

Select DSCRIPTN,ORMSTRID,ACTINDX
from T50001
where ACTINDX = 350
and DSCRIPTN Like in '%'+(select distinct rtrim(ORMSTRID) ORMSTRID from L10001)+'%'

hi,

you can not combine the two keywords... as you can see from BOL synopsis, LIKE expects an expression and not a multiple reusult.. and you can not combine the expression as you require..

you probably have to rewrite your subquery to retun something comparable with the main query result's primary key.. the LIKE operator should probably go inside the subquery..

regards

|||

Something like:

Select DSCRIPTN,ORMSTRID,ACTINDX
from T50001
where ACTINDX = 350
and EXISTS
(

select * FROM L10001 WHERE DSCRIPTN LIKE '%' + ORMSTRID +'%'

)

If you have multiple entries in the L10001 table you should use a subquery which create the DISTINCT values on the fly.

Jens K. Suessmeyer.

http://www.sqlserver2005.de