Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

URGENT......Plz. help me guys.....Getting an error:"ActiveX component cannot create Object" while my VB code goes to connect SQL Server6.5



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


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.