Fwd: Process Oracle Visual Studios Connection

1. Install Oracle Client 32 Bit

2. in VS 2010 -> View -> Server Explorer

3. Right Click on Data Connection ->  Add Connection ->

in server name ->  //OracleServerName:PortNo/InstenceName

//dc01xxxxxxx03.xxxxxx.ccc:80903/hixxjd

user id and password

 

4. Test connection

gridview -> use director-> Create connection string

 

 

and SQL statement

 

SELECT  * FROM DevUSER(Schema Name).[Table Name] WHERE ROWNUM <= 100