Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

create connection to oracle (VS 2005)

Hi
i install oracle 10g
i want to create project by C# 2005 with oracle database
i failed to create connection to oracle
Thanx for helping me
Rafeek
[196 byte] By [Rafeek] at [2007-11-11 10:31:31]
# 1 Re: create connection to oracle (VS 2005)
Are you using the Oracle Data Provider for .NET (ODP.NET)? If so, please see http://www.oracle.com/technology/sample_code/tech/windows/odpnet/howto/connect/index.html
Phil Weber at 2007-11-11 23:43:15 >
# 2 Re: create connection to oracle (VS 2005)
Also make sure that your TNSNAMES.ORA and SQLNET.ORA files are configured properly. This can be a big headache. You can find them in the Network folder in the Oracle Home directory.

If you had to instal the client more than once, I would also make sure that your Oracle home folder is set correctly in the global system variables in windows.

Good luck
TecGumbo at 2007-11-11 23:44:23 >