Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
minghai
Starting Member
1 Post |
 Posted - 2010-05-27 : 11:22:26
|
| Hi,I'm trying to import data from SQL Anywhere database to SQL Server 2008. I'm using .NET data provider for SQL Anywhere and .NET data provider for SqlClient. When debugging, the DbConnection.GetSchema( "DataTypes") was called by SQL Server Import and Export Wizard. Our ADO.NET provider supports the same schema data as SqlClient. The query based data transfer works perfectly, but I really don't understand why the 'Copy data from one or more tables or views' radiobutton is alway disabled.Could anyone give me some help?ThanksMinghai |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-05-27 : 11:58:08
|
| That will be to do with the drivers. Are you using 32 or 64 bit?What version of Sybase is sitting behind the SQL Anywhere tools as I know there are some issues with drivers if you are using 64bit SQL Server, you need the Sybase client tools to be at least version 15 (off the top of my head). |
 |
|
|
|
|
|
Can not copy data from one or more tables or views