does ado/myodbc not support blob data insert in vc6?

2009-08-10 Thread linux...@gmail.com
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk

does ado/myodbc not support blob data insert in vc6?

2009-08-09 Thread linux...@gmail.com
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk

Problems with MyODBC 3.51.12 for MacOSX Panther

2006-05-26 Thread Thurgood Alex
error message : /usr/lib/libltdl.3.dylib (No such file or directory) and indeed the libtool library isn't installed. The README provided with the MyODBC dmg package states that you don't actually need anything else to get MyODBC working, not even the MySQL client libraries, so what gives

Re: VIEW not working with myODBC in XP and Access 2003

2006-05-12 Thread sheeri kritzer
This is an Access problem; you'll need to find folks who know access to fix it. Try: http://www.tek-tips.com/viewthread.cfm?qid=1146857page=1 ?? -Sheeri On 4/26/06, Daevid Vincent [EMAIL PROTECTED] wrote: I have a critical problem that I hope there is a simple solution for. I've just spent

VIEW not working with myODBC in XP and Access 2003

2006-04-26 Thread Daevid Vincent
I have a critical problem that I hope there is a simple solution for. I've just spent a couple days converting a very messy hack to populate a table using a much more elegant VIEW solution now. Everything is going great, except now the whole point of this VIEW is so that people using MS Access

myodbc version 3.21.X

2006-04-20 Thread Reinhart Viane
Hey list, I'm am currently looking for myODBC 3.21.X but can't seem to find a suited downloadsite. Does anyone know a link to this version? Thanks in advance, Reinhart Viane

Re: How can I keep character_set_client value after MyODBC auto reconnect?

2006-01-11 Thread SGreen
think automatic reconnection is not bad when it can keep variables' value or can give me a chance to run more than one SQL statement to init my session. Another question: when will new verison of MyODBC3.5 be released? One of our application often disconnect and connect MySQL and then MyODBC

Re: How can I keep character_set_client value after MyODBC auto reconnect?

2006-01-11 Thread 古雷
Hi, Shawn Green Thanks for your reply. But I expect new version of MyODBC(one of mysql-connectors), not of mysqld. We now use mysql5.0. The newest version of MyODBC is 3.51.12. Regards, gulei - Original Message - From: [EMAIL PROTECTED] To: 古雷 [EMAIL PROTECTED] Cc: MySQL List mysql

Re: How can I keep character_set_client value after MyODBC auto reconnect?

