jez.lisle (2/4/2010)

---

dweil (2/4/2010)

---

I think you are getting closer now that you can connect via sqlplus.

Search the entire computer to see if there is more then one copy of tnsnames on...

dweil (2/4/2010)

---

I think you are getting closer now that you can connect via sqlplus.

Search the entire computer to see if there is more then one copy of tnsnames on it.

In...

dweil (2/4/2010)

---

Try changing “HOST = MyServer” to ”HOST = ip address”.

Oracle might not be resolving the host address correctly.

It that does not work you might try

1.renaming the...

dweil (2/4/2010)

---

Could the path not be set up correctly?

Can you tnsping from c:\ or E:\?

Also try renaming sqlnet.ora.

Sqlnet.ora in not necessarily needed and it might just not be making it...

I been reading the weblink again that I attached earlier, and realised that I had made an error and had previously installed 10g & 11g clients. I uninstalled it all...

Just to help with things, this is the website I found some instructions from

http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/">

http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/

DNA_DBA (2/2/2010)

---

hmmm.....

I just want to see if the client is connecting to the database as this will use the listener and prove the connection details are correct - can you...

jez.lisle (2/1/2010)

---

DNA_DBA (2/1/2010)

---

Looks like you've got both Oracle 10g client and 11g client installed. The 10g client knows where to find the database but the 11g client doesn't -...

DNA_DBA (2/1/2010)

---

Looks like you've got both Oracle 10g client and 11g client installed. The 10g client knows where to find the database but the 11g client doesn't - can...

DNA_DBA (1/29/2010)

---

if you've installed the oracle client you should have both tnsping and sqlplus.

at a command prompt, type

[font="Courier New"]tnsping MyDatabase[/font]

this should return some info about the...

No, Whats SQLPlus, how can...

Excellent, thanks for this...

I will give it a go and hopefully all be ok 😀

Thanks again

Thanks for that, I tried it and managed to build it up like this below

Original field 26.10.09

Substring Field 091026

but what I'm looking for is how to convert the fields that...

Thats all I have seen when I ran a query on just that field, but I'm going to go over it again to check

Checked again and made sure theres nothing...

Thanks for that, I've tried it and get the error

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

This is the line I included

convert(datetime,...