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:

Nested tags count question (1997) question: back button prevention (1997) Paths, relative paths, webstar server setup and security (Mac) (1997) Updating checkboxes made easy !!! (1998) Quit revisited (1997) Strange intermittent WebDNA problems Workaround (2008) unable to launch acgi in WebCat (1997) Beta Documentation (1997) encryption madness (2003) Associative lookup style? + bit more (1997) [WebDNA] trigger won't follow path? maybe (2009) Great product and great job ! (1997) Moment of Thanks (1997) RE: New WebCatalog Version !!! (1997) suffix mapping, use of cache, etc. (1997) passing search criteria (1997) [OT] Form POSTing with LONG variable (2007) Multiple Attachments with Sendmail [SOLVED] (2004) [WebDNA] WebDNA on LiveCD ... (2008) Problem with updating 2.1b7 -> 2.1.1 (1998)