SQL wrapper for MySQL
Hi, Is there a program/project/software suite out there that traps/wraps MS SQL commands (or database calls/commands/etc) and wraps that into MySQL commands? I'd like to trick a program that requires SQL (MSDE). I'm not just talking about porting the data, but a run-time solution... Thanks, Paul _ Paul Rigor [EMAIL PROTECTED] Go Bruins! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
porting Microsoft SQL into MySql
Hi, Does anyone know how MS_Sql creates tables for users/grants/etc? I'm trying to use a program that uses MSSQL (MSDE, not the full server)... I found one called sql porter http://www.realsoftstudio.com/ ... but it's NOOT free... any other suggestions? Thanks! Paul _ Paul Rigor [EMAIL PROTECTED] Go Bruins! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Saving file into database
Are you running a web server (or ftp server) as well? Because if you are, then you can upload the files to a separate directory using perl and just store the links to that file into a table in your database... If you're not running a webserver (or ftp)... then lemme konw if you get a viable suggestion. HEre's my 2cents. Since mysql is a relational database, it would be difficult to display that particular column/row containing the file (esp, binary). You can use perl (or another converter) to convert the binary file into uue (or other text format)... and then import that... make sure you remove the linefeeds and store information about the column widths of the uue (or other text format) into a table in your database. but geez, if the file is considerably large... like i said, it would put a strain on your server. (unless you have GIGS of ram and extra processing spd). good luck, paul At 01:49 AM 3/9/2004, Isa Wolt wrote: Hi, I would like to save a binary file into a mysql database, for later being able to use the file. I am using a perl interafce. Is this at all possible??? And would it be possible to then read that file from a c++ interface? would be greatful for any help/advices! Isa _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Paul Rigor [EMAIL PROTECTED] Go Bruins! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error on startup
Heya, Check the permission on that directory. Paul At 12:36 AM 3/9/2004, Lorenzo Rossi wrote: Hi. My system is Slackware 9.1. MySQL is the default version installed on Slackware cdrom while system installation, so I hope all the path are ok :) Then launched mysqld_install_db... but when I try to startup the server an error occured wrote in /usr/local/mysql/ginlemon.err like this: 3:49:08 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This is a tipical error for me, almost everytime I install mysql..:-( Any one can put me on the right way? Thanx, Lorenzo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Paul Rigor [EMAIL PROTECTED] Go Bruins! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Security
Heya, Those are the default databases that comes with the setup. the mysql database holds info on mysql accounts. the test is an empty database. You should create a new database CREATE DATABASE customers then use customers... after that... you can setup the tables you mentioned. Goodluck! Paul At 06:34 PM 3/9/2004, Mulugeta Maru wrote: I have used access in the past and now I have started using MySQL. I have customer table, customer order table, customer order detail table. How would I make sure that when a particular customer log-in he/she sees only the account that is set-up for them. What confused me is that MySQL has a database called mysql and a table in this database called users that is used to set a user name and password for each user. I could not figure out how a user in my case a customer that has access to a customer table could be restricted to see his/her transaction only. Any insight is very much appreciated. _ Paul Rigor [EMAIL PROTECTED] Go Bruins! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]