2006-01-10 Thread Dušan Pavlica
Hi, did you try SET CHARACTER SET utf8 as Initial Statement under Connection Options of your MyODBC DSN? HTH, Dusan - Original Message - From: 古雷 [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Monday, January 09, 2006 10:19 AM Subject: How can I keep

Re: How can I keep character_set_client value after MyODBC auto reconnect?

2006-01-10 Thread 古雷
variables' value or can give me a chance to run more than one SQL statement to init my session. Another question: when will new verison of MyODBC3.5 be released? One of our application often disconnect and connect MySQL and then MyODBC often core dump. Best regards, gulei - Original Message

How can I keep character_set_client value after MyODBC auto reconnect?

2006-01-09 Thread 古雷
Hello: I found that MyODBC use mysql_ping to check connection and reconnect. After reconnect by using mysql_ping character_set_client, character_set_connection and character_set_results go back to latin1. But I need them to be utf8. What can I do with MyODBC? Regards, gu lei 祝 事业有成,家庭和睦,身体健康

connect with myODBC to mysql through proxy

2005-11-12 Thread Danny Stolle
Hi all, I have a windows computer in my network which needs an odbc connection through proxy. the only thing is that i don't know how to do this on a windows machine. i have installed the myodbc driver and it works for connecting on a mysql server in my local network. but i have an isp

Re: connect with myODBC to mysql through proxy

2005-11-12 Thread Gleb Paharenko
thing is that i don't know how to do this on a windows machine. i have installed the myodbc driver and it works for connecting on a mysql server in my local network. but i have an isp address, the database name. connecting without proxy, that is directly, works fine; but i need to make

RE: Access 2002 hangs with MyODBC 3.51.11

2005-10-19 Thread nikos
2002 hangs with MyODBC 3.51.11 The attachment was stripped by the list manager: forwarded to list for general information Shawn - Forwarded by Shawn Green/Unimin on 10/18/2005 12:07 PM - Shawn Green/Unimin 10/18/2005 11:48 AM To nikos [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject

Access 2002 hangs with MyODBC 3.51.11

2005-10-18 Thread nikos
Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC

Fw: Access 2002 hangs with MyODBC 3.51.11

2005-10-18 Thread SGreen
with MyODBC 3.51.11 nikos [EMAIL PROTECTED] wrote on 10/18/2005 10:58:51 AM: Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver

Re: Access 2002 hangs with MyODBC 3.51.11

2005-10-18 Thread Daniel Kasak
nikos wrote: Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download

Problem compiling MyODBC - looking for sql.h file

2005-10-11 Thread Ryan Stille
I posted this on the ODBC list, but there is not much traffic there and no one replied. Hopefully someone here has dealt with this. I am setting up ColdFusion to access a MySQL 4.1.x database. This required new MyODBC drivers to be installed on the system for ColdFusion. After a lot of trial

Re: Problem compiling MyODBC - looking for sql.h file

2005-10-11 Thread walt
Ryan Stille wrote: I posted this on the ODBC list, but there is not much traffic there and no one replied. Hopefully someone here has dealt with this. I am setting up ColdFusion to access a MySQL 4.1.x database. This required new MyODBC drivers to be installed on the system for ColdFusion

Re: Connecting using MyODBC

2005-09-05 Thread Gleb Paharenko
Hello. I'm not familiar with this subject, however, have you been at: http://dev.mysql.com/doc/mysql/en/howto-cf.html http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html http

Connecting using MyODBC

2005-09-02 Thread Ryan Stille
I am trying to connect to MySQL from within ColdFusion on a linux box. ColdFusion (version 5) came with a Merant driver, but it is too old to support transactions. I've downloaded libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so (MyODBC 3.5) and could not get either of these to work

return result set in SPs and using MyODBC

2005-08-22 Thread Shaghayegh Sahebie
context MySQL in the application. can i set a cursor out put parameter and return it?(just like Oracle) or it has another solution? and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for OLEDB

Re: return result set in SPs and using MyODBC

2005-08-22 Thread Gleb Paharenko
parameter and return it?(just like Oracle) or it has another solution? and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for OLEDB) but i think somewhere in passing the call statement it had put

myodbc driver araise full table scan

2005-08-08 Thread chenwei
mysql,您好!  i use myodbc to connect to a big table, to my surprise, myodbc araise full table scan and crash. could anybody help me with that?  致 礼!   chenwei [EMAIL PROTECTED]  2005-08-08

Re: myodbc driver araise full table scan

2005-08-08 Thread Gleb Paharenko
Hello. Please, provide more information about your software and oprating system. Include versions of MySQL and MyODBC. See: http://dev.mysql.com/doc/mysql/en/bug-reports.html http://dev.mysql.com/doc/mysql/en/myodbc-bug-report.html chenwei [EMAIL PROTECTED] wrote: i use

Re: Problem with datetime values and MyODBC driver

2005-08-05 Thread Dušan Pavlica
Sent: Friday, August 05, 2005 6:34 AM Subject: Re: Problem with datetime values and MyODBC driver Dušan Pavlica wrote: Hello, I'm working in C++ Builder 6.0 and I'm trying to create application which could connect through ADO components to different databases using ODBC drivers. If I

Re: Problem with datetime values and MyODBC driver

2005-08-05 Thread Gleb Paharenko
parametr and I fill this parametr with valid datetime value then I can see in MYSQL's query log that only date portion is used. But if I use same query object to connect to MS Access then data in MS Access are OK. Win XP, MyODBC 3.51.11, MySQL 4.1.9 Does anybody have any idea how

Problem with datetime values and MyODBC driver

2005-08-04 Thread Dušan Pavlica
query log that only date portion is used. But if I use same query object to connect to MS Access then data in MS Access are OK. Win XP, MyODBC 3.51.11, MySQL 4.1.9 Does anybody have any idea how to solve this problem? Thanks in advance Dusan Pavlica

myodbc cygwin

2005-06-15 Thread Jan Bartholdy
Dear All, I tried several times to install myodbc 3.51.11 in cygwin (newest, recently updated version) without any success. ./configure works perfect, including the optional packages unixodbc and mysql which I have already installed without any problems. Make fails and make configure too

Any limit for MyODBC connections?

2005-05-23 Thread lakshmi.narasimharao
Hi, Is there any database login restriction for myODBC? meaning there is any upper limit of number of connections? Please help me in this. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments

Re: myodbc on mandrake

2005-03-21 Thread Gleb Paharenko
Hello. If you can't find rpms with this driver, you may install it manually. At first you should install unixODBC or iODBC. Then install MyODBC using binary tarball. See: http://dev.mysql.com/doc/mysql/en/myodbc-unix-tarball-installation.html Put the correct information

myodbc on mandrake

2005-03-20 Thread symbulos partners
Dear friends, I cannot locat the odbc driver for mysql in mandrake. Does anyone have an idea about the whereabouts of the thing? thanks in advance -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list

myodbc, mysql 5.0.0-alpha

2005-03-19 Thread Frederik Eaton
I'm having trouble compiling myodbc-3.51.11 against mysql 5.0.0 - something about int2str has too many arguments - should I be using a newer version of myodbc (I couldn't find one), or is it not supported yet for mysql 5.0.0, or ...? Running debian / linux 2.6.9-2-k7. Frederik -- http

