Re: Please Reply . It's Urgent.

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

Date: Sat, 20 Mar 2004 13:50:44 -0800

Hello, thanks for reply.
I have installed Win2003 server O.S. on my system with Oracle9i and
Visual Studio6.0.
I am trying to connect to database using ODBC link in VB, all within a
single computer only.

But i'm still not able to connect to Oracle Database either through ODBC
or ADO.

Earlier i had installed Active directory on my system.
So, When i tried 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 Showed an error as follows:(old error message)

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

But now after i removed active directory from my system, it shows an
error message(on testing the ODBC link created by selecting the driver
Oracle in Ora9i and testing the connection) as follows:(recent error
message)

Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name

I've also tried the driver: Microsoft ODBC for Oracle, but to no avail.
it doesn't connect to Oracle9i

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!

Relevant Pages

  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Ada DB bindings and APQ
    ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
    (comp.lang.ada)
  • Re: Mailmerge using a secure database
    ... Database does not have a long path name. ... When I tried re-opening my mail merge documents I get an error message ... Do you need or want specifically to connect with ODBC? ... likely to run into problems where Word truncates the connection string ...
    (microsoft.public.word.mailmerge.fields)
  • 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: Data from 2nd Database in a form
    ... >Login parameters for the ODBC. ... I will instantiate an new database object ... >with a connection to his user-account on Oracle and then ...
    (microsoft.public.access.formscoding)
Loading