Differences Between Vg 6 And Vg7

[invoso.com]

I started script designed in vg6 under vg7. In VG7 database query failed. this same query in vg6 worked good.

 

VG7 log:

 

130917.562 6 1 1 rv replace end: [sELECT id_proj, status FROM projekty WHERE id_infolinii=(SELECT id FROM infolinie WHERE ddi='878')]

130917.562 6 1 1 db strDatabaseName=[manager_vg7] strDbConnectString=[ODBC; Server=192.168.0.120;Database=manager5;UID=postgres;PWD=database_password;] sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.OracleClient|System.Data.SqlClient|VistaDB.NET20|]

130917.562 6 1 1 db using ado.net ODBC data provider : OdbcConnection/OdbcCommand/etc

130917.562 6 1 1 t timer set 30 sec : EV_TIMEOUT_HANGUP

130917.562 6 1 1 timer set completed lTimeLeft250msUnits=120, iTimeoutCode=9001

130917.562 6 1 1 db odbc RunQuery_Odbc [id_proj], db=[manager_vg7], connect=[ Server=192.168.0.120;Database=manager5;UID=postgres;PWD=database_password;], sql=[sELECT id_proj, status FROM projekty WHERE id_infolinii=(SELECT id FROM infolinie WHERE ddi='878')]

130917.562 6 1 1 db odbc thread init (threadpool)

130917.562 4 1 1 db odbc connection create call.

130917.562 4 1 1 db odbc connection open call.

130917.562 4 1 1 ERROR v7.1.3840.33895 (2010-07-07 17:49:50.44) ConnectAndRun_Odbc init : ERROR [iM002] [Microsoft][MenedĹĽer sterownikĂłw ODBC] Can't fing database source ‚or data,or no default driver

 

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)

at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.Odbc.OdbcConnection.Open()

at ..()

130917.562 4 1 1 oVgmDbQuery_AdoNetCommon_Completed SqlQueryType=ERROR, RowsCount=0, sRv=

130917.562 4 1 1 oVgmDbQuery_AdoNetCommon_Completed strError=ERROR [iM002] [Microsoft][Menedżer sterowników ODBC] Nie można odnaleźć nazwy źródła danych, a nie ma podanego sterownika domyślnego

130917.562 4 1 1 path {ERROR [iM002] [Microsoft][Menedżer sterowników ODBC] Nie można odnaleźć nazwy źródła danych, a nie ma podanego sterownika domyślnego} not found

130917.562 4 1 1 path {ERROR} not found

130917.562 4 1 1 path {error} not found

130917.562 4 1 1 FindNextVgmTitleInPathList: next module title is=[Play 1]

 

This query working in VG6:

SELECT id_proj, status FROM projekty WHERE id_infolinii=(SELECT id FROM infolinie WHERE ddi='878')

[SupportTeam]

The error shown in trace file is:

 

"Can't fing database source ‚or data,or no default driver"

 

Is the ODBC data source source "manager_vg7" defined on this system?

 

You are defining the ODBC data source as well as providing the connect string. If the ODBC data source is defined then there is no need to specify the connect string in the script as well.

 

If the ODBC data source is not defined then another approach is to use the ADO.NET data driver. Just specify the ADO.NET data driver name which is required to access your database (the ADO.NET data driver for your Database must be installed on your system), and then use the Connect string in the format that is expected by the ADO.NET data driver.