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 thenative client to connect to the database from the webserver (to makesure that it is still up)? Have you tried to use an ODBC client (likeAccess 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 itis 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 PeacockDaventab - 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:
What backend database are you connecting to? Have you tried to use thenative client to connect to the database from the webserver (to makesure that it is still up)? Have you tried to use an ODBC client (likeAccess 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 itis 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 PeacockDaventab - 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:
date tag not interpreted (2000)
ConvertChars? (1998)
Still Stumped on ShowNext...HELP! (1997)
Formatting a .txt file (1998)
Major bug report on rootbeer (1997)
Lost and Recovered. (1998)
Searching multiple Databases (1997)
form data submission gets truncated (1997)
WebMerchant 1.6 and SHTML (1997)
Webcat serving error page? (2000)
showif field is number (1997)
DB Size - MAX (2004)
and more [shipcost].... (2001)
Country & Ship-to address & other fields ? (1997)
Help formatting search results w/ table (1997)
Running 2 two WebCatalog.acgi's (1996)
Writing custom WebCat searches?? (2000)
pc (1997)
[ConvertChars] problem (1997)
Error Lob.db records error message not name (1997)