Re: ODBC

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35153
interpreted = N
texte = What backend database are you connecting to? Have you tried to use the native client to connect to the database from the webserver (to make sure that it is still up)? Have you tried to use an ODBC client (like Access or Oracle's ODBC Test)?There a lots of reasons that ODBC calls would stop working. You need to work backwards from the server to the client app to confirm where it is having a problem:1) can you connect to the database from another client? 2) can you connect to the database from another app on webserver? 3) can you connect using native tools (e.g. sqlplus for Oracle)? 4) can you connect using other ODBC clients? . . .HTHJohn Peacock Daventab - Dave Jones wrote: > > Webcat 3.0, NT 4.0 & > Webcat 3.0, Win 2000. > > About twice a day my SQL commands in webcatalog stop working. In order to > get them to start again I have to restart the server. I can't be sure which > website is causing this because SQL errors are not recorded in the error > log. It seems like the ODBC adapter just stops working all together. Any > page I try to access with SQL connect strings will not work. I am fairly > certain that the problem is not in the code. Have any of you ever > experienced this type of problem before? Any help would be great. > > Thanks, > > Dave. > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  2. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  3. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Terry Nair" 2019)
  4. Re: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (Donovan Brooke 2019)
  5. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  6. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Terry Nair" 2019)
  7. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  8. RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Terry Nair" 2019)
  9. [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  10. Re: MSSQL - ODBC - OSX ( "Nitai @ ComputerOil" 2005)
  11. Re: MSSQL - ODBC - OSX ( Jay Van Vark 2005)
  12. Re: MSSQL - ODBC - OSX ( Alex McCombie 2005)
  13. Re: MSSQL - ODBC - OSX ( "Nitai @ ComputerOil" 2005)
  14. MSSQL - ODBC - OSX ( Alex McCombie 2005)
  15. MSSQL - ODBC - OSX TIGER ( Alex McCombie 2005)
  16. ODBC / Paradox help needed ( Phil 2005)
  17. ODBC integration question ( "Peter J. DiCostanzo Jr." 2005)
  18. ODBC Error: SQL not supported ( Alexander Kulak 2005)
  19. Re: WebDNA+unixODBC+MS SQL ( Jim Lanford 2005)
  20. WebDNA+unixODBC+MS SQL ( Alexander V. Butenko 2005)
  21. ODBC ( Steve Craig 2005)
  22. Re: SQL/ODBC (again) ( Jim Lanford 2004)
  23. SQL/ODBC (again) ( Clint Davis 2004)
  24. ODBC/SQL Connecivity Performance ( "Crist, Trevor" 2004)
  25. Re: ODBC Help ( Larry Hewitt 2004)
  26. Re: ODBC Help ( "Sal" 2004)
  27. ODBC Help ( Larry Hewitt 2004)
  28. can't get WebDNA to display my SQL primary keys via ODBC ( Lucas Rockwell 2003)
  29. Re: [OT] WebDNA and MyODBC (Clint Davis 2003)
  30. Re: [OT] WebDNA and MyODBC (Brian Boegershausen 2003)
  31. [OT] WebDNA and MyODBC (Steve Craig 2003)
  32. ODBC on OS 9 (Patrick J 2003)
  33. Re: SQL, ODBC and MySql (Dale-Lists 2002)
  34. Re: SQL, ODBC and MySql (Le Pham 2002)
  35. SQL, ODBC and MySql (Dale-Lists 2002)
  36. Re: Mac OS X ODBC (Alain Russell 2002)
  37. Re: Mac OS X ODBC (Jay Van Vark 2002)
  38. Mac OS X ODBC (Alain Russell 2002)
  39. WebCatalog 4.5/Solaris and unixODBC (Dirk-Jan Wemmers 2002)
  40. OSX 10.2 ODBC (marc malacarme 2002)
  41. ODBC Problems (Ralph Canapa 2002)
  42. Re: ODBC on OSX continued (Alain Russell 2002)
  43. ODBC on OSX continued (Ben Swihart 2002)
  44. ODBC (Ben Swihart 2002)
  45. WebCatalog Startup and OSX with ODBC (Jason Tyler 2002)
  46. Re: WC + MYSQL + ODBC (Alain Russell 2002)
  47. Re: WC + MYSQL + ODBC (Nitai @ ComputerOil 2002)
  48. WC + MYSQL + ODBC (Eric MULLER 2002)
  49. Oracle ODBC Driver For Mac (Terry Nair 2001)
  50. Re: ODBC and WebCatalog on Solaris and talking to a Sybase database (Donovan Brooke 2001)
  51. ODBC and WebCatalog on Solaris and talking to a Sybase database (dale 2001)
  52. unixODBC and WebCatalog (Simon Buchanan 2001)
  53. Re: ODBC problems between webcatalog and filemaker pro (Marc Frechet 2001)
  54. Re: ODBC problems between webcatalog and filemaker pro (Scott Anderson 2001)
  55. Re: ODBC problems between webcatalog and filemaker pro (Marc Frechet 2001)
  56. Re: ODBC problems between webcatalog and filemaker pro (Scott Anderson 2001)
  57. ODBC problems between webcatalog and filemaker pro (Marc Frechet 2001)
  58. Re: ODBC problems between webcat and filemaker pro (Sam Lewis 2001)
  59. Re: ODBC problems between webcat and filemaker pro (Marc Frechet 2001)
  60. Re: ODBC problems between webcat and filemaker pro (Marc Frechet 2001)
  61. Re: ODBC problems between webcat and filemaker pro (Sam Lewis 2001)
  62. Re: ODBC problems between webcat and filemaker pro (Nitai @ ComputerOil 2001)
  63. ODBC problems between webcat and filemaker pro (Marc Frechet 2001)
  64. unixODBC: WebCatalog patch available for OS X Client/Server (Scott Anderson 2001)
  65. Re: Q: Linux WebCat to ODBC (Rob Blair 2001)
  66. Q: Linux WebCat to ODBC (Jim Lanford 2001)
  67. : fyi: getting ODBC MySQL ready for WebCat (Jim Lanford 2001)
  68. Re: ODBC Performance? (John Peacock 2001)
  69. Re: ODBC Performance? (James Howarth 2001)
  70. Re: ODBC Performance? (Jason Tyler 2001)
  71. Re: ODBC Performance? (Rob Blair 2001)
  72. Re: ODBC Performance? (Jason Tyler 2001)
  73. ODBC Performance? (Rob Blair 2001)
  74. Re: ODBC on Solaris for WebCat. . . (Le Pham 2001)
  75. ODBC on Solaris for WebCat. . . (Rob Blair 2001)
  76. ODBC Control panel for Mac - Where to find? (Dale Therio 2001)
  77. linux WebCatalog ODBC MySQL (Jim Lanford 2001)
  78. Re: ODBC (John Peacock 2000)
  79. Re: ODBC (Daventab - Dave Jones 2000)
  80. ODBC (Daventab - Dave Jones 2000)
  81. Re: ODBC (John Peacock 2000)
  82. Re: Linux ODBC and the ODBC Bridge (Nitai @ Eyework 2000)
  83. Re: Linux ODBC and the ODBC Bridge (Kim Ingram 2000)
  84. Re: Linux ODBC and the ODBC Bridge (Paul Uttermohlen 2000)
  85. Re: Linux ODBC and the ODBC Bridge (John Peacock 2000)
  86. Re: Linux ODBC and the ODBC Bridge (Nicolas Verhaeghe 2000)
  87. Re: Linux ODBC and the ODBC Bridge (Nitai @ Eyework 2000)
  88. Re: Linux ODBC and the ODBC Bridge (John Peacock 2000)
  89. Re: Linux ODBC and the ODBC Bridge (Kim Ingram 2000)
  90. Re: Linux ODBC and the ODBC Bridge (Nicolas Verhaeghe 2000)
  91. Re: Linux ODBC and the ODBC Bridge (John Peacock 2000)
  92. Re: Linux ODBC and the ODBC Bridge (John Peacock 2000)
  93. Re: Linux ODBC and the ODBC Bridge (Nitai @ Eyework 2000)
  94. Re: Linux ODBC and the ODBC Bridge (John Peacock 2000)
  95. Re: Linux ODBC and the ODBC Bridge (Nicolas Verhaeghe 2000)
  96. Re: Linux ODBC and the ODBC Bridge (Kim Ingram 2000)
  97. Linux ODBC and the ODBC Bridge (Nicolas Verhaeghe 2000)
  98. Re: ODBC-Interface (Vince Medina 2000)
  99. Re: ODBC-Interface (Nicolas Verhaeghe 2000)
  100. Re: ODBC-Interface (Vince Medina 2000)
  101. Re: ODBC-Interface (Nicolas Verhaeghe 2000)
  102. ODBC-Interface (Vince Medina 2000)
  103. Re: MacOS 9 => ODBC=> Ms SQL Server 7 (Nicolas Verhaeghe 2000)
  104. Re: MacOS 9 => ODBC=> Ms SQL Server 7 (Aaron Chute 2000)
  105. MacOS 9 => ODBC=> Ms SQL Server 7 (Nicolas Verhaeghe 2000)
  106. Re: WebCatalog + Linux + ODBC + Oracle ! ? (Lorenzo Perone 2000)
  107. Re: WebCatalog + Linux + ODBC + Oracle ! ? (Jay Van Vark 2000)
  108. Re[2]: WebCatalog + Linux + ODBC + Oracle ! ? (jpeacock@univpress.com 2000)
  109. Re: WebCatalog + Linux + ODBC + Oracle ! ? (Micheal O Shea 2000)
  110. Re: WebCatalog + Linux + ODBC + Oracle ! ? (WebDNA Support 2000)
  111. Re: WebCatalog + Linux + ODBC + Oracle ! ? (Micheal O Shea 2000)
  112. Re: WebCatalog + Linux + ODBC + Oracle ! ? (WebDNA Support 2000)
  113. WebCatalog + Linux + ODBC + Oracle ! ? (Lorenzo Perone 2000)
  114. Re[2]: ODBC to WebCat (jpeacock@univpress.com 2000)
  115. Re: ODBC to WebCat (Peter Ostry 2000)
  116. Re: ODBC to WebCat (Mike Davis 2000)
  117. Re: ODBC to WebCat (JHowarth@smithmicro.com 2000)
  118. Re: ODBC to WebCat (Peter Ostry 2000)
  119. Re: ODBC to WebCat (jpeacock@univpress.com 2000)
  120. ODBC to WebCat (Peter Ostry 2000)
  121. Re: [SQL] & ODBC on Mac - Reposted (Stuart Tremain 2000)
  122. Re: [SQL] & ODBC on Mac - Reposted (Stuart Tremain 2000)
  123. Re: [SQL] & ODBC on Mac - Reposted (Mike Davis 2000)
  124. [SQL] & ODBC on Mac - Reposted (Stuart Tremain 2000)
  125. [SQL] & ODBC on Mac (Stuart Tremain 2000)
  126. Re: [OT] ODBC between IIS and remote Access problem (jpeacock@univpress.com 2000)
  127. Re: [OT] ODBC between IIS and remote Access problem (Mike Davis 2000)
  128. [OT] ODBC between IIS and remote Access problem (Nicolas Verhaeghe 2000)
  129. ODBC ( UNIX)
What backend database are you connecting to? Have you tried to use the native client to connect to the database from the webserver (to make sure that it is still up)? Have you tried to use an ODBC client (like Access or Oracle's ODBC Test)?There a lots of reasons that ODBC calls would stop working. You need to work backwards from the server to the client app to confirm where it is having a problem:1) can you connect to the database from another client? 2) can you connect to the database from another app on webserver? 3) can you connect using native tools (e.g. sqlplus for Oracle)? 4) can you connect using other ODBC clients? . . .HTHJohn Peacock Daventab - Dave Jones wrote: > > Webcat 3.0, NT 4.0 & > Webcat 3.0, Win 2000. > > About twice a day my SQL commands in webcatalog stop working. In order to > get them to start again I have to restart the server. I can't be sure which > website is causing this because SQL errors are not recorded in the error > log. It seems like the ODBC adapter just stops working all together. Any > page I try to access with SQL connect strings will not work. I am fairly > certain that the problem is not in the code. Have any of you ever > experienced this type of problem before? Any help would be great. > > Thanks, > > Dave. > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ John Peacock

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebMerchant and PCAuthorize (1998) [TaxableTotal] - not working with AOL and IE (1997) Not really WebCat (1997) Dummy Credit Card Number for debug? (1997) HTML Editors (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Summing fields (1997) Date search bug (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Re:2nd WebCatalog2 Feature Request (1996) attn: smitmicro - cart limitation (2002) Frames and WebCat (1997) Search inside Include (1998) Adding Multiple Items (1999) Closing databases (2003) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Interpret twice? (1997) question: back button prevention (1997) Redirect frame targets (1998) relogin same user? (1998)