No, it doesn't have anything to do with the ODBC drivers on the Mac running Butler. Sorry about not continuing with this thread but I got busy elsewhere.
Garth do you want to take this offline and work this problem through? Perhaps if you sent me screen shots of the configuration of your Butler application, how the data source is set up, etc. I could compare it to how mine is set up to hopefully spot a difference. Please let me know. Thanks, 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 30, 2002 9:05 PM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: T3 tcp/ip db connection (licensing issue?) > > > I have had a t3 installation running very stably on 7.6.1 for the > past 4 or so years and haven't upgraded OS on that machine (doidn't > want to upset the apple cart). > > Where did you experience problems initially when you were setting up > the connection - it is pretty straight forward, so maybe there's > something missing in your setup. > > If you are using the Visigenic ODBC drivers that come with t3 > promo CD then: > 1. Install the TCP/IP link port in Butler > 2. Create a tcp/ip dsn on your app server box (ie wither through the > ODBC Control panel - not the ODBC PPC Control Panel which doesn't > work with the Visigenic drivers, or using t3 editor which is the > method I prefer) > 3. Create a taf and reference the appropriate dsn - it should load > the tables (this is where I'm getting stuck on my win2k box) > > As described in these posts I have recently tested it on 9.2.2 on a > G3 Powerbook (testing a Win to Mac tcp/ip connection - more on that > below) I didn't have any probs with Butler hanging when I was > accessing it though Tango 3 editor on the win box hung every time I > attempted this. > > I haven't recently tried a tcp/ip from one mac to another but I could > and will. I'll access my OS 7.6.1 server via tcp/ip from this Mac and > see how it goes and report to you if you'd like. > > I am still tying to figure out where my problem is with my win2k box > since everytime I try to load the tables to add them to a taf on the > win box, the request via tcp/ip goes through to the 7.6.1 box and > Butler begins loading the tables, but either doesn't fincish the > process, or can't send the data back. Either way, though, Butler > doesn't hang, it is still processing other (local) requests at the > same time. > > If you have any insight into my prob I'd appreciate it - if you have > a win2k box I'd love to hear from you if you could set up t3 on that > (from the Promo CD) and test the tcp/ip out and see if it works. > > I have a question? When a Mac or Win box sends a tcp/ip request to > Butler, it has nothing to do with the ODBC drivers on the Butler box > does it? I wouldn't have thought so but I just want to know for sure > so I can rule that out of my testing. > > cheers > Garth > > > >This thread got me curious, so I got out my old Tango 3.52 promotional CD > >and installed Butler 2.52. My thinking was that while we'll be staying > >with MacOS9 for another year, I might as well start preparing for > >migration from Filemaker to a RDBMS. > > > >So I got it running locally on my development machine (PowerMac G3/ > >MacOS9.2.2) -- no problems. But the first migration step is a separate > >DB server (currently Filemaker Pro 4 and Tango run on the samemachine, so > >I loaded ButlerSQL on a similar PMacG3/9.2.2 system, and after many > >frustrating attempts, finally got connected from my development machine, > >both in the Tango editor and via the Butler client. > > > >But what really perplexes me is the instability of Butler. It hangs > >whenever any background process runs. And when it hangs, it is really > >difficult to start (several power cycles required with Preferences > >trashing required). > > > >I'm hoping that if I turn off enough extensions I'll get this working. > >The system in question is pretty vanilla, but I could put MacOS 8.6 on a > >partition if that works. Anyone remember any tricks or conflicts with > >Butler? > > > >Thanks. > > > > > >>I now know the following about this situation: > >>- 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... > >>> > >>>>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, 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. > >>> > >>>>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? > >>> > >>>Yep, seems to be connecting from the Tango editor Ok when I request > >>>the data tables to load. > >>> > >>>> 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. > >>> > >>>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. > >>> > >>>>The > >>>>Butler version that was on that promo CD did not have any > limitations on > >>>>connections to the best of my knowledge. > >>> > >>>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). > >>> > >>>>One 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. > >>> > >>>yep -using that and that seems to be working (one way anyway - > >>>sending control data but maybe not receiving data back to the Win box > >>> > >>>>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. > >>> > >>>well I'll set up an access db and test it with a local datasource as > >>>well and get back to you. > >>> > >>>>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 requested > >>>>> it 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 the > >>>>> two 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 > >> > > > > > >Bill Conlon > > > >To the Point > >345 California Avenue Suite 2 > >Palo Alto, CA 94306 > > > >office: 650.327.2175 > >fax: 650.329.8335 > >mobile: 650.906.9929 > >e-mail: mailto:bill@;tothept.com > >web: http://www.tothept.com > > > > > >________________________________________________________________________ > >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
