It should work fine, as long as you use SQL92 syntax (or SQL89, depending on
the ODBC driver).
The only problem comes when you use SQL syntax that Access accepts that is
not really valid in the SQL specification. I believe 'limit' is one
example, but I'm sure someone will correct me if I am wrong. I'm also not
sure about 'top'.
I believe you have OpenLink's drivers installed? I'll open up access to an
SQLServer database for you tomorrow if you want to test the relevant queries
Let me know.
Director Technology Evangelism
XML & E-Business Infrastructure Technology
On 1/21/01 7:52 PM, "Sigurd Magnusson" <[EMAIL PROTECTED]> wrote:
> I have written a small program which uses ODBC to connect to a Access
> Database. I am simply wanting to know if this would also work with MS SQL
> without any modifications what so ever, or does ODBC not really accomplish
> what it was designed for ?
> The SQL statments used are very simple; the INSERT / UPDATE / DELETE are the
> same syntax as mysql, so i assume would also work under mSsql, and the
> SELECTs, although looking complex, don't perform JOINs or anything (eg: SELECT
> TOP 10 RECORD_NR, StatusField, ExtendedStatusField, PICTURE, SURNAME,
> FIRSTNAME, FORM, DOB, DESTINATION, EXPIRY FROM (SELECT TOP 20 * FROM WELLGIRLS
> ORDER BY RECORD_NR ASC,RECORD_NR ASC) ORDER BY RECORD_NR DESC,RECORD_NR DESC
> As I dont have access to a MSSQL server, can you someone please validate
> whether all this would work fine with MSSQL, and what problems/benefits (other
> than speed/security) I might have to deal with.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]