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.
--
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 http
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 arc
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 tech
th
> > 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
> >
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
", 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&q
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 w
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/pro
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/pro
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 num
:
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
__ ___ ___ __
/ |/ /_ __/
sions 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 f
BMS, 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 l
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/pro
load 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
__ ___ ___ __
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]>
/ /|_/
ximately 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 an
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/
Regar
r, 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
__ ___ ___ _
e 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
on?
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, Ve
on 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]>
/ /|_/ / // /\ \/ /_/ /
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]>
/ /|_/ / // /\ \/ /_/ / /
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 suppor
:
> -2.50.36 with Borland BDE 3.0 on win2k
> -3.51.01 with Borland BDE 3.0 on win98
> Can anybody advice me on the best ODBC drivers to use to get the maximum
> speed of it.
> Thanx
Better to use 2.50.39 only. If you want all features with ODBC 3.x spec,
then use 3.51.02.
Regard
N 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
gt; 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
ng 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
m.
> 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 tech
urce 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, V
sql.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
__ ___ ___ __
/ |/ /_ __/
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]>
esent 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.
base 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
__ ___ ___ __
T, 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
__ ___ ___ __
/ |/ /_ __/ __/ __
king 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
de
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 th
a 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.co
Hi Monty,
>
> >>>>> "venu" == venu <[EMAIL PROTECTED]> writes:
>
>
>
> venu> MySQL/MyODBC does accept connection timeout. Here is the code
> venu> snippet from driver:
>
> venu> case SQL_ATTR_CO
t;
> 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 binar
pect 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 h
ss 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 suppor
mpt 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 real
p...
> >
> > -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 th
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.
g MyODBC online manual from MySQL AB.
http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html#ODBC
If you need any further assistance, please send the comments to
[EMAIL PROTECTED], that way it will be exposed to MyODBC community.
Thanks in advance
venu
---
Hi !
Check the following link and see whether it helps you.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80405:200107:lajclcaepgpafkcfp
gpm
Regards
venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu
> -Original Message-
> From: kieran buckley [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 03, 2001 10:29 AM
> To: [EMAIL PROTECTED]
> Subject: RE: jdbc - tcp/unixsockets
>
>
> Venu...lifesaver!!
> thanks very much,
> kieran
You, welcome..
venu
&
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:52 AM
> To: '[EMAIL PROTECTED]'
> Subject: Access to MySQL Column Type Error
>
>
> I
mysqlfront " GUI tool, where in you can directly import
the tables from access (using access DB files) to mysql. You can download
this from www.mysqlfront.de.
Hope this helps you.
Regards
venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/
RS update.
-- traversal.java ( for scrolling)
-- updatability.java (RS update).
Hope this helps you.
Regards
venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
/ /|_/
this earlier. From Windows.
> R.Srivatsan
> [EMAIL PROTECTED]
> ___
> Sinisa Milivojevic <[EMAIL PROTECTED]> Wrote---
> SRIVATSAN RAGHURAMAN writes:
> > Hi Venu,
>
em maps to. See
)chapter 6 of
)your MySQL server manual for a very in-depth description of how to setup
)security.
)
Also, please read the previous mails in the JAVA/JDBC section of
lists.mysql.com, where in you can find the solution.
Regards
Venu
--
For technical support contracts, go to https://
failure) needs to be
fixed from the driver/server point of view, else this will defiantly causes
problem in heavy loads.
Thanks in advance
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTEC
" instead of "%" (= all).
Also, please check the following online MySQL manual for more on security.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#General_security
Hope it helps you.
Regards,
venu
--
For tech
joins? And if so
)is there a work around. Failing that, does anyone have any ideas on what
)the problem might be. I'm guessing not many people have experience of
)Approach, but i inderstand thats it is pretty similar to Access.
)
Thanks a lot
Venu
--
For technical support contrac
.html#
Missing_Sub-selects
Regards
Venu
)-Original Message-
)From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, August 15, 2001 7:48 AM
)To: [EMAIL PROTECTED]
)Subject: MySQL + VB problem
)
)
)I try to execute mySQL query from VB:
)
)strSQL = "SELECT @BF:= Date From Results Wh
2000-08-15 |
| b| 2000-08-15 |
| a| 2000-08-16 |
| b| 2000-08-16 |
+--++
4 rows in set (0.00 sec)
Here, you can use LIMIT 2 in the first insert itself to insert only first 2
records from t_date1 to t_date2, and later you can just select it.
Hope this hel
me through SQLSetCursorName prior to the execution.
Is it possible for you to send the ODBC trace, so that we can guess what
exactly is going wrong ?
Thanks in advance
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
n the second one and
see whether it works or not.
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /
t JSP. But as a first glance, the problem looks to
be with the Coonection object declaration. It should be Connection not
connection.
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Ve
x
)system? or 2) install iODBC on the Irix one and myODBC on that
)Linux machine
)where the mySQL db physically located? Thanks!
)
You need to install both iODBC or unixODBC and MyODBC in the client side
from which your ODBC application tries to access (Irix) the db from Linux
m/c.
Regards
Venu
-
Hi !!!
Can anyone has the answer for him ? How we can have a secure data transfer
over the web using MySQL and its APIs ? He is desperately needed some idea
in order to take further steps with MySQL ?
Regards
Venu
)-Original Message-
)From: A. Chris Nichols [mailto:[EMAIL PROTECTED
sue will be coming. You
can use DSN less connection, by specifying proper connection fields. The
only drawback in this case (for any odbc driver ) is it can only talk to
MySQL server, and it can't talk to any other, but its not the case when
going through the manager.
Regards
Venu
--
For te
e (mm.mysql-2.0.6.jar with
size 102 KB). Later I pointed my CLASSPATH to the extracted jar file and
worked out well.
But I did all these on Windows 200. The problem is in the web, the file name
looks like this: mm.mysql-2.0.6.1.jar, but it should be
mm.mysql-2.0.6.1.src.tar.
Hope this shou
DESCRIP causes
)the query to work. I'm wondering if filtering for the reserved
)word DESCRIBE
)causes DESC not to be legal for use in field names?
)
As per SQL-92, DESC and ASC are standard keywords. So, you can't use them in
the Data Defination statements.
Regards
Venu
--
For technic
uld work
fine.
Let me know whether this solves your problem or not.
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Dev
as the table/column names.
Here DESC is a standard keyword. So, change DESC to DESC1 and it will
absolutely work fine.
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <
ected odbc.ini. If not export ODBCINI to your odbc.ini file path
and try. Some times better to include filename also in to the path like
export ODBCINI=/usr/etc/odbc.ini
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/
ct and
display the version of the server.
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_
the same in the ODBC UserDSN setup window.
Execute GRANT ALL ON *.* TO "some"@"something.com" IDENTIFIED BY
"mypassword" at the root level, and then try to connect it. This gives all
types of access to user "some" from "something.com".
Regards, Ve
/bychapter/manual_MySQL_Database_Adm
inistration.html#Privilege_system
Regards, venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MyS
driver, even when application is using DSN-less
connection, driver always displays the connection dialog and waits for the
DSN to be entered (atleast you need to insert space). I fixed this couple of
days back, and the fix will be available for .39 version.
Regards, Venu
the db or not ? Did you connected through mysql command line
utility or MySQLAdmin or any third party tools ?
Regards, venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTEC
)the window!!!
Check the following link for the work-around:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:84548:200109:dgfijpnafhemmgcge
cnk
Regards, venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailt
will pass this to the JDBC development team.
Regards, venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\
which includes:
1. Version of the MyODBC driver and the server
2. Problem description
3. ODBC trace by ODBC DM and MyODBC
4. Reproducible sample.
So that we can look forward for the solution.
Regards, venu
--
For technical support contracts, go to https://order.mysq
C
Also, you can get the latest versions of server and MyODBC drivers from
www.mysql.com itself without any cost.
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PRO
On Wednesday 19 September 2001 14:32, Tom Meckna wrote:
> Hi Venu!
>
> Sorry for bothering you. I belive I have the driver installed correctly
> but I dont understand what name I use when calling it from a java program.
> A example would be
>
> Class.forName(driver
Hi
Take a look at the following links, which guides you step by step in
managing the user accounts:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management
Regards, venu
--
For technical support contracts, go to https
7;n' GUI utilities using
MyODBC as the underlying layer to control MySQL. Some of them are really
doing a great job.
Some of them are..
MySQLFront,
DbTools and so on..
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ _
d table structure in linked tables ?
>
> Also if I may ask, is there any difference between MyODBC for
> Unix going to
> Windows to MyODBC for Windows going to Unix? I'm assuming that all the
> difference is the starting point but achieves the same tasks.
No
from Access or there might be some setting that we
need to do it, inorder to see the changes to the table structure.
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL P
r it helps you or not.
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/
set properties set by the application, is it
possible for you to send the code snippet that opens the rs with all
properties ?
Also, verify the results by toggling "Don't optimize column width" option
in the DSN setup.
Regards, venu
--
For technical support contracts, go to htt
t and all SQL statements you can execute it.
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_
. You can find
more about this, in the following link:
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Comp
atibility
Hope this helps you
Regards, venu
>
> Venu wrote:
>
> >You can execute any valid SQL statements through SQLExecDirect API. Please
> >c
ccess and ODBC in the middle layer in the conversion,
from MSSQL-->MySQL, then probably you don't need any editing. Here is the simple
procedure:
1. Install MS Access and MS ODBC Driver
2. Import all or selected tables from MS SQL to MS Access through MS ODBC D
t; 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 s
roblem 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]>
/ /|_/ / // /\ \/
Hi !
> -Original Message-
> From: Sylvain Hamel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 5:34 PM
> To: [EMAIL PROTECTED]; MySQL Mailing list
> Subject: Re: DSN-Less connections using MyODBC?
>
>
> Hi Venu,
>
> > It doesn't depend
s 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.
distribution in /doc
directory, which can guide in programming.
Hope this helps you
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL A
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
e 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.
layed 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
__
; 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]>
/ /
ied
> 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
g 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.mysq
1 - 100 of 169 matches
Mail list logo
