Question about PHP dll's, mainly the ones related to MS SQL.
Posted: Sun Jun 27, 2010 3:21 pm
Good afternoon everyone,
Breakdown:
I'm migrating a forum from CommunityServer(MSSQL) to vBulletin 4.0 (MYSQL).
I have successfully imported the users, also the forums, but importing threads fails.
I noticed in my code, for the import threads module, it uses a "SELECT ROW_NUMBER()" SQL query,
Concerns:
1. I am running SQL 2000, database is on compatibility mode 80, in SQL 2000, the "ROW_NUMBER()" function is not available. (SQL 2005>)
Questions:
Does this matter? Do these MSSQL PHP dll's contain libraries that contain SELECT queries and ROW_NUMBER() functions?
Or does it use these DLL's just to connect, and then use the actual MS SQL backend to run the queries?
THANK YOU!!! >=P
Mike
Breakdown:
I'm migrating a forum from CommunityServer(MSSQL) to vBulletin 4.0 (MYSQL).
I have successfully imported the users, also the forums, but importing threads fails.
I noticed in my code, for the import threads module, it uses a "SELECT ROW_NUMBER()" SQL query,
Concerns:
1. I am running SQL 2000, database is on compatibility mode 80, in SQL 2000, the "ROW_NUMBER()" function is not available. (SQL 2005>)
Questions:
Does this matter? Do these MSSQL PHP dll's contain libraries that contain SELECT queries and ROW_NUMBER() functions?
Or does it use these DLL's just to connect, and then use the actual MS SQL backend to run the queries?
THANK YOU!!! >=P
Mike