Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

OLEDB source error Expand / Collapse
Posted Tuesday, July 1, 2008 2:22 AM



Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205

Am having "TableA" in sybase. I need to fetch the data from TableA using OLE DB Source.

I have connected to the database and test connection is succeeded. In the drop down, am able to see all the tables. But its appended with "dbo". My table looks like "dbo"."TableA" . If i click preview, am unable to get it and if i click "Ok" am getting the following error. Please help me to resolve this.

Code SnippetTITLE: Microsoft Visual Studio

Error at Data Flow Task [OLE DB Source [211]]: An OLE DB error has occurred. Error code: 0x80040E37.
An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80040E37 Description: "[Native Error code: 102]
[DataDirect ADO Sybase Provider] Incorrect syntax near '.'.

Error at Data Flow Task [OLE DB Source [211]]: Opening a rowset for ""dbo"."TableA"" failed. Check that the object exists in the database.


Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)



Thanks and Regards,
Venkatesan Prabu, :P
My Blog:
Post #526395
Posted Tuesday, July 1, 2008 5:39 AM


Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
It is a driver compatibility issue - you should contact DataDirect. My suggestion for a workaround (and probably theirs) would be to change the data access mode dropdown in the OLEDB Source component from "Table or View" to "SQL Command" and type the select statement in rather than choosing a table.
Post #526492
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse