RE: ODBC Stored procedures
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? www.mysql.com/certification -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 10:02 AM To: [EMAIL PROTECTED] Cc: MySQL Subject: Re: ODBC Stored procedures Wow! the list is quiet today, I really expected someone to respond to this by now. Just in case you didn't understand the problem: He is connecting to a 5.0 database using ODBC version 3.51 and running a stored procedure. He is having problems getting return values from his stored procedures through the defined OUT parameters through the ODBC driver. The ODBC driver is having no problems with his IN parameters (it seems to create his temporary table just fine). If he tries it from the mysql client, everything works just fine. His questions: Is there anyone else using ODBC 3.51 that is able to get at the values of the OUT parameters of a MySQL stored procedure? How are you doing it? Will ODBC 3.52 support the OUT paramters of stored procedures? If so, when will it be available? Are there any other ideas that he can use? Well, I can't answer anything about the ODBC driver being able to handle SP parameters but I do have a suggestion. Instead of putting all of your return values into OUT parameters, can you return a recordset that has those values as column values? SELECT @outparam1 as outparam1, @outparam2 as outparam2 Then all you need to do is check the fields of the returned recordset to read your values. I know that if you are using ADO to access your ODBC driver, you have the ability to recieve multiple recordsets as the result of a single request (I know it works with Access and MS SQL Server through ADO/ODBC so I assume it will still work with MySQL). If your OUT parameters are in the first recordset, you can still get to any other returned records in the second. FWIW, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 07/30/2004 11:49:09 AM: Hi, may be my english is poor, sorry for this. I'll be trying with odbc 3.51 and sp on 5.0 that returns out params and didn't work (at least for me). In parameters works fine. From mysql client command line out parameters works fine. The sp makes about 50 selects, this increase a lot the traffic on my lan if I didn't use it. The way to do this work through odbc was create a temporary table into the sp and fill one record with the out values (this exists only for the connection who call the sp). From the odbc client, I call the sp then make a select over the temp table and then drop it. Someone try out params with odbc and works? any other idea? odbc 3.52 support out params? when odbc 3.52 will be released? Thanks, Alejandro mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tergat MySQL Studio
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 Solutions' Dezign for Databases for this purpose a while back, but its somewhat clunky, unprofessional look/feel has been a bit of a turn off. I've enjoyed using Sybase' Powerdesigner for this purpose, it works pretty well. I only wish it supported MySQL in a more integrated, native fashion. I haven't had the pleasure of using Erwin, but I understand it's a good tool. Any other recommendations for ER modeling? -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 12:39 PM To: MySQL List (E-mail) Subject: RE: Tergat MySQL Studio So basically, if you already own Mascon (or buy it from http://www.scibit.com/ for $49.00), and download the latest installable binary releases of MySQL, Apache, etc, you've got the MySQL Studio, and as a bonus, it features a clean, standard UI, with the standard Windows style widgets. Ah, this is good to know. I wasn't interested in the binary installers or the Apache/MySQL since I build those myself. But I keep hoping for an enterprise level tool that works with MySQL. ER Studio and other packages really simplify my life with SQL Server, so I am greedy and want the same kind of design and management tools for MySQL :) c -- Chris Lott http://www.chrislott.org/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC availability
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 .. ? Is it a licensing issue, something to do with the ODBC spec, or just plain don't want to do that, so there (which, I hasten to add, is perfectly acceptable)? No such, as long as it is GPL distribution. I had it in unixODBC originally but I gather someone asked Nick to remove it. Mind you; I just built the OSX version of MyODBC by copying all the MyODBC source (just *.h and *.c) into the unixODBC source tree. However; I only checked the make (actually qmake project file) into unixODBC cvs. It was really important, when unixODBC first started, to have some drivers in the unixODBC source tree but it less important now. What is REALLY important is to encourage Linux, UNIX, and OSX people to put unixODBC itself into O/S distros as a standard thing. Then allow drivers to be added with the assumption that the O/S has some form of ODBC sub-system. It's not as of there is some kind of overhead of having it on a system and not being used (no processes and 1 meg on disk for the core stuff). The upside is significant. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC on OSX
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 standard Mac installer to ensure that they are as easy to install as possible. Furthermore; the drivers are auto-registered during their install using the unixODBC odbcinst command-line tool. The graphical parts of unixODBC, including the driver config dialogs, are supported by a Qt runtime which also installs using the standard Mac installer. The GUI stuff needs to be tweeked a bit but it appears to be quite usefull. This work was done as part of the development of Data Architect. It is hoped that it is usefull to others. Please support the development of open clients for data access by purchasing a copy of Data Architect. Peter BTW: I used qmake to build these in order to bypass the current GNU auto-tool confusion on OSX. The qmake project files and my notes are in the unixODBC cvs at Source Forge. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERD
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 to be a great tool. But it has always been very expensive. So I created DataArchitect. Data Architect is ERD centric, works on Win2K and Linux (has been ported to others such as OSX but not availible on those platforms yet). Its file format is XML and it works with MySQL and PostgreSQL... as well as others via the SQL92 model. I encourage you to check it out at... http://www.codebydesign.com/DataArchitect OR http://www.thekompany.com/products/dataarchitect/ Buying a copy will allow us to get more resources on this, and at least two Open Source projects (unixODBC and FreeTDS). Suffice to say we are not out to make a bucket load of cash we just want to fund our development. Some people buy Data Architect just to encourage the development. Of course; it is already very useful. Peter BTW: I am currently working on a Report Builder which is inspired by Crystal Reports. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: ERD
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 sure that it will get addressed promptly. Thanks for pointing it out. For the http://www.codebydesign.com/DataArchitect link to work you will have to scroll down the header if using ie5/6. Yup; looks fine in konqueror and Netscape (Linux). Sorry; I am too busy coding to worry much about this grin Thanks for the feedback. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: Data Architect 2.0
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Name of the Driver file ?
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 path of the file so that I can use it into odbc.ini file ? I am running Solaris 2.6. I have install MySql Source distribution in my Home Directory(/u/premc/mysql). I checked in /u/premc/mysql/lib/mysql . But it contains only libmysqlclient.so , libmysqlclient.so .10 libmysqlclient.so .10.0.0. Are these the correct Dirver files ? Can anybody help me out of this problem ? Thanks in advance, prem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UNIX ODBC
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 have ODBC but seldom by default ( http://www.unixodbc.com ) 2. You just need to get MyODBC running on your MS Windows machine. It does not sound like you need ODBC on the UNIX box because ODBC is just needed on the client side and it sound like the client is MS Windows. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access to MYSQL via ODBC?
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 a MYSQL DB not directly, but via ODBC? The reason (as states in my other message MS ACCESS on Linux) is that it would make possible to test on Linux PHP code that would eventually manage (wit xero or minimal changes) an MS access on NT/IIS. Is it possible? mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: unixODBC..
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 what all SQL staements i can give in SQLExecDirect call of unixODBC?? MS has a great ODBC reference online at... http://msdn.microsoft.com/library Basically you want to look into MDAC and then find ODBC. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL GUI-Based Table Creation Tools?
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: EMS MySQL Manager 0.92 released
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! Peter Table,MySQL - Original Message - From: Igor Brynskich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:32 AM Subject: ANN: EMS MySQL Manager 0.92 released Dear Sirs and Madams, EMS HiTech company is announcing the next version (0.92) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 0.92? 1. New services were added. Check out the Service menu to find this new features. Now you can Analyze, Check, Repair and Optimize tables step by step with corresponding wizard: a) Analyze Tables wizard allows you to analyze and store the key distribution for specified tables. b) Check Tables wizard allows you to check specified tables for errors. c) Repair Tables wizard allows you to repair a possible corrupted tables. d) Optimize Tables wizard allows you to optimize tables with variable-length rows. 2. The Server Properties menu item was added. Now you can get a detailed information about MySQL server, such as server version, server variables and currently running processes. See menu Service to find it. 3. A few little improvements and minor bugfixes were added. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL ODBC on Unix
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 program. Any idea about how to go about it?? (What I read from MyOODBC docs is that it is just a driver and not a program manager..I really don't know how to use ODBC on UNIX).. TIA.. There are two free Driver Managers; - unixODBC - iODBC I use unixODBC with great success. You can check it out at... http://www.unixodbc.org There is a mailing list there as well so you can get great support if you need it. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANN: EMS MySQL Manager 0.91 released
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 one just seems redundant. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query by design...
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 will have such a feature at some point but for now check out EasyDB at... http://www.hancom.com/en/ Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- Table,Database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About MYSQL APIs
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. But ODBC as a programming model is independent of RDBMS make. So, is MyODBC just for MySQL, or can one use it for talking to other databases via ODBC also? Sorry, I'm just confused today, I guess ;) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Check out... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_function_summary.asp ...for more information on ODBC. Also check out http://www.unixodbc.org ...for ODBC on UNIX/Linux. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANN: EMS MySQL Manager
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 some questions regarding EMS MySQL Manager. On which operating system does MySQL Manager works? Currently, MySQL Manager works on Windows 95/98/NT/ME/2000 operating systems. Linux version will be available soon. How much does EMS MySQL Manager costs? Q. Why should I pay a lot of attention to a company who spams a technical list in order to sell product under the guise of answering questions? It is common practice NOT to post such messages on a list such as this one... a development or support list. However; I do not consider an occasional ANN post a real problem... particularly for a 1st release of a 'relevant' product. Now about the getting [mysql] in the subject line... Peter BTW: Is libmysql.so/mysql.dll LGPL? In other words ok to distribute, alone, with a commercial product? -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
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 distro? It supports all features of MySQL... table options... column types and options... etc. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting value for an auto increment column?
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 +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC between MySQL-Server (Linux) and Linux-Client
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, wich doesn't exist? My /etc/odbc.ini on the other Linux client (same as on the server): How did you add the odbc.ini entry... using ODBCConfig? I am thinking that you may have dropped it into the wrong place using a text editor... but then again... it does not quite sound like it. Hmmm The default location for the system ini is /usr/local/lib/etc/odbc.ini or something like that. Using ODBCConfig (or odbcinst) is a good way to ensure that you modify the correct ini file. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NewLine between statements
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 -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket
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, wich doesn't exist? My /etc/odbc.ini on the other Linux client (same as on the server): How did you add the odbc.ini entry... using ODBCConfig? I am thinking that you may have dropped it into the wrong place using a text editor... but then again... it does not quite sound like it. Hmmm The default location for the system ini is /usr/local/lib/etc/odbc.ini or something like that. Using ODBCConfig (or odbcinst) is a good way to ensure that you modify the correct ini file. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NewLine
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 -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
subject header
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 Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php