Page 1 of 1

Question about PHP dll's, mainly the ones related to MS SQL.

Posted: Sun Jun 27, 2010 3:21 pm
by amateurdbadude
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

Re: Question about PHP dll's, mainly the ones related to MS

Posted: Sun Jun 27, 2010 4:21 pm
by requinix
amateurdbadude wrote:Or does it use these DLL's just to connect, and then use the actual MS SQL backend to run the queries?
Basically, yes.