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:
WebCatalog for Mac 2.0.1 Released (1997)
Strange Search Results (2004)
Some Advise needed (1997)
Speed Admin? (Was FlushDatabases) (1997)
[quantity] within formulas (1997)
[WebDNA] Still having problems (2008)
Possible Bug in 2.0b15.acgi (1997)
Extended [ConvertChars] (1997)
RE: formula.db, adding option prices (1997)
test (2003)
browser info.txt and SSL (1997)
%@#*& back button!!! (1999)
Updating fields from different platforms (1998)
Transfering [text] variables (2000)
Re:HTTP header line is too long? (1997)
Whats up with emailer? (1998)
Error 11 (1996)
Checkbox question (1997)
Major OT shopping cart test request. (2002)
Major Security Hole (1998)