Re: Connect string using MS Oracle ODBC driver. help.

From: idt news <dovidf_at_net2phone.com>
Date: Thu, 27 May 1999 19:00:38 -0400
Message-ID: <7ikis0$4vj@nnrp4.farm.idt.net>

> So if I add the "ODBC;" prefix
> i.e.
>

"ODBC;UID=MyUserName;PWD=MyPassword;CONNECTSTRING=MyServiceName;DRIVER={Micr
> osoft ODBC for Oracle};"
>
> Then I get.....
>
> "ODBC-call failed."
>
> Almost looks like something is wrong on my Oracle side, not with my
connect
> strings.
>

You said that you could connect using oracle drivers? Run your Oracle odbc test using the dsn set up with the Microsoft Oracle driver and see if you can connect that way. Also, check your sqlnet.ora to see if the .world suffix is appropriate. Received on Thu May 27 1999 - 18:00:38 CDT