Retrieving results of a stored function using MySql C API

2009-04-15 Thread Venu Gopal
heers, Venu

Reset of Status Parameters

2008-06-19 Thread Venu Madhav Padakanti
parameter so that the data can reflect current without restarting the MySQL Thanks in advance ..venu

Problem with ibdata1

2004-12-29 Thread Venu Sunil Boyireddy
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 redu

Re: odbc.ini

2003-06-12 Thread Venu
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. --

RE: Crystal Reports and MySQL

2003-03-31 Thread Venu
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 > >

Re: MyODBC: SQLBindParameter mix DATA_AT_EXEC with direct boundparam eters

2003-03-11 Thread Venu
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

Re: MyODBC 3.51 - Memory allocation error with BLOBs

2003-03-02 Thread Venu
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

Re: MySQL + ADO + ODBC

2002-12-22 Thread Venu
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

Re: MyODBC with iODBC on Mac OSX 10.2 Jaguar

2002-11-06 Thread Venu
ase 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. --

Re: New to MySQL, ported from MS Access. Using ASP & MyODBC - UPDATEproblem...

2002-11-04 Thread Venu
mally 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 t

RE: mysql odbc bug? with centura application using bind variable

2002-10-28 Thread Venu
> > 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

Re: is AppendChunk interactive or accumulative?

2002-10-26 Thread Venu
d 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 > > > --

RE: Slow opening a recordset

2002-10-19 Thread Venu
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 M

RE: ODBC connection from Mysql to Mssql

2002-10-02 Thread Venu
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 __ ___ ___ __ / |/

RE: MySQL client unusable with large data sets

2002-07-01 Thread Venu
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.

RE: RecordCount

2002-07-01 Thread Venu
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

RE: MyODBC DSN Configuration Dialog Hidden

2002-06-07 Thread Venu
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

RE: MySQL & Access 97 slow

2002-06-04 Thread Venu
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

RE: core dump, multithreading using MyODBC on Solaris

2002-06-02 Thread Venu
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

RE: @@IDENTITY

2002-05-29 Thread Venu
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

RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

2002-05-19 Thread Venu
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

RE: VC++6.0 MFC app with MyODBC 2.50 "no cursor name avb."

2002-05-18 Thread Venu
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

RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

2002-05-17 Thread Venu
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

RE: Any ideas how to speed this up?

2002-05-03 Thread Venu
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

RE: MyODBC Question

2002-04-30 Thread Venu
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 __ ___ ___ __ / |/ /_ __/ __/ __

RE: MyODBC Question

2002-04-30 Thread Venu
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 __ ___ ___ __

RE: mySQL & PervasiveSQL

2002-04-30 Thread Venu
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.

RE: MyODBC Question

2002-04-30 Thread Venu
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]>

RE: ODBC Problem.....

2002-04-30 Thread Venu
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 __ ___ ___ __ / |/ /_ __/

RE: How to make the Win target from source?

2002-04-28 Thread Venu
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

RE: Multi Line SQL Statements

2002-04-24 Thread Venu
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

RE: MySQL, MyODBC and MS Access

2002-04-22 Thread Venu
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

RE: MySQL subtracting an hour from DATETIME types I insert?

2002-04-16 Thread Venu
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

RE: Creating a mysql database usinc VC++

2002-04-09 Thread Venu
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

RE: MyODBC on win98

2002-04-09 Thread Venu
: > -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

RE: download latest odbc-driver

2002-04-09 Thread Venu
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

RE: Begging for help.

2002-03-30 Thread Venu
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]> / /|_/ / // /\ \/ /_/ / /

RE: Coldfusion,Mysql,Myodbc

2002-03-26 Thread Venu
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]> / /|_/ / // /\ \/ /_/ /

RE: MySQL, MyODBC and MS Access

2002-03-23 Thread Venu
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

RE: Slow query

2002-03-15 Thread Venu
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

RE: ADO API & ODBC Alternative help

2002-03-13 Thread Venu
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 __ ___ ___ _

RE: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)

2002-03-13 Thread Venu
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

RE: Leaking Handles

2002-03-10 Thread Venu
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

RE: Client installation by itself?

2002-02-27 Thread Venu
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]> / /|_/

RE: MyODBC 3.51 build for Mac OSX

2002-02-23 Thread Venu
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 __ ___ ___ __

RE: Naming a Provider?

2002-02-23 Thread Venu
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

RE: MySQL + Access + MyODBC + LARGE Tables

2002-02-22 Thread Venu
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

RE: MyODBC Blocking Table for DROP request ?

2002-02-20 Thread Venu
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

RE: GetDefaultConnect

2002-02-18 Thread Venu
: 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 __ ___ ___ __ / |/ /_ __/

RE: MySQL + Access + MyODBC + LARGE Tables

2002-02-14 Thread Venu
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

RE: MyODBC BDE invalid configuration error (BDE Error 12550)

2002-02-12 Thread Venu
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

RE: MyODBC BDE invalid configuration error (BDE Error 12550)

2002-02-08 Thread Venu
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

RE: blob field

2002-02-06 Thread Venu
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

RE: Error in myodbc 3.51.01.00

2002-02-06 Thread Venu
", 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

RE: MyODBC leaking handles...

