Pervasive sql 2000i and logn_fail error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Pervasive sql 2000i and logn_fail error

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-10 : 08:21:49

Nasir writes "I got the following error when saving patient's study file (rather saving in database)

step 'DTSStep_DTSExecuteSQLTask_4' failed
Step error source: microsoft data transformation services (DTS) package
Step Error Description: unspecified error
(microsoft OLE DB Provider for SQL Server (8000405): cannot open database requested in login 'Clab_optical'. login fails)

Step error code: 80074005
step error help file: sqldts.hlp
step error help contect id : 1100

It is saving my patient file in db...

we have windows nt workstation
and using cardiolab software with this"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-10 : 13:18:07

I think you need to reset your default database with sp_defaultdb. Or maybe your login doesn't have access to that database, in which case ask the DBA to provide you access.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources