[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Pachu

4/30/2007 6:49:00 PM

Hi, im building a connection string for Odbc data provider, without
DSN because i dont want to create a dsn in each client machine (there
are a lot) the string is complete, but i get this exception below the
text of mail.

I think is a problem with DRIVER=IBM INFORMIX ODBC DRIVER but i dont
understan putting the string via server explorer it connects ok, but
building it comes the error..


Message="ERROR [IM002] [Microsoft][Administrador de controladores
ODBC] No se encuentra el nombre del origen de datos y no se especificó
ningún controlador predeterminado"
Source=""
ErrorCode=-2146232009
StackTrace:
en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode)
en System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, OdbcConnectionString constr, OdbcEnvironmentHandle
environmentHandle)
en
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningObject)
en
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
en
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
en
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
en System.Data.Odbc.OdbcConnection.Open()

in settings:

<connectionStrings>
<add name="OrigenConfiguracionBaseDatos"
providerName="System.Data.Odbc"
connectionString="DRIVER={IBM INFORMIX ODBC
DRIVER};SRVR=desa1db;HOST=proteo;SERV=26000;DB=basurero" />
</connectionStrings>

i try removing brackes with no result, if i use a DSN works fine

Some idea ??