Hi,
I have a problem when trying to use SSMA to migrate from Sybase 12.5
to SQL Server 2005. My problem is that the OLE DB provider, which SSMA
is using, isn't installed correctly. The reason for this is that the C:
\sybase installation directory is simply a copy from some other
server. This works fine for the applications that only need to have
the ctlib dlls in the PATH, but SSMA requires an OLE DB provider data
source to be installed and registered.

I have, by registering the dlls with regsvr32, managed to successfully
run the Sybase ASE OLE DB Administrator and test the connection
successfully. Still SSMA fails to connect with a simple "cannot
connect to data source" message. Any ideas on what I am missing here?
Are there any registry keys etc that are needed?

The full error message in the ssma log is:

[Gui: Error] [4048/4] [2010-04-14 15:23:34]:
LowLevelAdapter.ReadSource : Read Source error:
Microsoft.SSMA.Framework.Sybase.Base.Connection.Es tablishingSybaseConnectionException:
Cannot connect to data source. ---> System.Data.OleDb.OleDbException:
Cannot connect to data source.
at
System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString
constr, OleDbConnection connection)
at
System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at
Microsoft.SSMA.Framework.Sybase.Base.Connection.Sy baseConnectionFactory.Connect(SybaseConnectionPara meters
connectionParameters, SecureString password)
--- End of inner exception stack trace ---
at
Microsoft.SSMA.Framework.Generic.Workspaces.Defaul t.MetabaseWorkspaceItem.Connect(String
connectionParameters, SecureString password)
at
Microsoft.SSMA.GUI.Product.SybaseToMsSql.LowLevel. AppConnectToSourceSybase.ConnectToSourceStart(Obje ct
guiContext)
[Gui: Error] [4048/4] [2010-04-14 15:23:34]: Exception: Cannot connect
to data source.
site: Void Connect(System.String, System.Security.SecureString)
source: Microsoft.SSMA.Framework.Generic.SSMAEnvironment
at
Microsoft.SSMA.Framework.Generic.Workspaces.Defaul t.MetabaseWorkspaceItem.Connect(String
connectionParameters, SecureString password)
at
Microsoft.SSMA.GUI.Product.SybaseToMsSql.LowLevel. AppConnectToSourceSybase.ConnectToSourceStart(Obje ct
guiContext)
[Gui: Error] [4048/4] [2010-04-14 15:23:34]: Inner Exception #1:
Cannot connect to data source.
site: Void .ctor(System.Data.OleDb.OleDbConnectionString,
System.Data.OleDb.OleDbConnection)
source: Sybase ASE OLE DB Provider
error code: -2147467259
at
System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString
constr, OleDbConnection connection)
at
System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at
Microsoft.SSMA.Framework.Sybase.Base.Connection.Sy baseConnectionFactory.Connect(SybaseConnectionPara meters
connectionParameters, SecureString password)

thanks
Magnus