Sanjoy,
The select statement needs a couple of adjustments. When you make an ODBC
connection through MapInfo Pro, it hides some complexity. Please open one
of those successful .tab files with a word processor such as Notepad.exe and
read the select statement. It will have _more_ than you need; just keep
what comes inside the quote marks.
Essentially, the select must explicitly reference all column names, and the
case must be correct: "select id, attribute1, attribute2 from circle;"
I think select * won't work.
Good luck!
Sam Kome
Sage Software
Durham, North Carolina
www.sagesoft.com
-----Original Message-----
From: IDS <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, August 01, 1999 10:00 AM
Subject: MI ODBC ERROR.
>Hello,
>
>I have Personal Oracle 8.0.4 loaded in my local system. I am trying to
>access the oracle database through mapbasic. I have written the following
>codes:
>
>Open Table "d\MapInfo\Data\India\Dist.tab" Interactive
>Map From India
>set map redraw off
>set map redraw on
>Register Table "oracle"
>TYPE ODBC
>TABLE "Select * From circle"
>CONNECTION
>"DSN=test2;UID=po8;PWD=po8;dlg=1;"
>Into
>"D:\workspac\circle.TAB"
>Open Table "D:\workspac\circle.tab"
>Interactive
>Map From circle
>
>
>I get the following error message:
>
>ODBC ERROR: table or view circle not found in Database. No columns in
>table circle. Unable to prepare table d:\workspac\circle.tab
>
>I have been able to open the same table through MapInfo ODBC process.
>Can anyone help me as to where I may be making a mistake.
>
>Regards
>
>Sanjoy Dassarma
>
>**************************
>Integrated Digital Systems
>4B Sundaram
>46F Rafi Ahmed Kidwai Road
>Calcutta 700 016
>Tel : 91 33 2290541/2295265
>Fax : 91 33 4667974
>**************************
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
