Can you elaborate further?

if you had the 3 tables grade,owner,ownergrades

it would be something like

select owner

from owners

where (

exists (select * from ownergrades inner join grades on ownergrades.grade=grades.grade and ownergrades.owner=owners.owner and...

What is exactly the problem? The acquire connection or the unicode conversion?

Have you tested the oracle connection from the server using "sqlplus" for both the clients?

Just to improve my english, what is the meaning of "Rodders..."?

Members of a hotrod club

or maintenance (access?)

or the thing you use to unclog pipes (duct rodders)

Can you give an example of "only display the numbers after the decimal related to random"?

Have a look at Salted Password Hashing - Doing it Right

Rnd is a random function

Hello,

The code looks like php

You'll have to construct a query with the where exist clause Koen mentioned.

Did some googlefu and ended up with:

insert statements with codeigniter

query with codeigniter

Select *

Define all varchar's as varchar(max) to be on the safe side.

Passing strings as date-parameters: where mydate='01/06/2005' -> the first of june or the sixth of january ?

sqlserver works best with the oracle oledb driver (OraOLEDB)

For newbieuser: convert '18/01/2009' to a proper datetype instead of relying on the occasional dateformat of the server. By using convert?

For penny: have you checked the distiributed transaction coordinator...

As Koen mentioned, did you install the 64-bit variant of the oracle client?

Did you reboot?

Oracle home environment variable properly set?

Didn't know about the bug, glad you mentioned it.

100 is the default fetchsize for the Oracle Client, you might increase it through the registry/provider string

Case sensitivity? (collaction/Oracle case sensitivity)

Mix of datatypes? trim(x)=:comp -> characters? :comp=0 -> number?

Why is the trim added in the last line?

You have supplier_country = receiver_country and :ccty = 0 (without...

I would expect

Declare @OrderID Int

Exec ('Call DATALIB.BP_PUSH_F(?)', @OrderID OUTPUT) AT ERP

if I read correctly (link)