Does MyODBC support SQLDescribeParam ?

2005-03-01 Thread Gu Lei
Hello: I need SQLDescribeParam to get parameters' type information. But with MyODBC3.51 and MYSQL 4.1.10max I got wrong type and wrong number of parameters. Does MyODBC support SQLDescribeParam ? When will MyODBC support SQLDescribeParam ? Thanks. Regards, Gu Lei -- inline: cover.jpg

MyODBC SQLDescribeCol can't get ColumnSize of any String types column

2005-03-01 Thread Gu Lei
Hello: MyODBC3.51 MYSQL4.1.10-max MyODBC SQLDescribeCol can't get ColumnSize of any String types column. SQLDescribeCol can get ColumnSize of numeric column. Why ? Regards, Gu Lei -- inline: cover.jpg-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

MyODBC 3.5.9 and MySQL 4.1.8

2005-01-05 Thread nikos
Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet

RE: MyODBC 3.5.9 and MySQL 4.1.8

2005-01-05 Thread Mechain Marc
Have a look at: http://dev.mysql.com/doc/mysql/en/Old_client.html Marc. -Message d'origine- De : nikos [mailto:[EMAIL PROTECTED] Envoyé : mercredi 5 janvier 2005 10:09 À : mysql@lists.mysql.com Objet : MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've

RE: MyODBC 3.5.9 and MySQL 4.1.8

2005-01-05 Thread Homam S.A.
2005 10:09 À : mysql@lists.mysql.com Objet : MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got

RE: MyODBC 3.5.9 and MySQL 4.1.8

2005-01-05 Thread Tom Crimmins
Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror that has it: http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: nikos Sent: Wednesday, January 05, 2005 3:09 AM

RE: MyODBC 3.5.9 and MySQL 4.1.8

2005-01-05 Thread Homam S.A.
Tom, this is awesome! It must have been fresh out of dev because I downloaded 3.51.09 a couple of days ago. I just downloaded it and it works fine with 4.1 authentication. Thanks! --- Tom Crimmins [EMAIL PROTECTED] wrote: Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror

Re: MyODBC 3.5.9 and MySQL 4.1.8

