Thanks all. What I found interesting is the following scenario: PC #1 SConnects to ODBDC source HFINC and SAttachs to table UPS_Table with an Alias of UPSODBC
Do a list table on PC# 2 and the UPSODBC table is listed and you can do a select from it. No pop up about what ODBC driver source to use is seen. The table is active and ready. So the SCONNECT must be database wide. PC#1 issues a SDISCONNECT HFINC . PC# 2 can still select data from UPSODBC as well as PC #1. The SDISCONNECT does not seem to have any effect on either PC. So I am unsure what the SDISCONNECT does. PC #1 issues SDETACH UPSODBC and both PC's no longer list the UPSODBC table. SDETACH is definitely not user specific. So my main question was the SCONNECT statement does not seem to be needed at all by other sessions once one session has SATTACHED to the ODBC table and the SDISCONNECT seems to have no effect on either PC. I am asking this in that I have been getting a random access violation error. I have seemed to isolate it to this one program that SCONNECTS and SDISCONNECTS to the ODBC database. Although I have not been able to repeat it at will, I believe it has to do with the SDISCONNECT being issued while another session is still in the database and attached to an ODBC table. Although using 2 PC's, I have not been able to get the SDISCONNECT to seem to make any difference at all on either PC. I believe I will remove any SDISCONNECT statements and see if the problem goes away. -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "Walker, Buddy" <[EMAIL PROTECTED]> Bob Once you SCONNECT and then SATTACH a table anyone using that table must use the same type of SCONNECT. For example if you SCONNECT using a DSN and then SATTACH sometable. If I want to use sometable then I must have the same DSN on my workstation. When I try to use the sometable the SCONNECT is transparent as long as I have the same DSN. If a number of users will be using the same SATTACH table then I dont SDETACH it. Buddy From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, November 17, 2008 12:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - SCONNECT / SDISCONNECT This is something I should already know, but did not find a distinct answer in my first help search. Is Sconnect / SDisconnect session unique or database unique? I.E. 5 users connected to the same database, all five accessing an ODBC table, if one session issues a SDisconnect will this effect the other users? During brief testing, it appears that SCONNECT / SDISCONNECT does not effect other users, however SATTACH or SDETACH does effect other users. If I have a table SATTACHED and issue a SDISCONNECT, the table still functions, it appears the SDISCONNECT has no impact. If I SCONNECT and SATTACH an ODBC table in session one, session two can access this table and never have to SCONNECT. So this seems to indicate that SCONNECT is database specific and not session specific. However, if I issue a DISCONNECT, it does not effect other users at all. I can Disconnect in session one and session two can still access the table fine. So my question is, do I need to worry about SCONNECT or SDISCONNECT in a multi user environment? My initial tests seem to say no.? Certainly SATTACH and SDETACH makes a big difference. Thanks, -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441
