Hello,

I have questions about database connection.

I have created a database with different tables. Ok, no problem.
name : BASE_EXPLOITATION_MTA
user : dba
password : sql

I have made a site with powersite. I have several html pages.
And in this pages i call the database, i make a connection :

I use this syntax :
myconnect = psServer.GetConnection("Compete_Connection");
and
myConn = site.GetConnection ( "Compete_Connection" );

I have defined in powersite a database connections : Compete_Connection
Name : Compete_Connection
Description :
Connection String : DSN=BASE_EXPLOITATION_MTA
Connection Timeout : 15
Command Timeout : 30

In runtine i have :
User Name :
Password :
Cursor Location :
I have written nothing.

What do i write in runtine ? (ans what is the aim of runtime)

for example must i write :
User Name : dba
Password : sql
Cursor Location : server

I have another question :
I have write the connection in sybase central :
Compete_Connection

Connection type : ODBC
Connection name : Compete_Connection
ODBC data source : BASE_EXPLOITATION_MTA
User Id : dba
Password : sql

OK but after a moment when i see in sybase central : there are not
User and password :
User Id :
Password :

I think it is a problem when i call the fonction :

myconnect = psServer.GetConnection("Compete_Connection");

Perhaps must i write user and password in the GetConnection
for example : myconnect =
psServer.GetConnection("Compete_Connection","dba","sql");

but this doesn't work.

What is the good syntax ?

Can you help me ?

Thanks in advance
ALT
IMPULSOR