DB2 Connetion Failed[IBM][CLI Driver] SQL10007N Message "0" could not be retriev ed.

14 Years Ago appunu 0 982 Views

I new to python . I created the one console application in python for that i used two data bases IBM_DBI and POSTGRESQL8.4. I converted the console application into windows exe for that i used py2exe. It is created, while running the exe it coudn't connect with DB2 data base it give the Following error

DB2 Connetion Failederror return without exception set
DB2 Connetion Failed[IBM][CLI Driver] SQL10007N Message "0" could not be retriev
ed. Reason code: "6". SQLCODE=-1393

My code is mention in snippet. MY question what i want to added to above code for resolving above error. Please any one can help me in advance

Thanks in advance,
Ramesh R.

python

from distutils.core import setup
import glob
import py2exe

setup(console=[path+"DriverScript\\""DriverScript.py"],
      data_files=[("DB_Manager",[path+"DB_Manager\__init__.py",path+"DB_Manager\DB2_Connection.py",path+"\DB_Manager\PostGreConnection.py"]),
                    ("GenericFunctions",[path+"GenericFunctions\__init__.py",path+"GenericFunctions\ExcelReporting.py",path+"GenericFunctions\EmailSending.py",path+"GenericFunctions\FtpUnzip.py",path+"GenericFunctions\ReadExcelfile.py"]),
                    ("TestScript",[path+"TestScript\__init__.py",path+"TestScript\Count_Validation.py",path+"TestScript\Feed_Data_Validation.py"]),
                    ("Test_Data",glob.glob("E:\MacysPOC\Macys\Test_Data\\*.xls")),
                    ("System32dll",glob.glob("C:\WINDOWS\system32\\*.dll")),
                    ("ibm_db-1.0.2-py2.6-win32.egg",glob.glob("C:\Python26\Lib\site-packages\ibm_db-1.0.2-py2.6-win32.egg\\*.*"))]
                    )

TrustyTony 888 ex-Moderator

14 Years Ago

Code which is not tested to function Ok belongs to discussion thread. Just that you know next time.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.