file name in OPENDATASOURCE()

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » file name in OPENDATASOURCE()

file name in OPENDATASOURCE()

Rate Topic

Display Mode

Topic Options

Author

Message

Jignesh Patel-441242

Posted Thursday, September 11, 2008 1:06 PM

Forum 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 »

Permissions