MSSQL Error related to import of accounts

[nvdp2002]

Operating system type and version Windows 2003 Server
Sugar Suite version Open Version 5.0.0b (Build 3150)
Webserver type and version IIS 6
PHP version 5.2.5
MSSQL server version MSSQL 2005 express

Hi
Thanks in advance for any and all help.
I get the following error when i try to import anything. When ever i click on import i get the following error.

SQL Error : Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.

[DragonflyMaster]

Hi.
When exactly do you get this error? As soon as you click import? Or in one of the subsequent steps?

[nvdp2002]

Hi

As soon as i click on import.

Thanks

[DragonflyMaster]

In one of my Sugar instances I am using your same specs:

Operating system type and version Windows 2003 Server
Sugar Suite version Open Version 5.0.0b (Build 3150)
Webserver type and version IIS 6
PHP version 5.2.5
MSSQL server version MSSQL 2005 express

and it works fine.
I suggest you to take a look at the installation manual (if you haven't done that yet);
in particular, this SQL Error makes me think you need to read this.
Let me know if it works.

[datasponge]

Hi nvdp2002,

SQL Error : Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.

I had similar problems with collation in MySQL - I don't know MSSQL, but I expect they will be very similar.

I was trying to import directly from another database, not using Sugar UI import functions. Collation refers to how the sort order is defined for a character set and language including special characters specific to that language. In my case, I had different collation defined for two tables and I was trying to use an SQL query that selected data from one into another in one query and you can't do that if the two tables have different collations.

This looks a littel different, but it sounds like you are trying to select from a Unicode collated data source directly and the tools don't allow this.

If you are importing directly from a database table, check the defined collation using describe on the server. You can change the collation on a per table basis or if you're not comfortable mucking around that way, you can import in two steps, exporting the data to an intermediate table or text file, then importing separately.

Hope that helps.

Phil

[DragonflyMaster]

If you are importing directly from a database table, check the defined collation using describe on the server. You can change the collation on a per table basis or if you're not comfortable mucking around that way, you can import in two steps, exporting the data to an intermediate table or text file, then importing separately.

Hi datasponge,
I don't think nvdp2002's case is about collation, because he gets that SQL error when clicking import button, that means a few steps before selecting a source to import data from.

[nvdp2002]

Hi Thanks for the help.

Im following the instructions in the link you sent me. Ill let you know what happens soon.

[DragonflyMaster]

Hi Thanks for the help.

Im following the instructions in the link you sent me. Ill let you know what happens soon.

Ok, I'll wait for it

[nvdp2002]

Just a half way update.

I have sugar installed on my own pc as a test. Just to see what would happen, i commented out extension=php_dblib.dll in php.ini and left extension=php_mssql.dll uncommented and Sugar works fine.

Then i commented out extension=php_mssql.dll as discribed in the instructions, and then when i go to the index.php page i get the following message.

Could not connect to server NASSER as nasser

[datasponge]

Hi datasponge,
I don't think nvdp2002's case is about collation, because he gets that SQL error when clicking import button, that means a few steps before selecting a source to import data from.

I see what your trying to fix now. That'll teach me to not click on DragonflyMaster's links

Good luck

Phil