Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: dias7777 on January 25, 2007, 10:22:11 AM

Title: Genesys Agent Scripting ?
Post by: dias7777 on January 25, 2007, 10:22:11 AM

Hi all.

I am developing the GAS using tomcat. (jsp). In order to connect to database(SQL server 2000) to suspend scripts i go to configuration tab into target environment properties and i set the G_SYSTEM_DB_CONNECTION_STRING to
jdbc:microsoft:sqlserver://myserver:1433;DatabaseName=myDatabase;User=myuser;Password=mypassword

I see that in the database that the table GASScriptInstances it is updated when i suspend scripts. The strange thing is that when i want
to connect to a sql server through a page i create a database connection with database type sqlserver, developementconnection:(DSN=myserver;UID=myuser;PWD=mypassword) provider static and com.microsoft.jdbc.sqlserver.SQLServerDriver
and runtme connection static and jdbc:microsoft:sqlserver://myserver:1433;DatabaseName=myDatabase;User=myuser;Password=mypassword. When i do this and then i create a new database interface with the connection that i specified and query type select when i try to add table the following message appears. cannot connect to database
Anyone had similar problems?
Thanks in advance.