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..

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

Good Luck

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..

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.
================================================== =========

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..

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.
================================================== =========

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?

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..