Hi
We are also having problems connecting to our SQL 7.0 servers from Mapinfo.
The error is different. I'am able to establish a connection with the MS
drivers, but when I try to open the table, I'm reciving a ODBC error
stating, that the connection is busy with another hstmt (the same ODBC DSN
works fine with Access and MS Query).
We are using the new MDAC 2.1 from Microsoft (you need it to get a god
connection from Access to your SQL server), but had the same problem with
the original ODBC driver manager.
I have just tried to greate a new Mapinfo ODBC connection with the MI SQL
server driver and succedded !!!.
The trick of the tale was, to create a SQL server user (we are using
integrated NT security) and use this user to get access to the SQL server.
Ole Gregor
Viborg Amt, Milj� og Teknik
(45) 87 27 13 07
[EMAIL PROTECTED]
> -----Original Message-----
> From: Geografma y Electrsnica. [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 08, 1999 1:53 AM
> To: [EMAIL PROTECTED]
> Subject: MI MapinfoPro and SQL server 7.0
>
> Hi, Mappers.
>
> I need to connect MapInfo Pro 5.0 to SQLserver V7.0, but haven't been able
> to. Below you'll find a description of my current situation.
>
> SITUATION:
> I'm trying to access the SQLserver 7.0 with the Mapinfo's Intersolv ODBC
> driver that ships with MInfoPro 5.0, which is version 3.10; and fails with
> an error in spanish which translates as "[MapInfo Win32 SQL Server 6
> Driver]This driver is version 6 and client software is from a previous
> version. You need to install a client software version 6". In this
> machine, the "client software" for SLQserver client is version 7.00.032.
> (Both NTWDBLIB.DLL and DBMSSOCN.DLL, and both are in \WinNT\System32 dir).
> I have Windows NT at the client workstation, and also winNT at the
> server.
>
> I've found out that I can't use Intersolv (now Merant) standard drivers,
> since they are different from the MapInfo-ready ones. The have released 3
> versions since the 3.10 that comes with MapInfo 5.0. 1) Version 3.11, 2)
> Version 3.50 and 3) Version 3.51. In the Version 3.50 documentation you
> can read "this driver can now connect to SQLserver 6.5 and 7.0". We can
> deduct from this that Version 3.10 can't be connected to SQLserver 7.0.
> According to Merand's tech support, it "may work", but not as a "supported
> configuration".
>
> 3) I can't use the microsoft or standard Intersolv/Merant drivers. I've
> downloaded all ver 3.11, ver 3.50 and ver3.51 drivers from Merant, but
> their drivers are different from the MapInfo ones. (even their names.
> Ivss614.dll vs Miss614.dll). When I try to connect the ver3.50 drivers
> (which are plain Merant, not MapInfo-ready-and-renamed) I get the exact
> same error as when I try to use the standard Microsoft driver (message
> from
> MapInfo Pro, reading "error converting data types", where you have already
> defined which columns, which rows from which table and into which mapinfo
> table you want it, right in step 4 of 4, when Mapinfo is about to download
> the data.
>
> 4) MapInfo Corp has not included the Merand "modified" odbc drivers
> version
> 3.50 in MapInfo pro 5.5, but they tell me that the SQLserver ODBC driver
> will work ok.
>
> QUESTION:
> Have anybody connected MapInfo Pro 5.0 to SQLserver 7.0? Have you found
> this same error? With MapInfo Pro 5.5? With SQLserver 6 or 6.5?
>
> Thanks for your answer.
> ---------------------------------
> Ing. Juan Pufleau Correa
> Geograf�a y Electr�nica, SA de CV
> Aguascalientes, Mexico
> ---------------------------------
> ----------------------------------------------------------------------
> 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]
