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:
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:
Close-to Comparison Code (1998)
Exclude by date - multiple (1997)
Store Builder Weirdness (1999)
$flushcache causes crash (2000)
removing programming logic white space (2003)
Problem with empty form-variables in [search] (1998)
Problems with SELECT MULTIPLE (1999)
Secure Server (1999)
OT - quiet on the list today - here's something (2004)
Bug Report, maybe (1997)
Where is the bug fix info for 4.0.1? (2000)
Weird happenings when viewing in IE 3.02 (1998)
Quit revisited (1997)
[OT] Redhat 6.1 (2003)
unable to launch acgi in WebCat (1997)
NT error logs (1997)
[SearchString] problem with [search] context (1997)
minimalist shopping cart. (1997)
about this server and links to who (1997)
Summ=T Problem (1997)