Retrieving results of a stored function using MySql C API
Hi guys, I am using stored procedures and stored functions for the first time. And currently stuck at a this point where. I am unable to retrieve results returned by stored function using MySql C API. Kindly let me know how to do so. In case you need details I'll share the source code. Cheers, Venu
Reset of Status Parameters
I am using MySQL version 5.0.22, I am interested in knowing the current performance on the MySQL. With the status command we can get the queries per second but it will average since the beginning of time when SQL was up and running and not the current rate? Is there any way to reset that parameter so that the data can reflect current without restarting the MySQL Thanks in advance ..venu
Problem with ibdata1
Hi Any help is greatly appreciated. When I upload some data into my mysql database, the file ibdata1 is growing. Usually I export contents of files into database. That's our requirement. When I remove the same data from tables, there is no change in ibdata size. I.e. it is not getting reduced with the deletions. But if I export again the same file its not growing. When I created the tables again the size remains same. How do I handle/manage/configure the file ibdata, as the size of it should grow/reduce with my operation. Please suggest any configurations required. Regards Sunil
Re: odbc.ini
On Thu, 2003-06-12 at 17:29, David Crowley wrote: Please change the comments at the top of the example odbc.ini file to start with # instead of ; characters.. It took my 2 hours to find out why unixODBC was choking... Thanks, will be taken care. -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Crystal Reports and MySQL
On Mon, 2003-03-31 at 07:57, Wynne Crisman wrote: Hi !! I too have had problems with Crystal Reports and MySQL using the ODBC drivers provided by MySQL. The problem is not that you can't make Crystal Reports work with MySQL, but that when you connect to the database Crystal Reports is unable to display the tables that are in the database. This makes interacting with MySQL more difficult since the queries have to be written by hand. For complex reports requiring multiple queries it makes CR very inefficient (because it won't modify hand written queries, it just runs the query once for each drill down). I have not yet figured out how to get around this. Some one page reports take 10 seconds to complete and involve dozens of queries when only 3 should be necessary. Obviously this won't scale well for larger reports involving thousands of records. I am using the root login and testing under win2k/XP with the latest compiled version of MySQL, latest (3.51) ODBC driver, and CR 9.0 with the latest patches. Crystal Decisions, the company behind Crystal Reports is currently working actively on why CR 9 is failing with MySQL, but it used to work fine with earlier versions like 8.x. Will let you know any status on this to myodbc list in a day or so. Thanks ~Wynne -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 5:09 AM To: 'Brei, Matt'; [EMAIL PROTECTED] Subject: RE: Crystal Reports and MySQL Sounds to me that you have some permission problems. I use Crystal Reports against MySQL and many other databases and it works fine. All you have to do is setup a ODBC DSN (user or system DSN) with a username and password. Make sure this user exists in MySQL so the user can get in. I would check your MySQL log files and system log files to see if you are getting denied access. -Original Message- From: Brei, Matt [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: Crystal Reports and MySQL I am looking for any type of documentation on using Crystal Reports with MySQL. I have connected to mysqld from CR but when it shows the selected database, there are no tables listed. Is there something I have to configure in the MyODBC driver? Please help me out with any advice you may have. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC: SQLBindParameter mix DATA_AT_EXEC with direct boundparam eters
On Mon, 2003-03-10 at 09:40, Naumann, Frank wrote: Hi all, Hi !! I found a problem (bug?) when updating a blob column via MyODBC. The statement i run is like that: UPDATE blob_table SET blob_col = ? where id = ? when i do NOT bind the restriction as input parameter, but write it directly in the string, it works perfectly. but when i want to bind the restriction directly, the following happens: 1. I bind the blob_col with SQL_LEN_DATA_AT_EXEC(length) as indikator (SQLBindParameter returns SQL_SUCCESS) 2. I bind the id restriction directly to a program variable (SQLBindParameter returns SQL_SUCCESS) 3. I call SQLExecute, it returns SQL_NEED_DATA as expected. 4. I call SQLParamData to access the blob_col, it returns also SQL_NEED_DATA as expected. 5. I call several times SQLPutData to fill the blob_col, each returns with SQL_SUCCESS 6. I call SQLParamData to indicate that the blob_col is populated with data completely and would expect SQL_SUCCESS. I just tested it, and it returns SQL_SUCCESS unless if you have more parameters data to be supplied during the run-time. Possible reason could be, you might have specified the same pcbLength buffer to all parameters in SQLBindParameter. Here is a simple snippet from the test suite for the similar case: .. .. rc = SQLPrepare(hstmt,update t_putdata set c2= ? where c1 = ?,SQL_NTS); mystmt(hstmt,rc); rc = SQLBindParameter(hstmt,1,SQL_PARAM_INPUT,SQL_C_CHAR, SQL_LONGVARCHAR,0,0, (SQLPOINTER)1,0,pcbLength); rc = SQLBindParameter(hstmt,2,SQL_PARAM_INPUT,SQL_C_LONG, SQL_INTEGER,0,0,c1,0,NULL); pcbLength = SQL_LEN_DATA_AT_EXEC(0); c1 = 10; rc = SQLExecute(hstmt); myassert(rc == SQL_NEED_DATA); rc = SQLParamData(hstmt, token); myassert(rc == SQL_NEED_DATA); strcpy(data,mysql ab); rc = SQLPutData(hstmt,data,6); mystmt(hstmt,rc); strcpy(data,- the open source database company); rc = SQLPutData(hstmt,data,strlen(data)); mystmt(hstmt,rc); rc = SQLParamData(hstmt, token); mystmt(hstmt,rc); SQLFreeStmt(hstmt, SQL_RESET_PARAMS); SQLFreeStmt(hstmt, SQL_CLOSE); .. .. The data updated is: data: mysql - the open source database company(40) Thanks -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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 3.51 - Memory allocation error with BLOBs
On Sun, 2003-03-02 at 21:19, Aaron O'Neil wrote: How-To-Repeat: I suspect there is a bug in the ODBC driver in relation to blobs. I'm now using 3.51.06, but was having this same problem on 3.51.05. I'm using Visual C++ and their CRecordset wrapper for the ODBC calls. I'm using the positioned updates. As long as I keep the binary data I'm trying to transfer under the default buffer size (8192) it works fine. I'm guessing it is a default buffer size from looking at the debug text. Here is the output info from setting a binary field that works, the data for the binary field is 6933, less than the 8192. Thanks for the clear report. I just tested this, and noticed that this is happening only with the debug version of the driver and not with the release version, and thats why it wasn't even caught with the regression test suite before the releases. Did you tested this with the release version of the driver ? If yes, what was the outcome. I will investigate and fix why 'my_realloc' is crashing if using the debug version of the MySQL client libraries. Thanks SQLSetPos | enter: irow: 1 fOption: SQL_UPDATE Lock: 0 | init_dynamic_string | | _mymalloc | | | enter: Size: 1024 | | | exit: ptr: 11ae198 | | _mymalloc | init_dynamic_string | find_used_table | | _mymalloc | | | enter: Size: 8 | | | exit: ptr: 10238a8 | | _mymalloc | find_used_table | dynstr_realloc | dynstr_realloc | dynstr_realloc | dynstr_realloc | extend_buffer | | enter: current_length: 0 length: 6934 buffer_length: 8192 | extend_buffer | info: param: 0x12eddc ctype: -2 SqlType: -4 data: 0x1412c58 length: 6933 actual_len: 6933 pos_in_query: 00FCF764 | info: param: 0x12eddc ctype: 1 SqlType: 4 data: 0xfced54 length: 1 actual_len: 1 pos_in_query: 00FCF764 That above works just fine. Here is what happens whenever I try to set binary data 8192: SQLSetPos | enter: irow: 1 fOption: SQL_UPDATE Lock: 0 | init_dynamic_string | | _mymalloc | | | enter: Size: 1024 | | | exit: ptr: 11ae198 | | _mymalloc | init_dynamic_string | find_used_table | | _mymalloc | | | enter: Size: 8 | | | exit: ptr: 1023808 | | _mymalloc | find_used_table | dynstr_realloc | dynstr_realloc | dynstr_realloc | dynstr_realloc | extend_buffer | | enter: current_length: 0 length: 11016 buffer_length: 8192 | | _myrealloc | | | _mymalloc | | | | enter: Size: 16384 | | | | exit: ptr: 11ae5f0 | | | _mymalloc | | | _myfree | | | | enter: ptr: f37d58 | | | _myfree | | _myrealloc | extend_buffer | info: param: 0x12eddc ctype: -2 SqlType: -4 data: 0x1412d30 length: 11015 actual_len: 11015 pos_in_query: 00FCF764 | extend_buffer | | enter: current_length: 2582681 length: 11527 buffer_length: 8192 | | _myrealloc | | | safe: Reallocating unallocated data at line 145, 'execute.c' | | _myrealloc | extend_buffer | copy_error | | error: code :4001, state: S1001, err :(null) | | exit : SQL_ERROR This happens every time I try to store more than 8192 bytes. - 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 -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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 + ADO + ODBC
On Sun, 2002-12-22 at 17:25, Michael She wrote: Hi all, Does MySQL's ODBC v2.50 driver support Bookmarks? MySQL doesn't support bookmarks, so no means that the drivers will support this either :) -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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 with iODBC on Mac OSX 10.2 Jaguar
Tarin wrote: Has anyone had any success in building the MySQL ODBC 3.51 Driver (formerly MyODBC) against iODBC on Mac OSX 10.2 Jaguar? Specifically, I would like to use the MySQL ODBC 3.51.04 Driver built using the iODBC Unix libraries, rather than the iODBC frameworks available on OSX through OpenLink. Has anyone had any success in building this target? One of my main problems is that one of the prerequisites of building MyODBC is that MySQL's libmysqlclient library must be installed as a shared library, but the binary distribution of MySQL for 10.2 does not include a shared version, only a static one. I cannot seem to get any success building a shared version of this library from the source distribution of MySQL on OSX 10.2. If anyone has any ideas, advice or comments, I'd really appreciate it. Thanks! Hi !! What type of errors are you getting while building the driver as well as building mysql shared libraries. I built on HP 10 and 11 without any problems along with mysql shared ones. From next release onwards, I will also include the client shared libraries for download along with the driver. In case if you need client shared libs for HP 10/11, please let me know, I can provide you the link to download. Did you had any chance to test with the MyODBC 3.51.04 HP 10 binaries from the main download site ? Thanks. Tarin Haig. PS: Please forgive me if any of this doesn't make sense - I'm very new to the world of MySQL. -- Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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: New to MySQL, ported from MS Access. Using ASP MyODBC - UPDATEproblem...
Luis Sanches wrote: Hi, I've recently made the move over from Access to MySQL. So far, everything has been fine. I'm using: Win2K server (ASP) WinMySQLadmin 1.4, MyCC 0.8.4-alpha, MyODBC 3.51 and MySQL 3.23.51-nt First problem: (fixed) -- I had used some keywords as table names, but SQL in a Nutshell by O'Reilly put me on the straight track. Second problem: (also fixed) Then I had problems using this line: % If MyRS.recordcount 0 Then %... I discovered that under ASP, the recordcount is -1, so I worked around this by using the following line: % If MyRS.EOF = False Then %. All was fine, and exporting data straight from Access2000 into MySQL was easy. I then found one bizarre problem: Third Problem: (Circumvented) - I could edit any old record set - originally created on Access, but not newly created ones! Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Query-based update failed because the row to update could not be found. I spent quite some time looking for information on how to fix this, and drew a blank. I can display all the info from the new record set, but I can't update it... ..that is until I tried a different way to update it: Old way: 1) Open connection (sql=select * from mytablename where UserID = '1') 2) MyRS(UserName) = New Value 3) MyRS.Update '-- Error occurred at this line 4) MyRS.Close New way: 1) Open connection with update directly in sql statement: (sql=UPDATE mytablename SET UserName = 'New Value' WHERE UserID = '1') So... here's my questions to you knowledgeable lot: a) Why did the second method work, and not the first? - is this a MyODBC bug? b) Why is this only happening to NEW rows in the database? - is it a MyODBC bug? c) could I gain/fix anything by changing over to MySQL 4 ? d) how do YOU normally update MySQL records from within ASP? Many thanks for any insight. As I said, I've made it work, so I'm not too troubled, but I would like to code things in the 'standard' way. You just need a correct OPTION value passed to the connect string or setting them in the DSN configuration. Check the following code, which has .update, .addnew and .delete methods from ADO: http://www.mysql.com/products/myodbc/manual.html#MyODBC_With_VB -- Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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 bug? with centura application using bind variable
Hi !! Hi, I'm using: -- - W98 - MySql ODBC (MyODBC-3.51.04.exe) / Tried also (myodbc-2.50.39-win95.zip) - Application with Centura Team Developer CTD 1.5.1 PTF6 (Gupta Sqlwindows) - MySql Server on Linux 3.23.48-19, (from Suse Linux 8.0) Problem: Using bind variable in select statement in where clause get's no result. Examples (Centura Application Code) - NOT WORKING: Set sKKey = '4711' Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = :sKKey' Call SqlPrepareAndExecute( hSqlA, sSel ) Call SqlFetchNext( hSqlA, nErr ) Gets no Result. How this SqlPrepareAndExecute is binding the data for sKKey value ? Can you cross the call from SQLBindParameter from the ODBC log whether it is passing the valid pointer with the value that you are expecting ? The reason could be the sKKey is bound to different value than the expected or sent a wrong pointer. And it's a basic functionality from the driver, and that is used by many users. Don't using bind variable in where clause - WORKING: Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = \'4711\' I've searched many hours in newsgroups and mailing list but I can't find a solution! I guess, the value sent in the where clause didn't match. But more information can be found from the odbc log. Send me the log file. Thanks Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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: is AppendChunk interactive or accumulative?
On Fri, 2002-10-25 at 23:42, Michael J. Fuhrman wrote: Hello All, Need to know if a RecordSet AppendChunk is interactive or does it accumulate the field's data until an Update is called? I'm finding that the Update fails if the total RecordSet size is greater than Max_Allowed_Packet. If the later is true .. I guess I'll need work around suggestions, please. It uses second option; and you must increase the max_allowed_packet size in this case. Below is my test: CREATE TABLE test ( ID INTEGER AUTO_INCREMENT, PRIMARY KEY (ID), szText LONGTEXT, szBlob LONGBLOB ) VB Code === Const nMaxChunk = 64000 Dim nMaxAllowed as Long On Error Resume Next Dim szString as String szString = String (., nMaxAllowed + 1) Dim szSQL as String Dim cn as Object Dim rs as Object Set cn = CreateObject (ADODB.Connection) ... szSQL = SHOW VARIABLES -- where variable_name = 'max_allowed_packet' Set rs = cn.Execute (szSQL) nMaxAllowed = rs (1) rs.close szSQL = SELECT * FROM test WHERE ID = 0 Set rs = CreateObject (ADODB.Recordset) ... rs.open (szSQL) rs.AddNew Dim t as Long Dim szChunk as String t = 1 do szChunk = mid (szString, t, nMaxChunk) rs (szMemo).AppendChunk (szChunk) t = t + nMaxChunk loop while (t nMaxAllowed) t = 1 do szChunk = mid (szString, t, nMaxChunk) rs (szBlob).AppendChunk (szChunk) t = t + nMaxChunk loop while (t nMaxAllowed) rs.Update if (err 0) then stop rs.Close === Any suggestions? ENetArch === ' Keywords: ' myODBC, mySQL, Visual Basic, VB, ADODB.RECORDSET ' ADODB.CONNECTION, ADO, AppendChunck, GetChunck, ' rs.Update, Max_Allowed_Packet ' Errors: ' [MySQL][ODBC 3.51 Driver][mysqld-3.23.51-nt] ' MySQL server has gone away ' Got a packet bigger than 'max_allowed_packet' ' Lost connection to MySQL server during query ' Environment: ' WkStn - Windows 2000 WkStn, 256 meg, AMD K6-2 500 mhz, build 2195, SP1 ' MDAC 2.7 ' myODBC 3.51 - WinX ' ' Server - Windows NT 4.0 Server, 64 meg, Pentium II 400 mhz ' mySQL - 3.23.51 - NT ' max_allowed_packet = 4MB - 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 -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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: Slow opening a recordset
Hi !!! Hi all I'm having a performance problem opening a recordset using a CRecordset class (Visual C++). If the table is empty (or contains few records) it takes a very little time to open, but if the table contains many records (about 48000 in my tests) it takes too much time (about 20 seconds) to open. Its because of mysql_store_result(), instead you should check the option 'Don't cache results' to use 'mysql_use_result()'. The table is very simple: CREATE TABLE accounts ( IDAccount int(11) NOT NULL auto_increment, IDUser int(11) , Date timestamp(14) , Status varchar(50) , IDItem int(11) , Qty double , Price double , Visible int(11), PRIMARY KEY (IDAccount) ) TYPE=MyISAM; Of course I tried to 'play' with DSN options and, as suggested in MYODBC faq, I cheched off the options Return Matching Rows , Allow BIG Results and Enable Dynamic Cursor without results. I tried to set the check Don't Cache Results...Force use of Forward-only Cursors and it seemed to work but in that case I had 2 problems: 1. I cannot update/modify records 2. it takes the same long time (about 20 seconds) to CLOSE the recordset Must have client side cursor in this case as driver can't simulate server side/scrollbale cursor on non-cached result sets. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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: ODBC connection from Mysql to Mssql
Hi !!! hey guys i got a scenario here i need to extract some CDR records from a Mssql database into a mysql database and have them available on a website. I have not really configured odbc before, so i am having some problems, i am running SuSE 7.2 on my linux box, i got the the source (myodbc) from mysql.com and followed the instructions in the README, and also got iodbc-2.50.17, but it has failed to install am i missing something out here, or have i missed to install something. Could someone who has done something similar please take me through the procedure maybe i have missed/overlooked something The iODBC is pretty old, better you choose the latest 3.0.6 one from www.iodbc.org. Whats the error you are getting ? It is at configure level or at the compilation or during the setup of the DSN ? You can find complete detailed instructions for all these from http://www.mysql.com/products/myodbc/faq_toc.html under the section '2 : Installation '. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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: RecordCount
- Original Message - From: Steve Edberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 28, 2002 1:49 PM Subject: RE: RecordCount I assume you are using ODBC to access MySQL; I have had this problem before (sorry, don't remember the details...it was several years ago). Some ODBC drivers don't return the record count - they return -1 instead. You might need to update your driver. The myodbc mailing list might be of more help... -steve The ADO rs.recordCount method returns the correct value only when you are using the client side cursor, but server side cursor will always return -1 as the total number of rows in the current resultset, and this is a known issue. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL client unusable with large data sets
Hi, -Original Message- From: Dave Harms [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: MySQL client unusable with large data sets I've been a loyal MySQL fan for a few years now, and use it extensively in web site development. But I've run into a problem now (MyODBC 3.51.03) that is making me reconsider my choice. Most of my database access is local using JDBC, but I have some critical Windows software that relies on MyODBC. On small result sets, no problem. But on large result sets, where MySQL should shine, queries take far too long to complete because MyODBC uses mysql_store_result instead of mysql_use_result. If I change the driver to use mysql_use_result, I run into the Commands out of sync; You can't run this command now error, presumably because there's a new query executing before the first one has been fully fetched. This appears to be a fundamental weakness in the MySQL client library design. The only way MyODBC will be usable to me in the future is if it can retrieve records only as needed by the client, and can do this from multiple tables without closing each query first. Is such a thing possible? If possible, will it happen soon? Thanks. We will be considering this option in the next release, 3.51.04, so that one can enable either cache(mysql_store_result) based or non-cache based(mysql_use_result) resultset handling through the connection flag(OPTION parameter). Actually this implementation was added to 3.51.03 itself, but at the last minute the new code base is removed due to some consistency issues. Currently we suggest you to use option 1+2+2048+ 8192 (only for systems that supports named pipes) in accessing large tables. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 DSN Configuration Dialog Hidden
Hi , -Original Message- From: mySQL list [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:35 AM To: [EMAIL PROTECTED] Subject: MyODBC DSN Configuration Dialog Hidden Hi, I have a vb application which connects to mysql via ado/myodbc 3.51.03. In it, users can choose to connect to databases on different machines. I construct a connection string from the hostname, database etc. So far so good. The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). You can disable the re-connect prompt in ado by using DriverNoPrompt option from your conn.open method. You can also disable the prompt during the failed connection from the DSN using the option 'Don't prompt on connect'. And as far as hidden dialog, am not sure how does that come in to picture as we use XP and 2000 for all internal testing. Can you cross check whether the dialog is really active by using 'alt-tab' ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL Access 97 slow
-Original Message- From: Tom Worobec [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:56 AM To: MySQl Lists Subject: MySQL Access 97 slow Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC? Unless the table is too big, it shouldn't take much time. Make sure no debug and/or traces enabled for the driver/ driver manager. Check with the new version of the driver 3.51.03 that is released yesterday. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: core dump, multithreading using MyODBC on Solaris
Hi, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 01, 2002 8:56 AM To: [EMAIL PROTECTED] Subject: core dump, multithreading using MyODBC on Solaris Hello, I'm using MyODBC 3.5 on Solaris. From time to time I get segmentation/bus error when using in a multithreaded environment. Looks always in the same place '_db_return_'. Each of my threads has its own connection. To be more accurate I'm using OTL http://members.fortunecity.com/skuchin/home.htm to wrap the MyODBC as I compile my code with Workshop compiler. The OTL was initialized with multithreaded flag turned on. So it is either my code, OTL, or MyODBC 3.5 on Solaris. But after checking my code and OTL I suspect the MyODBC implementation. Have you seen this also? Do you know any workaround? Regards, Can you please provide me the coredump of this ? Also, can you try by building the driver with DBUG_OFF flag ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: @@IDENTITY
-Original Message- From: Richard Davidson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1:31 PM To: MySql List; [EMAIL PROTECTED] Subject: FYI: @@IDENTITY I don't know if this is just weirdness on my system but I thought I would pass this on in case anyone runs into this problem. I'm converting some Java/JDBC code from a commercial DBMS to MySQL. The existing code executed the SQL statement Select @@identity after an INSERT to retrieve the autoincrement value. But, MySQL would never return from this query -- just hang until I stopped and restarted the service. After some trial-and-error-and-error, I found that @@IDENTITY worked as expected but @@identity would cause this hang symptom. Moral of the story: don't use lower case letters in SELECT @@IDENTITY. This is fixed from MySQL 3.23.50 and 4.0.2 versions, so you can give a try with the 3.23.50 from: http://www.mysql.com/downloads/mysql-3.23-pre.html Make a note that, the Windows binaries are not pre-releases, and they are official and can be used in production. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490
Hi Monty, venu == venu [EMAIL PROTECTED] writes: cut venu MySQL/MyODBC does accept connection timeout. Here is the code venu snippet from driver: venu case SQL_ATTR_CONNECTION_TIMEOUT: venu DBUG_RETURN(mysql_options(dbc-mysql, MYSQL_OPT_CONNECT_TIMEOUT, venu (const char *)((SQLUINTEGER)ValuePtr))); venu break; venu So, driver does set correctly. Make a note that, the value '0' means venu default in ODBC, and that means no timedout. Venu, the above code is slightly wrong: To be 100 % correct, it should be: case SQL_ATTR_CONNECTION_TIMEOUT: { uint timeout_argument= *(SQLUINTEGER*) ValuePtr; DBUG_RETURN(mysql_options(dbc-mysql, MYSQL_OPT_CONNECT_TIMEOUT, (const char *) timeout_argument)); } Small update .. This is true if ValuePtr is a SQLUINTEGER *, but it is SQLUINTEGER. Here is the spec contents for this one .. An SQLUINTEGER value corresponding to the number of seconds to wait for any request on the connection to complete before returning to the application. The driver should return SQLSTATE HYT00 (Timeout expired) anytime that it is possible to time out in a situation not associated with query execution or login. If ValuePtr is equal to 0 (the default), there is no timeout. The SQLSetConnectAttr will get the SQLUINTEGER value as: retcode = SQLSetConnectAttr(hdbc, SQL_ATTR_CONNECTION_TIMEOUT, (void*)5, 0); So, the possible option could be the caller(DM/App) is not passing the correct data to the driver. Richard, can you please send us the log file for this, so that it will enable what is happening. I just even tested the behaviour and it just works fine. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: VC++6.0 MFC app with MyODBC 2.50 no cursor name avb.
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 18, 2002 5:17 AM To: [EMAIL PROTECTED] Subject: VC++6.0 MFC app with MyODBC 2.50 no cursor name avb. I get a No cursor name available window in an Visual C++ 6.0 MFC application whenever i try to make updates to the database. I use a CRecordset class to connect to the database trough MyODBC 2.50.39. MySQL server is 3.23.49 stable release on Windows 2000 Pro. I'm kinda new in the area of MySQL. If someone could help me it would get me out of a lot of trouble. Thanks ! Check the list archive .. http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:5441:200205:nkckmapjdedbik boiogc Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490
Hi, -Original Message- From: Richard Morton [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 4:14 AM To: MySQL List; Mysql Bugs; MyODBC Subject: FWD: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490 please see below -- Forwarded Message -- FROM: euro.support [EMAIL PROTECTED] TO: Richard Morton [EMAIL PROTECTED] DATE: Fri, 17 May 2002 10:26:06 +0200 RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490 Hi Richard, I have received an answer from our dev team, please see below: -- MySQL does not accept SQLSetConnectAttr function for setting the SQL_ATTR_CONNECTION_TIMEOUT which is added recently to the same value as the query timeout. Unfortunately although it is legal ODBC 3.0 parameter MySql crashes instead of reporting error if it does not support it. This should be considered MySQL bug. MySQL/MyODBC does accept connection timeout. Here is the code snippet from driver: case SQL_ATTR_CONNECTION_TIMEOUT: DBUG_RETURN(mysql_options(dbc-mysql, MYSQL_OPT_CONNECT_TIMEOUT, (const char *)((SQLUINTEGER)ValuePtr))); break; So, driver does set correctly. Make a note that, the value '0' means default in ODBC, and that means no timedout. How does MySQL crash for this parameter ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Code is changed in PU 8 not to call this function if timeout is set to 0. I will post here just a FDbase.fdl which can be used even on PU007 Release. But customer still needs to change its script to set query timeout to 0. How-To-Repeat: - 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: Any ideas how to speed this up?
Hi, -Original Message- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 2:00 PM To: 'Alexander Shaw'; MySQL List Subject: RE: Any ideas how to speed this up? What version of the ODBC Drivers are you using? I had a VB app using the 3.5x versions of the ODBC driver manipulating very small tables and it was absolutley painful to run. Hmm, I don't *really* agree on this lines. The 3.51 is using the same 2.50 code base with extensions that will not cause the performance issues like this. There is a chance that you enabled OPTION=32 from 3.51 which causes this issue, as this option will enable the driver to fetch the latest data from server. Make sure you turn off this option as well as other debug options, if there is any. If you still feel the driver is talking extra time, then please let me know, so that if there is anything we can incorporate in 3.51.03, which will have lot of code cleanups. Also, the performance will be increased drastically with 4.1 protocol, which is tuned to have best performance from all client APIs with lot of advanced features. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: ODBC Problem.....
Hi, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:28 AM To: [EMAIL PROTECTED] Subject: ODBC Problem. I've downloaded a version of MySQL ODBC Driver from The MySQL.com site named [ myodbc-2.50.36-win95.zip ] which is supposed to be supported on an Operating System of Win98 but when i installed it on a Win 98 Second Version Operating System it installed itself without any error messages whatsoever but the Mysql Driver was actually not installed ...i've tried to reboot my system several times but alas the driver wasn't to be found ny the operating system Was it the Driver Version that was faulty ? Is that driver version not compatible with Win98 second version? Could i please get a feedback from that problem First, You should be either Administrator or should have admin privileges, to see the driver listing from ODBC Adminstrator. Second, Please make sure to use the latest one 2.50.39(stable) or 3.51.02(development) versions avaialable from http://www.mysql.com/products/myodbc/ I recommend you to start with MyODBC 3.51.02. If you have any further questions, please send a detailed mail to mailto:[EMAIL PROTECTED] Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 Question
Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:35 PM To: [EMAIL PROTECTED] Subject: MyODBC Question I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. That is supposed to be for the fix for invalid mapping of SET and enum types from other vendors while migrating (MSSQL, ACCESS, DTS and all conversion tools), else the behaviour is not expected. One magic here is that, if you set this to CHAR(..) then the Access 97 works, and if it is VARCHAR(..) then All other ACCESS (98, 2000, XP) works, but 97 fails. We are trying to fix this issue in next versions to have a common procedure by allowing TEXT type to accept field size. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: mySQL PervasiveSQL
Hi, -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 1:05 PM To: 'Andrew Hazen'; [EMAIL PROTECTED] Subject: RE: mySQL PervasiveSQL [snip] Now here's a bit of an oddball question: I am building a php/mysql web app that will be linking with an accounting system in PervasiveSQL. Right now the various pieces of the web app are built in mySQL. Is there a way to do JOINS between tables in the two different databases? [/snip] No. You can't at present. The problem that you will run into is connecting to both databases. Normally in PHP you use something like the following to connect to a single database; $dbconnect = mysql_pconnect(127.0.0.1, user, password); mysql_select_db(mydatabase, $dbconnect); Using the PHP native connections to MySQL. Assuming PervasiveSQL has an ODBC connection available it can be done. I have seen it done, here are some examples with 2 MySQL databases; All these represent the query manipulatation in individual database either by establishing each connection to a database or by switching between the databases(catalogs). Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 Question
Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? You can always make use of TEXT, MEDIUM TEXT, LONG VARCHAR, .. and similarly for BLOBs. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 Question
Hi, Please call SQLGetTypeInfo with SQL_LONGVARCHAR, then you get the results what is expected. Here is the output snippet: SQLGetTypeInfo: In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARCHAR=-1 Return: SQL_SUCCESS=0 Get Data All: .. long varchar, -1, 16777215, text, -1, 65535, mediumtext, -1, 16777215, 3 rows fetched from 19 columns. SQLGetTypeInfo: In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARBINARY=-4 Return: SQL_SUCCESS=0 Get Data All: .. long varbinary, -4, 16777215, blob, -4, 65535, longblob, -4, 2147483647, tinyblob, -4, 255, mediumblob, -4, 16777215 5 rows fetched from 19 columns. Ok, also, you said you got TEXT max size as 255 in the prepares, do you have any log on that ? Because the driver won't return the length as 255. The mapping in SQLGetTypeInfo is intended for SET and ENUM not for direct TEXT, so it won't affect what you are describing. You can see that the TEXT deals separatly in the same SQL_GET_TYPE_INFO_values which returns the max length as 65535. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question I don't mean to beat a dead horse here, but when the backend checks the length of the datatype for the columns to prepare the statment, the TEXT column comes back as length of 255 so my 1,500 char string gets cut off. Is there a datatype that the MyODBC driver will return as character data greater than 255? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:45 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? You can always make use of TEXT, MEDIUM TEXT, LONG VARCHAR, .. and similarly for BLOBs. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: How to make the Win target from source?
Hi !! -Original Message- From: Dennis George [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 28, 2002 11:10 AM To: MySQL List Subject: How to make the Win target from source? I downloaded mysql-3.23.49-win-src.zip. There are various files missing (e.g. Makefile) that would enable compiling with gcc. Has anyone out there made mysql from source on Win platform with gcc? I had been trying to compile my own client but was getting a lot of undefines at link time - the instructions said that mysql should be remade from source to solve this problem. I am stuck trying to do that. If you want to build the server from source on Windows, there are two ways: 1. Using VC Project: Download the VC project(s)(the above one) and extract the files to a desired folder. Once extracted, load the 'mysql' workspace to VC Editor and start building. If you encounter any problems, just post the error message, then we can guide you how to proceed further. 2. Using cygwin Environment: Through this is not a recommended way, you can give a try. Download the linux source and extract it to a folder and start building it in the normal way by configuring or by using any of the scripts from BUILD/ which suites your needs. We don't recommend the build process on Windows except if you want to debug. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Multi Line SQL Statements
Hi !! -Original Message- From: Michael Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:51 PM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject: Re: Multi Line SQL Statements It's The MySQL Control Center program. I can take and save the sql statements from Mycc to a text file and call MySql c:\sql.txt and it runs fine... MySQL 4.1 will have a better solution for this, which allows multi query execution directly in server side. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Gerald R. Jensen wrote: Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2)); Query OK, 0 rows affected (0.06 sec) mysql create table zipstates (state char(2), zip char (5)); Query OK, 0 rows affected (0.06 sec) Put the same query in a script piped into MySQL with same results. How are you entering a multiple SQL statement? Gerald Jensen - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 6:59 PM Subject: Multi Line SQL Statements I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create table ZIPSTATES (state char(2), zip char(5))' at line 1 What am I doing wrong? mike ps: I am using MySQL Control Center 0.8.2 alpha - 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, MyODBC and MS Access
Hi !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 11:52 PM To: [EMAIL PROTECTED] Subject: MySQL, MyODBC and MS Access Hello! You are my last chance, reading FAQs and asking in newsgroups gives no effect. I have a problem when connecting a MySQL table in MS Access (2000) through MyODBC. MySQL is ver. 3.23.44 running on FreeBSD 4.5 box. Description of the problem: I connect the table and Access correctly retrieves data. But when user tries to add data or to change any field, access performs an error box that some another user has changed this field when you were changing it, but actually nobody was connected to MySQL at that time. This problem takes place only in Windows'98. When I perform the same operation from Windows XP all is correct. Maybe I have to make some additional settings for MyODBC (version 2.50.39-win95) in Windows98? Please help. Thanks in advance! You should set the OPTION=2. I think its listed in the FAQ too. Coming to XP, whats your Access version on XP ? (that might be a latest version, which has many fixes towards ODBC that exists in older versions :) Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL subtracting an hour from DATETIME types I insert?
Hi ! -Original Message- From: Richard Bolen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:25 PM To: MySQL Mailing List (E-mail) Subject: MySQL subtracting an hour from DATETIME types I insert? I have a java application accessing MySQL via the mm.mysql type 4 jdbc driver. It appears that when I insert a record with a DATETIME type in it, it's subtracting an hour from the time. Does anyone know why this might be happening? Is it a timezone or daylight savings time issue? My server daemon has 'eastern daylight time' as the timezone, which I believe is the correct timezone. I have the same application running on top of an Oracle DB and the times are stored correctly. It got fixed in 2.0.9, so you should try the latest version. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: download latest odbc-driver
Hi !! -Original Message- From: Ralph Walther [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:43 PM To: [EMAIL PROTECTED] Subject: download latest odbc-driver hi, if i try to download the latest odbc driver i get a file with 43k. what is wrong ? the original file on http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K... what have i to do? It should be ~600k only. Please try from another mirror, and if nothing works out try from ftp. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Creating a mysql database usinc VC++
Hi !! -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 1:39 PM To: Guy-Maurice Lepoutre; [EMAIL PROTECTED] Subject: Re: Creating a mysql database usinc VC++ On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote: Hello, I wondered if there is a way to create a mysql database using Visual C++ 6.0. I don't want the database to be registered, I want the program to create the database for me. Certainly. If by no other way, execute a batch file to do this. You cannot, afaik, do this using ODBC. That's a limitation of ODBC. You only have three options, which uses ODBC internally. 1. Making use of direct VC Database project: Just create a VC project called 'Database project' (under new - projects), upon entering the project name, it displays the ODBC DSN dialog, and you can continue from their by extending the code. 2. Making use of MFC ODBC (Direct) Classes: Another option is, write your own code using MFC ODBC classes. For more information, refer to MSDN under 'CDatabase' class, which directs you in the right path. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/htm l/_mfc_cdatabase.asp 3. Making use of MFC DAO(CDAO*) classes. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/htm l/_mfc_cdaoworkspace.asp Hope this helps you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Begging for help.
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 30, 2002 12:40 PM To: [EMAIL PROTECTED] Subject: Begging for help. Hi all, Begging for help. Newbie so please keep solutions as simple as possible please. I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine running mysql version 3.23.44. What steps do I take ? Unfortunately do not know enough about linux and Mysql to understand the manual. Simple steps are here .. http://www.mysql.com/products/myodbc/faq.html#Remote_connection Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Coldfusion,Mysql,Myodbc
Hi !! Sorry for the delayed response on this. Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. What type of compilation errors ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL, MyODBC and MS Access
Hi ! -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 11:19 PM To: MySQL List Subject: RE: MySQL, MyODBC and MS Access This seems to be a very common question that appears very frequently on the group, in fact one I have asked in the past too. Could I stick my head over the parapet and suggest a person or persons with experience of Access front ends and MySQL backend puts together an FAQ for this, or better still it's included in detail in the documentation? Most of the common question got answered from online MyODBC faq from: http://www.mysql.com/products/myodbc/faq_toc.html If you find something is missing or wants to add under MSAccess section, then please send a mail to mailto:[EMAIL PROTECTED] with details. Thanks. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Slow query
Hi !! -Original Message- From: m.colurcio@ [mailto:[EMAIL PROTECTED]]On Behalf Of Massimo Colurcio Sent: Friday, March 15, 2002 1:59 AM To: [EMAIL PROTECTED] Subject: Slow query Hi all. I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry) accessing to database via ODBC (MySQL ODBC release 3.5.01.01) and VC++6.0 MFC (CRecordset). I have noticed that queries are really slow... with a simple SELECT like this: SELECT ID_Field, Text_Field, Date_Field, Num_Field FROM mytable ORDER BY Num_Field the server takes about 31 seconds to show all the 2872 records. I tried to modify some parameters in the DSN and I noticed that checking 'Use compressed protocol' the same query takes only about 6 seconds to complete and I said That's great : I have used for the tests WinSQL (www.indus-soft.com/winsql) and -of course- the program I'm developing. Now I would like to know: Am I doing something wrong? No. There is nothing wrong in using the compressed protocol. Also, the current dynamic cursor behaviour slows down the performance drastically. I am working on this to have a different logic, and probably included in the next 3.51.03 version. I recommend you to use 3.51.02 instead of .01 as the new one has lot of fixes and improvements on Windows. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)
Hi !! -Original Message- From: Markus Lervik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:22 AM To: [EMAIL PROTECTED] Subject: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie) Hello, list! I'm not quite sure that this is the right place to ask, but I'm having problems getting MySQL and ColdFusion Server 5 to work together. I have a ColdFusion server that connects to MySQL via ODBC. I've configured the Merant MySQL ODBC driver via the ColdFusion administrator, and it is able to connect to my MySQL database (at least it claims that the connection was successful when clicking verify in the CF admin). The datasource name is hpTest. However, trying to connect to the database in an CFM doesn't seem to work at all. My error message is ODBC Error Code = 08003 (Connection not open) [MERANT][ODBC lib] Connection not open The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:114). and the code goes like this: cfquery name=Test dbtype=ODBC dbname=hpTest datasource=hpTest SELECT * FROM hpTest /cfquery cfoutput query=hpTest#FieldName1#, #FieldName2#br/cfoutput I've been reading TFM, browsing TFW, reading TFML and I've even been to (*ghasp*) Microsofts ODBC-pages looking for an answer (and you know it's -bad- when that happens!g). Reading the manual I got the impression that coldfusion would open the connection when using a cfquery-tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. We don't recommend to use third-party drivers with MySQL unless if they are from our parters or directly linking with MySQL. As we never tested the above driver(s) with MySQL, we can't comment any thing. We appriciate if you can make use of the following MySQL ODBC Drivers, as they are tested and working fine with CF. - MyODBC 2.50 (stable) and - MyODBC 3.51 (developmemt). For more information about MySQL ODBC, refer to http://www.mysql.com/products/myodbc/ Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: ADO API ODBC Alternative help
Hi ! -Original Message- From: Nick Gorham [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 5:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ADO API ODBC Alternative help - When I hit the line setting value of password, I get the following message: Run-time error '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. If you (or any one else) finds what causes this could you please tell me, I have just the same problem with our interbase driver, but I can't for the life of me see what the problem is. It works to SQL Server, but not Interbase. For what its worth Microsofts Access ODBC driver also generates this error, so we are not alone. Check the online MyODBC faq, which has a working ADO code with AddNew and Update methods. http://www.mysql.com/products/myodbc/faq.html#SAMPLE_-_VB Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Leaking Handles
Prasad, -Original Message- From: Prasad Gurav [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 10, 2002 10:37 PM To: [EMAIL PROTECTED] Subject: Leaking Handles Hello, We are using MySQL as the database for our product . The frontend is in VC++ . The environment is as follows :- 1) MYSQL version 3.43.23 2) MySQL ODBC Driver Version 3.51 3) WIN NT Server Version 4.0 SP6 We have observed that if a global connection to the database is kept open for a long time the handle count increases . Approximately 24 per hour . The handle count can be seen by using the Task Manager . The application has to work with 2500 simultabeously open tables. Can some one suggest any solution ? Best Regards Prasad Gurav We fixed this Windows handle leak just couple of days back and fix will be there for 3.51.03. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Client installation by itself?
Hi, -Original Message- From: Scalper [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:53 AM To: [EMAIL PROTECTED] Subject: Re: Client installation by itself? I asked this question as well some time back and got the standard answer 'READ THE MANUAL'. However, I still never found the answer to my question, so when I get closer to deployment, I am going to experiment. I am thinking that only MyODBC installation is required on the client and possibly one or more of the following files: libmysql.dll libmysql.lib mysqlclient.lib Perhaps someone can shed some light on this? Otherwise, I am going to have to just do some trial and error. Let me know, Carl, if you find out. If you are using MyODBC binary, you don't need any of the above. If you want to build the driver yourself from source, then you need mysqlclient.lib and client headers. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Naming a Provider?
Hi, -Original Message- From: D Nyberg [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: Naming a Provider? Guys, I'm very new to ODBC, so please bear with, okay? I'm looking at example code in a particular windows binding package, and see the following: ... -- Open Database Open (DB_Control.Database, Provider=Microsoft.Jet.OLEDB.4.0; Data Source=..\..\tutorials\adotest.mdb); ... That statement succeeds in opening that mdb (Access) file for further manipulation. I have no idea where they came up with the information that the way you connect with an access database is to use the incantation Microsoft.Jet.OLEDB.4.0. Likewise, I have no idea what comparable magic string would specify a mysql database. 1) What string would I substitute into that code sample to connect with a mysql database instead of an access database? It depends up on which provider and programming language you are trying to use. To know what connection string(s) can be used to access MySQL through (My)ODBC, refer to the following samples: http://www.mysql.com/products/myodbc/faq.html#SAMPLE_-_VB 2) What document should I have been looking at to discover that for myself? MyODBC : http://www.mysql.com/products/myodbc/ ODBC : http://www.microsoft.com/data Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 3.51 build for Mac OSX
Hi, -Original Message- From: Brian Reed [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: MyODBC 3.51 build for Mac OSX Sorry, Im new here and Im sure this has been discussed ad naseum, but does anyone have information on where to get an installer for the Mac OSX version of the MyODBC drivers? The latest build I could find on the web is 2.5. The 3.51 Mac build is not available for downloads. Possibly will add from 3.51.02 versions onwards. The alternative is to download the source and build the driver yourself. Here is a mail which describes how to build 3.51 driver on Mac. http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4816:200202:kikmibdplecdpppfcd jm Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL + Access + MyODBC + LARGE Tables
Hi, -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:04 PM To: MyODBC Mailing List; MySQL List Subject: RE: MySQL + Access + MyODBC + LARGE Tables All, there were many emails posted about this on the MyODBC list which, of course, can be viewed via the archive on the mysql.com site. For the most part I will neither quote nor repeat the information from those emails here. The conclusion is that MySQL + Merge Tables is perfectly capable of being a data warehouse and is in fact better in most regards when compared to other RDMBS. One example: For similar record counts and identical index definitions, speed wise MySQL and the other rdbms are about the same when the query is disk bound (e.g. the index is not cached). MySQL is 5-10x faster than the other rdbms in the cached index case. There are many other benefits as well. (I will not name the other commercial RDBMS out of fear of lawyers, the DCMA, and posting unauthorized benchmarks. You will have to trust me that it is a major RDBMS, MySQL is /fast/ comparatively, and that I am not an idiot at setting up and optimizing databases.) Using MyODBC-3.51.01.01 works fine to access the MySQL database via MS Access. Venu (bless him for all of his help) is going to add information to the FAQ as such: In the large table case one needs to check off three options Return Matching Rows, Allow BIG Results, and Enable Dynamic Cursor. I needed to do one last truly terrible hack to MyODBC (patch below) so that if someone tries to open a very long table (43M rows in my test case) bad things don't happen as MySQL tries to copy the results to a temporary table/file. Perhaps there could be a config for Max Rows When There Is No Criteria in MyODBC? Yes. I had this option in mind before the release of the 3.51 driver, but certainly lost the control on that. As you know, the current MyODBC drivers lacks performance if the table size is too big as it tries to cache everything internally, and that causes the issue. We can introduce the following options: - Use cache results, set the max limit size --- - Don't use cache results, get the row based on the request. Will discuss this with 'monty' when he is back and lets see how it goes. Even this logic could be used for the new interfaces for MySQL that are under discussions. In the next month or two I will try to write an article describing what I did in more detail so that everyone may benefit. Really a good idea, and most of the Access users who are suffering from performance issues should be able to benefit out of this. b. [bill@badams bill]$ cat myodbchack.patch --- ../myodbc-3.51.orig/execute.c Fri Feb 22 10:55:35 2002 +++ execute.c Fri Feb 22 10:53:48 2002 @@ -72,7 +72,26 @@ query=tmp_buffer; } } - } + } + /* Terrible hack by Bill Adams */ + else if( + !my_casecmp(query, select, 6) + my_casecmp(query, where, 5) + my_casecmp(query, limit , 7) + ){ +/* Limit the number of rows when someone does a query without + any criteria */ +char *tmp_buffer; +uint length=strlen(query); +if ((tmp_buffer=my_malloc(length+30,MYF(0 + { + memcpy(tmp_buffer,query,length); + sprintf(tmp_buffer+length, limit %lu, 2); /* Arbitrary */ + if (query != stmt-query) + my_free((gptr) query,MYF(0)); + query=tmp_buffer; + } + }/* End Terrible Hack */ pthread_mutex_lock(stmt-dbc-lock); if (check_if_server_is_alive(stmt-dbc) || mysql_query(stmt-dbc-mysql,query)) Thanks for the patch. The above should do the work on this. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 Blocking Table for DROP request ?
Hi, -Original Message- From: Fabrice Schleifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:31 PM To: [EMAIL PROTECTED] Subject: MyODBC Blocking Table for DROP request ? Hello everybody, here is a strange thing that creates me nightmares ... How-To-Repeat: Stage 1 . Using a my SQL GUI : Create a simple Table ... create table FAKE (bidon integer) Everything works fine ... Stage 2. Using a C compiler and MyODBC3.51 Driver (actually I use Borland as C Compiler) cut Everything successes in this code , always SQL Success is returned ( note: I removed the lines that use the result set of SQLColumns.. because of no interest ..) Stage 3. Using the GUY , try to erase the table ... DROP table FAKE Message : Error on delete of '.\LemoineDB\fake.MYI' (Errcode: 13) (I think this is an permission problem) I am almost sure I habe all the permissionss : I cannot succeed in deleting the table until I stop the server and restart it . Once the server is restarted I can drop the table using the command above with no problem . Other test I did : If I comment out the SQLColumns API , everything works fines from stage 1 to 3 . Fix: I have to restart the server to drop the tables ..(that not a fix ) :--))) See also information below and joined the MyODBC.log I created running the code . Please , give me a quick answer even if no quick solution . I could able to reproduce the bug, and will fix it for the next release versions by finding the exact cause (possibly some where we are not closing the opened session while using the mysql_list_fields()). The immediate work around is to execute FLUSH TABLES before you try to drop it, that way you can eliminate the server shutdown. And, thanks for the good functionality bug. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: GetDefaultConnect
Hi, -Original Message- From: Massimo Colurcio [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 6:19 PM To: [EMAIL PROTECTED] Subject: GetDefaultConnect Hi, I'm having some problems using MySQL ODBC Driver release 3.51. When I try to call GetDefaultConnect() from an opened CRecordset object (Viual C++ 5.0, MFC), I see a 'weird' behaviour of the driver; the return string is: ODBC;WeissDBMySQL ODBC 3.51 Driver;DESC=;DATABASE=WeissDB;SERVER=lovalhost;UID=weissdb;PASSWOR D=;PORT=;OPTION= 16387;STMT=; ['WeissDBMySQL ODBC 3.51 Driver' should be 'DNS=WeissDB'] This is a know issue due to invalid build of the driver from different src tree, and was fixed last week itself. To have a fix, you need collect the patch and apply it from: ftp://support.mysql.com/pub/mysql/hidden/myodbc/MyODBC-3.51.01.01.zip Or, pull the latest code from development tree, and build the driver yourself. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL + Access + MyODBC + LARGE Tables
Hi, Monty, Venu, I hope you read this... :) I really, really want to use MySQL as the database backend for my datawarehouse. Mind you I have played around with merge tables quite a bit and know that MySQL is more than up to the task. There are numerous (not necessarily cost related) reasons as to why MySQL is better for my application. If it were just me, it would be a slam-dunk as I only use perl, etc. to extract data from the database. However most of my users use MS Access as a front end and extraction tool. When pulling datasets from a database, Access tries to be smart and if there is what it thinks is a primary key on a table, it will extract the values of the primary key for the matching records and then re-query the table with a parameterized query to get the rest of the values. This is true in both the case where a user tries to view a table or runs a simple query. Taking a simple case of the user opening the table in data sheet view (if this is solved, the other cases will be solved too), the following happens -- okay, this is a bit simplified, see my message Large Datasets w/Access for better background: http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4918:200202:bjcebaok cknfmaldpokp -- Access opens a statement handle (#1) and queries the table for the primary key values. E.g. It would pass SELECT idx FROM TABLE. Note that it only cares about getting a partial list here. I.e. if the screen only shows 10 records, Access only cares about 10 primary key values. -- Access opens a second statement handle (#2) without closing the first handle and then gets the values in a parameterized query. E.g.: SELECT a, b, idx FROM table WHERE idx=? OR idx=? It then pulls the records it cares about with this statement and closes the statement. -- If, say, the user presses page down, [I think] access then gets the next set of primary key values from statement handle #1, sets up another prepared query and gets the values as above. MyODBC, as compiled today, uses mysql_store_result to get records. This is fine for reasonably sized tables. However, if the table has millions of records, writing the results to a temporary table has many detrimental effects, e.g.: Access seems to hang from the user's perspectiv, Access crashes because there are too many records for it to handle at once (data requirements to great); MySQL creates HUGE temporary tables or bombs if SQL_BIG_RESULT was not set. Probably we can add extra DSN options, to make use of either mysql_store_result() or mysql_use_result(). In the second case, lot of code change is needed in all result set dependency APIs too. So in the case of a very long table, it is important to use mysql_use_result instead. This makes it so that results are returned right away and eases the load on all programs involved. The astute reader will realize that if one uses mysql_use_result and does not fetch all of the records, the next query will return the remaining records from the previous query first. It follows that Access bombs because in statement #2 it is getting results from statement #1. (This is seen from the myodbc.log line: | error: message: Commands out of sync; You can't run this command now in the myodbc3.dll changed to use the said function.) Can you be more specific on this ? And a MS ODBC DM trace will be better to analyze. The bottom line is that in order for MySQL + Access + MyODBC to be usable as a datawarehouse MySQL/MyODBC (a) must be able to return uncached results; and (b) be able to have multiple statements open, active, and with pending data to be fetched at the same time. Try to use Dynamic Cursor Type (OPTION=32) in MyODBC 3.51. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 BDE invalid configuration error (BDE Error 12550)
Hi, -Original Message- From: Guido Sohne [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 6:54 AM To: [EMAIL PROTECTED] Subject: MyODBC BDE invalid configuration error (BDE Error 12550) We're running a MySQL 3.23.47 server on Windows 98, and when trying to connect to BDE version 3.0 (bundled with Borland C++ Builder 1) using MyODBC version 3.51 we get something like Invalid configuration parameter: Alias: database_alias BDE Error 12550 [0x31][0x6] I've searched the list archives and realize that some people have occasionally come across this problem but haven't found a solution or an indication of what the problem is ... Is it possible for you to trace MS ODBC DM calls and send that log ? That enables the clear picture of what is happening. I tried to download the eval copy of Borland C++ Builder to give a try, but it is ~140 MB, so waiting for your log. If it doesn't help, then I will go ahead and give a try by downloading. Borland,s web site says of BDE Error 12550 12550 Invalid configuration parameter. One possible cause for the error: ODBC ALIASES. When creating and/or using a BDE alias that is using an ODBC DSN make sure that the ALIAS parameter ODBC DSN is set to the DSN that you wish to use and that has been created using ODBC Manager. Available ODBC DSN's can be chosen from the parameter's drop-down edit using the BDE Administrator. Another possible cause: Using ISAPI app and ODBC against NT web server. ODBC DSN on NT machine should be set to system instead of user. Did you tried with the 'system dsn' or 'file dsn' ? And whats the outcome ? For more information on different types of DSNs, refer to http://www.mysql.com/products/myodbc/faq.html#DSN_Types Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Error in myodbc 3.51.01.00
Hi, -Original Message- From: Peter Klinge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 5:33 AM To: [EMAIL PROTECTED] Subject: Error in myodbc 3.51.01.00 Dear all, today I have switched from myodbc 2.50.39.00 to 3.51.01.00, because I had a problem using SQLColumnPrivileges (see below) After that I couldn't use my application because of the ConnectionHandle was destroyed. After logging the application I have found, that there is an problem inside of SQLGetInfo. I made a call: SQLHDBC hdbc=NULL; SQLUSMALLINT MaxStatementHdls; SQLSMALLINT len; SQLGetInfo (hdbc, SQL_ACTIVE_STATEMENTS, MaxStatementHdls, sizeof (MaxStatementHdls), len); SQLAllocHandle (SQL_HANDLE_STMT, hdbc, hstmt); after SQLGetInfo and before SQLAllocHandle, the hdbc lost his low part. The reason for that seems to be the variable MaxStatementHdls defined as SQLUSMALLINT (like the description of ODBC in MSDN). len says, that in MaxStatementHdls will be returned a value with a lenght of 4 (instead of 2). As work around I have changed the definition of MaxStatementHdls from SQLUSMALLINT to int. (see attached file sql.log) SQL_ACTIVE_STATEMENTS is deprecated/renamed in ODBC 3.x spec, and the new one is SQL_MAX_CONCURRENT_ACTIVITIES. You should try to use this with 3.x applications. SQL_MAX_CONCURRENT_ACTIVITIES returns SQLUINTEGER only, though it was a typo error as SQLUSMALLINT in ODBC spec. And this is my original problem - but here I can't find a reason: If I try to call SQLColumnPrivileges (hstmt, NULL, 0, NULL, 0, (SQLCHAR*)patdat, SQL_NTS, NULL, 0) ? I get a error message [Microsoft][ODBC Driver Manager] Driver does not support this function if I use myodbc V2.50. If I try to do the same with myodbc V3.51 I will get [mysqld-3.23.43]Driver doesn't support this yet. But the documentation says, this functions is included in both versions. We don't support yet. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: blob field
Hi, -Original Message- From: Shankar Unni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 9:29 AM To: Yoram Naim Cc: '[EMAIL PROTECTED]' Subject: Re: blob field [redirecting to mysql list because of general interest] Yoram Naim wrote: Can some one send me a code sample (C , CPP ) How can I copy file data to MYSQL BLOB field but not in one piece . Is this even possible? If so, I'm sure that the JDBC driver could use such a feature to stream large blobs to the database (currently, in 3.23, we're stuck with the 16MB single-packet limitation). -- Its possible with MyODBC Drivers to 'n' size. You can supply BLOB/CLOB data in pieces to desired size by making use of SQLParamData and SQLPutData APIs. Here is a simple examples using 'C-ODBC'. 1. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbc sending_long_data.asp 2. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbc sqlputdata.asp I think it should also be possible with MmDriver, but never tested. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:42 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again Venu, I tried the latest one. I'm sorry to say that the error persists... Still leaking handles at terrible speeds. One handle for each select even if we close the set. You mentioned something regarding a new version of the server engine as well... Is this going to be released soon? Does this affect this issue? Perhaps this fix just works with ODBC server of later versions and not only the ODBC one. Hmmm, am sorry. Actually the 8k leak fix(charset and initialization) was there in .47 version of server and 3.51.01, together should be able to work out. If it happens with the above configure, could you please able to trace back the call sequence of leaks ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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
Hi, when I use the wizard to configure the data source in .NET, it throws an error, unable to use this connection or something. What is this **configure the data source in .NET** ? Can you please elaborate ? FYI : I used the following compilation options: csc /t:exe /out:mycon.exe mycon.cs /r:System.dll /r:System.Data.dll /r:C:\WINNT\Microsoft.NET\Framework\v1.0.2914\System.Data.Odbc.dll And here is the simple C# sample using ODBC.NET (though its not perfect sample) to makeuse of BIGINTs fetch with MyODBC 3.51 driver. /** * @sample: mycon.cs * @purpose : Demo sample for ODBC.NET using MyODBC or MyODBC 3.51 * @author: Venu, [EMAIL PROTECTED] * * (C) Copyright MySQL AB, 1995-2002 * **/ using Console = System.Console; using System.Data.Odbc; namespace myodbc3 { class mycon { static void Main(string[] args) { try { //Connection string for MyODBC /*string MyConString = DRIVER={MySQL}; + SERVER=localhost; + DATABASE=test; + UID=venu; + PASSWORD=venu; + OPTION=3; */ //Connection string for MyODBC 3.51 string MyConString = DRIVER={MySQL ODBC 3.51 Driver}; + SERVER=localhost; + DATABASE=test; + UID=venu; + PASSWORD=venu; + OPTION=35; // Dynamic cursor support OdbcConnection MyConnection = new OdbcConnection(MyConString); MyConnection.Open(); Console.WriteLine(\n !!! success, connected successfully !!!\n); //Connection Console.WriteLine(Connection Information:); Console.WriteLine(\tConnection String: + MyConnection.ConnectionString); Console.WriteLine(\tConnection Timeout: + MyConnection.ConnectionTimeout); Console.WriteLine(\tDatabase: + MyConnection.Database); Console.WriteLine(\tDataSource: + MyConnection.DataSource); Console.WriteLine(\tDriver: + MyConnection.Driver); Console.WriteLine(\tServerVersion: + MyConnection.ServerVersion); //Create a sample table OdbcCommand MyCommand = new OdbcCommand(DROP TABLE IF EXISTS my_odbc_net,MyConnection); MyCommand.ExecuteNonQuery(); MyCommand.CommandText = CREATE TABLE my_odbc_net(id int, name varchar(20), idb bigint); MyCommand.ExecuteNonQuery(); //Insert MyCommand.CommandText = INSERT INTO my_odbc_net VALUES(10,'venu', 300); Console.WriteLine(INSERT, Total rows affected: + MyCommand.ExecuteNonQuery());; //Insert MyCommand.CommandText = INSERT INTO my_odbc_net VALUES(20,'mysql',400); Console.WriteLine(INSERT, Total rows affected: + MyCommand.ExecuteNonQuery()); //Insert MyCommand.CommandText = INSERT INTO my_odbc_net VALUES(20,'mysql',500); Console.WriteLine(INSERT, Total rows affected: + MyCommand.ExecuteNonQuery()); //Update MyCommand.CommandText = UPDATE my_odbc_net SET id=999 WHERE id=20; Console.WriteLine(Update, Total rows affected: + MyCommand.ExecuteNonQuery()); //COUNT(*) MyCommand.CommandText = SELECT COUNT(*) as TRows FROM my_odbc_net; Console.WriteLine(Total Rows: + MyCommand.ExecuteScalar()); //Fetch MyCommand.CommandText = SELECT * FROM my_odbc_net; OdbcDataReader MyDataReader; MyDataReader = MyCommand.ExecuteReader(); while (MyDataReader.Read()) { if(string.Compare(MyConnection.Driver,myodbc3.dll) == 0) { Console.WriteLine(Data: + MyDataReader.GetInt32(0) + + MyDataReader.GetString(1) + + MyDataReader.GetInt64(2)); //Supported only by MyODBC 3.51 } else { Console.WriteLine(Data: + MyDataReader.GetInt32(0) + + MyDataReader.GetString(1) + + MyDataReader.GetInt32(2)); //BIGINTs not supported by MyODBC } } //Close all resources MyDataReader.Close(); MyConnection.Close(); } catch (OdbcException MyOdbcException) { Console.WriteLine(Error + \n + NATIVE: + MyOdbcException.Errors[0].NativeError.ToString() + \n + SQLSTATE: + MyOdbcException.Errors[0].SQLState + \n + MESSAGE: + MyOdbcException.Errors[0].Message ); } } } } Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com
RE: Problem with SQLSetPos(SQL_DELETE)
Hi, -Original Message- From: Jim Dickenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 5:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Problem with SQLSetPos(SQL_DELETE) I have an application that works with EasySoft's OOB driver but not with MyODBC. I have compiled version 2.50.39 under RedHat 7.2 and I think there is a problem in the code. In cursor.c on line 217 there is a test to see if irow is being passed correctly. I think the test is wrong. I fetch one record at a time so irow can only be 1. As best as I can tell the test is checking against which row in the whole result set we are currently on. This is not the test that should be done as best as I can figure. Although I did select 6 records from my datasource I am only reading one at a time. If I want to delete the current record I want to delete the only record in my fetch set which is record 1, not the specific record in the result set, which in my case is record 6. Looking at the code for SQLSetPos it looks like irow is taken as a row in the result set not in the fetched set. I do not think that this is correct. Yes, I agree !!! That was corrected in 2.50.40 version, and we didn't released that, as we wanted to have 3.51 out. So, you can find this in 3.51 driver, which has a completely different cursor handling based on the rowset and for batch operations. You will here the release tomorrow, and let me know the outcome after testing with new driver. You can also get the development version of 3.51 driver using: * Install Bitkeeper (http://www.bitkeeper.com/) * bk clone bk://work.mysql.com:7003 myodbc-3.51 * cd myodbc-3.51 * bk -r edit * aclocal; autoheader; autoconf; automake * ./configure * make * make install Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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
Hi, -Original Message- From: Mike Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: MyODBC Any plans to upgrade the MyODBC driver to support .NET? I downloaded a copy of MySQL and tested it with a .NET app and received an error that this version of ODBC wasn't supported. Just wondering if this is on the development horizon. You should be able to work with .NET through MyODBC with out many problems. I tried with ODBC.NET, ADO.NET through MyODBC and could able to do the basic stuff without any problems. If you need a ODBC compliant of 3.x or more, we will be releasing a new MyODBC 3.51 Driver shortly, which should fit for most of the requirements. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 problem: Show Processlist
Hi, Hallo, Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC 2.50.38. In some part of this application I like to know the processes that are running on MySql. I'm using SHOW PROCESSLIST expecting a recordset back like in SHOW STATUS. I'm getting an runtime-error -2147467259 (80004005), Function sequence error when I try to go to the first record (.MoveFirst). This works ok with SHOW STATUS. I traced the ODBC calls and enclosed the files. You can see that the SHOW STATUS leaves no error in the trace file. The SHOW PROCESSLIST however does. I hope you can give me an advice. Thanks in advance. Frans Streur -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* Frans Streur - 's-Hertogenbosch - The Netherlands EMail [EMAIL PROTECTED] -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* Errors Tracefile: SHOW PROCESSLIST VB6 120-534 EXIT SQLNumResultCols with return code -1 (SQL_ERROR) HSTMT 031F17E0 SWORD * 0x0012E908 DIAG [S1010] [Microsoft][ODBC Driver Manager] Function sequence error (0) What is its previous call ? Is it SQLPrepare or SQLExecDirect ? Note that, if it is SQLPrepare, then please upgrade your driver to .39 version to have a fix for this. Other wise, please send me the complete trace, but before that try with .39 version of the driver. NOTE: The error is returned by the DM, not by the driver, so we need to have a trace to understand what is happening from the application, and my guess is something to do with app calling sequence. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL - Win SQL2k DTS - MySQL
Hi, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 7:51 AM To: [EMAIL PROTECTED] Subject: MySQL - Win SQL2k DTS - MySQL Hello, Has anyone successfully implemented using a Microsoft SQL 2000 DTS package to copy data from one mysql database into another mysql database? I am getting some errors pertaining to 'cannot insert blob fields'. -which they are not blob fields. I've tried this on text, char, varchar, tinytext. I feel like the MyODBC driver is very limited in the data types that it supports. I will look into it. Last time when I traced this, found that the DTS is not doing a correct data type mapping while converting. Let me investigate further on this today. Thanks for the info. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: My ODBC Error
Hi, -Original Message- From: Frankie Cooke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: My ODBC Error Hello All I can currently connect to a Mysql database on my local machine, a windows o/s. However, when I try and do this on unix - get the error: Vbscript Runtime error 'ASP 0185 : -2147467259' Data source name not found or no default driver specified include/dbconnectcrop.asp,line 11 Line 11 is the where I am opening the connection. I feel that I have not matched the driver name. Is the driver MyODBC called something different on Unix, other than MySQL. Below is my conenction string. % ' Connect to MySQL database for passwords section documents Dim dbconnect, anyRs, insComm set dbconnect=Server.CreateObject(ADODB.Connection) dbconnect.ConnectionString=Driver=MySQL;server=localhost;Database=cropwise; dbconnect.Open % Thanks for any help Frankie You said you are trying to connect to server running on Unix, but your ADO connect string has localhost. Any way, For more information on how to establish a remote connection using MyODBC, refer to the following link: http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4326:200112:pnidmlbpjaokppdkhnhp Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: RogueWave Dbtools++ 4.0.1 and myodbc (conclusions)
Hi, -Original Message- From: Bob Dixon [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 12:08 PM To: '[EMAIL PROTECTED]' Subject: RogueWave Dbtools++ 4.0.1 and myodbc (conclusions) Sorry: sent previous message prematurely: to recap: I am evaluating MySQL as a database solution for a production product that uses RW DBtools++ for DB access. We currently can connect via MS-SQL, Oracle and SqlAnywhere and I've been asked to evaluate MySQL. After installing MyODBC on NT ( verifying its connection to MySQL using MS-Access), I get the following when trying to run our utility which does the DB initializtion: Database Error: Error 13 ([NOTSUPPORTED] The specified ODBC Data Source uses an ODBC driver which conforms to an ODBC specification prior to the 3.0 specification. This driver version is not supported by DBTools.h++. Please upgrade to a newer driver.). Vendor error 0 () Vendor error2 0 () Error connecting to database: driver name EVISION_MYSQL user ***, password *** Error message [NOTSUPPORTED] The specified ODBC Data Source uses an ODBC driver which conforms to an ODBC specification prior to the 3.0 specification. This driver version is not supported by DBTools.h++. Please upgrade to a newer driver. --- I have check this and the main mysql list and archives as well as a search of the 'google' lists; it appears that a few people are using RogueWave and Mysql(perhaps older versions of Rogue Wave). If anyone has experience, ideas or can let me know when myodbc will be at 3.0 support would be much appreciated. (Note that this version of RogueWave will be 'obsoleted' in May, so using an older version of RW is not an option for us). You need to wait till the release of 3.51 version of MyODBC which conforms to 3.51 ODBC specifications. We planned to have a release of this ne driver in the first week of this month itself, but due to some last minute changes, we are holding the release. Hopefully everything will happen very soon. Thanks for your time.. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:44 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) There was a leak in the server and some part of driver in 2.50.39 w.r.t. loading and unloading. The server side got the fixes from 4.0.1 or 3.23.48 versions, and driver will have from 2.50.40 or 3.51.01 onwards. The 3.51 driver will be released shortly. Keep tuned to [EMAIL PROTECTED] for the release announcement. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.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
RE: ODBC for newbie
Hi, -Original Message- From: Lew Schwartz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:58 AM To: [EMAIL PROTECTED] Subject: ODBC for newbie Are there any odbc how-to's, tutorials, samples and/or resources I could look at? I'm new to mySQL. -Lew MyODBC Downloads: www.mysql.com/downloads/api-myodbc.html MyODBC Online Document: http://www.mysql.com/doc/O/D/ODBC.html ODBC : www.microsoft.com/data/odbc ODBC Programmer's Guide : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbca bout_this_manual.asp Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Vb DbGird Limitation
Hi, -Original Message- From: yousif shams [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 7:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Vb DbGird Limitation hi there, I was writing a MS VB 6 code and I have added to the form a DBGIRD component (unbound) to display the data, which was retrieved by an sql statment to the from from a MySQL database into a recordset. But I got an error in the VB mentioned the following: Rowset not Bookmarkable I started to debug the program. Finally I found that was a limitation in the MySQL. Is it true? What is the alternative way to solve this issue? MySQL nor MyODBC doesn't support any bookmark functionality. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: ODBC DRIVERS for MYSQL
-Original Message- From: Peter Reck [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 3:31 PM To: [EMAIL PROTECTED] Subject: ODBC DRIVERS for MYSQL A newbie question: DESIRED FUNCTION: to import data from MySQL db to MS word through webquery ODBC I was guided to install myODBC by going to http://www.mhysql.com --- downloads -API's --MyODBC myODBC 2.5.39 DOWNLOADED, UNIZPPED AND INSTALLED I was told to add a NEW SYSTEM DSN for MySQL PROBLEM there is NO SYSTEM DSN offered to add under the add button under the SYSTEM DSN tab QUESTION How can I set up the required DSN for my SQL? Any help is greatle appreciated! Are you sure there is no ADD button under System DSN ? Anyway, try creating USER DSN. For more information, refer to: http://www.mysql.com/doc/O/D/ODBC.html or, refer to the following link on how to create User DSN for MyODBC. http://www.devshed.com/Server_Side/MySQL/ODBC/page4.html Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: conceptual problem with ODBC and mysql
Hi, -Original Message- From: Barbara Ferrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 10:11 AM To: [EMAIL PROTECTED] Subject: conceptual problem with ODBC and mysql i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual problem with how i am going to get the data from my microsoft Access database and insert it into mysql tables. i thought i was going to use ODBC but after reading lots of pages it looks like you use this program if you continually wanted to access data on a windows server..which i am not going to do...i just want my data out of the MSACCESS and into mysql on a linux server my linux box is not connected to a network. my access database is on the network. i have a cdrewritable and put access on it and some of the data (it is only 12MB). now what in the heck do i do now? i don't want to read anymore chapters and create a webpage and never use it again. do i need to learn the ODBC stuff if i an never going to use windows again? If I understood your problem correctly, you can export the desired tables and or data one time from Access to MySQL using MyODBC, the MySQL ODBC Driver. http://www.mysql.com/downloads/api-myodbc.html Here is the Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: using ASP with MYSQL
-Original Message- From: Milder Lisondra [mailto:[EMAIL PROTECTED]] Sent: Monday, December 24, 2001 3:48 PM To: '[EMAIL PROTECTED]' Subject: using ASP with MYSQL Has anyone used or tried to use Activer Server Pages with MYSQL. I am currently working on a project currently only has access to these 2 dev tools. Thanks, Milder Goto http://www.mysql.com/portal/development/html/index.html and do a search for ASP in All portal categories.. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: odbc connection problem
Hi, -Original Message- From: Devore, Jacob [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 10:01 AM To: '[EMAIL PROTECTED]' Subject: odbc connection problem When I connect through odbc I get a succes with info, when I look at the info I have a sql state of s1000, native error 0. If I try to query the database I get an error and the sql state is s1000 with native error code of 1142. Everything I read on the internet says it's some kind of permissions thing. I have tried the mysql commands What is the (warning) message ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com GRANT ALL PRIVILEGES ON fr6 TO Devore@jdevore-02; INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES (jdevore-02, Devore@jdevore-02, , Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y); GRANT ALL PRIVILEGES ON fr6 TO %@%; And when I used these it let me connect but I got all those errors. Before I started adding people to the user table I couldn't even connect. Does anyone know what I'm doing wrong or is the odbc driver not recommended? Thanks, jake - 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 leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.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: Problem with ASP and GROUP BY queries
Hi, -Original Message- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:14 AM To: [EMAIL PROTECTED] Subject: Problem with ASP and GROUP BY queries My query: SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type I have a problem with MySQL and a query. If I type the Query in a program with direct db connect, in my case EMS Mysql manager, everything works OK but when I use it from an ASP page it don't. I don't get any matches, it even works with an ODBC connection to MS Query. I have tried to use sum(id) in stead of count(*) and it works fine but of course dosen't give the information that i want. I can use count(*) without the GRUOP BY and it works OK, it seams that the only query that don't work is the query i wan't. I run the MySQL server locally on a computer with Win98 installed, I use PWS for testing purpose but i don't think there will be any difference when I install it on IIS 5... Anybody have any tip how to fix this? It will work after specifying the OPTION=16386, or by enabling the appropriate flags from DSN configure dialog. For more info on the flags, refer to MyODBC online manual, which describes this issue. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.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: MyODBC availability
Hi Kevin, -Original Message- From: Kevin Donnelly [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 12:47 PM To: [EMAIL PROTECTED] Subject: 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. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Error ODBC
Hi, -Original Message- From: Juan Majorel [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 8:56 AM To: [EMAIL PROTECTED] Subject: Error ODBC Hello ! I can't connect to MySQL 2.23.64 under linux redhat 7.1 The ODBC client is version 2.50.39 for NT version 4. I think that the problem is ODBC Driver. Please help me and Thank You !!! Juan the error text is : [TCX][MYODBC]Can't connect to MySQL server on 192.168.1.20 (10071)(#2003) This is because, either the server is not running or not listening to the port specified. For more information, refer to: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: VB6 ADO and UPDATE method
Hi, -Original Message- From: Stefano Vaccari [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 3:10 AM To: [EMAIL PROTECTED] Subject: VB6 ADO and UPDATE method Hello to everybody. I have a problem with the Update method in the following simple VB6 code: Dim MyConn as New ADODB.Connection Dim MyRs As New ADODB.Recordset MyConn.ConnectionString = DSN=test;uid=sa;pwd=;database=test MyConn.Open MyRs.CursorLocation = adUseClient MyRs.Open lines, MyConn, adOpenKeyset, adLockOptimistic, adCmdTableDirect Do While Not MyRs.EOF MyRs!StartAngle = AngleValues(MyRs!LineId).StartAngle MyRs!EndAngle = AngleValues(MyRs!LineId).EndAngle MyRs.Update MyRs.MoveNext Loop The invocation of the methot MyRs.Update raise an error ( -2147217864 It's impossible to find the row to update). Everything works fine if I make the update using the method MyConn.Execute (UPDATE lines SET ) I've installed the latest releases of MySql and MyOdbc drivers (3.23.46 and 2.50.39 under win2000) I just would like to know if the simple moving through records and updating is supported, or if there is something wrong in my code. Thank you Stefano Change connection string from DSN=test;uid=sa;pwd=;database=test to DSN=test;uid=sa;pwd=;database=test;option=2, then everything will be fine. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Importing for MicroSoft Access 97
Hi, -Original Message- From: Hajar Abdus-Sabuur [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 7:29 AM To: [EMAIL PROTECTED] Subject: Importing for MicroSoft Access 97 Hello- I created a schema for my database in MicroSoft Access 97. I would like to know if there is anyway to import this schema into MySQL? PLease help. Thank You Make use of MyODBC. For more information, refer to http://www.mysql.com/downloads/api-myodbc.html Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: odbc driver
Hi, -Original Message- From: avital raz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 12:56 PM To: [EMAIL PROTECTED] Subject: odbc driver hello i need help i have a database in mysql. i use an outside program that connect to the databas through odbc (dsn) and make graphs. the program worked very good for months but at the last week something disrupted. when i tried to make graph from one specific table, i receive an error message. the message is: [microsoft][odbc drivermanager] driver does not support this parameter ERR= -2147467259. the sql that i request is very simple - select of tree columns table.month, count(table.visits), table.year using group by 1,3. i must say that if i run that sql in oracle odbctest or directly in mysql i got the recordsets proper with no problem. another importent fact - when i remove the table.year from the sql i got the recordsets proper in my program to. all others graphs works well, and have the same structure of what i writed here. so, if someone can give me an idea what to do i will thank him/her very much Can you please send me the ODBC trace, so that it becomes easy to trace what is happening. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Problem making myodbc on Solaris 8
Hi, -Original Message- From: Matthew Dougherty [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 11:06 AM To: [EMAIL PROTECTED] Subject: Problem making myodbc on Solaris 8 make fails with mksh: Fatal error in reader: = missing from replacement macro reference Current working directory /opt/perlModules/MyODBC-2.50.37 I have ODBC working for SQL Server. If I do a make -V is leads me to a bad set of lines in Makefile: DEPS_MAGIC := $(shell mkdir .deps /dev/null 21 ||:) -include $(DEP_FILES) If I take out the colon on the :=, I don't get an error. Is the -include a typo? I don't see a matching subroutine in Makefile. If I change it to include $(DEP_FILES) it can't find the files. DEP_FILES is previously defined as a list of files in .deps. I am running as root using GCC 2.95. I have a separate build of perl that I am using instead of /usr/bin/perl on Solaris 8. The PATH is set to /usr/local/bin:/usr/local/mysql/bin:/usr/bin:/usr/sbin:/usr/ccs/bin I am using the make in /usr/ccs/bin. The LD_LIBRARY_PATH is set to /usr/local/lib:/usr/local/mysq:/usr/lib The configure command is as follows: ./configure --with-odbc-ini=/etc/odbc.ini --with-iodbc-includes=/usr/local/openlink/w3configu/include --with-iodbc-libs=/usr/local/openlink/lib --with-mysql-dirs=/usr/local/mysql/lib/mysql --with-mysql-includes=/usr/local/mysql/include/mysql Can you download and try the latest version 2.50.39(unix source) from: http://www.mysql.com/downloads/api-myodbc.html Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 Problem with SQL2000 - MySQL Data Transformation
Hi, -Original Message- From: Jack A. Fobel [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 01, 2001 3:22 PM To: MySQL List Subject: MyODBC Problem with SQL2000 - MySQL Data Transformation Hi Folks, I'm having a problem when I try to populate a MySQL database using DTS in SQL2000. The data types on the SQL2k table are varchar, as well as the types in MySQL. I am receiving a 'Data Overflow' error for each column that it tries to update. I've tried numerous ways of population, each failing with this error code. I'm beginning to think it is the MyODBC driver. I connect to SQL2k with OLD DB and use MyODBC to connect to MySQL. Have any of you tried doing this yet? Just curious that maybe you have run into this before. Last week only I spent some time on this issue, as the DTS from MS is not mapping the varchar columns properly to MySQL when using MyODBC, and in some cases it maps varchar to set :) I will trace down the problem this week, and I will update you on that. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: SQL state S1090: Almost connected to mysql via PHP/odbc
Hi, -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 2:03 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: SQL state S1090: Almost connected to mysql via PHP/odbc Hello, thanks to the precious suggestions I had on this list some day ago, I have made some progresses, or at least have something new to report. I would like to ask now above the error mentioned in the subject, because I have not found it inside www.,mysql.com I have a database called m97. It *is* listed when I run show databases in themysql monitor. It *shows* when I run isql -v m97. I have modified /etc/odbc.ini and /etc/odbcinst.ini and /etc/odbc.ini as follows: /etc/odbc.ini [m97] Trace= On TraceFile= stderr Driver = /usr/lib/libmyodbc.so DSN = m97 SERVER = localhost USER = test PASSWORD = gee PORT = 3306 OPTIONS = 1 DATABASE= m97 SOCKET = /tmp/mysql.sock # /etc/odbcinst.ini # From the MyODBC package [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc.so FileUsage = 1 In the PHP file I have: putenv(LD_LIBRARY_PATH=/usr/lib/); putenv(ODBCINSTINI=/etc/odbcinst.ini); putenv(ODBCINI=/etc/odbc.ini); $DSN=m97; $cnx = odbc_connect( $DSN , 'test', 'gee' ); The result in netscape is still: Warning: SQL error: [unixODBC][TCX][MyODBC]Invalid DSN specified, SQL state S1090 in SQLConnect in /home/mweb/public_html/test.php on line 360 The problem is that, unixODBC is not able to find your MyODBC DSN entry. This is probably due to the fact that it is not picking the right odbc.ini file. Did you tried by using isql -v m97 to check whether it is really picking the .ini or not. For more information on howto setup MyODBC, unixODBC and MySQL, refer to the following link: http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:3657:200108:einnhiokafobjmjbmcbm Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
conceptual question.
hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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
What is errno: 13
Hello All: I am working on a particular database, which I created some days ago in mysql ver. 3.23.36. I am quite sure that I have not made any changes to the system (Dell WS with Red Hat Linux 7.1) either. What I see is this... ### [Venu@localhost Venu]$ db Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'ecg_datafile' Didn't find any fields in table 'event_info' Didn't find any fields in table 'event_lookup' Didn't find any fields in table 'lead_lookup' Didn't find any fields in table 'properties_info' Didn't find any fields in table 'record_info' Didn't find any fields in table 'subject_info' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use sadms Database changed mysql mysql mysql select * from ecg_datafile; ERROR 1017: Can't find file: './sadms/ecg_datafile.frm' (errno: 13) mysql quit Bye [Venu@localhost Venu]$ # what is this error? I created all these tables a few days back and now I am unable to view them. Could anyone suggest what is going and what the solution is? Thanks Venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC: DSN Creation
Hi Kevin, -Original Message- From: Kevin Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 9:25 AM To: [EMAIL PROTECTED] Subject: MyODBC: DSN Creation Hi All, I need to setup MyODBC DSN's for MySQL access. Does anyone know how to build a simple installer that will create User/System DSN's from a file? ie. like the odbc.inf file included with the MyODBC installer? Can odbcconf.exe be used to install a DSN? If so, what are the parameters used to create a DSN, can you give me a good example. Many thanks, You can make use of 'myodbc.rsp' file that comes with the binary distribution, which configures MyODBC and the sample DSN using odbcconf.exe. The simple command for this is odbcconf /f myodbc.rsp Here is the myodbc.rsp that is included in the distribution for 2.50.40 version. INSTALLDRIVER MySQL Driver|Driver=myodbc.dll|Setup=myodbc.dll|| CONFIGDRIVER MySQL Driver APILevel=2 CONFIGDRIVER MySQL Driver ConnectFunctions=YYN CONFIGDRIVER MySQL Driver DriverODBCVer=2.50.40 CONFIGDRIVER MySQL Driver FileUsage=0 CONFIGDRIVER MySQL Driver FileExtns=*.txt CONFIGDRIVER MySQL Driver SQLLevel=1 CONFIGDRIVER MySQL Driver CPTimeout=60 CONFIGDSN MySQL Driver DSN=sample-MySQL;Description=MySQL ODBC Driver;SERVER=database_server;User=odbc;DB=test;Port=3306|| Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL with MyODBC Access
Hi, -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 6:54 AM To: '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: MySQL with MyODBC Access Hi I recently upgraded MyODBC as you stated on our terminal server and two PCs. Now I tried running the install.bat file but it didn't seem to work so I just looked at the batch file and did it all manually. I believe for some odd reason the variable %windir% wasn't working. Either way the upgrade seem to go over well. The only issue I noticed since upgrading MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it appears. The first driver is MySQL and the second is MySQL Driver. Both show the version at 2.50.39.00 and company as MySQL AB. Is this a problem? The main reason I ask is for some odd reason on our terminal server the users using MyODBC are prompted with the MyODBC dialog box and seems to be missing the password. I've checked the registry and it's in their perfectly. If you enter the password manually when the dialog box appears it works with no problem. I do not want the users knowing this password (even though they could look it up in the registry, smile). How do I stop this dialog popping up and use the password I providing the System DSN profile? Is this issue maybe related to me having to MySQL drivers? It should be {MySQL} only, might be the .rsp file got the wrong driver name. Any way, that shouldn't cause any problems in the driver behaviour as both of them are listening to the same driver DLL. You can correct it by removing the other one :) PS : Please, don't put everything in a single paragraph, as this is making hard to read. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 6:17 AM To: Adam Douglas Subject: RE: MySQL with MyODBC Access Just download the driver files and copy them to system directory by ovveriting previous files. - 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 Newbie and Access Database
Hi Jose, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Gerardo Amaya Giron Sent: Thursday, November 22, 2001 1:11 PM To: [EMAIL PROTECTED] Subject: MySQL Newbie and Access Database Hello all, I just start up with mysql so I have some stupid questions to ask. right now I have an MS Access database with one table that has 25 fields and like 2000 records in it. I'm trying to move to MySQL in order to have a better DB. I can define the database and the table manually that's not a problem, My problem is how can I export the 2000+ records from the Access DB to MySQL DB. does an export file from access do the job??? I read a little bit about myODBC, does myODBC help me in this situation, does it help me export all the records to the new database??? Yes. You can make use of MyODBC to export tables and/or associted data from MS Access to MySQL. Here is the snippet from new MyODBC manual on how to export data from MS Access to MySQL. Q. Export a table or query to MySQL using MyODBC data source Note: You can only export a table or query to MySQL server, if you have installed the latest MyODBC driver 2.50.38 or grater, else you will experince problems with text and varchar data types. 1. In the Database window (The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click the name of the table or query you want to export, and then on the File menu, click Export. 2. In the Export Object Type 'Object name' To dialog box, in the Save As Type box, click ODBC Databases (). 3. In the Export dialog box, enter a name for the file (or use the suggested name), and then click OK. The Select Data Source dialog box is displayed; it lists the defined data sources for any ODBC drivers installed on your computer. 4. Click either the File Data Source or Machine Data Source tab, and then double-click the MyODBC data source that you want to export to To define a new data source for MyODBC driver, please follow the instructions from: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#Installi ng_MyODBC 5. Microsoft Access connects to the MySQL server through MyODBC data source and creates the new table in the server. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: HOW TO : Run wave files stored in BLOB field ???
Hi, -Original Message- From: Delphi Guy's [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 2:06 PM To: [EMAIL PROTECTED] Subject: HOW TO : Run wave files stored in BLOB field ??? Hi all, This the first post for me to this lists I appreciate If I take a good picture as I hear... I creat table in MySQL like this CREATE TABLE test ( ItemID INT NOT NULL AUTO_INCREMENT, FirstNameCHAR(50), LastName CHAR(50) NOT NULL, SoundLONGBLOB, PRIMARY KEY (ItemID) ); the Sound field is for storing wave files , it is stored ok now I want to run this wave from this field . I'm trying to use this methode by using ASP with MySQL... == Listenwav.asp File == %@ LANGUAGE=VBSCRIPT % % ' Clear out the existing HTTP header information Response.Expires = 0 Response.Buffer = TRUE Response.Clear ' Change the HTTP header to reflect that an audio is being passed. Response.ContentType = audio/wave StrConnection = driver={MySQL};server=127.0.0.1;database=test Set ADODataConn = Server.CreateObject(ADODB.Connection) ADODataConn.Open strConnection Set rs = ADODataConn.Execute(SELECT Sound FROM Test WHERE ItemID=1 ;) Response.BinaryWrite rs(Sound) Response.End % the HTML File will be == Listen.htm FILE == HTML BODY EMBED src=ListenWav.asp autostart=true loop=false /EMBED /BODY /HTML = this way is not working ... I don't know way ... Can any one tell me way , or how can I do it with another way... NOTE THAT I DO SAME WAY TO DISPLAY IMAGE AND IT IS WORKING FINE !!! I am not quite sure of ASP. As per the comments from another MyODBC user, the following code works fine to play back your wav file. HTML BODY bgsound src=listenwav.asp loop=-1 /BODY /HTML Can you try whether it works with you ? Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Driver problem
Hi Satish, -Original Message- From: K. Satish Kumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 10:55 PM To: [EMAIL PROTECTED] Cc: Apparsamy perumal Subject: Driver problem Hi! This is Satish. I am using your mysql software for administering my database. We have developed an application using VB as the front end and mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The problem where we are facing is while installing the driver. It works fine with NT and not with any other windows platform and we are exhausted hunting for the reason. The installation quits telling that a particular .dll is already running and sometimes quits from the installation. It would be highly appreciable if you would look into the matter and give us a right solution at the earliest since we are struggling with the software very badly. Please read the manual from www.mysql.com/doc (section 8.3.1), which has the detailed information on what needs to be done when the above installation error occurs. http://www.mysql.com/doc/I/n/Installing_MyODBC.html And hope you don't make us to feel bad for selecting your software by delaying the reply. Also, if the mail id what I have chosen for my query is not right suggest me the right mail id/site where I can get the solution immediately. This is also a right place, but use [EMAIL PROTECTED] for any MyODBC related queries. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Connection Terminated
Hi Prabhu, -Original Message- From: Prabhu Venkata [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 11:14 PM To: '[EMAIL PROTECTED]' Subject: Connection Terminated Hi all I have my mysql database installed on NT. I have written small VB application to upload .txt files into database. If I work from NT to NT is working fine. If I install my vb application on Win98 and having the database at NT then after couple of line reading from the text file. It gives me an error stating Cannot connect to mysql on Server {ip address}. This means that, the driver is not able to connect to the server specified using either the m/c name or IP address. Check your network and/or ISP issues. Are you able to ping to the specified host/IP ? Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Remember it upload the file and write to the databases after sometime only it gives an error. There is no error in SQL Insert command. Using Novell Netware. What would be the reason for it. I am really struggling to get this done. Thanx for your timely help. Regards Prabu - 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: Benchmarking
Hi, -Original Message- From: Rachman M.H [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 11:02 PM To: [EMAIL PROTECTED] Subject: Benchmarking Dear all, I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97. But, SQL Server 7 and M$ Access is won when connected and opening recordset using ADO, Even i'm using MyODBC with TCP/IP connections. If i'm use cursorlocation=serverside with adOpenDynamic, and adLockOptimistic, still MyODBC is looses. Something interesting. When I did a small research on this, I got MyODBC as the best result for most of the cases. Is it possible for you to pass the following info, so that we can also cross check: 1. Test scenarios 2. Comparision analysis for various tools/applications 3. MyODBC version and the DLL type (debug/share version) 4. MySQL version How can i make speed up the connection and opening recordset for MySQL ? It also depends up on your SELECT query and how the table is structured. You can find more information on this in the manual ( 5. MySQL optimisation). Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: java.sql.SQLException: Cannot connect to MySQL serveronlocalhost:3306.
Hi, -Original Message- From: Prasad Valmeti [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 12:42 AM To: [EMAIL PROTECTED]; Nguyen Trong Phuc; [EMAIL PROTECTED] Subject: RE: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306. Hi Venu, Thanks for ur response. Ur first guess is correct ... mysqld server is not running. But whenever i tried to run it, it is showing this error: 08 13:59:01 Can't start server : Bind on unix socket: Address already in use 08 13:59:01 Do you already have another mysqld server running onsocket:/tmp/mysql.sock ? 08 13:59:01 Aborting I have tried to run it on different ports using -P option. But still i am getting same error. Please check the following link for more information on this: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Start ing_server Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 9:39 PM To: Prasad Valmeti; Nguyen Trong Phuc; [EMAIL PROTECTED] Subject: RE: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306. Hi, -Original Message- From: Prasad Valmeti [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 4:31 AM To: Nguyen Trong Phuc; [EMAIL PROTECTED] Subject: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Thanks for ur response. I am sending code also. Earlier it was connected to data base. I haven't used it sometime. Now i am trying but unable to connect to Data base. Please have look and suggest me some solution to solve this problem. import java.io.*; import java.sql.*; import java.util.*; public class TextToDatabaseTable { private static final String DB = secmngr, TABLE_NAME = records, HOST = jdbc:mysql://localhost:3306/, ACCOUNT = scott, PASSWORD = tiger, DRIVER = org.gjt.mm.mysql.Driver, FILENAME = records.txt; public static void main (String[] args) { try { // connect to db Properties props = new Properties(); props.setProperty(user, ACCOUNT); props.setProperty(password, PASSWORD); Class.forName(DRIVER).newInstance(); Connection con = DriverManager.getConnection(HOST + DB, props); Statement stmt = con.createStatement(); // open text file BufferedReader in = new BufferedReader( new FileReader(FILENAME)); // read and parse a line String line = in.readLine(); while(line != null) { StringTokenizer tk = new StringTokenizer(line); String first = tk.nextToken(), last = tk.nextToken(), email = tk.nextToken(), phone = tk.nextToken(); // execute SQL insert statement String query = INSERT INTO + TABLE_NAME; query += VALUES( + quote(first) + , ; query += quote(last) + , ; query += quote(email) + , ; query += quote(phone) + );; stmt.executeQuery(query); // prepare to process next line line = in.readLine(); } in.close(); } catch( Exception e) { e.printStackTrace(); } } // protect data with quotes private static String quote(String include) { return(\ + include + \); } } I am not sending errors because those are in the below mails. The possible reasons are: 1. The server is not up and running 2. The server is up and running, but not to the default port. Regards, venu Thanks, Prasad. -Original Message- From: Nguyen Trong Phuc [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 8:50 AM To: Prasad Valmeti; [EMAIL PROTECTED] Subject: Re: hai Hi Valmeti ! it's general error, have too many reason. how about yr source code. maybe grant access, mm.mysql driver ... - Original Message - From: Prasad Valmeti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 2:49 AM Subject: hai Hai All, I am using Mysql, JDBC on LINUX. I am unable to connect Mysql from JDBC. I am getting these errors :: java.net.ConnectException: Connection refused
RE: mysql+myodbc+coldfusion
Hi, -Original Message- From: berndt [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 8:49 PM To: [EMAIL PROTECTED] Subject: mysql+myodbc+coldfusion Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine. However i keep getting a [TCX][Myodbc]Transactions are not enabled error. In the setup for the system dsn I have NOT disabled transactions. So whats up? any help would be really appreciated. I really don't want to be forced into using some other product because of this. This error comes when you are trying to perform some transactional calls in MyODBC on a non-transactional MySQL server. You can avoid this by either: 1. Enabling InnoDb/BDB table support in MySQL server or 2. By Disabling the transactions in MyODBC by checking ' Disable transaction' option from DSN dialog. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Thanks David Berndt - 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: about MySQL
-Original Message- From: Nick Ooka [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 7:06 AM To: MySQL-General Subject: Re: about MySQL Correction: I meant that he can use the ODBC driver with *MySQL* to be able to use Access as a MySQL client... :) Is this true? Yes. Thx. On Sun, 18 Nov 2001 00:00:49 +0900 Nick Ooka [EMAIL PROTECTED] wrote: Hi guys, Just curious... Can't he use the ODBC driver with Access to use MySQL? I think it *might* be possible. Pretty sure I read about it somewhere... Correct me if I'm wrong. Thx. On Sat, 17 Nov 2001 19:13:10 -0800 Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control MySQL from command promt. MySQL dont have windows screen. r u using windows c:\[mysql dir]mysqld -create table read mysql manual for more detail. --- Trong Phuc - Original Message - From: Zhou Jiang Yang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 4:15 AM Subject: about MySQL dear Sir/Madam, I have downloaded mySQL from your company's website. Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that means I can create table very easy. just from window screen. I hope get your reply. Thanks for you help. john - 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 Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306.
Hi, -Original Message- From: Prasad Valmeti [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 4:31 AM To: Nguyen Trong Phuc; [EMAIL PROTECTED] Subject: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Thanks for ur response. I am sending code also. Earlier it was connected to data base. I haven't used it sometime. Now i am trying but unable to connect to Data base. Please have look and suggest me some solution to solve this problem. import java.io.*; import java.sql.*; import java.util.*; public class TextToDatabaseTable { private static final String DB = secmngr, TABLE_NAME = records, HOST = jdbc:mysql://localhost:3306/, ACCOUNT = scott, PASSWORD = tiger, DRIVER = org.gjt.mm.mysql.Driver, FILENAME = records.txt; public static void main (String[] args) { try { // connect to db Properties props = new Properties(); props.setProperty(user, ACCOUNT); props.setProperty(password, PASSWORD); Class.forName(DRIVER).newInstance(); Connection con = DriverManager.getConnection(HOST + DB, props); Statement stmt = con.createStatement(); // open text file BufferedReader in = new BufferedReader( new FileReader(FILENAME)); // read and parse a line String line = in.readLine(); while(line != null) { StringTokenizer tk = new StringTokenizer(line); String first = tk.nextToken(), last = tk.nextToken(), email = tk.nextToken(), phone = tk.nextToken(); // execute SQL insert statement String query = INSERT INTO + TABLE_NAME; query += VALUES( + quote(first) + , ; query += quote(last) + , ; query += quote(email) + , ; query += quote(phone) + );; stmt.executeQuery(query); // prepare to process next line line = in.readLine(); } in.close(); } catch( Exception e) { e.printStackTrace(); } } // protect data with quotes private static String quote(String include) { return(\ + include + \); } } I am not sending errors because those are in the below mails. The possible reasons are: 1. The server is not up and running 2. The server is up and running, but not to the default port. Regards, venu Thanks, Prasad. -Original Message- From: Nguyen Trong Phuc [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 8:50 AM To: Prasad Valmeti; [EMAIL PROTECTED] Subject: Re: hai Hi Valmeti ! it's general error, have too many reason. how about yr source code. maybe grant access, mm.mysql driver ... - Original Message - From: Prasad Valmeti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 17 November, 2001 2:49 AM Subject: hai Hai All, I am using Mysql, JDBC on LINUX. I am unable to connect Mysql from JDBC. I am getting these errors :: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:320) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:133) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:120) at java.net.Socket.init(Socket.java:273) at java.net.Socket.init(Socket.java:100) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.init(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:146) at TextToDatabaseTable.main(TextToDatabaseTable.java:23) java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is ther e a MySQL server running on the machine/port you are trying to connect to? (java .net.ConnectException) at org.gjt.mm.mysql.Connection.init(Connection.java:239) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:146) at TextToDatabaseTable.main(TextToDatabaseTable.java:23) Please help me to solve out this problem. Thanks, Prasad. -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
RE: How to Create Tables ... and Clients using winmysqladmin
Hi Shekar, -Original Message- From: ChandraShekarReddy Talakola [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 6:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: How to Create Tables ... and Clients using winmysqladmin Hi, I am just install the mysql database and i start the system at dos prompt winmysqladmin i got the test tables with permissions and i have created my own database but iam unable to create table for that how can i create table and also i want create clients for my server and set the permission i tryed the artonic administrator but i can't understand how to create clients ,could tell me how to create tables and also there is an error some when i am starting mysqld-max-nt --standalone --console at prompt saying InnoDB is error with my.cnf showing different size Please send details to [EMAIL PROTECTED] regarding how to create tables and clients and how to work the clients with server using TCP/IP of windows Also please mention the ODBC connection string for connecting the ASP to mysql database not with respect to MyOLEDB connection All answers are in MySQL manual. You can find this from /docs subdirectory in the distribution or at www.mysql.com/doc Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: JDBC driver recommendatons
Hi, -Original Message- From: Wally Flint [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 6:01 PM To: Mysql mailing list Subject: JDBC driver recommendatons Anyone have a preferred JDBC for MySQL? I need a driver that will be reliable under heavy load. Yes. It is MM.MySQL JDBC Driver. For more information refer to http://mmmysql.sourceforge.net/ Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Simple JDBC Question
Hi Michael, -Original Message- From: Michael Bitzko [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 5:57 PM To: [EMAIL PROTECTED] Subject: Simple JDBC Question Please forgive the simplicity of the question, but I'm having trouble reading between the lines regarding the JDBC interface.I have the following simple code, which load the bridge driver, and then attempts to connect to the driver. The system can't make the connection. My question is the address section of the url. Where would it be looking for a database my-dsn, and if I have mySql located in the C: drive, what would the syntax appear like? Thanks for your help Mike Bitzko public static void initialize() { String query = SELECT * FROM emp; String url = jdbc:odbc:my-dsn; try { // Load the jdbc-odbc bridge driver Class.forName (sun.jdbc.odbc.JdbcOdbcDriver); System.out.println(.. Loading of the system driver completed ); DriverManager.setLogStream(System.out); // Attempt to connect to a driver. Each one // of the registered drivers will be loaded until // one is found that can process this URL System.out.println(.. Attempt to connect to a driver ); Connection con = DriverManager.getConnection (url, my-user, my-passwd); System.out.println(.. Attempt to connect is successful ); checkForWarning (con.getWarnings ()); === \jdk1.3.1_01\bin\javaw -classpath D:\IntroitSys\untitled1\classes;E:\JBuilder4\lib\jbcl.jar;E:\JBuilde r4\lib\dx.jar;E:\JBuilder4\lib\beandt.jar;D:\jdk1.3.1_01\demo\jfc\Jav a2D\Java2Demo.jar;D:\jdk1.3.1_01\jre\lib\i18n.jar;D:\jdk1.3.1_01\jre\ lib\jaws.jar;D:\jdk1.3.1_01\jre\lib\rt.jar;D:\jdk1.3.1_01\jre\lib\sun rsasign.jar;D:\jdk1.3.1_01\lib\dt.jar;D:\jdk1.3.1_01\lib\htmlconverte r.jar;D:\jdk1.3.1_01\lib\tools.jar untitled1.Application1 .. Loading of the system driver completed .. Attempt to connect to a driver DriverManager.getConnection(jdbc:odbc:my-dsn) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcD river@4a8cd1] *Driver.connect (jdbc:odbc:my-dsn) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 2.0001 Current Date/Time: Thu Nov 08 17:46:05 PST 2001 Loading JdbcOdbc library Allocating Environment handle (SQLAllocEnv) hEnv=166007376 Allocating Connection handle (SQLAllocConnect) hDbc=166007544 Connecting (SQLDriverConnect), hDbc=166007544, szConnStrIn=DSN=my-dsn;UID=my-user;PWD=my-passwd RETCODE = -1 ERROR - Generating SQLException... Closing connection (SQLFreeConnect), hDbc=166007544 Closing environment (SQLFreeEnv), hEnv=166007376 getConnection failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified *** SQLException caught *** SQLState: IM002 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Vendor: The above error says, you didn't configured the MyODBC DSN 'my-dsn'. When you are using JdbcOdbc Bridge driver inorder to access MySQL through JAVA applications through MyODBC driver, you need to define MyODBC DSN also. So, first define this, and then try connecting, and hopefully it will. For more information about MyODBC, refer to its online manual at www.mysql.com/doc (section 8.3) Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MS Access Front end with MySQL Back-end
Hi -Original Message- From: Matt Sellers [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 7:37 AM To: [EMAIL PROTECTED] Subject: MS Access Front end with MySQL Back-end Hi there, I am new to MySQL, but not to databases. I have several MS Access databases (97 and 2000) that I would like to integrate, storing their data in a MySQL database. I want to keep the Access 97 and 2000 front ends, because my users are comfortable with them. I had autonumber fields in Access tables to generate IDs for records. I emulated that behavior by having auto_increment fields in the MySQL DB when I move the data. I have installed myODBC and set up a connection for Access. I Get External Data from Access, and link to the MySQL table. I have tried having MyODBC set to Return matching rows and not, and to Simulate ODBC 1.0 and not. Here's the problem. When I insert a row in a table (from the table in Datasheet view, or from a form), I leave the ID field null so mySQL will assign it. When I move off the record, all fields show #Deleted. If I exit the table and re-enter, or if I requery the form, the record is there with the expected ID from mySQL. Is there some way I can have Access behave in a more acceptable manner when dealing with linked MySQL tables with auto_increment fields? Versions of software I am using: MS Access 2000 MySQL server version: 3.23.38-nt MySQL ODBC ver 2.50.37.00 Please check the following link for the work-around solutions when the records in the linked tables are displayed as #DELETED http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#MyODBC_c lients Also, upgrade the driver to 2.50.39, available from http://www.mysql.com/downloads/api-myodbc.html Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Experience with mm.mysql-2.0.x ?
Hi !!! And coming to your problem, I belive it got fixed in the latest release. Regards, venu -Original Message- From: Mark Arnold [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 6:20 PM To: [EMAIL PROTECTED] Subject: Experience with mm.mysql-2.0.x ? Hi, did anybody ever use the new mm.mysql-2.0.4 (or another 2.x version) library that is introduced as stable on the download section? Is it stable enough to use on production servers? Any positiv / negative comments on that? 2.0.6.1 is the latest and is in production in many places. It can be found at http://mmmysql.sourceforge.net/ www.mysql.com is pointing to old versions, and that is causing lot of problems. So, we will ask our web team to fix this ASAP. I am having problems with the 64k size limit bug in the earlier versions and I'm wondering if I should upgrade to 2.0.4 (which has it fixed) although it seems not to have production release status (yet). Please verify with the above version, it should be. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: MySQL with MyODBC Access
Hi -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 12:55 PM To: 'David Turner'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail); '[EMAIL PROTECTED]' Subject: MySQL with MyODBC Access I've recently setup MyODBC and MS Access to use a ODBC profile that is global to everyone. What I did was make a new user in MySQL and then create a MyODBC User DSN. I made the links to MySQL in Access using this profile. The problem I'm having is this, when you initially go into MS Access you have to always click on a specific table then close it and begin the task you wish to do. If you do not do this then nothing works. For some odd reason if you try to open a form or a link it will come up with the ODBC dialog box and always seems to have the database name wrong. The database name seems to match the DSN name. Any ideas why this is not working properly for me? If you need any more information please let me know. Oh yeah the part that makes this really odd is that I have a User DSN setup for myself and one other person for administration purposes only. This User DSN seems to work fine on both our machines. Really odd. This is due to invalid connection parameters supplied in the DSN entries. for a particular MyODBC DSN, you might have specified only the valid DSN and other fields you left it as blank, and that's why driver behaves as you explained above. Please refer to the following link, for more information on how to setup a DSN for MyODBC with different connection parameters. http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#ODBC_adm inistrator Also I've noticed that using Access as a front end to MySQL it seems to not bring through data that is using a type of bigint. Is this a limitation of using Access as a front end? If so what other column types would MS Access not support? As per the ODBC spec, BIGINT is not a privileged data type with 2.x specifications, so MyODBC doesn't support this. The new MyODBC 3.51 which is going to be released shortly supports BIGINT. For more information about Access--MySQL data types, refer to the following thread: http://lists.mysql.com/cgi-ez/ezmlm-cgi?4:mss:7537:200110:nbhnfhhlmikphfjkncdh Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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:Update with SQLSetPos doesnt work with some kind ofprimary keys?
Hi !!! -Original Message- From: Cenk Akyüz [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 1:55 AM To: [EMAIL PROTECTED] Subject: MyODBC:Update with SQLSetPos doesnt work with some kind of primary keys? MySQL Version: 3.23.42-max-nt MyODBC Version:2.50.39 OS Version= Windows 2000 Server If I change the order of fields in a multi-column primary key table, I cant update the table with SQLSetPos. ie: If I declare my table :(Primary key fields's order is the same as in table) create table A( name varchar(20) not null, surname varchar(20) not null, addresss varchar(50), constraint pkA primary key(name, surname )) insert into A(name, surname) values('Bill', 'Gates') select * from A It works. But If I declare primary key like this create table A( name varchar(20) not null, surname varchar(20) not null, addresss varchar(50), constraint pkA primary key(surname, name )) It doesnt work. It doesnt give any error, but doesnt update any row. the output is : SQLSetPos: Operation = SQL_UPDATE=2, LockType = SQL_LOCK_NO_CHANGE=0 Return: SQL_SUCCESS_WITH_INFO=1 stmt: szSqlState = 01S03, *pfNativeError = 0, *pcbErrorMsg = 36 szErrorMsg = [TCX][MyODBC]No rows updated/deleted Thanks for the bug. That was a silly mistake in passing the bind parameter number for internal binding, now I fixed this and it will be available for MyODBC-2.50.40. You can also find the intermittent driver with the fix, from ftp://support.mysql.com/pub/mysql/hidden/myodbc/myodbc-39-win32.zip and let me know outcome of it. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: DSN-Less connections using MyODBC?
Hi !!! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 1:36 PM To: MySQL Mailing list Subject: DSN-Less connections using MyODBC? Anyone ever tried a MySQL dsn-less connection (I am working in Borland C++ Builder)? I can do it with a dsn but can't seem to make connection in dsn less. You need to specify the exact name of the driver in the connect string as: DRIVER={MySQL Driver}; or DRIVER={MySQL}; based on the driver name configured in your system. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: DSN-Less connections using MyODBC?
Hi !!! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 2:26 PM To: MySQL Mailing list Subject: Re: DSN-Less connections using MyODBC? Thx for the quick response... Here's my connection parameters. I always get invalid parameter. DRIVER={MySQL}; USER NAME=myusername; PASSWORD=mypassword; SERVER=10.10.10.45; DATABASE NAME=DatabaseName; PORT=3306; I am pretty sure of the driver name since MySQL is the exact string Windows98 ODBC manager shows me. I put the port param there just in case but I think 3306 is the default port number and therefore is not necessary. Could it be possible it is because I did not set any options? It doesn't depend upon OPTION value. Can you change the following parameters and try it out. 1. UID instead of USER NAME 2. DATABASE or DB instead of DATABASE NAME 3. PWD instaed of PASSWORD Here is the simple DSN-less connection string: DRIVER={MySQL};SERVER=localhost;DATABASE=test;UID=monty;PWD=monty; If you are still facing the problem means, then check whether the driver is loaded or not by the DM. If it is, then send the ODBC log. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Original Message - From: Venu [EMAIL PROTECTED] To: Sylvain Hamel [EMAIL PROTECTED]; MySQL Mailing list [EMAIL PROTECTED] Sent: Friday, October 05, 2001 5:07 PM Subject: RE: DSN-Less connections using MyODBC? Hi !!! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 1:36 PM To: MySQL Mailing list Subject: DSN-Less connections using MyODBC? Anyone ever tried a MySQL dsn-less connection (I am working in Borland C++ Builder)? I can do it with a dsn but can't seem to make connection in dsn less. You need to specify the exact name of the driver in the connect string as: DRIVER={MySQL Driver}; or DRIVER={MySQL}; based on the driver name configured in your system. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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