Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

file name in OPENDATASOURCE() Expand / Collapse
Author
Message
Posted Thursday, September 11, 2008 1:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 24, 2009 7:46 AM
Points: 3, Visits: 28
Hello,

I may be asking silly question!

I am using SQL Server 2005 Standard Edition (SP2).

I ran query using OPENDATASOURCE(). I am using tab delimited text file as "Data Source". I got following SQL exception when I ran query with "ParthaMishra_1172_Sov_ITMSUpload_UnitedWay_NewEngland_2009Final.txt" file name.
------Exception-----
Exception in Thread com.microsoft.sqlserver.jdbc.SQLServerException: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "ParthaMishra_1172_Sov_ITMSUpload_UnitedWay_NewEngland_2009Final#txt". The table either does not exist or the current user does not have permissions on that table.
---------------------

Interestingly, I ran the query again after changing name of the file to "PPM_ITMSUpload_1172.txt" and it worked.

So my question is: Is there anything with length of file name when using OPENDATASOURCE()?

The physical paths of the file are "E:\PMS\UploadedFiles\23055\2008\emp_CBD6042EEB20D1B68E1A51F194B024BD_1221156673057\ParthaMishra_1172_Sov_ITMSUpload_UnitedWay_NewEngland_2009Final.txt" and "E:\PMS\UploadedFiles\23055\2008\emp_CBD6042EEB20D1B68E1A51F194B024BD_1221157087084\PPM_ITMSUpload_1172.txt"

Please clarify me.

Thank you!
Post #568063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse