July 1, 2008 at 2:22 am
Hi,
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.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:
http://venkattechnicalblog.blogspot.com/
July 1, 2008 at 5:39 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply