Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

psServer.GetConnection

3 posts in General Discussion (old) Last posting was on 2000-02-29 14:29:32.0Z
ALT Posted on 2000-02-25 13:12:27.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 25 Feb 2000 14:12:27 +0100
From: ALT <alt@impulsor.fr>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en,fr
MIME-Version: 1.0
Subject: psServer.GetConnection
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 11
NNTP-Posting-Host: 212.155.127.189
Message-ID: <347_38B67FBB.675BF8B6@impulsor.fr>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27821
Article PK: 159164

hello,

I use this syntax :

"myconnect = psServer.GetConnection("Compete_Connection");

mycommand = myconnect.CreateCommand("SET OPTION quoted_identifier =
'OFF'");
mycommand.Execute();"

and i want to know if after mycommand.execute(); the memory is free. If
the connection is free after.

Perhaps it exists a command "disconnect" ?

Can you help me ?

Thanks in advance
Alexandre LEDET
IMPULSOR


Valentin Class Posted on 2000-02-28 12:30:56.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 28 Feb 2000 08:30:56 -0400
From: Valentin Class <catherinev@edp.ssspr.com>
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: psServer.GetConnection
Content-Type: multipart/alternative; boundary="------------4A6387C106E8C397FD7377C4"
Lines: 42
NNTP-Posting-Host: ppp-196-42-49-248.coqui.net 196.42.49.248
Message-ID: <347_38BA6A80.618ECB52@edp.ssspr.com>
References: <347_38B67FBB.675BF8B6@impulsor.fr>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27679
Article PK: 159044

Hi:
  If you use ODBC connection you need:

  myconnection = psServer.CreateConnection (DSN="YOUR_ODBCNAME", "YOUR_LOGIN", "YOUR_PASSWORD"

Catherine :-)

ALT wrote:

hello,

I use this syntax :

"myconnect = psServer.GetConnection("Compete_Connection");

mycommand = myconnect.CreateCommand("SET OPTION quoted_identifier =
'OFF'");
mycommand.Execute();"

and i want to know if after mycommand.execute(); the memory is free. If
the connection is free after.

Perhaps it exists a command "disconnect" ?

Can you help me ?

Thanks in advance
Alexandre LEDET
IMPULSOR

 


ALT Posted on 2000-02-29 14:29:32.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 29 Feb 2000 15:29:32 +0100
From: ALT <alt@impulsor.fr>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en,fr
MIME-Version: 1.0
Subject: Re: psServer.GetConnection
Content-Type: multipart/alternative; boundary="------------8BF09190CFB953B9F6003ED9"
Lines: 64
NNTP-Posting-Host: 212.155.127.189
Message-ID: <347_38BBD7CB.B6BF2C0C@impulsor.fr>
References: <347_38B67FBB.675BF8B6@impulsor.fr> <347_38BA6A80.618ECB52@edp.ssspr.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27526
Article PK: 158912

hello,

thanks for your answer.

But what is the difference between :
CreateConnection and GetConnection.

and  is the syntax :
myconnection = psServer.GetConnection (DSN="YOUR_ODBCNAME", "YOUR_LOGIN", "YOUR_PASSWORD" good ?

and when the memory become free ?

thanks in advance
ALT
IMPULSOR
 
 

Valentin Class wrote:

 Hi:
  If you use ODBC connection you need:

  myconnection = psServer.CreateConnection (DSN="YOUR_ODBCNAME", "YOUR_LOGIN", "YOUR_PASSWORD"

Catherine :-)

ALT wrote:

hello,

I use this syntax :

"myconnect = psServer.GetConnection("Compete_Connection");

mycommand = myconnect.CreateCommand("SET OPTION quoted_identifier =
'OFF'");
mycommand.Execute();"

and i want to know if after mycommand.execute(); the memory is free. If
the connection is free after.

Perhaps it exists a command "disconnect" ?

Can you help me ?

Thanks in advance
Alexandre LEDET
IMPULSOR