Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
| Search | Today's Posts | Mark Forums Read
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 1st, 2009, 09:06 AM
Friend of Wrox
 
Join Date: Jan 2006
Location: Hardwar, Uttranchal, India.
Posts: 180
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via ICQ to dpkbahuguna Send a message via MSN to dpkbahuguna Send a message via Yahoo to dpkbahuguna
Default [Microsoft] [ODBC driver for oracle] [oracle] ORA-06413: connection not open

Hello Friends,

i have made a program ..which is running fine but as i making the EXE of it ..and run this exe then I am getting this error..

enybody can tell me pls wht are the situations for coming such a errors.

my source like:

Private Sub OpenConnection()
On Error GoTo lab
'CON.ConnectionString = "Provider=MSDAORA;User ID=kkb;Password=slider;Data Source=TallyNet;"
CON.ConnectionString = "dsn=Mydsn;uid=XYZ;pwd=xyz"
CON.CursorLocation = adUseClient
CON.Open
Exit Sub
lab:
MsgBox "Oracle Connection Couldn't be opened. (" & Err.Description & " )"
End Sub



its urgent....
thanks in advanced.
__________________
DPK..

Last edited by dpkbahuguna; May 2nd, 2009 at 11:17 PM..
 
Old May 2nd, 2009, 01:55 PM
Authorized User
 
Join Date: Mar 2009
Posts: 49
Thanks: 0
Thanked 8 Times in 8 Posts
Default

Check you connection string against what is published at http://www.connectionstrings.com/

Good Luck

 
Old May 2nd, 2009, 11:19 PM
Friend of Wrox
 
Join Date: Jan 2006
Location: Hardwar, Uttranchal, India.
Posts: 180
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via ICQ to dpkbahuguna Send a message via MSN to dpkbahuguna Send a message via Yahoo to dpkbahuguna
Default Error is coming only in EXE

thanks friend for replying ....i dont think there is any probe with connection string because my programe is running but only its EXE is not running any solution for that....

thanks
__________________
DPK..
 
Old May 3rd, 2009, 10:01 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

Did you check it?? it doesn't look good.
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========
 
Old May 4th, 2009, 01:04 AM
Friend of Wrox
 
Join Date: Jan 2006
Location: Hardwar, Uttranchal, India.
Posts: 180
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via ICQ to dpkbahuguna Send a message via MSN to dpkbahuguna Send a message via Yahoo to dpkbahuguna
Default Exe Error

yes I checked it my Program is running well but when I am making its EXE and executing the EXE but it is not running. Please give me solution I am stuck with it ...in implementing time.

when error is coming there is a file named "sql.log" is generating it contains.

Fatal NI connect error 6413, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.0.3)(PORT=1521)))(CONNECT_DATA=(SERV ICE_NAME=orcl)(CID=(PROGRAM=C:\Pro_rander(2MAY-09)-4.exe)(HOST=MKT)(USER=CPG))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
Time: 02-MAY-2009 17:24:48
Tracing not turned on.

Thanks, waiting for your reply.
__________________
DPK..

Last edited by dpkbahuguna; May 4th, 2009 at 01:10 AM..
 
Old May 4th, 2009, 07:41 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

The exe is on the development PC or in another one?
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========
 
Old May 4th, 2009, 09:54 PM
Authorized User
 
Join Date: Mar 2009
Posts: 49
Thanks: 0
Thanked 8 Times in 8 Posts
Default

If it is on another machine...

Did you create an instal package via the PDW or Inno?
Did you set up the ODBC Driver with the same name as on your development machine?
Is that driver the same as on your machine?
 
Old May 5th, 2009, 12:31 AM
Friend of Wrox
 
Join Date: Jan 2006
Location: Hardwar, Uttranchal, India.
Posts: 180
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via ICQ to dpkbahuguna Send a message via MSN to dpkbahuguna Send a message via Yahoo to dpkbahuguna
Default Solved

My probe has solved .... what COM i am using that is not registered COM so I can make only One connection at a time...if I am making more than one connection then I was getting that error...

thanks for you cooperation.... :)
cheers :)
__________________
DPK..




Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR [42000] [Microsoft][ODBC driver for Oracle][ sanjeev jha General .NET 0 June 28th, 2008 12:50 AM
[Oracle][ODBC][Ora][ORA-01013 Corey Access 1 December 15th, 2006 10:29 AM
ODBC DSN connection to Oracle Vera Classic ASP Databases 1 December 15th, 2006 10:13 AM
[Microsoft][ODBC SQL Driver]Connection is busy muthumari_p2003@yahoo.com Pro JSP 0 May 8th, 2006 07:51 AM
Microsoft ODBC for Oracle amjad_mahmood VB Databases Basics 1 August 22nd, 2005 10:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.