Re: ODBC
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35162
interpreted = N
texte = It's important to run all of the permutations. Since I know now that you are running Oracle, I can give more specific suggestions.When the WebCat queries fail, use sqlplus from the webserver as well as another machine to connect to the database. If the database is on the same machine as the webserver, check your TNSNAMES entry and see whether you are connecting via TCPIP or BEQUEST, and try the other one. For a remote Oracle database, you only have the choice of TCPIP. You can also try TNSPING80 from the webserver and another machine and make sure that the listener is still, umm, listening. BEQUEST connections do not need to have the listener running, by the way.The Oracle for NT installation should include an executable which they call Oracle ODBC Test. It is a 330k executable that you can copy to any machine you want to use to test ODBC connectivity. It is pretty lame, but it does work acceptably. You can use this to test that the ODBC driver is still functioning (after a fashion). I would try and run the same queries that WebCat is running.Lastly, install all of the Oracle management tools. They are daunting for a new DBA, but they can tell you exactly what is going on inside the database itself.Oh, one more thing, have you tuned your indexes intelligently? Oracle is very picky about indexes; you think you have created a good index and yet Oracle will not use it until you create the appropriate query. For example: select field1, field2, field3 from table1 where field1 > 0 and field2 > '' and field3 > 0 order by field1, field2, field3If you have created an index on field1, field2, field3, the ORDER BY clause will not use the index unless all three fields are used in the WHERE clause. This really makes you crazy the first dozen times you forget it, but it makes for very efficient queries when you understand it. My example contains trivial WHERE criteria on purpose; as long as the field is being tested, the query optimizer will evaluate the indexes for use during the query. If you leave out any of the fields from the WHERE clause, that index will not be used and you are going to do a full table search.Here's an even more neat trick: say you have a lookup table and you only want to return records from the main table that are in the lookup table. select field1, field2 from table1 where exists ( select 1 from table2 where field1=table1.field1) and field2 = 'something'If you have an index on table2 for field1, this is an extremely fast query, similar to the difference between [search] and [lookup].HTHJohn PeacockDaventab - Dave Jones wrote: > > 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 can > not 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 PM > Subject: 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 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/ > > > > ------------------------------------------------------------- > 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:
It's important to run all of the permutations. Since I know now that you are running Oracle, I can give more specific suggestions.When the WebCat queries fail, use sqlplus from the webserver as well as another machine to connect to the database. If the database is on the same machine as the webserver, check your TNSNAMES entry and see whether you are connecting via TCPIP or BEQUEST, and try the other one. For a remote Oracle database, you only have the choice of TCPIP. You can also try TNSPING80 from the webserver and another machine and make sure that the listener is still, umm, listening. BEQUEST connections do not need to have the listener running, by the way.The Oracle for NT installation should include an executable which they call Oracle ODBC Test. It is a 330k executable that you can copy to any machine you want to use to test ODBC connectivity. It is pretty lame, but it does work acceptably. You can use this to test that the ODBC driver is still functioning (after a fashion). I would try and run the same queries that WebCat is running.Lastly, install all of the Oracle management tools. They are daunting for a new DBA, but they can tell you exactly what is going on inside the database itself.Oh, one more thing, have you tuned your indexes intelligently? Oracle is very picky about indexes; you think you have created a good index and yet Oracle will not use it until you create the appropriate query. For example: select field1, field2, field3 from table1 where field1 > 0 and field2 > '' and field3 > 0 order by field1, field2, field3If you have created an index on field1, field2, field3, the ORDER BY clause will not use the index unless all three fields are used in the WHERE clause. This really makes you crazy the first dozen times you forget it, but it makes for very efficient queries when you understand it. My example contains trivial WHERE criteria on purpose; as long as the field is being tested, the query optimizer will evaluate the indexes for use during the query. If you leave out any of the fields from the WHERE clause, that index will not be used and you are going to do a full table search.Here's an even more neat trick: say you have a lookup table and you only want to return records from the main table that are in the lookup table. select field1, field2 from table1 where exists ( select 1 from table2 where field1=table1.field1) and field2 = 'something'If you have an index on table2 for field1, this is an extremely fast query, similar to the difference between [search] and [lookup].HTHJohn PeacockDaventab - Dave Jones wrote: > > 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 can > not 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 PM > Subject: 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 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/ > > > > ------------------------------------------------------------- > 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:
[WebDNA] Needing a new host.... (2013)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
showif and cart (1997)
SKU Question (1999)
form data submission gets truncated (1997)
WebMerchant Error (1998)
Sitebuilder (2004)
Shownext from POST (2000)
Showif probably dumb question (1997)
[WebDNA] PayPal Integration (2017)
emailer (1997)
Shopping carts and reloading pages (1997)
[GROUPS] followup (1997)
Sku numbers (1997)
Migrating to NT (1997)
Webcatalog and CyberSTUD (1998)
all records returned. (1997)
Re2: Calculating multiple shipping... (1997)
DNABill Screen Shots (2003)
Help name our technology! (1997)