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:

How to best sort in a pre-defined item-by-item order ... (2003) Troubles with Selection Drop Down List Search (1998) WebCatalog2 for NT Beta Request (1997) Problems passing [SKU] with $Replace in 2.0 (1997) New Guestbook Source (1997) Re:emailer 150 (1997) Ranking search results (2002) truncating email part II (1997) Surprise x and y post args (1998) Re:no [search] with NT (1997) Updating a database once per day - An example (1998) Upgrade to 3.07 problems (2000) Using Plug-In while running 1.6.1 (1997) Running _every_ page through WebCat ? (1997) Webmerch tags? (1998) this works sometimes and sometimes not (1997) I have troubles to send message out (1998) My new discussion forum (2003) WebCat2b15MacPlugin - showing [math] (1997) 4.5 Upgrade (2003)