- I can setup a taf to a access db on the Win2k box so I know that tango 3 on the win 2k server is working properly.
- I setup a new db on the Mac and a new tcp/ip dsn to connect to it from the Win2k box and it connects to Butler on the Mac but hangs. If I delete the file source then it gives me the appropriate error. So I know that the control requests made via the Butler WIN32 dsn are working correctly.
- When I request to see the tables of the tcp/ip dsn which is listed in the tango 3 editor on the Win 2k box, I can see the user appear in the Butler Users window on the Mac and see the number increase from 1 to 9 in increments (which is what a DAM dsn does from a user on the Mac itself) so I know that the Butler WIN32 dsn is requesting the data and finding it correctly, but it just doesn't send the data back and tango 3.6 editor on the Win2k box hangs when that happens.
We have run netstat to see what's happening when we make the request, and it shows the win2k box using port 1039 and going to the mac butler port of 8682 correctly, however maybe the data i s coming back on a different port which is being blocked?
So, my summation is that the problem is either
- port mapping
- MTU problem on the Mac (as the mac is running on a ADSL connection)
what do you think it would be?
If I can get this running this will solve a major prob that we are having with some firewalls blocking access to the Mac from outside on the Internet (because it can only be accessed through port 81 for http and port 22 for ftp).
any suggestions are received gratefully.
Garth
below...Yep, that's what I was saying - I try a SQL query from the editor on this datasource (which is definitely a tcp/ip dsn) and I can see it access via port 8682, loads the user in the Butler Users window, and then hangs. When we delete the database from the Public Databases folder, it gives us the appropriate error. So we know that we are definitely taking to Butler on the Mac. But that's about all we know at present.Do you have an T3 Editor on the Windows box? If so, try using the SQL Query window from the editor with the appropriate data source to make a connection. If it can, you should then be able to eliminate the Mac side as the source of the problem.
Yep, seems to be connecting from the Tango editor Ok when I request the data tables to load.You mentioned that you can see the attempt at a connection in the Users window of Butler. It is a TCP/IP port that is set up and not program linking, right?
Maybe that's where the problem is - I'll create an entirely new taf using the Win T3 editor with a tcp/ip dsn and a new database on the Mac and see how that goes.Also where was the original taf file created? I seem to recall problems with taf files that were originally set up with Program Linking rather than TCP/IP after they were moved to a Windows box.
I certainly haven't seen any readme about any limitations on the license apart from the number of concurrent users (which I know to be 10).The Butler version that was on that promo CD did not have any limitations on connections to the best of my knowledge.
yep -using that and that seems to be working (one way anyway - sending control data but maybe not receiving data back to the Win boxOne other thing to look at is whether the appropriate port is opened to the machine running Butler. I think it needs port 8682 and of course this should be set up in both the datasource, and on the port in Butler. Also make sure that the port is activated on Butler.
well I'll set up an access db and test it with a local datasource as well and get back to you.I don't think the references to the old P.SQL drivers would cause this problem. Since Pervasive came into the picture in 98 I have always had both P.SQL and Butler drivers installed on my Win boxes.
Hope this helps,Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.skadt.com-----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com]On Behalf Of Garth Penglase Sent: October 23, 2002 8:16 AM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: T3 tcp/ip db connection (licensing issue?) I don't think so, since it includes demos using PSQL datasources, but I'll have a look at the info on the Tango CD and see if I can find any clues as to whether it is licensed only for access. I have been using the Mac 3.52 promo version only with Butler so I don't know if it has limitations otherwise. The installer seems to make references to other ODBC sources I think. When I use the Windows Tango 3.52 Editor that comes on the CD to open a taf with the Butler tcp/ip link as the datasource, I can see the Butler drivers making a connection with Butler on the Mac but then Butler seems to time out (something times out) because everything just sits there - whatever user account was used to open the taf in> the editor and make the load request is shown in the Butler Users > table and there are connections made, but it hangs from there. We did > test the connection by deleting the datasource and when we requestedit to load the tables it gave an appropriate error (saying that it couldn't connect to the datasource) so the connection from the Win 2k box via Butler tcp/ip on the standard Butler port seems to be working> - I have a feeling that it may be a port mapping problem between thetwo machines since the mac is sitting on the internal network and is reached externally (form the Internet) by mapping incoming requests to port 81 for http and that has presented some problems when ftping to the machine from certains networks - any ideas on how we can test that? I'll make a connection to a local dsn (say an access db) and see how it goes. We did load the PSQL demos but we were having the stanza problem at that time so we un-installed the whole tango installation and re-installed a few times, the last couple of times without the PSQL demos so haven;t tested it with them I don't think. Another point to note is that the uninstaller did not remove the references to the PSQL drivers in the ODBC panel in Win2k - is this, in some way, a possible cause of the problem would you think? It is annoying - we'll re-install them and see if they work and then try to un-install them separately - any tips on that? thanks Steve Garth >Any chance you're using a Tango for Access product? Yes there was a release >of a product that was similar to Tango for Filemaker but for Access and the >windoze platform. I can't remember if it was a 2.x product or 3.x. I used to >have a list of the serial number prefixes which identified the exact version >of the product but I don't know where it is. > >Other things to check is that you've set up a system data source, etc. I >know that the Win Butler driver works under Win2000 because I've used it. > >Will that same version connect to any other data source? > >Hope this helps, > >Steve Smith > >Skadt Information Solutions >Office: (519) 624-4388 >GTA: (416) 606-3885 >Fax: (519) 624-3353 >Cell: (416) 606-3885 >Email: [EMAIL PROTECTED] >Web: http://www.skadt.com > > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:owner-witango-talk@;witango.com]On Behalf Of Garth Penglase >> Sent: October 22, 2002 9:20 PM >> To: Multiple recipients of list witango-talk >> Subject: Witango-Talk: T3 tcp/ip db connection (licensing issue?) >> >> >> >> -- >> Hi everyone, >> this is particularly for those who have been around tango for >> quite a while. >> >> I recently installed Tango 3.52 promo version (10 user version) under >> Win 2k. Originally I was getting stanza probs which we finally were >> able to resolve (by fluke only though the suggestions from historical >> and recent entries on this list were useful). >> >> Now I am trying to connect from the Win2k box using Butler WIN 32 >> drivers to a Mac running Butler but when running the taf which uses >> the tcp/ip DSN I get this message: >> >> An error occurred while processing your request: >> >> Position: Insert >> Class: Internal >> Main Error Number: -109 >> >> This type of data source is not supported by the server license. > > >> Position: Insert >> Class: Internal >> Main Error Number: -4 >> >> Unable to connect to the specified data source. >> Verify that data source is properly configured and that database >> server is online. >> >> I'm sure I remember having connected via tcp/ip from one mac to >> another using the same license (actually the Mac version of the >> software off the same CD) so I think the server license message is >> erroneous. But am I wrong? Is it indeed not possible using this >> license? >> >> thanks >> Garth >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body -- ________________________________________________________________________> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]with unsubscribe witango-talk in the message body________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body-- ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
--
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
