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:


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


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

Some idea ??

Archived from group: microsoft>public>dotnet>framework>odbcnet