Re: Hi and could anyone help me please with some ADO

We have had a lot of success using just
dsn=primary;uid=whatever;pwd=whatever;

At 09:36 AM 11/15/00 -0800, you wrote:

>Hi Guys
>I am new to this list and quite enjoying to listen at the background and
>from time to time send a comment if I could be of any help. This is the
>busiest list I've ever come across with, pretty hard work to keep track.
>
>Well my problem is: one of our customers is trying to connect from an
>in-house developed application which uses Microsoft ADO to connect to our
>Oracle 8.0.5. database. He's tried various connect strings. I've set up
>the security requirements (username/pass, grants..) on the Oracle and you
>can see that a successful session is created on oracle but no data can be
>exchanged between server and the client.
>
>I know that the problem is a bit vague and depends what exactly your
>program is doing, but if you have any experience with a reliable way of
>connecting to Oracle 8.0.5 using ADO, regarding a correct ADO connect
>string, I really appreciate your help. Two of the example connect string
>have been used are as follow.
>
>'driver=Oracle73 Ver 2.5;uid=SYSTEM;ASY=OFF;DBQ=primary;pwd=manager'; --
>primary is a net8 alias which connects to the server
>
>'driver=Oracle ODBC DRIVER;uid=SYSTEM;ASY=OFF;DBQ=primary;pwd=manager'; --
>primary is a net8 alias which connects to the server
>
>As I've noticed from the odbc logs, there could be a driver incompatibility.
>I've attached the odbc log.
>The error happens on a simple select statement such as
>select job_id from test:
> the test table has one single column job_id as number(9)
>Thanks a lot for any help you can provide.
>regards
>Reza
>+++++++++++++++++++++++++++++++++
>6a:50 ENTER SQLSetDescField
> SQLHDESC 0x02ad23c8
> SQLSMALLINT 1
> SQLSMALLINT 1010 <SQL_DESC_DATA_PTR>
> SQLPOINTER 0x00000040
> SQLINTEGER 0
>
>fin 6a:50 EXIT SQLSetDescField with return code -1
>(SQL_ERROR)
> SQLHDESC 0x02ad23c8
> SQLSMALLINT 1
> SQLSMALLINT 1010 <SQL_DESC_DATA_PTR>
> SQLPOINTER 0x00000040
> SQLINTEGER 0
>
> DIAG [S1004] [Oracle][ODBC]SQL data type out of range
> <0>. (0)
>
> DIAG [HY021] [Oracle][ODBC]Inconsistent descriptor
> information. (0)
>
>fin 6a:50 EXIT SQLSetDescFieldW with return code -1
>(SQL_ERROR)
> SQLHDESC 0x02ad23c8
> SQLSMALLINT 1
> SQLSMALLINT 1010 <SQL_DESC_DATA_PTR>
> SQLPOINTER 0x00000040
> SQLINTEGER 0
>
> DIAG [S1004] [Oracle][ODBC]SQL data type out of range
> <0>. (0)
>
> DIAG [HY021] [Oracle][ODBC]Inconsistent descriptor
> information. (0)
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Wed Nov 15 2000 - 12:25:30 CST