Re: SQLConnect to Oracle database

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59375
interpreted = N
texte = As the docs say: > Currently, the new WebDNA SQL contexts support the mySQL RDBMS with > support for MS SQL Server and Oracle planned for future releases. So you can only use the nifty new SQL tools for MySQL until SMSI follows through with their promise to support MS SQL and Oracle. You should be able to use the old ODBC-based SQL context, though it takes a bit more effort than the new tools. - brian On Sep 15, 2004, at 4:02 AM, edwin@hoevers.com wrote: > Hello, > > I try to connect a Oracle database with SQLconnect: > > [SQLConnect > dbType=ORACLE&host=hostname&uid=username&pwd=password&conn_var=conn1] > [/SQLConnect] > SQLinfo reports:
> [SQLInfo conn_ref=conn1] > Host: [SQL_HOST]
> Server type: [SQL_SERVERTYPE]
> Server version: [SQL_SERVERVER]
> Client version: [SQL_CLIENTVER]
> Database name: [SQL_DBNAME]
> [/SQLInfo] > > We have got the following error: > ERROR: ORACLE DATABASE CONNECTION FAILED! - (NO IMPLEMENTATION ERROR > STRING > PROVIDED) SQLinfo reports: > ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1". > - Subsequent SQL commands attempting to use that result ID will fail. > > How do i connect to oracle database on a other computer. > We use WebDNA 6, on a Windows 200 advanced server > > Thxs. ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQLConnect to Oracle database ( Brian Fries 2004)
  2. SQLConnect to Oracle database ( edwin@hoevers.com 2004)
As the docs say: > Currently, the new WebDNA SQL contexts support the mySQL RDBMS with > support for MS SQL Server and Oracle planned for future releases. So you can only use the nifty new SQL tools for MySQL until SMSI follows through with their promise to support MS SQL and Oracle. You should be able to use the old ODBC-based SQL context, though it takes a bit more effort than the new tools. - brian On Sep 15, 2004, at 4:02 AM, edwin@hoevers.com wrote: > Hello, > > I try to connect a Oracle database with SQLconnect: > > [SQLConnect > dbType=ORACLE&host=hostname&uid=username&pwd=password&conn_var=conn1] > [/SQLConnect] > SQLinfo reports:
> [SQLInfo conn_ref=conn1] > Host: [SQL_HOST]
> Server type: [SQL_SERVERTYPE]
> Server version: [SQL_SERVERVER]
> Client version: [SQL_CLIENTVER]
> Database name: [SQL_DBNAME]
> [/SQLInfo] > > We have got the following error: > ERROR: ORACLE DATABASE CONNECTION FAILED! - (NO IMPLEMENTATION ERROR > STRING > PROVIDED) SQLinfo reports: > ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1". > - Subsequent SQL commands attempting to use that result ID will fail. > > How do i connect to oracle database on a other computer. > We use WebDNA 6, on a Windows 200 advanced server > > Thxs. ------------------------------------------------------------- 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://webdna.smithmicro.com/ Brian Fries

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:

japanese characters (1997) Grepping URL-Encoded Text (2004) changing creator codes (2000) back button problem (1999) New Lawsuit Alleges Unitedhealth/Pacificare Deceived (2006) lazy programming (2000) Environment Variables (2000) notification solutions (1997) Emailer kaput? (2000) [WebDNA] Apache configuration fail when... (2013) PCS Frames (1997) Shell Script needed (2003) RedHat Linux glibc version 2.1.2 or higher required (2000) WebDNA 5.1 and Mac OS X Server v10.3 - Working ??? (2003) [WebDNA] Quick grep question (2009) Huge databases and RAM (1998) Webcatalog 2.1* and Personal Web Server 4.0 (1998) Passing Cart variable to subdirectory files? (1997) Re:Emailer and encryption (1997) Opinion: [input] should be called [output] ... (1997)