dbTalk Databases Forums  

DTS dbase5 Connection could not open dbf File in Win2K Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS dbase5 Connection could not open dbf File in Win2K Server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prabhat
 
Posts: n/a

Default DTS dbase5 Connection could not open dbf File in Win2K Server - 07-23-2004 , 02:31 AM






Hi All,

I have one DTS Package which has a dbase 5 Connection. If I RUN the DTS
Package in SQL Server Installed in Windows 2000 Prof. Then That Works Fine.
But that Gives the below Eoor Message if I Try to run that Package from a
SQL Server Installed in Win 2000 Server Ed. Or Advanced Server Ed.
----------------------------------------------------------------------------
----------------
Error Source: Microsoft JET Database Engine

Error Description: The Microsoft Jet database engine could not find the
object 'bct 072303'. Make sure the object exists and that you speel its name
and the path name corretly.
----------------------------------------------------------------------------
-----------------

I found that I can Run the DTS Package in Win 2000 Server / Adv. Server ed.
If I open a .DBF file which has name of (8.3) format. File Name having
length more than 8.3 is having that Problem. But the Long File anme are able
to open from win 2000 Proff. Ed.

Then What is the problem in Windows 2000 Server Ed? And How Do I Resolve
that Problem so that My DTS Package will able to open long file names with
in the windows 2000 server ed.?

Thanks
Prabhat




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.