Bandit88_Johnson
asked on
Table " cannot be found
VB6 DESIGNERS & CRYSTAL REPORT9
ERROR: Table " cannot be found!
I have tried everthing I know to solve this problem including:
CurrentDataBaseName=F:\JEMSWIN\JEMSVB\JEMSDB.M DB
frmRecPrinting.Report11.Da tabase.Tab les(1).Set LogOnInfo "", CurrentDataBaseName, "", DBPassword
frmRecPrinting.Report11.Da tabase.Tab les(1).Loc ation = CurrentDataBaseName
set frmRecPrinting.Report11=no thing
DOEVENTS
SLEEP(100)
Report11.VerifyOnEveryPrin t = True
Report11.DiscardSavedData
Problem occurs when the database changes locations. When you look at the designer, database location remains in default location and Verfiy on Every print is checked. If in the designer, you reset the database location, then this stuff works, but that won't work when the package is deployed.
What causes this error and how can it be fixed?
ERROR: Table " cannot be found!
I have tried everthing I know to solve this problem including:
CurrentDataBaseName=F:\JEMSWIN\JEMSVB\JEMSDB.M
frmRecPrinting.Report11.Da
frmRecPrinting.Report11.Da
set frmRecPrinting.Report11=no
DOEVENTS
SLEEP(100)
Report11.VerifyOnEveryPrin
Report11.DiscardSavedData
Problem occurs when the database changes locations. When you look at the designer, database location remains in default location and Verfiy on Every print is checked. If in the designer, you reset the database location, then this stuff works, but that won't work when the package is deployed.
What causes this error and how can it be fixed?
what is the exact error message you are getting
ASKER
Error is - THE TABLE " CANNOT BE FOUND
jrm213jrm213: - I hope you are incorrect in the syntax as my software runs on many different servers as multiuser stuff whose names are unknown to me. Please reply back on this matter if you are correct.
This is so crazy as many reports issue the above error - immediately run it again and it works.
No VB code issued seems to change the default database location of the Designer. If you manually set it in stone inside the designer - it seems to work correctly everytime.
jrm213jrm213: - I hope you are incorrect in the syntax as my software runs on many different servers as multiuser stuff whose names are unknown to me. Please reply back on this matter if you are correct.
This is so crazy as many reports issue the above error - immediately run it again and it works.
No VB code issued seems to change the default database location of the Designer. If you manually set it in stone inside the designer - it seems to work correctly everytime.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't know if this will help or not but I don't think that your parameters for setlogoninfo are valid
I believe the parameters are server, database, user, password
so you are trying to connect to the database with a password but no user