Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
korssane
Posting Yak Master
104 Posts |
 Posted - 2009-03-26 : 11:00:31
|
| Hi All ,i have setup a linked server to oracle data base.the query gives me the correct shema but when trying to read a specified table i got this error messg:(0 row(s) affected)OLE DB provider "MSDASQL" for linked server "LINKED_ORA" returned message "[Oracle][ODBC]Invalid column number <77>.".Msg 7330, Level 16, State 2, Line 30Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "LINKED_ORA".I am stuck and i do not know what is the prob. the name of the table is correct ..i have already tested it using MS access.Any helpwill be greatly appreciated.thanks |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-26 : 11:25:06
|
| try a "select top 1 * from " to checked column names spelt correctly etc. |
 |
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-03-26 : 12:09:05
|
| thanks,but stil having the same error. |
|
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-03-26 : 12:12:31
|
| Sorry ,just to let you know that i am running SQL2005 Express edition if this can help.thanks |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-26 : 13:06:27
|
| whats the query that you are running ? Have you checked for the version of the driver you are using ? May be you need a more recent one. |
|
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-03-26 : 13:09:36
|
| HI,I fixed the problem. I think it is a limitation in SQL 2005 Express..i have just specified columns in a table and it worked fine. Might be limitted by a max # of culumnsthanks for the help.I have another question for you.i am quering Date filed but i do not see date format it seems ike a number format..Are you familiar qith date/time syntax ?thanks |
|
|
|
|
|
|
Oracle Linked server error.