EDAM
03-15-2001, 10:37 AM
Can you run a program built on MS SQL 7.0 or 2000 off a linux box (RedHat 6.2) running MySQL?
Click to See Complete Forum and Search --> : This maybe a stupid question, but...
Energon
03-15-2001, 01:16 PM
*scratches head*
you can build a program out of SQL? Uhh... I don't think so... if you're talking about them dinkly little Access programs, I don't think so... I know you can import/export from/to Access and a MySQL server, but that takes some work and probably anything on the Access side (like them programs) have to be manipulated on the Access database, which you then export to MySQL...
you can build a program out of SQL? Uhh... I don't think so... if you're talking about them dinkly little Access programs, I don't think so... I know you can import/export from/to Access and a MySQL server, but that takes some work and probably anything on the Access side (like them programs) have to be manipulated on the Access database, which you then export to MySQL...
EDAM
03-15-2001, 02:33 PM
Originally posted by Energon:
*scratches head*
you can build a program out of SQL? Uhh... I don't think so... if you're talking about them dinkly little Access programs, I don't think so... I know you can import/export from/to Access and a MySQL server, but that takes some work and probably anything on the Access side (like them programs) have to be manipulated on the Access database, which you then export to MySQL...
Sorry... I am not a programmer....I don;t exactly know how these things work.
What I meant was: Can you run a program that uses SQL Server 7 or 2000 as a back end on MySql. Or does the program have to be specifically designed with a MySQL back end in mind?
*scratches head*
you can build a program out of SQL? Uhh... I don't think so... if you're talking about them dinkly little Access programs, I don't think so... I know you can import/export from/to Access and a MySQL server, but that takes some work and probably anything on the Access side (like them programs) have to be manipulated on the Access database, which you then export to MySQL...
Sorry... I am not a programmer....I don;t exactly know how these things work.
What I meant was: Can you run a program that uses SQL Server 7 or 2000 as a back end on MySql. Or does the program have to be specifically designed with a MySQL back end in mind?
Energon
03-15-2001, 10:52 PM
ahhh... so you mean, like a program that generally uses the MS Database servers on MySQL? Depends on if it's a Linux client or Windows client... if it's Windows, I'm pretty sure you can use the MyODBC driver (see www.mysql.com (http://www.mysql.com) for more info)...
The basic problem is that the SQL queries need to be converted to use types closer to basic SQL and MySQL (since MS SQL is a little proprietary)...
Pretty much just read the MySQL documentation to get something working...
The basic problem is that the SQL queries need to be converted to use types closer to basic SQL and MySQL (since MS SQL is a little proprietary)...
Pretty much just read the MySQL documentation to get something working...
EDAM
03-16-2001, 09:29 AM
Originally posted by Energon:
ahhh... so you mean, like a program that generally uses the MS Database servers on MySQL? Depends on if it's a Linux client or Windows client... if it's Windows, I'm pretty sure you can use the MyODBC driver (see www.mysql.com (http://www.mysql.com) for more info)...
The basic problem is that the SQL queries need to be converted to use types closer to basic SQL and MySQL (since MS SQL is a little proprietary)...
Pretty much just read the MySQL documentation to get something working...
That's exactly what I needed to know. Thank You. I see a long road ahead (and a lot of work).....
ahhh... so you mean, like a program that generally uses the MS Database servers on MySQL? Depends on if it's a Linux client or Windows client... if it's Windows, I'm pretty sure you can use the MyODBC driver (see www.mysql.com (http://www.mysql.com) for more info)...
The basic problem is that the SQL queries need to be converted to use types closer to basic SQL and MySQL (since MS SQL is a little proprietary)...
Pretty much just read the MySQL documentation to get something working...
That's exactly what I needed to know. Thank You. I see a long road ahead (and a lot of work).....
justlinux.com
Copyright Internet.com Inc. All Rights Reserved.
Copyright Internet.com Inc. All Rights Reserved.