Oracle Database Express Edition (XE)

Good night:

I'm trying to connect from a laptop application (in visual basic .net) to Oracle 10g Express Edition installed in a desktop computer.

I referenced system.data.oracleclient dll and imported system.data.oracleclient namespace.

I went to http://www.connectionstrings.com/oracle#p14 to search a connection string.

I've tried several options like


dim cadcon1 as string ="Driver=(Oracle in XEClient);dbq=192.168.2.103:1521/XE;Uid=HR;Pwd=a;" that results in a vb argumentexception because the word driver is not admited.

Dim cadcon2 as string ="SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.2.103) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=XE))); Uid=HR; Pwd=a; but I've got a ORA-12170 error: TNS: connection timeout.

But the two machines ping each other with 2ms and TTL=128.

Also I've tried

Dim cadcon3 as string ="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=HR;Password=a;" and had another ORA-12170 TNS timeout connection.


Does anybody knows how to connect from a visual basic application in a machine to an oracle xe server?.

Which steps should I follow?.

Good night

Best regards