2/22/2025 8:00:15 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Is SLX Web 7.2.1 compatable with SQL 2000?
Posted: 11 Mar 08 2:01 PM
|
The documentation seems to imply yes, but on the system I'm playing with, the Web client views all appear normally, but there's no data.
I can enter new accounts & contacts into the web client, and they appear in the LAN client, but all searches in the web client come up with no records.
I found that when I enter a new record into the web client and save it, the data I entered appears in the detail view just find. Then if I change the accountid in the URL to a different account, that account comes up successfully.
I did a SQL trace for the Web client search query, and it errors on the function row_number(). Looking at SQL Books online for SQL 2000 and 2005, it appears that row_number() is new in SQL 2005.
Is this corrected in 7.2.2?
|
|
|
|
Re: Is SLX Web 7.2.1 compatable with SQL 2000?
Posted: 12 Mar 08 8:21 AM
|
Works perfectly fine.. In fact, we run our production SalesLogix (7.2.2) on SQL2000 - with SP4 (don't forget sp4!). I also have clients on 7.2 w/Slx 7.2.1
--
RJLedger - rjlSystems |
|
|
|
Re: Is SLX Web 7.2.1 compatable with SQL 2000?
Posted: 12 Mar 08 9:29 AM
|
Interesting... Our SQL 2000 server is SP 4.
The first line of a query I captured in SQL profiler is SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY (isNull(A1.LastName,'''') + '', '' + isNull(A1.FirstName,'''')) ASC)... From what I'm reading on the Microsoft KB (http://support.microsoft.com/kb/186133/en-us), row_number() is a new SQL 2005 function that does not exist in SQL2K.
Does SLX Web construct it's queries based on the verson of SQL it believes it is running on? |
|
|
|
Re: Is SLX Web 7.2.1 compatable with SQL 2000?
Posted: 13 Mar 08 12:24 AM
|
| That happens if the wrong provider type is selected in the connection manager for the database (for example if you select SQL Native Client instead of SQL OLEDB) |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|