Re: Witango-Talk: SQL data manager tool

[Rick Sanders]

Hi Marc,   Seems you're have a PSQL problem. I haven't been following this thread all the way through, but this email caught my attention.   Obviously the client isn't connecting to the server. Ensure the following things:   1. The default TCP port is 1583. It seems you've changed that port. Try changing the port back to 1583, and see if it works. 2. In your server configuration settings under Communication protocols, ensure you have Winsock TCP/IP as your ODBC Connection Manager support. 3. "TCP/IP Multihomed" is OFF, unless you've specified a "Listen IP Address" 4. Microsoft TCP/IP is in your list of "Supported Protocols". 5. You should install Service Pack 4.   Rick Sanders Hi Brendt,   Thanks again for the help.   I do not use SPX protocol so I don't know why it gives this error. Server and client use TCP/IP on port 1536. Maybe there's a port conflict? After installing service pack 3(P.SQL 2000i) this is the new message I get:   [Pervasive][ODBC Client Interface][Client LNA]Connection attempt timed out.  The SQL Connection Manager may be inactive or using a different transport protocol from the client.   How would you force the SQL Connection Manager to be active?   If anyone has ever had these problems, please reply!    Thanks! Marc Leblanc   ----- Original Message ----- From: Bengt Bredin To: [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:07 Subject: SV: Witango-Talk: SQL data manager tool Hi Marc ! It�s seems to be a problem with the SPX protocol on the server. Do you need SPX on the Windows server ? If not try to take it away from the communication protocols in the Control Center and restart the service. Not sure what you mean with the �SQL Data manager Tool� is it a Pervasive tool ? I also recommend to update to at least SP3 on the Pervasive.SQL 2000.     Med v�nlig h�lsning/Best regards Bengt Bredin ----------------------------------------------------------------------- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] ----------------------------------------------------------------------- -----Ursprungligt meddelande----- Fr�n: Marc Leblanc [mailto:[EMAIL PROTECTED] Skickat: den 5 november 2003 16:28 Till: [EMAIL PROTECTED] �mne: Re: Witango-Talk: SQL data manager tool   Hi Brengt,   Thanks for the reply, I'm in a really bad situation right now   I get those errors in PVSW.log   10-21-2003 13:22:43 NTMKDE          00000414 NTDBSMGR.EXE    SERVER          I                        Error initializing the SPX protocol. Error code: 6. 10-21-2003 13:38:32 NTBTRV          000003E8 BIN\NTBTRV.EXE" SERVER          E                        NTBTRV.EXE failed to load. RC = 4083. 10-21-2003 13:46:56 NTBTRV          000000F4 BIN\NTBTRV.EXE" SERVER          E                        NTBTRV.EXE failed to load. RC = 6. 10-21-2003 13:50:14 NTMKDE          0000046C NTDBSMGR.EXE    SERVER          I                        Error initializing the SPX protocol. Error code: 6. 11-04-2003 13:41:22 W3MIF10F        0000133C 2\odbcad32.exe" SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:31:22 W3MIF10F        00000D5C SW\Bin\pcc.exe" SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:32:54 W3MIF10F        000016F0 IN\W32MAINT.EXE SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:34:36 W3MIF10F        000016F0 IN\W32MAINT.EXE SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:36:04 W3MIF10F        000016F0 IN\W32MAINT.EXE SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:51:46 W3MIF10F        000016F0 IN\W32MAINT.EXE SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2 11-05-2003 09:52:26 W3MIF10F        000016F0 IN\W32MAINT.EXE SERVER          E               00000225 3020: EstablishSessionWithEngine(). Failed to get to InitData. OS rc=2   Any idea why the "SQL data manager tool" would not be installed.   The 10-21-2003 was the installation date.   Thanks a lot!   Marc Leblanc         ----- Original Message ----- From: Bengt Bredin To: [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 02:19 Subject: SV: Witango-Talk: SQL data manager tool   Hi Marc ! We still use Pervasive.SQL 2000 in many applications. Not for Witango but others. Error 3020 stands for: 3020: An error occurred while loading the MicroKernel You receive this status code when an error occurs while loading the MicroKernel or when access to the server and client machine shared memory objects are unavailable. Check the Pervasive Event Log (PVSW.LOG) for more information. What do you see in the logfile ? Try to use the Maintenance tool on the server and try to open a Pervasive file and see what happens.       Med v�nlig h�lsning/Best regards Bengt Bredin ----------------------------------------------------------------------- LabIT Solutions AB Fagerstagatan 18 A 163 94 Stockholm SWEDEN Tel : +46 8 621 36 32, Fax : +46 8 621 36 38, Mobile : +46 708 213 971 mail : [EMAIL PROTECTED] ----------------------------------------------------------------------- -----Ursprungligt meddelande----- Fr�n: Marc Leblanc [mailto:[EMAIL PROTECTED] Skickat: den 4 november 2003 23:04 Till: [EMAIL PROTECTED] �mne: Witango-Talk: SQL data manager tool     Hi all,   I was wondering if any of you were still using the Pervasive SQL 2000 database. I'm getting this error while doing a test connection in ODBC. [Pervasive][ODBC Engine Interface][Data Record Manager] An error ocurred while loading the MicroKernel(Btrieve Error 3020). Also in the Pervasive control center I cannot use the SQL data manager tool even if I try to add it through the custom tools properties.   Any ideas?   This install was done using Tango2000 Application Server (service pack 1) disc on a windows 2000 server OS.   Thanks!   Marc Leblanc ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf