External Db Connection To Ms Sql 2005

[iTime]

Dear Support,

 

I have been using outdial function to MS SQL 2005 O.K. so far. But now I need to change the connection to a server outside of network, using IP address, but all I get is the following error.

140219.936  5   0 ERROR v7.0.3188.36826 (Tue 23/09/2008 19:27:33.09) Db_CreateTables_ExecuteNonQuery : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

  at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
  at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
  at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  at ..(DbConnection conn, String sProviderInvariantName)

 

The following is the config setting in config.xml file for the connection:

<OutDialQue_ADODB_Provider>System.Data.SqlClient</OutDialQue_ADODB_Provider>
<OutDialQue_Database>DemoDB</OutDialQue_Database>
<OutDialQue_ConnectString>Data Source=xxx.x.xx.xxx,1433;Initial Catalog =$DATABASE; UserID=IVRUser; Password=xxxx;</OutDialQue_ConnectString>
<OutDialQue_SqlPrefix></OutDialQue_SqlPrefix>
<OutDialQue_SqlSuffix></OutDialQue_SqlSuffix>

 

I don't know why this does not work. I simplay changed the database name and Data Source.

I also attach the log file.

Please help me.

 

Thanks!

 

0402_1402_vgEngine.zip

[SupportTeam]

Have you created the new database on the SQL Server? The Database itself needs to be created and you need to give permissions for the user that you specify in the connect string to do all the alters/updates/inserts etc for this database. Then VG will connect to the database and create the required tables and start using them.

 

If your problem is with IP connectivity here is recent thread on MS board that covers debugging IP connectivity to SQL Server: http://www.microsoft.com/communities/newsg...p;sloc=&p=1

 

[SupportTeam]

In your connect sting:

 

Data Source=xxx.x.xx.xxx,1433;Initial Catalog =$DATABASE; UserID=IVRUser; Password=xxxx;

 

change:

 

UserID

 

to

 

User ID

 

there needs to be a space between the User and ID.

 

vgEngine trace shows:

 

140219.905 5 0 Db_Open conn.Open : Keyword not supported: 'userid'.

[iTime]

That worked.

Thanks!