RE: ODBC & Stored procedures

2004-07-30 Thread Peter Harvey
MyODBC 3.53 will be the next majour release (not 3.52) and it will support stored procedures so please hang on a bit. At the moment we are focusing on a backlog of MyODBC 3.51 bugs/issues. Peter Harvey, Software Developer MySQL AB Office: +1 619 251-6923 Are you MySQL certified

Re: MyODBC Guru's Having MyODBC Woes

2002-01-31 Thread Peter Harvey
Hey Samy; re. could not find odbc.ini This is reported by the ODBCConfig when it can not find the odbc.ini but it is usually looking for the User one (the one in your home dir) - so it goes on to create it and you should not get this message anymore. If you continue to get the message then it

Re: Tergat MySQL Studio

2002-01-18 Thread Peter Harvey
You may want to try... http://www.codebydesign.com/DataArchitect Its not perfect but its quite useful. Inspired by PowerDesigner. Peter On Friday 18 January 2002 12:09, Alok K. Dhir wrote: > Unfortunately Mascon doesn't have any ER diagramming tools for schema > modeling. I bought Heraut S

Re: MyODBC availability

2001-12-17 Thread Peter Harvey
> > > > Does anyone know why it is that the MyODBC authors prefer not to allow > > that to be distributed in the unixODBC package, or with distros (eg the > > SuSE CDs don't contain it)? > > Peter will answer this, why MyODBC is not included in > unixODBC distribution :) > > Peter, any comments ..

ODBC on OSX

2001-12-16 Thread Peter Harvey
I have made binary distributions of; - unixODBC - PostgreSQL Driver - MySQL Driver availible to the public at http://www.codebydesign.com/DataArchitect. These binary distributions are based upon Open Source code which was configured and built on the Mac OSX. All distributions use the standar

Re: Re: ERD

2001-11-30 Thread Peter Harvey
database,sql,query,table > yeah, but the http://www.thekompany.com/products/dataarchitect/ link to > buy the dl version just shows that you have nothing in your cart, and > doesn't give you dl options. I recommend not using that site. I have forwarded your comments to the CEO of theKompany. I am

Re: ERD

2001-11-30 Thread Peter Harvey
> Anyone know a good ERD program that will also interact with MySQL to write > the CREATE scripts? As usual open source would be nice, also running on a > win2k workstation. > > I used to use PowerDesigner. Nice software but too expensive. > I have used PowerDesigner for years and have found it

ANN: Data Architect 2.0

2001-11-27 Thread Peter Harvey
Cross-platform, cross-database, ERD based, data architecting tool. Screenshots http://www.thekompany.com/products/dataarchitect/screenshots.php3 Product Information http://www.thekompany.com/products/dataarchitect/ -- Peter Harvey

Re: Name of the Driver file ?

2001-11-18 Thread Peter Harvey
You should install MyODBC. Peter http://www.mysql.com http://www.unixodbc.org On Saturday 17 November 2001 23:34, Chaudhary, Prem Shankar wrote: > Hi all, > > I want to connect through ODBC Driver Manager(libiodbc-3.0.5) to MySql > Server. > > Can you tell me the MySql driver's Name & pat

Re: UNIX & ODBC

2001-11-17 Thread Peter Harvey
> I'm looking for a way to download MySQL tables from a > remote server to MS' Access 97 in my PC. > > Many suggested MyODBC. > > Although I was originally told othewise by my hosting > provider, the provider now tells me that UNIX doesn't > support ODBC. > > How can I then do it? > 1. UNIX does

RE: Access to MYSQL via ODBC?

2001-11-13 Thread Peter Harvey
Look for unixODBC on http://www.sourceforge.com Peter -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 7:23 AM To: phplist; mysqllist Subject: Access to MYSQL via ODBC? Hello, apart from performance issues, is it possible in PHP to read/write

Re: unixODBC..

2001-09-30 Thread Peter Harvey
> Hi All, > According to the guidance in the list (Thanks for guidance), I have > set up MySQL-3.23.42 server on Linux, and unixODBC-2.0.9 & > MyODBC-2.50.39 on other Linux m/c. I was able to communicate and > sucessfully execute a test program mentioned in the document. Now I > want to know

Re: SQL GUI-Based Table Creation Tools?

2001-09-21 Thread Peter Harvey
> Can anyone out there provide GUI-Based table creation tools for mySQL? > (something like Access) > Here is an ERD based tool with full support for MySQL. Versions for various platforms including Linux and Windows http://www.thekompany.com/products/dataarchitect/index.php3?dhtml_ok=1 Peter

Re: EMS MySQL Manager 0.92 released

2001-09-17 Thread Peter Harvey
Ok... this is getting out of hand. Is it just me or are we getting a posting every week on this? Please keep these postings to majour releases (1.0, 2.0, etc)... at most. Post your minor releases to your own mailing list. This is a relevant product but we do not want to pollute the list. Thanks

Re: ANN: EMS MySQL Manager 0.91 released

2001-09-13 Thread Peter Harvey
> database,sql,query,table > > Igor Brynskich wrote: > > > > Dear Sirs and Madams, > > > Perhaps you should consider creating your own mail list for minor release announcements? We do this for Data Architect. I am sure that 90% of the people on this list received your last announcement so this o

Re: MySQL & ODBC on Unix

2001-09-13 Thread Peter Harvey
"Srinivasa T.N." wrote: > > Hi, > The m/c on which I have my database is also Unix, and the machine > from which I want to connect is also Unix. Instead of directly > connecting to database, I want to use ODBC in between, so that, if > tomorrow, my database changes, I should not change my pr

Re: Query by design...

2001-09-08 Thread Peter Harvey
> Does anyone know of a QBD (query by design) interface for MySQL? What I > mean is the same thing that MS Access has where you can drag fields, create > joins and have it generate SQL syntax. > > Right now I am using MS Access via MyODBC. but Access has its own > peculiarities. Data Architect

Re: About MYSQL APIs

2001-09-07 Thread Peter Harvey
Ed Carp wrote: > > Sinisa Milivojevic ([EMAIL PROTECTED]) writes: > > > Ed Carp writes: > > > Sinisa Milivojevic ([EMAIL PROTECTED]) writes: > > > > > > > > > ODBC, or MyODBC? > > > > ODBC as an API. > > > > Then you install ODBC driver for RDBMS of your choice and configure > > ODBC likewise. >

Re: ANN: EMS MySQL Manager

2001-09-06 Thread Peter Harvey
Paul DuBois wrote: > > At 6:54 AM -0500 9/6/01, Ed Carp wrote: > >Igor Brynskich ([EMAIL PROTECTED]) writes: > > > >> First, thanks to everyone who interested in our product -- EMS MySQL > >> Manager -- and answered to our previous announce! > >> > >> This message intended for shed light on so

Re: On Redhat 7.1

2001-09-04 Thread Peter Harvey
> That depends on what you install. MySQL isn't (like many other > packages) in any of the premade installation categories - you can > select it in a custom install, or do a "everything" install. I bet a product like Data Architect ( http://www.codebydesign.com ) would be a great fit in this dist

Re: Starting value for an auto increment column?

2001-09-03 Thread Peter Harvey
> Is there a way to specify a starting value for an auto increment > column? Take a look at the CREATE TABLE syntax. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- -

subject header

2001-09-01 Thread Peter Harvey
Would it be possible to get a header prefix on the subject line for all email sent out from this list. For example; [mysql] subject header This is becoming quite common these days and is very useful when interpreting the subject line. Thanks!! Peter -- +--- | Data A

NewLine

2001-09-01 Thread Peter Harvey
>> It really depends on the client. MySQL does not inherently know how to >> process multiple statements. If you're sending SQL from a program you >> developed, you'll probably have to separate the statements and submit them >> individually. >> > >I may take exactly that approach. Thanks! > >Pet

[unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket

2001-09-01 Thread Peter Harvey
>> >> root@workstation3:/home/manuel > isql -v MySQLtest dbuser >> [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket >> '/var/lib/mysql/mysql.sock' (2) >> [ISQL]ERROR: Could not SQLConnect >> root@workstation3:/home/manuel > >> >> It seems to try to connect to a local mysql

Re: NewLine between statements

2001-09-01 Thread Peter Harvey
> It really depends on the client. MySQL does not inherently know how to > process multiple statements. If you're sending SQL from a program you > developed, you'll probably have to separate the statements and submit them > individually. > I may take exactly that approach. Thanks! Peter -- +-

Re: MyODBC between MySQL-Server (Linux) and Linux-Client

2001-09-01 Thread Peter Harvey
> > root@workstation3:/home/manuel > isql -v MySQLtest dbuser > [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > [ISQL]ERROR: Could not SQLConnect > root@workstation3:/home/manuel > > > It seems to try to connect to a local mysql-server,

NewLine between statements

2001-08-31 Thread Peter Harvey
MySQL Anyone know what the deal is with sending multiple statements to the server and getting errors at ";\n" on the first statement? Even the result will come back with something other than '\n' in error messages. I am using MyODBC but I am not certian that it is a MyODBC behaviour. Any pointe