2005-01-05 Thread Prasad Mhatre
I Agree I did downloaded from dev.x MyODBC 3.5.10-x86-win-32bit.exe and it works with MySQL 4xx Thanks Love and regards Prasad - Original Message - From: Homam S.A. [EMAIL PROTECTED] To: Tom Crimmins [EMAIL PROTECTED]; nikos [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday

MyODBC 3.51.10

2005-01-04 Thread Erich Beyrent
I somehow managed to download and install MyODBC 3.51.10 on my XP box, and it connects with no problems to my database server running version 4.1.7. However, it seems that MySQL is only allowing downloads for 3.51.9, and when I installed it on my Server 2003 and attempted to connect, I get

RE: MyODBC 3.51.10

2005-01-04 Thread J.R. Bullington
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the my.ini file. Set-variable = old_passwords=1 It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password hashing, 4.1.x uses a more secure one that will be covered in MyODBC 3.53 (coming soon...). J.R

RE: MyODBC 3.51.10

2005-01-04 Thread Erich Beyrent
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the my.ini file. Set-variable = old_passwords=1 It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password hashing, 4.1.x uses a more secure one that will be covered in MyODBC 3.53 (coming soon

RE: MyODBC 3.51.10

2005-01-04 Thread Tom Crimmins
4.1 auth is not supported until MyODBC 3.51.10. I don't know why the win binaries are not on the download page anymore, though the source is there. Here is a mirror with the windows binaries. http://mysql.netvisao.pt/Downloads/MyODBC3/MyODBC-3.51.10-x86-win-32bit.exe --- Tom Crimmins Interface

Re: Help using SSL from VB client, using MyODBC

2004-11-11 Thread Gleb Paharenko
. What I don't know how to do it make my client use SSL with MySQL. Can you help me? or give me some direction? My application runs on M$ Windows. It's written in M$ Visual Basic 6 from Visual Studio 6. I'm using MDAC 2.7 and M$ ADO. I'm using MyODBC 2.50 but can easily and happily

Help using SSL from VB client, using MyODBC

2004-11-10 Thread William Blair Wagner
and connections. What I don't know how to do it make my client use SSL with MySQL. Can you help me? or give me some direction? My application runs on M$ Windows. It's written in M$ Visual Basic 6 from Visual Studio 6. I'm using MDAC 2.7 and M$ ADO. I'm using MyODBC 2.50 but can easily and happily upgrade

Re: Still problem with MyODBC :((

2004-09-13 Thread SGreen
= OLD_PASSWORD('fixme') where user = 'odbcuser'; Then you will be able to authenticate. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Danesh Daroui [EMAIL PROTECTED] wrote on 09/11/2004 06:24:17 AM: Hi all, I have still problem with MyODBC. When I want to connect to my

Re: Still problem with MyODBC :((

2004-09-12 Thread Daniel Kasak
Danesh Daroui wrote: Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents

Still problem with MyODBC :((

2004-09-11 Thread Danesh Daroui
Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about

Mysql 4.1 and MyODBC don't like each other

2004-09-07 Thread Nico Sabbi
Hi, I tried to compile Myodbc 3.51.0[67] against mysql4.1, but while 0.7 doesn't even configure correctly because of undefined automake macros, .06 fails because it calls int2str() with three parameters instead of 4 (defined in m_string.h). What does the 4th parameter mean? Is MyODBC a dead

error while working with MySQL MyODBC and MS Access 97

2004-08-06 Thread Joshua Bacher
hi their, i have a problem working with access mysql and myodbc. i ported a access database to mysql. now i had to integrate the mysql db in the old access frontend. i realized this with linked tables. now i have a problem, because myodbc seems to return the wrong results. the relation between

install myodbc 2.50.39

2004-06-16 Thread Silmara
I'm installing the myodbc2.50.39win95 in a Athlon XP 2200+, but when I start the setup.exe the following error: insufficient memory or disc space. After this, it's finishing the installation. My machine have RAM 256 and +/- 30GB free disc. What is happening? Thanks Silmara

myODBC connect problems

2004-06-08 Thread Annie Law
Hi, I would appreciate help on the following. I have installed myODBC 3.51 on my Windows 2000 computer. I am trying to connect mysql database on a linux server. I configured the ODBC data source adminstrator from the administrative tools. After trying to add a new data source and entering all

Re: myODBC connect problems

2004-06-08 Thread SGreen
to: 06/08/2004 02:16 Subject: myODBC connect problems PM

MyODBC - SQLColAttribute with SQL_DESC_OCTET_LENGTH parameter

2004-05-30 Thread Karam Chand
Hello, In my application, I am connecting to various RBDMS but primarily SQL Server and MySQL using ODBC 3.0 driver. In SQL Server, if I execute SQLCollAtrribute with SQL_DESC_OCTET_LENGTH, it is returning me the maximum number of bytes that the column can have irrespective of whether the column

myodbc - ms-access problem: table contents not shown

2004-04-06 Thread Mike Bosschaert
codeweaves) and it works (can make and view tables and forms and modules, etc). I also setup ODBC (installed myodbc 3.51, newest mdac, and jet sp). I can make an ODBC-pointer to my database. In Access I can link to the ODBC definition and the table shows up in the table-list, I can view the table

myodbc compiling priblems

2004-03-29 Thread Luiz Rafael Culik Guimaraes
Dear Friends then in compiling MyODBC (3.51.06)... Making all in samples make[1]: Entering directory `/storage/MySQL/src/MyODBC-3.51.06/samples' source='my_basics.c' object='my_basics.o' libtool=no \ depfile='.deps/my_basics.Po' tmpdepfile='.deps/my_basics.TPo' \ depmode=gcc3 /bin/sh

MyODBC and Windows XP

2004-03-18 Thread José Angel Blanco Linares
Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server, and via MyODBC I connect to the MySQL server to run my

Re: MyODBC and Windows XP

2004-03-18 Thread Daniel Kasak
Jos Angel Blanco Linares wrote: Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server, and via MyODBC I

Re: MyODBC and Windows XP

2004-03-18 Thread Miguel Angel Solorzano
At 19:14 18/3/2004, José Angel Blanco Linares wrote: Hi, Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server

Re: MyODBC Help

2004-02-19 Thread Michael Stassen
to install MyODBC and now I get this error upon 'make': ../libtool[1296]: yes/lib: not found libtool: link: cannot determine absolute directory name of `yes/lib' make[2]: *** [libmyodbc3.la] Error 1 make[2]: Leaving directory `/virtual/MyODBC-3.51.06/driver' make[1]: *** [all] Error 2 make[1

Error installing MyODBC - Please help...

2004-02-19 Thread Morgan, Andrew R.
Hello all. I'm trying to 'make' MyODBC, and I receive the following error: gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -Iyes/include -O3 -DDBUG_OFF -c utility.c -Wp,-MD,.deps/utility.TPlo -fPIC -DPIC -o utility.lo /bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -o

Re: Field Name whitespace via MyODBC

2003-12-12 Thread info
, December 11, 2003 11:19 AM Subject: RE: Field Name whitespace via MyODBC I can just alter table to rename the fields right? -Original Message- From: Patrick Sherrill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:27 AM To: Brian Duke; [EMAIL PROTECTED] Subject: Re

Field Name whitespace via MyODBC

2003-12-11 Thread Brian Duke
On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data

Re: Field Name whitespace via MyODBC

2003-12-11 Thread Patrick Sherrill
Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: Brian Duke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:50 AM Subject: Field Name whitespace via MyODBC On the windows machine I have Acess2003. I

RE: Field Name whitespace via MyODBC

2003-12-11 Thread Brian Duke
I can just alter table to rename the fields right? -Original Message- From: Patrick Sherrill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:27 AM To: Brian Duke; [EMAIL PROTECTED] Subject: Re: Field Name whitespace via MyODBC Brian, I think you are going to need

Possible MyODBC Bug?

2003-12-11 Thread Randy Chrismon
First, is there a separate mailing list for MyODBC issues? I have Lotus Script code that uses odbc in an attempt to write data to a MySQL table. I can't get even the very first record inserted because I consistently get the following error: Field mapping failed due to a missing field

MyODBC errors

2003-12-05 Thread trevor%tribenetwork.com
Mysqlians, I am getting the following errors in an application log for 4.0.16 mysql and 3.51 myODBC SQL Error: SQLSTATE=S0002 Native error=1146 '[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16-Max-log]Table 'TRIBE.NETWORK_VECTOR' doesn't exist' SQL Error: SQLSTATE=S1000

Re: MyODBC and MySQL 4.1

2003-11-29 Thread Director General: NEFACOMP
I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.exe

Re: MyODBC and MySQL 4.1

2003-11-29 Thread Director General: NEFACOMP
I have found the issue. It is talked about at the URL http://www.mysql.com/doc/en/Password_hashing.html The question now is When Will MyODBC support that new hashing? Thanks Emery - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: abaid al-mutairy [EMAIL

MyODBC and MySQL 4.1

2003-11-28 Thread Director General: NEFACOMP
Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my

Re: MyODBC and MySQL 4.1

2003-11-28 Thread Sergei Golubchik
Hi! On Nov 27, Director General: NEFACOMP wrote: Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create

MySQL/MyODBC/Access 97 alpha-sorting doesn't work. PLEASE HELP.

2003-11-13 Thread Apollo (Carmel Entertainment)
I have Mysql 4.0.14 with MyODBC3.51 and Access97. I have a query SELECT inquiry_data_simple.inquiry_id, inquiry_data_simple.organization, inquiry_data_simple.event_date, inquiry_data_simple.event_id FROM inquiry_data_simple ORDER BY inquiry_data_simple.organization; The organization field does

Ann: New Article on SSH Port Forwarding of MyODBC

2003-10-27 Thread mhillyer
Hi Everyone; I have published a new article covering SSH port forwarding of MySQL sessions, which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html The article covers connecting a Windows client to a *NIX based server. Anyone with previous experience will probably find the

RE: New Article on SSH Port Forwarding of MyODBC

2003-10-27 Thread Andrew
known? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 15:39 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ann: New Article on SSH Port Forwarding of MyODBC Hi Everyone; I have published a new article covering SSH port forwarding

RE: New Article on SSH Port Forwarding of MyODBC

2003-10-27 Thread Adam Trimeloni
to the normal post-office, just so the post-office will send it back to you) Anyway, that's my take on it. -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

RE: New Article on SSH Port Forwarding of MyODBC

2003-10-27 Thread mhillyer
-cards.(hopefully, your internal mail system would know not to send this message out to the normal post-office, just so the post-office will send it back to you) Anyway, that's my take on it. -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc

PHP/MySQL/MyODBC drivers

2003-10-02 Thread Terry . L . Long
I need to know the syntax to link two tables together that are in two seperate DB's using the ODBC drivers in PHP. Can anyone help with an example? Thanks Terry L. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: PHP/MySQL/MyODBC drivers

2003-10-02 Thread Paul DuBois
At 16:43 -0400 10/1/03, [EMAIL PROTECTED] wrote: I need to know the syntax to link two tables together that are in two seperate DB's using the ODBC drivers in PHP. Can anyone help with an example? Depends on what you mean by link two tables together. if you're trying to perform a join, you can

myODBC on Cobalt RAQ4

2003-09-04 Thread Phillip Blancher
Hello all, I was wondering if any of you have ever added the MyODBC to a Cobalt raq4? I have downloaded the RPM ( MyODBC-3.51.01.i386-1.rpm ) When I go to rpm the file I recieve the error below--- [root /JON]# rpm -ivh MyODBC-3.51.06-1.i386.rpm error: failed dependencies

MyODBC 3.51 + Windows Server 2000 = Memory Leak

2003-08-23 Thread Jon Drukman
We have a very high traffic mysql app running in ASP on Windows 2000. It connects to a Linux mysql server (4.0.12) via ADODB and MyODBC. It's leaking memory like crazy. We've implemented connection pooling and long timeouts on connections so as to minimize the number of connects closes

Re: MyODBC 3.51 + Windows Server 2000 = Memory Leak

2003-08-23 Thread Jim McAtee
We're running MyODBC 3.51 on Windows 2000 Ssrver with IIS5 and ColdFusion 5 applications and don't see any memory leaks. In a very hight traffic application, you'll want to keep connections open as long as possible anyway. There's also a MyODBC list that you might try. - Original Message

Error configuring myodbc ver 3.51

2003-07-01 Thread marvc
New list member and mysql newbie with first time post. I'm running into a problem getting MyODBC ver3.51 configured on my RH7.3 server running mysql 4.0.12. Anyone happen to be familiar with this error when configuring MyODBC: Could not find 'libmysqlclient' from '/usr/local/mysql/lib/mysql

Is the MyODBC password encrypted?

2003-06-27 Thread Mike Fish \(Shoal Computer Solutions Ltd\)
Hi I'm connecting to a MySQL server on the internet from a VB6 app on Win2K using MyODBC. I understand that the connection itself is not secure. I cannot implement SSH for the connection as my ISP does not support this with MySQL. However, when MyODBC sends the username and password etc

RE: Is the MyODBC password encrypted?

2003-06-27 Thread Mike Hillyer
Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form, but not encrypted. Is the remote server MySQL 4.x? You could possibly use Stunnel (www.stunnel.org) to access the server via SSL. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Mike Fish (Shoal

Re: Is the MyODBC password encrypted?

2003-06-27 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike Hillyer wrote: Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form, but not encrypted. Is the remote server MySQL 4.x? You could possibly use Stunnel (www.stunnel.org) to access the server via SSL. The MySQL protocol

Re: Authentication problem with MyODBC 3.51

2003-06-24 Thread Paul DuBois
At 9:17 +0200 6/17/03, Laura del Cano wrote: Hello, I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000. I create a new database in Mysql and a user with all the privileges on it (using GRANT ALL privileges...). I create a User DSN in the windows Control Panel and when I test

Re: MyODBC 3.51 for MySQL 4.1

2003-06-24 Thread Paul DuBois
At 9:54 +0100 6/17/03, [EMAIL PROTECTED] wrote: I am using MySQL 4.1 alpha for windows for new development. Is MyODBC 3.51.06 supposed to work for MySQL 4.1 alpha? I get message [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL

Authentication problem with MyODBC 3.51

2003-06-17 Thread Laura del Cano
Hello, I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000. I create a new database in Mysql and a user with all the privileges on it (using GRANT ALL privileges...). I create a User DSN in the windows Control Panel and when I test the connection (in the same DSN panel) I get

MyODBC 3.51 for MySQL 4.1

2003-06-17 Thread Rajendra . Wadje
I am using MySQL 4.1 alpha for windows for new development. Is MyODBC 3.51.06 supposed to work for MySQL 4.1 alpha? I get message [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL client. Any clue about when MyODBC 3.52

Problem compiling MyODBC 3.51.06

2003-05-29 Thread Pierre
Hi, I try to compile MyODBC-3.51.06 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : # gmake Making all in driver gmake[1]: Entering directory `/tmp/MyODBC-3.51.06/driver' gmake all-am gmake[2]: Entering directory `/tmp/MyODBC-3.51.06

MyODBC on AIX 4.3.3

2003-04-02 Thread Hannes
I was wondering whether somebody on this list has successfully installed MyODBC on AIX 4.3.3. I tried it today using the 3.51 binaries and could not get it to work with either the latest iODBC or unixODBC driver manager. I someone has experience I happy to post more detailed error messages

Can't set timeout on MyODBC/MySQL from an ADO/ASP program on Windows XP?

2003-03-26 Thread Emmanuel KARTMANN
Hi, I've tried without success to set a timeout for SQL queries on a MySQL server (version 4.0.12 - so far the latest production release) running on a Windows XP SP1 box. The calling program is a Web site developed in ASP (going through ADO to access MyODBC...). I tried many different methods

Using LOAD DATA IN FILE or SOURCE with MyODBC.

2003-03-25 Thread William Bailey
Hello all, I am thinking about produceing a small app that will use MyODBC on a windows machine to connect to a MySQL server on a remote FreeBSD machine. I already have something that will open an MS Access database and output either a MySQL syntax or CSV file and before i

Question on MySQL, MyODBC VC++

2003-03-24 Thread Terrance Win
Hello Everybody, I install MySQL in my W2K server and MyODBC also. I created a new database named Log and tried to connect from my project in VC++ via MyODBC. But my program get a runtime error when it try to open the database. I used CRecordset class to open it. Then I tried to open

Re: Question on MySQL, MyODBC VC++

2003-03-24 Thread Martin Gainty
Terry- Personally I cant do much until I can see the stack trace, local variables and any diagnostics from your try/catch.. Regards, -Martin Hello Everybody, I install MySQL in my W2K server and MyODBC also. I created a new database named Log and tried to connect from my project in VC

AUTO_INCREMENT Columns reacting differently to MyODBC

2003-03-19 Thread Andrew Kuebler
In one of my tables, I have an AUTO_INCREMENT column that changes to #Deleted in each column in Access when I add a new record. To read the data, I just entered, I must close the table and then reopen it. In another table when I do the same thing, I see the new AUTO_INCREMENT number come up in the

Re: access-myodbc-interruption_mode?

2003-03-18 Thread [EMAIL PROTECTED]
[EMAIL PROTECTED] schrieb: access-2000 w2k-prof/xp-prof via myodbc 3.51 different mysql-servers (win-lin) everywhere the same, including win9x if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51 i cannot close ms-access: - free translation: this procedure will put

Re: access-myodbc-interruption_mode?

2003-03-18 Thread Daniel Kasak
[EMAIL PROTECTED] wrote: hi, access-2000 w2k-prof/xp-prof via myodbc 3.51 different mysql-servers (win-lin) if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51 i cannot close ms-access: - free translation: this procedure will put the current code back

  1   2   3   4   5   6   >