Issue on SQL in MS SQL2000 and Access

I am not a programmer so anyone who can help, please do.

I have downloaded an application written for MS SQL2000 but I want to use my desktop for testing and configuration where I have Access and XP Pro IIS. I was told that the SQL in MS SQL2000 is not the same as SQL in Access, so I will face problem even if I change the connection string to point to Access instead of MS SQL2000.

Is this true? If yes, how can I change the SQLs so that it works with Access?Yes, it is decidely true. While Jet (the database engine that MS-Access uses by default) uses an SQL-like language, it isn't the real McCoy. MS-SQL implements nearly all of the SQL-92 standard, and plays by the rules nearly all of the time.

With the Professional version of MS-Access, you get MSDE included on the CD, but not automajikally installed. You can install it (and I'd strongly recommend applying Service Pack 3), and it will give you almost exactly the same functionality as MS-SQL, but pared down to run on a workstation.

-PatP|||Does that mean if I buy a MS Office Pro (which I supposed have MSDE in it) and install the software in my desktop, it should run fine? Or should I buy other software from MS?

And you mentioned the MSDE not installed automatically, how do I then installed it?|||Operative word being should, yes, the application should work using MSDE.

MSDE is included in all of the Professional versions of MS-Access, including the one that ships as part of MS-Office Professional.

The MSDE installation instructions vary slightly from one product to another. To install the version shipped with MS-Office, you double click the SETUP icon in the MSDE folder on the CD.

-PatP|||Thanks again for the information.

Just to further my knowledge on SQL, do you have samples (or do you know a website that has samples) that shows the differences between the SQL in an Access query and that in MS SQL2000?

It would be nice to know some basic differences....

isqlw won't start

Hi there,

I tried to install MS SQL Server 2000 on my desktop computer after
uninstalling a version 7 instance. Everything worked fine. Using
Enterprise Manager I can manage databases and the database enginge itself.

My problem is now, that ISQLW.exe, i.e Query Analayzer won't start. The
taskmanager shows a process isqlw.exe but nothing happens. MSSQL Log
files give no hints, neither does the Windows 2000 event log.

I assume a problem with the previously installed MSSQL7 version, but
walked through the registry as well.

Are there any hints why isqlw doesn't want to speak to me?

Thanks,
AndreAndre Ma@.ss schrieb:

Quote:

Originally Posted by

Are there any hints why isqlw doesn't want to speak to me?

Meanwhile I have solved the problem. I have installed SP3 and have
repaired the registry entries. After that Query Analyzer worked fine.

Thanks,
Andre|||Andre Ma@.ss (Samweis11@.gmx.de) writes:

Quote:

Originally Posted by

I tried to install MS SQL Server 2000 on my desktop computer after
uninstalling a version 7 instance. Everything worked fine. Using
Enterprise Manager I can manage databases and the database enginge itself.
>
My problem is now, that ISQLW.exe, i.e Query Analayzer won't start. The
taskmanager shows a process isqlw.exe but nothing happens. MSSQL Log
files give no hints, neither does the Windows 2000 event log.
>
I assume a problem with the previously installed MSSQL7 version, but
walked through the registry as well.
>
Are there any hints why isqlw doesn't want to speak to me?

Tried rebooting? More importantly, have you installed any service pack
for SQL 2000? You should install at least SP3, but there is an SP4 as
well. There is a serious security threat in SQL 2000 RTM which is fixed
in SP3. (The Slammer worm.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx