Re: VB6 connection with Oracle9i using ODBC

From: syed nizami (s_azam_nizami_at_indiatimes.com)
Date: 03/07/04

  • Next message: syed nizami: "Re: VB6 connection with Oracle9i using ODBC" 
    Date: Sun, 07 Mar 2004 13:22:46 -0800

    Hello, thanks for reply.
    I have installed Win2003 server O.S. on my system with Oracle9i and
    Visual Studio6.0.
    But i'm still not able to connect to Oracle Database either through ODBC
    or ADO.
    I am trying to connect to database using ODBC link in VB, all within a
    single computer only.

    When i try to connect using Microsoft ODBC Data Source Administrator by
    creating
    system DSN or User DSN & selecting the driver: Oracle in Ora9i, & tests
    the connection,
    It Shows an error as follows:

    Unable to connect.
    SQL state=S1000
    [Oracle][ODBC][Ora]ORA-12637 Packet Receive failed

    I've also tried the driver: Microsoft ODBC for Oracle, but to no avail.

    The Oracle service & TNS Listener service starts smoothly, & i always
    make sure
    to start them before trying to connect to database.

    Once earlier, the connection through ODBC was successful & Test also
    succeeded but
    when i used that ODBC link in VB Appln. wizard to check whether the
    database was accessible, it
    showed all except the tables created by me in the database.
    Please tell me how to resolve these problems.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: syed nizami: "Re: VB6 connection with Oracle9i using ODBC"

    Relevant Pages

    • Re: Set up an ODBC connection Programmatically?
      ... the correct DSNless connection string for Oracle? ... Doug Steele, Microsoft Access MVP ... Other people can use this database, ... they have their system ODBC drive set up exactly as mine was when I ...
      (microsoft.public.access.modulesdaovba)
    • Re: Please Reply . Its Urgent.
      ... But i'm still not able to connect to Oracle Database either through ODBC ... Oracle in Ora9i and testing the connection) as follows:(recent error ...
      (microsoft.public.vb.database.ado)
    • Re: Problem with numeric blank fields
      ... Oracle 8i and ASA 8.03. ... I checked the ODBC log to find out what ODBC types they were bound to. ... which type of database? ... thing I can think off is to modify the SQL directly in MS Query (i.e. ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Connectivity between Oracle and Progress Database
      ... Forse che io mi connetto ad oracle, faccio delle query ed il server stesso ... Una sorta di DBLink utilizzando gli ODBC? ... > am new to progress database. ...
      (comp.databases.oracle.server)
    • Re: ODBC JBDC Linked tables
      ... Access on a local Jet database is blazing fast. ... in return for other features of DB servers like Oracle and SQL Server. ... Mary Chipman wrote a book on how to optimize Access with SQL Server. ... I am using odbc drivers to link to the tables. ...
      (microsoft.public.access.externaldata)