[Henry Vuong]

Your are right that SQL Server 2008 supports CLR, but it only supports version 2.0 CLR, which runs on .NET 2.0, 3.0, and 3.5. Since SixBit is running on .NET 4.5, I want to use SQL Server 2014, which support CLR 4, which in turn runs on .NET 4 and later.

The upgrade is successful now I am able to use SQL Server 2014. Thanks

[Henry Vuong]

I got this answer from the developers:

Since SQL was installed manually, there’s an additional step to allow the SixBit Agent to be able to access the database.

Since the SixBit Agent runs as the SYSTEM user, the ‘NT AUTHORITY\SYSTEM’ needs to be added to the sysadmin role. You can run the following query in SSMS to do this:

ALTER SERVER ROLE sysadmin ADD MEMBER [NT AUTHORITY\SYSTEM]

I run the query and it works. Everything looks OK now. I’ll keep posting here if there’s any problem.

Clark Frazier wrote:
Can you be more specific regarding the functions?

It’s a CLR user-defined functions that uses some regular expression. Since MSSQL does not support regular expression, I must use this function written in C# to employ it. CLR is only supported by MSSQL 2012 or later, that’s why I need to upgrade.

[Henry Vuong]

I am able to restore my database to previous condition but I am stuck with SQL Server 2008. I want to upgrade to 2014 because I am writing a program that queries some data from SixBit database. This program needs SQL Server 2014 because some functions do not work with version 2008. Has anyone here been successfully upgraded from previous SQL Server version to 2014?

[Henry Vuong]

I ran the upgrade again and changed the database compatibility level to 120 but nothing improved. I had to reverse the process one more time.

[Henry Vuong]

I am using Enterprise Duo to list on eBay and Amazon. Even though I have no problem paying $99.99 per month, I must say that the pricing is not reasonable. The Enterprise version should include both eBay and Amazon accounts. For people who only sells on Amazon, the only option now is Enterprise Duo, that’s a high bar for those who never tried SixBit before. If I were an Amazon who never tried SB, I would be hesitating. I guess most people who use SB for Amazon are already an eBay seller.

A more rational approach would be like this:

Home & Hobby ($19.99): eBay only
Small Business ($34.99): one site (eBay or Amazon)
Enterprise ($69.99): eBay and Amazon

With the coming of Etsy integration, SB can add more option to each version and use the highest price tier ($99.99) for all three sites.

(Been on eBay for 16 years and used this software in the days when it was still called Blackthorne.)

[Henry Vuong]

I see. Now I have other questions:

1) Let’s say I set the qty listed at 5. When my inventory is above, the eBay listing will display “5 available”, correct? If my inventory drops to 3, will the listing automatically display “3 available”?

2) How do I set allocation plan for listings that are running? I have many fixed-price listings that have been running for a while and they have past orders. When I listed them, I set allocation plan to “none” so they do not have allocation plan. I do not want to end them and start new listings because they have long history of sales and their search ranking on eBay is high because of this (many of them have over 50 orders).

[Author]

Posts