Hi,
I found a problem with your binary distribution of MyODBC 3.51 for Mac
OS X.
I downloaded the binary distribution of MyODBC 3.51 for Mac OS X (I am
currently using Mac OS X 10.2.4 Darwin 6.4). When I tried to use iODBC
I got a dynamic linking problem. More specifically, when running
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 into the interruption
mode. would you like
should initialize it at least with 0. ;)
Next time I post to the appropriate list (myodbc) ;)
Frank
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 11:03 PM
To: Naumann, Frank
Cc: '[EMAIL PROTECTED]'
Subject: Re: MyODBC: SQLBindParameter mix
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
Hi all,
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
How-To-Repeat:
I am tried to use MS DTS to transfer a table from MSSQL 2000 to MYSQL
3.23.55,
however there has an error during the transformation on one data type. The
error happens when I have a text datatype on MSSQL 2000 table, and
text/blob on MySQL table.
The error is fail to insert or
I have never tried MS DTS, but SQLyog works great for
me in transferring MS SQL Server data to MySQL.
--- phil [EMAIL PROTECTED] wrote:
How-To-Repeat:
I am tried to use MS DTS to transfer a table from
MSSQL 2000 to MYSQL
3.23.55,
however there has an error during the transformation
on
www.astatech.com and ZEOS components.
-Original Message-
From: Liu Qianghua-qch1942 [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 11:50 PM
To: [EMAIL PROTECTED]
Subject: How to connect to mysql server without myODBC
All,
I want to develop application with Delphi which can
There are some components named zeos library that can connect to a remote
mysql server without myodbc.
- Mensaje original -
De: Liu Qianghua-qch1942 [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviado: domingo, 02 de marzo de 2003 7:49
Asunto: How to connect to mysql server without myODBC
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
All,
I want to develop application with Delphi which can connect to remote mysql server.
Whether I must install myODBC? If are there another way, please tell me? Thanks.
Best Regards,
Q.H. Liu
-
Before posting, please check
Help!, I am developing a multilingual site in English,
Spanish and Japanese. I am using MySQL with PHP in the
server side, and Access 2002 in the local side, using
MyODBC to communicate MySQL with Access 2002.
MySQL and PHP works toguether ok in Japanese, English
and Spanish (using EUC_JP
Don't know, but:
Are you using the Japanese Access 2002? What locale is your OS configured
for?
HTH,
Tore.
- Original Message -
From: Juan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 6:12 AM
Subject: Problem with MySQL, MyODBC, Access 2002 and Japanese
Hi,
I am currently running mysql-3.23.52-3 on Linux 8.0 and myodbc 3.51.05 on win2000
machines
respectively.
Users and host IP has been setup on mysql, and innodb has been setup with as below.
innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=70M
set
Loren McDonald wrote:
Have you done all the office (or at least Access) XP updates? If not,
it is possible that one of them my resolve your crash problem. I have
been testing Access XP with the same versions of MyODBC and MySQL for a
few weeks now and have yet to see a crash. About the only
Hi All,
My MySQL Server is 3.23.53-max-nt. I'm linking to it via MyODBC
3.51.05.00 and accessing its tables via Access XP linked tables.
For some reason, Access XP crashes regularly in this setup. No
meaningful error messages, just crashes and reloads after a repair. Even
more odd (and I only
I have seen this behavior reported several times in regards to the MySQL
being accessed via MyODBC and MS Access, (various versions). Are you
detailing that Access crashes and you have to repair the MySQL tables? If
so, is there an error being written to the MySQL error log?
-Original Message
M Wells wrote:
Hi All,
My MySQL Server is 3.23.53-max-nt. I'm linking to it via MyODBC
3.51.05.00 and accessing its tables via Access XP linked tables.
For some reason, Access XP crashes regularly in this setup. No
meaningful error messages, just crashes and reloads after a repair. Even
more
Have you done all the office (or at least Access) XP updates? If not,
it is possible that one of them my resolve your crash problem. I have
been testing Access XP with the same versions of MyODBC and MySQL for a
few weeks now and have yet to see a crash. About the only problem I
have ran
PROTECTED]]
Sent: Sunday, 26 January 2003 2:33 PM
To: '[EMAIL PROTECTED]'
Subject: Needed: Working VB6 example of DAO DSN LESS connection using
MyODBC to MySQL preferably with passthruquery
This message intended for MyODBC questions list.
Hello VB6, MySQL, and DAO developers,
A very simple
Dear Sir or Madam,
I have been having problems downloading myodbc from your website.
I went to web page http://www.mysql.com/downloads/api-myodbc-2.50.html.
I then selected the option MyODBC 2.50.39NT/2000/XP full setup
(1.5M)Download
As a result of a number of attempts one of two things
This message intended for MyODBC questions list.
Hello VB6, MySQL, and DAO developers,
A very simple example of my problem:
Dim ws As Workspace
Dim conn As Connection
Dim str As String
Set ws = DBEngine.CreateWorkspace(testing, , , dbUseODBC)
str = odbc;driver={MySQL ODBC 3.51
I notice that sometimes when I establish a connection with myODBC with
Microsoft Access, and send it occasional sql statements it works fine at
first. But if you let it sit for, say, 30 minutes and comes back, the
Access table locks up. I am not sure if this is a problem with myODBC
(which I
-Original Message-
From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
I notice that sometimes when I establish a connection with
myODBC with
Microsoft Access, and send it occasional sql statements it
works fine at
first. But if you let it sit for, say, 30 minutes and comes back
Hi guys..
I'm building an entire portal system, with two separate layer.
An application layer on 2000 server with ASP, and database
layer on Red Hat 8 Mysql...
I try to connect my application to mysql via MyODBC connector
2.50.39 or 3.51.05, but i faced this problem:
[TXC] [MyODBC] lost
application to mysql via MyODBC connector
2.50.39 or 3.51.05, but i faced this problem:
[TXC] [MyODBC] lost connection to Mysql server during query (#2013).
I've tried to disable the iptable chain in DBserver assuming that
like a Firewall problem no results.
I've tried
Configuration:
- WinXP SP1 (Workstation)
- Windows 2000 SP2 (Server)
- MySQL 4.0.4-beta-max-ny-log
- MyODBC 3.51.05
- InnoDB
- Delphi 7
- ADO 2.7
Problem with simple query Delphi/MyODBC 3.51.05:
- qry.SQL.Add('select * from lokalen');
- qry.open;
When I open the query, the next message
I have the following problem:
I use Delphi 7 in combination with TADOquery and MyODBC 3.51.
I got unspecified error when i run the next query:
- qry.SQL.Add('select * from lokalen');
- qry.open;
if i define the query on design time (in the property SQL of
TADOQuery), it works fine
I've upgraded to 4.0.6 and now MyODBC does not function properly when it
used to work fine with 4.0.1. When I try to open a linked table in
Access I get the error:
ODBC--Call Failed
[MySQL][ODBC 3.51 Driver][mysqld-4.0.6*gamma-nt]Access denied for user:
'@(My IP)' to database '(Database name here
I think you need the ODBC driver for plain text files to do so. It is
generally installed in Win32, but I do not know about Linux. As to use
MyODBC for that, I do not think it will work.
HTH
JFernando
** sql **
-Original Message-
From: Nikola Pentchev (ESA) [mailto:[EMAIL PROTECTED
Hello,
I am writing this e-mail just to ask about the following:
I plan to implement some data storage in flat ASCII files. I want to work with SQL in
order to automate requests from/to the files. Can I use MyODBC in order to work
against flat files? If yes, what do I need to install (can I
Hi ¡ :
I Have a problem. I 'm connecting Centura Team Developer to Mysql Trough
myodbc . when i send a select to the server , i can see that the select
statement works fine. but when I evaluate the variables that the server
returns , it returns the CHAR fields as empty values . this does
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
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
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
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
granted.
Host Db User
192.168.0.ntsmaster mysql (all privileges selected)
- Original Message -
From: John Jacques
To: Jeff Bluemel
Sent: Saturday, October 05, 2002 6:26 PM
Subject: Re: myodbc prolbems between linux windows
Ha, I don't recall either
with no problems, telnet between the 2,
ftp, web applications. there is no firewall or restrictions between the 2
computers, and I can connect to mysql on the localhost (which is the linux
box).
I am using the myodbc driver. I am completely stuck on this, and I cannot
figure out how to resolve this.
I have
Hello
I'm trying to connect a Lotus Server through DECS, to a MySQL db.
The Lotus and the MySQL servers are installed on the same linux machine.
I installed iodbc, myodbc, successfully tested them with odbctest from
Linux, and with ndctest (or smth like that) from a Windows system.
Anyway, I'm
Subject: re: Connecting to remote database using MyODBC
From: Egor Egorov
Date: Fri, 20 Sep 2002 16:33:01 +0300
Adam,
Thursday, September 19, 2002, 8:33:17 PM, you wrote:
AW Have been trying to connect to a remote MySQL server from Matlab through
an
AW ODBC connection, however
Adam,
Tuesday, September 24, 2002, 2:57:04 PM, you wrote:
Subject: re: Connecting to remote database using MyODBC
From: Egor Egorov
Date: Fri, 20 Sep 2002 16:33:01 +0300
Adam,
Thursday, September 19, 2002, 8:33:17 PM, you wrote:
AW Have been trying to connect to a remote MySQL server
}' command I get access
denied because the user has only 'USAGE' privileges on all databases.
Since MyODBC connects to a single database, it would get an access denied
error with the USAGE priv.
issuing a 'GRANT SELECT ON *.* TO testuser@'%' IDENTIFIED BY password'
allows access for that user
AW Have been trying to connect to a remote MySQL server from Matlab through
an
AW ODBC connection, however the error is receive is
AW [TCX][MyODBC]Can't connect to MySQL server on
AW 'server name' (10060)
AW I have searched the docs and archives and google... But can't see any
answer
Adam,
Thursday, September 19, 2002, 8:33:17 PM, you wrote:
AW Have been trying to connect to a remote MySQL server from Matlab through an
AW ODBC connection, however the error is receive is
AW [TCX][MyODBC]Can't connect to MySQL server on
AW 'server name' (10060)
AW I have searched the docs
Hi,
Have been trying to connect to a remote MySQL server from Matlab through an
ODBC connection, however the error is receive is
[TCX][MyODBC]Can't connect to MySQL server on
'server name' (10060)
I have searched the docs and archives and google... But can't see any answer
to what this error
I tried to use myODBC 3.51 to connect OpenOffice1.0.0 to my MySQL db on
my 'Debian GNU/Linux Sarge' machine. I was able to view tables and
addbut I wasn't able to add new records. I installed the 'stable'
version of the myODBC driver and then it worked. (Same options/programs
other myODBC
-2.2.2.tar.gz from www.unixodbc.com
MyODBC-3.51.03.tar.gz from www.mysql.com
HOWEVER, when building the driver from MyODBC 3.51.02 which came with
unixodbc,
this seg fault doesn't occur
The server in binary distribution
mysql-3.23.52-pc-linux-gnu-i686.tar.gz
und the shared lib
Glory!
I'm looking for a Provider for the myODBC Driver to
connect my Visual Basic code with my mySQL database.
I have in kknowledge one such provider known as
MSADSQL..but niether do i know where to find it nor do
i know whether it's the right thing or not.
T. Edison Jr
Hi - I'm having some problems with using MySQL,
MyODBC, and Coldfusion together, so I thought I'd post
here and see if anyone had any ideas on how to fix the
problems. I see other people have had similar issues,
so hopefully someone can help me out.
So, we've running on Solaris 2.7, with Mysql
Hello All,
I need help with MyODBC, I need to create a front-end for MySQL using Visual
C++ 6.0.
Have any one used MyODBC with Visual C++? I need a source code how to create
a ODBC connection using MyODBC drivers.
Please help,
Thanking in Advance...
Regards
Nitesh
Hi,
When I open a link table in access (that is opening a table in a mySQL
dbase on our server), it will not allow me to alter the data.
It keeps telling me that someone else is trying to access or alter the
data and that I have to Copy to Clipboard or Drop Changes. I know
100% that I am the
Hi again . I have a project whereby the client has a legacy M$ Access (
as far as im concerned ) and i'm to design.build and construct a MySql
v4 Back-end and more than likely pursue a front-end with MS Access due
to easability and conversant of it's user's nevertheless are there any
field
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my
gui, and MyODBC 2.50.39-nt
I am able to run reports, queries and use the SQL pass through in access
to retrieve data from the MySQL database through MyODBC. The
problem is that I can not create a table in MySQL from
I may be a little OT, but the current myODBC driver does work quite well
with Access. So you can use Access to write your queries and app etc and
have mySQL as your backend.
I've mainly used Access and myODBC to port manipulate Access data to
mySQL. For writing mySQL frontends my preferred
sql query
We have data stored as BIGINT in unix, and there are 32bit unsigned values
but nothing larger. I would assume if we convert this to integer in win98
it would seem that values over 31bits would be wrong. Are there workarounds
for this? Is this also an issue in later version of
Nitesh,
Tuesday, July 16, 2002, 3:46:39 AM, you wrote:
ND I have my MySql 3.23 running, I installed MyODBC in my Win98 PC and created a DSN
for MySql.
ND When I use MS Access to connect to MySql I get an Error saying Host 192.168.1.103
is not allowed to connect to this MySql Server.
ND I
HI
Lately I tried to connect MSQL with new Autocad 2002.
In earlier version of Autocad it was impossible.
In fact Autocad 2002 also doesn't support Mysql , but
when I try to connect Mysql with Autocad2002 by MYODBC
it works.The problem is that always when try to look on the table
when I connect
Hello All,
I have my MySql 3.23 running, I installed MyODBC in my Win98 PC and created a DSN for
MySql.
When I use MS Access to connect to MySql I get an Error saying Host 192.168.1.103 is
not allowed to connect to this MySql Server.
I also tried connecting using telnet 192.168.1.109 3306 I
Look at the GRANT documentation to see how mysql authenticates using host and user.
-Original Message-
From: Nitesh Divecha [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 5:47 PM
To: [EMAIL PROTECTED]
Subject: MyODBC Error
Sensitivity: Confidential
Hello All,
I have my MySql
Sorry about the rant.. I've been spending the last two days trying to
install gcc, MySQL, MyODBC and UnixODBC on several AIX and HP boxes with
varying degrees of success and lots of aggravation (much of it due to
braindead configure scripts that ALWAYS want to leave gcc arguments around
when
I've found a nasty in SQLError.. I'm guessing it is a causualty of
cut-n-paste.. Notice that the CLEAR_STMT_ERROR macro is being used to clear
the error of hstmt when it's null.. Not only is the macro name wrong, but
the argument as well.. In my case, hstmt was null, and it was dereferencing
Ok.. Bug #2.. (yes, I'm getting a bit cranky!)..
The copy_if_not_empty() routine is whacking my username (and it would my
password if it was also set). In my case, the routine gets the following
args :
copy_if_not_empty (to=0x7f7f41b0 rflower, max_length=64, from=0x7f7f0980
, length=-3) at
Hi,
I´ve emailed the list but my problem doesnt seem to have catch much
attention. I guess a re-phrasing might help.. It´s pretty
simple (I´m using myODBC 3.51 and VC++ 6.0 ) : how do I declare and bind
variables/parameters for a TIMESTAMP column?
Here´s what I´ve done so far: I declare my
Hello,
I am trying to set up a MyODBC connection from my MAC OS9. I
have a filemaker database on the MAC OS 9 machine that I would
like to connect to a MySQL database on my host server. There are
MyODBC drivers published for MAC OS X on the MyODBC downloads
page, but they don't seem to work
For anyone else having this problem building the MyODBC MySQL driver, I
ended up commenting out all of the ctl3d calls in setup.c (and replacing
SetWindowLong(hdlg, DWL_MSGRESULT,Ctl3dDlgFramePaint(hdlg, wMsg, wParam,
lParam)); with SetWindowLong(hdlg, DWL_MSGRESULT,lParam);) The driver
now
When trying to use the /auto feature of the Windows MyODBC driver setup
program, it wants to use read a odbcinst.ini file. Anyone have any info
on the format of this file and what should be in it? Many thanks in
advance...
-- Rick
MySQL spam killer strikes again
Hi,
I have installed the newest version of MyODBC 3.51 in my PC with Win98, but
do not install the MyODBC 2.50. After I start the MySQL and open the
MySQLAdmin, the box titled MyODBC in the Environment page shows Not
Found. However, all databases are shown on the Database page. Later when
I want
-Original Message-
From: TH Leung
Sent: Friday, June 14, 2002 11:55 AM
To: '[EMAIL PROTECTED]'
Subject: MyODBC 3.51 - Transaction is not enabled
Hi,
I have installed the newest version of MyODBC 3.51 in my PC with Win98,
but do not install the MyODBC 2.50
I have an sql database on my Verio hosted web site using MySQL.
In order to do an sql query I need the MyODBC on my computer.
I downloaded the current version of MyODBC (myodbc-2.50.39-win95.zip) and ran
setup.exe.
The installation stopped dead with the following error message:
An error
]
[EMAIL PROTECTED]
- Original Message -
From: Jerry Burg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 9:14 PM
Subject: Re: Unable to Install MyODBC on Windows 98 PC
I have an sql database on my Verio hosted web site using MySQL.
In order to do an sql query I need
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
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
Hi Venu,
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'
, each with their own mysql login, the machine is a newly setup
(maybe about 2 weeks now), and the first one we have here that uses MySQL]
system info:
Win2k (w sp2)
Apache 1.3.24
ColdFusion 5
Php 4.2.1
MyODBC 2.50.39-nt
MySQL 3.23.49-nt
each virtual domain that uses mysql database has their own
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a
user ODBC@localhost fixed it.
all off a sudden i need a user named ODBC@localhost, and last i checked, i'm
the only one here that knows anything about how to use mysql here at the
office. so what might have been
Ray,
Thursday, June 06, 2002, 4:39:11 PM, you wrote:
R Error Occurred While Processing Request
R Error Diagnostic Information
R ODBC Error Code = S1000 (General error)
R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
R The error occurred while processing
Processing Request
R Error Diagnostic Information
R ODBC Error Code = S1000 (General error)
R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password:
NO)
R The error occurred while processing an element with a general identifier
of R (CFQUERY), occupying document position (3:1) to (4
Hi.
Can we use Access to link table in MySQL and force Access to refresh data
from MySQL automatically when data in MySQL table have change.
Kittiphum Worachat,M.T.
www.hatyailab.com
-
Before posting, please check:
://www.calevans.com
*
-Original Message-
From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 7:54 AM
To: [EMAIL PROTECTED]
Subject: Autorefresh MyODBC
Hi.
Can we use Access to link table in MySQL and force Access to refresh data
from MySQL automatically when data in MySQL
This depends on whether the table will always be open
I believe you are using MyODBC connection.
Create a new table and then choose link table in access.
While linking choose to save the password.
Any changes which will occur in the mysql table will be viewable from
access.
But this will occur
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
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
Hello,
Can someone tell me what is the difference between MyODBC and iODBC?
My understanding is that in order for an application to be able to talk to
a database it needs a protocol, and that protocol would be ODBC.
What I'm trying to do is have the Tango2000 application server
yvon,
Monday, May 27, 2002, 11:33:42 PM, you wrote:
yd I tried to connect to a mysql database running on a
yd linux server using an odbc connection in windows 98. I
yd get the following message:
yd [TCX][MyODBC]Host x.x.x.x is not allowed to connect to
yd this MySQL server
yd (#1130)[Microsoft
Hi,
I tried to connect to a mysql database running on a
linux server using an odbc connection in windows 98. I
get the following message:
[TCX][MyODBC]Host x.x.x.x is not allowed to connect to
this MySQL server
(#1130)[Microsoft][ODBC Driver Manager] Connection not
open (#0)
The username
Hi
I'm new with mySQl and I'm experiencing problems when using it with
myODBC (my OS is W2000).
I developped a short program which uses myODBC to insert and
retrieves values from a mySql table. The problem I have is : When I
send,threw myODBC,
a query such that:
insert into table1 values
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
-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
i am connecting to mysql thru myodbc using iodbc driver manager. when
retrieving data, SQLFetch() crashes with
SIGSEGV signal. i 'gdb'ed into SQLFetch() and found that it crashed in the
very first statement, ENTER_STMT(pstmt). there are no problems when
executing SQLExecDirect and SQLBindCols
Hello,
I can't think straight today. So please help me:
I downloaded and installed myODBC 3.51. As far as I understand, it is
only the driver, which provides the connection to the database. In my
example, it is MySQL 3.23.49.
The manual says that in my application I have to allocate
Python has its own MySQL interface module.
You don't need MyODBC.
Sabine Richter wrote:
Hello,
I can't think straight today. So please help me:
I downloaded and installed myODBC 3.51. As far as I understand, it is
only the driver, which provides the connection to the database. In my
example
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.
SQL 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
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?
- Original Message -
From: Venu [EMAIL PROTECTED]
To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 2
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
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
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
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
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
101 - 200 of 528 matches
Mail list logo