RE: MI ODBC error nightmare
I've had the same problems after installing peer web services (NT) on machines, the SQL sever ODBC seems to muck up the ODBC drivers for MapInfo A service pack or MI ODBC reinstall doesn't seem to work. But your best bet to overcome this message is to "map a drive" to a machine of similar spec e.g. MapInfo and SP4 and from the Windows Directory copy all the *ODBC* DLL's from their system32 directory to yours (Backup your files just in case!). This cleared up my problem. Tim Chinchen (GIS Systems Developer) 01202 454723 I.T. Services Bournemouth Borough Council Mailto:[EMAIL PROTECTED] PS what sort of apps are you developing with XSite? - Inter/Intra? > -Original Message- > From: Andy [SMTP:[EMAIL PROTECTED]] > Sent: Friday, October 15, 1999 4:26 PM > To: mapinfo mailing list > Subject: MI ODBC erro nightmare > > Hi Listers, > I have the day thrashing my computer into an inch of its life trying to > install MapXSite. Due to reasons I can't fully explain I've been > installing/uninstalling it about four times so far. Unfortunately on the > last 'remove program' it managed to mess up my ODBC 'stuff'. And I know > receive the following error when trying to run MapInfo: > > ODBC Driver Manager > The ODBC resource DLL (C:\WINNT\System32\odbcint.dll) is a different > version than the ODBC driver manager > (C:\WINNT\System32\ODBC32.dll). You need to reinstall the ODBC components > to ensure proper operation. > Press OK to proceed, CANCEL to abort. > > I've tried to reinstall the ODBC products from the MI disk thinking this > is what the error is referring to, but now I suspect not. Unfortunately I > am not a great ODBC expert and I'm not plum-stick on what to do next. Am I > supposed to look into reinstalling sections of Windows NT or the Service > Pack 4? Or is it wholly a MapInfo problem? > > Any assistance will be worshipped for the rest of my lifetime.. > > Andy ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.bournemouth.gov.uk ** -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI ODBC Error
Hi Mappers: Does anyone else get this error with ODBC? "ODBC Error: ODBC RC=-1, ODBC SQLState=S1000, DBMS RC=0, DBMS Msg=[Microsoft][ODBC SQL Server Driver]Connection is busy with results from another hstmt." It seems to happen whenever I first open up a table, and also when I try to do a refresh. I am using SQL Server 6.5 and MapInfo 5.5. Thanks a bunch! Eric -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI ODBC ERROR.
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]
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]