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

OLEDB source error Expand / Collapse
Author
Message
Posted Tuesday, July 01, 2008 2:22 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205
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, :P
My Blog:

http://venkattechnicalblog.blogspot.com/
Post #526395
Posted Tuesday, July 01, 2008 5:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, 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