Re: [WebDNA] PROBLEM WITH [SQL]

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104281
interpreted = N
texte = This was for Arturo: >=20 > We are trying to connect to an orace database using [sql] I have = tested the > odbc connection on the server where WebDna is installed and it = connects. > Searching this on the old list shows this error message but no way to = fix. > Other than one instance of Smith Micro requesting a call to the direct > number. > Does anyone have any experience setting this up? >=20 >=20 > Thanks >=20 > Here is the error: >=20 > SQL Error: 00000 >=20 >=20 >=20 >=20 > Here is the code: > [SQL = dsn=3Dmydsn&username=3Dmyusername&password=3Dmypassword&statement=3DSELECT= * > from CSS.SEC] > Found [numfound] items > [founditems] > [sec_code] > [/founditems] > [/SQL] >=20 >=20 > Art. Vargas On Dec 30, 2009, at 15:14, Alex McCombie wrote: > We have our DNA search MSSQL under windoze via odbc. >=20 > No issues. (well nothing worth mentioning). >=20 > What error are you getting? > All zeros? >=20 > Sorry.. Have been away from the list for a while. >=20 > Alex >=20 >=20 >=20 >=20 > On 12/23/09 3:47 PM, "christophe.billiottet@webdna.us" > wrote: >=20 >> Is there anybody using WebDNA with ODBC under Windows OS? >>=20 >> - chris >=20 > --=20 > Alex J. McCombie=20 >> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . >> Adventure Skies Interactive >> 479 County Route 35 Fulton, NY 13069 >> p. 315 .233 .9403 >> e. Alex@AdventureSkies.com >> www.AdventureSkies.com >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] PROBLEM WITH [SQL] ("Arturo Vargas" 2009)
  2. Re: [WebDNA] PROBLEM WITH [SQL] (christophe.billiottet@webdna.us 2009)
  3. Re: [WebDNA] PROBLEM WITH [SQL] (Alex McCombie 2009)
  4. Re: [WebDNA] PROBLEM WITH [SQL] (christophe.billiottet@webdna.us 2009)
  5. [WebDNA] PROBLEM WITH [SQL] ("Arturo Vargas" 2009)
This was for Arturo: >=20 > We are trying to connect to an orace database using [SQL] I have = tested the > ODBC connection on the server where WebDna is installed and it = connects. > Searching this on the old list shows this error message but no way to = fix. > Other than one instance of Smith Micro requesting a call to the direct > number. > Does anyone have any experience setting this up? >=20 >=20 > Thanks >=20 > Here is the error: >=20 > SQL Error: 00000 >=20 >=20 >=20 >=20 > Here is the code: > [SQL = dsn=3Dmydsn&username=3Dmyusername&password=3Dmypassword&statement=3DSELECT= * > from CSS.SEC] > Found [numfound] items > [founditems] > [sec_code] > [/founditems] > [/SQL] >=20 >=20 > Art. Vargas On Dec 30, 2009, at 15:14, Alex McCombie wrote: > We have our DNA search MSSQL under windoze via ODBC. >=20 > No issues. (well nothing worth mentioning). >=20 > What error are you getting? > All zeros? >=20 > Sorry.. Have been away from the list for a while. >=20 > Alex >=20 >=20 >=20 >=20 > On 12/23/09 3:47 PM, "christophe.billiottet@webdna.us" > wrote: >=20 >> Is there anybody using WebDNA with ODBC under Windows OS? >>=20 >> - chris >=20 > --=20 > Alex J. McCombie=20 >> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . >> Adventure Skies Interactive >> 479 County Route 35 Fulton, NY 13069 >> p. 315 .233 .9403 >> e. Alex@AdventureSkies.com >> www.AdventureSkies.com >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 christophe.billiottet@webdna.us

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:

Location of Webcat site in folder hierarchy (1997) Enhancement Request for WebCatalog-NT (1996) Show shoppingcart after remove last item (1997) Searching multiple fields (1997) Search Engine questions ... (2002) different show next (1997) RE: Multiple Stores and WebCatalog Prefs (1997) Country & Ship-to address & other fields ? (1997) Looking up two prices in Formulas.db (1997) WebMerchant 1.6 and SHTML (1997) embedded showif statements (2000) New syntax feedback for 4.0 (2000) Orders coming up blank (2004) Clean Code: Rules for inserting keyboard returns? (1997) [SHOWIF]s and empty arguments (1997) dates and hex formatting (1997) Re:Navigator 4.01 (1997) RE: creating writefile data from a nested search (1997) WC hosting services required (1998) Error Log.db --however (1997)