Jet to Ansi SQL converter

I've got a weird question --
Have any of you ever come across software that can convert MS Jet SQL to ANSI standard SQL or other SQL flavors?
Could be a huge help in my next project. Please let me know if you know of anything like this!!
:)I'm not aware of any such software. And I probably wouldn't trust any that I came across. I just think it would be a difficult job writing software to interpret and translate all the crappy code that is out there!|||i do know that you can set the global database properties for microsoft access so that it will write it's queries in MS SQL format (ansi 92).

this would allow you to create simple queries in the query designer and then you could modify them and the designer would parse them but you can also do that in the graphical queries in the SQL Server 2000 Enterprise Manager

{For Access Queries in ANSI 92}
open a database
tools > options > Tables/Queries > SQL Server Compatible Syntax (ansi92)
choose this database or default for all new databases.

{For ANSI 92 Queries Graphically in SQL Server}
Open the SQL Server enterprise manager
expand Servers > [your server name] > Databases > [your database name]
open tables or views
right click one of the tables or views and select Open Table > Query
have at it.

i hope this helps

JDBC performance on Windows Xp SP2

I wrote a conversion program to convert some dbf data to an sql server 2000.
When I run the program on a Windows 2000 SP4 everything works fine. When
I run the same program on a Windows XP SP2 the program is really slow.
Haven't tried the program on a xp without sp 2. Maybe SP is the problem.
Anyone had the same problem?
On a 2000 machine the program copies up to 100 records a second. The same
program running on a xp machine copies only one record a second!
I tried the latest ms jdbc driver as wel as the open source driver.
No difference, same problem.
It's a sql server 2000 Sp3.
I disabled the xp firewall, but same result. Still to slow.
Both machines (2000 and xp) have the same hardware: pentium IV 2.4 GHz with
512MB ram.
I'm using the sun java 1.5.0_01.
Any idea?
Thanks Davy
Davy,
Have you been able to narrow down at all what is slower? Is it reading
the data from dbf or inserting into SQL Server?
Sue Purkis
DataDirect Technologies
"Davy" <Davy@.discussions.microsoft.com> wrote in message
news:5D7E84B6-DF43-41C3-98FA-6C9AF13E34C8@.microsoft.com...
> I wrote a conversion program to convert some dbf data to an sql server
2000.
> When I run the program on a Windows 2000 SP4 everything works fine. When
> I run the same program on a Windows XP SP2 the program is really slow.
> Haven't tried the program on a xp without sp 2. Maybe SP is the problem.
> Anyone had the same problem?
> On a 2000 machine the program copies up to 100 records a second. The same
> program running on a xp machine copies only one record a second!
> I tried the latest ms jdbc driver as wel as the open source driver.
> No difference, same problem.
> It's a sql server 2000 Sp3.
> I disabled the xp firewall, but same result. Still to slow.
> Both machines (2000 and xp) have the same hardware: pentium IV 2.4 GHz
with
> 512MB ram.
> I'm using the sun java 1.5.0_01.
>
> Any idea?
>
> Thanks Davy
|||Inserting the records into SQL Server.
"Sue Purkis" wrote:

> Davy,
> Have you been able to narrow down at all what is slower? Is it reading
> the data from dbf or inserting into SQL Server?
> Sue Purkis
> DataDirect Technologies
> "Davy" <Davy@.discussions.microsoft.com> wrote in message
> news:5D7E84B6-DF43-41C3-98FA-6C9AF13E34C8@.microsoft.com...
> 2000.
> with
>
>