Re: ODBC
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35158
interpreted = N
texte = I am connecting to Oracle 8i.I haven't tried connecting with the oracle client tools yet while it's down.But I will be sure to the next time it happens. To answer number 2, no I cannot connect to the database with any other WEBCATALOG app.Thanks,Dave.----- Original Message -----From: John Peacock
To: WebCatalog Talk Sent: Tuesday, July 25, 2000 1:01 PMSubject: Re: ODBC> 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?> .> .> .>> HTH>> John 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 orderto> > get them to start again I have to restart the server. I can't be surewhich> > 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/>-------------------------------------------------------------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:
I am connecting to Oracle 8i.I haven't tried connecting with the oracle client tools yet while it's down.But I will be sure to the next time it happens. To answer number 2, no I cannot connect to the database with any other WEBCATALOG app.Thanks,Dave.----- Original Message -----From: John Peacock To: WebCatalog Talk Sent: Tuesday, July 25, 2000 1:01 PMSubject: Re: ODBC> 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?> .> .> .>> HTH>> John 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 orderto> > get them to start again I have to restart the server. I can't be surewhich> > 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/>-------------------------------------------------------------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/
Daventab - Dave Jones
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:
Multiple Users.db Possible? (1997)
Using Currencies other than Dollars (1997)
[search] & [encrypt]/[decrypt] (2001)
[CART] (1997)
4.0.2b5 not finding databases under load (2000)
Pithy questions on webcommerce & siteedit (1997)
Best way to add data to .db (1999)
Where is f2? (1997)
Headers displaying (2000)
Shell traceroute (2001)
WebCat2: Formulas.db question (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Carriage Returns on mail receipt (2002)
A helpful tip to avoid pulling an Aaron OT (2000)
Authorize.Net down 2 days in row (2004)
Merging databases (1997)
Listserver problem (1997)
product differences (1999)
little help (2001)
[WebDNA] Variable mystery (2009)