How to Migrate Microsoft SQL Server Connections from the OLE DB to the ODBC Provider Type

Back Next

How to create a MS SQL Server connection for Informatica Developer by using the Informatica command line program?

Run the

infacmd isp CreateConnection

command to create a Microsoft SQL Server connection for Informatica Developer.

The

infacmd isp CreateConnection

command uses the following syntax:

<-DomainName|-dn> domain_name
<-UserName|-un> user_name
<-Password|-pd> password
[<-SecurityDomain|-sdn> security_domain]
[<-ResilienceTimeout|-re> timeout_period_in_seconds]
<-ConnectionName|-cn> connection_name
[<-ConnectionId|-cid> connection_id]
<-ConnectionType|-ct> connection_type
[<-ConnectionUserName|-cun> connection_user_name]
[<-ConnectionPassword|-cpd> connection_password]
[<-VendorId|-vid> vendor_id]
[-o options] (name-value pairs separated by space)

Enter the following options to specify the provider type values for a Microsoft SQL Server connection:

Set the value to

ProviderType=0

to use the ODBC provide type. Default is 0.

Set the value to

ProviderType=1

to use the OLE DB provide type.

Set the value to

UseDsn=true

to enable the DSN.

Set the value to

UseDsn=false