Re: cannot connect using ms odbc driver

In article <8ua5tu$3fl$1_at_tilde.csc.ti.com>,   "John Hayles" <spoonman_at_ti.com> wrote:
> 1) I am running mdac 2.6sp1 and Net8. I cannot use the 'Microsoft
 Oracle
> ODBC Driver' to connent to the database through anything (Excel,ASP
 pages,
> etc...) except for the 'Oracle ODBC test' utility. When I try to
 connect
> thruogh Excel I enter the psw, id, db info and hit enter, what is
 returned
> is a dialog box with a single exclamation mark in it '!'. I get no
 clue as
> to the error. When trying to cneect through ASP I get
 error: 'Microsoft OLE
> DB Provider for ODBC Drivers error '80004005''. If I go into
 the 'Oracle
> ODBC test' utility and select the same connection I am able to get
 through
> using the same info. I have tried setting up other connections. Any
 help
> with this is appreciated.
>
> 2) What I want to do is set up a web page in ASP to 'page' through
 query
> results for large record sets. See:
> http://msdn.microsoft.com/voices/server05222000.asp. However from
 what I
> can tell the Oracle driver does not support this. It will not allow
 setting
> the value of recordset property: AbsolutePage. I get an error
 message : the
> 'provided' does not support ...

Can you clarify exactly how you're connecting to the database? There appear to be 3 options for you when you're writing an ASP-

• Oracle OLE DB Provider
• Microsoft OLE DB Provider for Oracle
• Microsoft OLE DB Provieder for ODBC

If you're using the third option, you'll also have the option as to which ODBC driver you're using (Microsoft ODBC driver for Oracle, Oracle ODBC driver, Merant ODBC driver for Oracle, etc.)

Depending on exactly how you're connecting, there may be different functionality available.

Also, can you give the failing connect string you're using in the ASP?

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.