
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Hi guys I'm facing a typical problem. I'll describe that below. I call a VB's .exe file from a batch process, where from I pass the parameters for connecting to the database. PLz. Note the database I am using is SQL Server6.5. First I give below the batch file: ****************** f: cd \batch_jobs\st_to_mp\ftp F:\batch_jobs\st_to_mp\invoice_insert\invoicepost.exe invoicepost="f:\batch_jobs\st_to_mp\ftp\invoicepost.txt" DBConnect="provider=SQLOLEDB;uid=softnite;pwd=peach;server=usilesea;database=softrax" LogFile="F:\batch_jobs\st_to_mp\invoice_insert\log\LogFile.txt" FileAttchPath="f:\batch_jobs\st_to_mp\invoice_insert\rpt" TrgPath="f:\batch_jobs\st_to_mp\trigger\invoicepost.trg" EmailAddr="oveba01;ormth01;cohdo02;butsu01;urbth01;" MasterConn="provider=SQLOLEDB;uid=softnite;pwd=peach;server=usilesea;database=master" USA_GL = "010072400004080003" INAR_GL = "030250000004080003" *************************** now as you see above, in the batch file, as it tries to connect the database using the DBConnect string it gets a error having an ERROR no. 249 and ERROR Messege of: "ActiveX component cannot create Object" I simply can't get hold of what is the error. Mind it the .vbp file from which the .exe file was created didnot have any missing dll's.
| <-- __Chronological__ --> | <-- __Thread__ --> |