Why get “ORA-12560: TNS:Protocol adapter error.” when connect to oracle server?
1. Make sure that Oracle TNSListener is started. 2. Install Oracle Instant Client for ESF Database Migration Toolkit 3. Put the correctly Oracle Service Name/SID in “Database” field.12) Cannot create a row of size XXXXX which is greater than the allowable maximum of 8060. In SQL Server 2000, this error message indicates that you have variable length columns in your table (such as nvarchar or varbinary) and that the total maximum length of all the columns adds up to more than 8060 bytes. You can still insert rows into the table provided that the total length of the data in each row does not exceed 8060 bytes. However, if the data does exceed 8060 bytes, the insertion fails. To resolve this problem: in “Select Tables&Views” Page, click “Transform” button, select “Overwrite Table” option, find out which field’s size is larger that 8060, and change its data type to text or image(for Blob data). Others: In SQL Server 2005 or above supporing row size large than 8060 bytes.
1. Make sure that Oracle TNSListener is started. 2. Install Oracle Instant Client for ESF Database Migration Toolkit 3. Put the correctly Oracle Service Name/SID in “Database” field.13) Cannot create a row of size XXXXX which is greater than the allowable maximum of 8060. In SQL Server 2000, this error message indicates that you have variable length columns in your table (such as nvarchar or varbinary) and that the total maximum length of all the columns adds up to more than 8060 bytes. You can still insert rows into the table provided that the total length of the data in each row does not exceed 8060 bytes. However, if the data does exceed 8060 bytes, the insertion fails. To resolve this problem: in “Select Tables&Views” Page, click “Transform” button, select “Overwrite Table” option, find out which field’s size is larger that 8060, and change its data type to text or image(for Blob data). Others: In SQL Server 2005 or above supporing row size large than 8060 bytes.
1. Make sure that Oracle TNSListener is running. 2. Put the correctly Oracle Service Name/SID in “Database” field.16) Cannot create a row of size XXXXX which is greater than the allowable maximum of 8060. In SQL Server 2000, this error message indicates that you have variable length columns in your table (such as nvarchar or varbinary) and that the total maximum length of all the columns adds up to more than 8060 bytes. You can still insert rows into the table provided that the total length of the data in each row does not exceed 8060 bytes. However, if the data does exceed 8060 bytes, the insertion fails. To resolve this problem: in “Select Tables&Views” Page, click “Transform” button, select “Overwrite Table” option, find out which field’s size is larger that 8060, and change its data type to text or image(for Blob data). Others: In SQL Server 2005 or above supporing row size large than 8060 bytes.
