VB6 and Oracle errors

[juliemac]

I designed a system, works well on my machine but fails on others machines.

I create an ADO connection, passing the Uname and Pword and on my machine with this connection.
<conn>
ConnString = "Provider=MSDAORA.1;User ID=Uname;Password=Pword;Data Source=Servername;Persist Security Info=true"
</conn>
Again, this works in the IDE as well as the exe on my machine.

One error is TNSfile cannot connect. All tns files are updated for the new server and they cannot TNSPing the systems either.

Another is null password and will not connect. Arrrghhh

I'm thinking its the Oracle install. Nothings standardised here.

[si_the_geek]

Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)

[juliemac]

Ooops. Thanks.

[RhinoBull]

Your typical tns entry may look like this:

TNSNAME =
(DESCRIPTION=
   (ADDRESS_LIST=
      (ADDRESS=
         (PROTOCOL=TCP)
         (HOST=YOURHOST)
         (PORT=1111)
      )
   )
   (CONNECT_DATA=(SID=SOMESID)
   )
)

Open command prompt and try to ping YOURHOST (it could be allias say DBPROD or actual IP Address).
If it's not pingable then that's your problem - ask your DBA or guys from your infrastructure to help you with that.

[GaryMazzone]

Is the server up? Is the database running? Is the listener on the db server running and listening on the right port?