Sherry,
Not quite the same problem but I have had difficulties with "more than one
user per machine" with a SpatialWare/Oracle Application using a VB
IntMapping Approach. Each time my program opened a table from the Oracle SID
it clocked up another licence (we currently have only 10 spatialware client
licences, so it quickly proves to be a major hassle) to get round some of
the problems, I coded a MapBasic application (rather than coding within the
VB app) with the connection strings and a server disconnect command, within
VB I just used:-
mapinfo.do "run application ""C:\mapinfo\Program.mbx"""
With the Mbx containing the following:-
Declare sub MAIN
Sub Main
dim conNum as integer
If ConNum = 0 then
ConNum = server_connect ("qelib","DSN=CONNECTION")
End If
server conNum link table
"select * from TABLE1"
into Table1
server conNum link table
"select * from TABLE2"
into Table2
Server ConNum Disconnect
end sub
I don't know whether this will aid any problems with your SQL Server
connection, but it has reduced some of the licensing problems with our
SpatialWare project.
If anyone has any other suggestions or experiences I'd be most interested.
Thanks
Tim Chinchen (IT Services)
mailto:[EMAIL PROTECTED]
> -----Original Message-----
> From: Sherry Xiao [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 03, 1999 1:49 PM
> To: MapInfo Co.; MapInfo Users Group
> Subject: MI Server connect
>
> Hi, there:
> I have an application made by VB integrated with MapInfo/MapBasic. I
> used two connection strings. One is for connecting VB to SQL Server and
> another connecting MapInfo to SQL Server using different DSNs. My
> application works well by itself. But there is an error message appear
> when it works with other applications together. The error is about the
> number of users. It seems that my application occupies more than one
> users and other application cannot connect to SQL Server again.
> I used Server_Connect() function to communicate with the server. I
> wonder whether there is any configuration in code to specify the user
> numbers. Any suggestions are very appreciated.
>
>
> Sherry Xiao
>
> ----------------------------------------------------------------------
> 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]
