Hey Frank :)
It worked now there is no error but it does not display records
set db [ns_db gethandle]
set sql "select * from MQUser"
set row [ns_db select $db $sql]
while {[ns_db getrow $db $row]} {
set table [ns_set get $row name]
ns_puts $table
}
any idea?
Prakash
-----Original Message-----
From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf
Of Franclim Félix Bento
Sent: Tuesday, April 10, 2001 2:01 PM
To: [EMAIL PROTECTED]
Subject: Re: [AOLSERVER] Connect To SQL Server(NewBie)
Hi,
You need also this section:
#
# Server database pools
#
ns_section "ns/server/${servername}/db"
ns_param Pools *
ns_param DefaultPool "odbc_pool"
I hope this helps...
Frank
-----Original Message-----
From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf
Of Prakash Sinha
Sent: terça-feira, 10 de Abril de 2001 15:27
To: [EMAIL PROTECTED]
Subject: [AOLSERVER] Connect To SQL Server(NewBie)
I have these two files, config.tcl has been modified to accomodate Database
Driver and Pooling
config.tcl
#
# Database Pool
#
ns_section "ns/db/pool/odbc_pool"
ns_param Driver "nsodbc"
ns_param Connections "5"
ns_param Datasource "wireless"
ns_param User "Sprint"
ns_param Password "Sprint"
ns_param LogSQLErrors "on"
ns_param Verbose "on"
ns_section "ns/db/pools"
ns_param odbc_pool "SQL Server Pool"
In this file i use this piece of code and it throws an error
firstAdp.adp
set db [ns_db gethandle] ********************This is where it says is an
error*******************
set sql "select * from tables"
set row [ns_db select $db $sql]
can somebody figure out whats wrong with this piece of code, it throws an
error
command "ns_db" is not enabled
while executing
"ns_db gethandle"
Any idea anybody?
Prakash
Prakash