2002-02-04 Thread Venu
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

RE: MyODBC

2002-02-01 Thread Venu
: 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)

RE: Problem with SQLSetPos(SQL_DELETE)

2002-01-29 Thread Venu
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]

RE: MyODBC

2002-01-26 Thread Venu
d 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 __ ___ ___

RE: My ODBC Error

2002-01-15 Thread Venu
e > 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:pnidmlbp

RE: MySQL -> Win SQL2k DTS -> MySQL

2002-01-15 Thread Venu
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. Rega

RE: MyODBC problem: Show Processlist

2002-01-15 Thread Venu
.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

RE: RogueWave Dbtools++ 4.0.1 and myodbc (conclusions)

2002-01-14 Thread Venu
r 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 __ ___ ___ __ / |/

RE: MyODBC leaking handles...

2002-01-03 Thread Venu
er 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 __ __

RE: ODBC for newbie

2002-01-02 Thread Venu
-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 /_/ /_/\_, /___/\_

RE: Vb DbGird Limitation

2001-12-29 Thread Venu
lly 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 __ ___ ___

RE: ODBC DRIVERS for MYSQL

2001-12-28 Thread Venu
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 contrac

RE: conceptual problem with ODBC and mysql

2001-12-26 Thread Venu
bles 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 <[

RE: using ASP with MYSQL

2001-12-25 Thread Venu
; 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

RE: odbc connection problem

2001-12-20 Thread Venu
k 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 comma

RE: Problem with ASP and GROUP BY queries

2001-12-19 Thread Venu
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 __ ___ ___

RE: MyODBC leaking handles...

2001-12-19 Thread Venu
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 s

RE: MyODBC leaking handles...

2001-12-18 Thread Venu
s 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 ?

RE: MyODBC availability

2001-12-17 Thread Venu
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 __ ___ ___ ___

RE: Error ODBC

2001-12-13 Thread Venu
cause, 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 __ ___ ___ __ / |/ /_ __/

RE: VB6 ADO and UPDATE method

2001-12-09 Thread Venu
der 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;ui

RE: Importing for MicroSoft Access 97

2001-12-07 Thread Venu
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 suppor

RE: odbc driver

2001-12-04 Thread Venu
t 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 __ ___ ___ __ / |/ /_ __/

RE: MyODBC and Accents

2001-12-04 Thread Venu
> with ASP, > but I noticed that driver MyOBDC 2.50.39 it correctly does not return the > accents from the words. > > Somebody can help me? > Can you be more specific on the problem, please ? Regards, Venu -- For techni

RE: Problem making myodbc on Solaris 8

2001-12-03 Thread Venu
onfigu/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.h

RE: SQL state S1090: Almost connected to mysql via PHP/odbc

2001-12-02 Thread Venu
LConnect 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 th

RE: MyODBC Problem with SQL2000 -> MySQL Data Transformation

2001-12-02 Thread Venu
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://or

conceptual question.

2001-11-29 Thread Venu Allavatam
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

What is errno: 13

2001-11-28 Thread Venu Allavatam
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

RE: MyODBC: DSN Creation

2001-11-26 Thread Venu
quot;DriverODBCVer=2.50.40" CONFIGDRIVER "MySQL Driver" "FileUsage=0" CONFIGDRIVER "MySQL Driver" "FileExtns=*.txt" CONFIGDRIVER "MySQL Driver" "SQLLevel=1" CONFIGDRIVER "MySQL Drive

RE: Connection Terminated

2001-11-22 Thread Venu
ng "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, ven

RE: Driver problem

2001-11-22 Thread Venu
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 pl

RE: HOW TO : Run wave files stored in BLOB field ???

2001-11-22 Thread Venu
> 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 ano

RE: MySQL Newbie and Access Database

2001-11-22 Thread Venu
onnects 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]> / /|_/ /

RE: MySQL with MyODBC & Access

2001-11-22 Thread Venu
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. Ve

RE: Benchmarking

2001-11-19 Thread Venu
are 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, ve

RE: mysql+myodbc+coldfusion

2001-11-18 Thread Venu
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, Devel

RE: java.sql.SQLException: Cannot connect to MySQL serveronlocalhost:3306.

2001-11-18 Thread Venu
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:3

RE: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306.

2001-11-17 Thread Venu
line = in.readLine(); > } > in.close(); > } > > catch( Exception e) { > e.printStackTrace(); > } >} > >// protect data with quotes >private static String quote(String include) { > return("\

RE: about MySQL

2001-11-17 Thread Venu
ns I can create table very easy. just from window screen. > I hope get > > > > your reply. > > > > Thanks for you help. > > > > john > > > > > > > > - &g

RE: How to Create Tables ... and Clients using winmysqladmin

2001-11-09 Thread Venu
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

RE: Simple JDBC Question

2001-11-08 Thread Venu
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

RE: JDBC driver recommendatons

2001-11-08 Thread Venu
; 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]> / /

RE: MS Access Front end with MySQL Back-end

2001-10-26 Thread Venu
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 __

RE: MySQL with MyODBC & Access

2001-10-23 Thread Venu
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.

RE: Experience with mm.mysql-2.0.x ?

2001-10-23 Thread Venu
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

  1   2   >