[sqr-users] Remote connection

["Vicki Nygren" <Vicki.Nygren@post.ca.gov>]

Does anyone know how to create a connection from within a PowerBuilder 
application to a remote SQR server (version 8.1) on SQLServer 2000.  The 
PowerBuilder application is on the client pc and SQR is on the remote server.  
We need to be able to run SQR programs which can also be viewed from the 
client's pc.  

We are trying to upgrade from SQR 4.x to SQR 8.1 and also SQLServer 6.5 to 
SQLServer 2000 .  We were able to connect to 6.5 using the following code in 
PowerBuilder:

// Set up the connection to the server-side object
sqrconnect = create connection  
sqrconnect.driver = "winsock"
sqrconnect.application = "10099"  
sqrconnect.location = "xxx.xxx.xx.x"  
ll_rc = sqrconnect.ConnectToServer()  
IF ll_rc <> 0 THEN      
   MessageBox("Server-side Connection failed", ll_rc) 
end if


Any information will be appreciated.  Thanks.




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users