>>>I have been successful in connecting to a Watcom data base, using the Sybase 32 bit driver in the view wizard form.
>>>I am able to see all of the tables, fields, etc. I can even preview the query. But that's it!
>>>
>>>When I try to save the connection, or the view or even try to cancel and leave the view designer, my machine locks up.
>>>By lockup I mean, that the hourglass appears as if it is saving something, but it doesn't go away.. (I even left it up for 2 hours, while I had a meeting to go to.)
>>>
>>>Any ideas, what is going on?
>>>I have only used the wizars to make these connections or views.
>>>
>>>Any help would be appreciated,
>>>
>>>Mike
>>
>>Hello Mike,
>>
>>I currently use SYBASE ANYWHERE 5.5 (test download from the SYBASE site). This works fine for me on a local install (server+client on W95).
>>
>>From what you say i understand you use a previous version 3 or 4 still with "watcom brand" (a product that i also used in the past).
>>
>>Concerning this marvelous product (i stick to "marvelous"!)i would suggest you do as i did :
>>
>>- upgrade to 5.5 version (with 32 driver of course)
>>- use VFP 5.0 (if you don't)
>>
>>I made extensive tests of the previous versions and always had difficulties.
>>
>>NB:
>>VERY IMPORTANT! make sure that when you configure the database (DBINIT), you use SQL SERVER COMPATIBLE STRING MANAGEMENT (i don't really remember the title of that option in the SYBASE ANYWHERE database creation wizard .. you will find it).
>>


>>If you don't your ODBC driver will not be able to manage string key fields in your remote views. It took me days to figure that out.
>>
>>Once this is set up correctly, the product is very easy and really shines (OLE and memo field management thru LONG varchar and binary type is so cool) !
>>
>>Do not hesitate to keep me informed if you have other difficulties.
>
>I am interested in any kind of knowledge, written or otherwise, that will enlighten me into the world of ODBC. A lot of what you said above is not totally clear.
>
>Anyways, I am not able to write to the data base (that would be a no-no) but I do need to read from it.
>
>Upgrade to VFP 5, I will try it, but was refusded when product was released... (politics)
>
>It is extremely frustrating when you have the tool available and you are not allowed to use it.
>
>Mike

Sorry not to be able to help you more with this. I just can tell you that the VFP and FOX are a good combination for small to mid-size DB. MS and SYBASE are alas in a very intense competition. I found not a piece of document and support on this duo ANYWHERE.

It also looks as is nobody except the 2 of us use that smart CANADIAN product on VFP-UT. I stick to the fact that it combines with Fox pretty well.. get a VFP 5 and DB upgrade , it's worth it.

François