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

From: Brad Pybus <Brad_pybus_nospam_at_hotmail.com>
Date: Thu, 27 May 1999 20:01:34 GMT
Message-ID: <ywh33.158$8q5.74804@client.news.psi.net>

>Just use the keywords that are in the following statement
>
>UID=UserName;PWD=Password;CONNECTSTRING=<left side of tnsnames
>entry>;DRIVER={Microsoft ODBC for Oracle};
>
>and don't use the other keywords. This works for us.

Ok, if I just use the key words in the above statement I get: "Couldn't find installable ISAM."

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.

Brad Received on Thu May 27 1999 - 15:01:34 CDT