Problem mit ODBC treiber

[baumina]

Evtl. ist der Provider auf dem anderen Rechner ohne das ".1"

Provider=MSDASQL.1;Password=0000;Persist Security Info=True;User ID=erven;Data Source=Delphi;Initial Catalog=delphi

Zitat:

The Provider Keyword

The Provider keyword identifies the OLE DB provider to be used. To specify your OLE DB provider, set the value of the Provider keyword to the VersionIndependentProgID value of the provider.

Provider=MSDASQL

The value can also be set to the ProgID of the provider, which may have a version attached to it.

Provider=MSDASQL.1

If two versions of a provider are installed on the same system, use the ProgID to specify exactly which version to use. If two versions are installed on a system and the VersionIndependentProgID value is specified, the most recent version of the provider is used.

If no Provider keyword is in the string, the OLE DB Provider for ODBC (MSDASQL) is the default value. This provides backward compatibility with ODBC connection strings. The ODBC connection string in the following example can be passed in, and it will successfully connect.

Quelle : http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx