Grokbase Groups MySQL odbc March 2003

Search Discussions

77 discussions - 167 posts

  • rst.Open "SELECT * FROM specific_test_data WHERE TravelTag = " + Chr(34) + Chr(34) + ";", conConnection, adOpenStatic, adLockReadOnly gives an immediate E_FAIL, yet causes no problem in the ...
    Adam LawrenceAdam Lawrence
    Mar 24, 2003 at 10:12 pm
    Mar 28, 2003 at 4:47 pm
  • Hi, I have a VB app that at one point cycles through an array containing several hundred thousand values, inserting some or all of them into a MySQL myISAM table. At random points in the loop, the ...
    Mar 11, 2003 at 3:22 pm
    Mar 11, 2003 at 6:06 pm
  • Norwegian currency is written as NOK 123,45 (comma - not period), but when I export a table from MS Access via MyODBC - it ends up being written as 123.45 in MySQL. What settings do I need to change ...
    Mar 6, 2003 at 2:35 pm
    Mar 6, 2003 at 7:35 pm
  • Greetings, I would like to know if anyone could point me to some good articles/samples or even a newsgroup on how to set up, load and iterate through a 'Record/Data Set' using the ODBC.NET ...
    Rick BeckerRick Becker
    Mar 28, 2003 at 9:55 pm
    Apr 6, 2003 at 12:35 pm
  • I have connected a MySQL database sitting on a linux machine to an access database on a windows machine (linked tables). To test the speed difference, I also have an access database on a windows ...
    Mar 13, 2003 at 10:05 am
    Mar 14, 2003 at 6:11 am
  • Hi, we have found that MyODBC does not check for buffer overflows when formatting error messages, allowing the application to corrupt its own memory and become unusable and/or crash (both have been ...
    Maarten LITMAATHMaarten LITMAATH
    Mar 12, 2003 at 3:22 pm
    Mar 13, 2003 at 6:10 pm
  • Hi I'm using MyODBC 3.51 with MySQL 3.25.55-max-nt. Most of the time all is fine. However, I'm now getting the following message whenever I trry to access the external data source: [MySQL][ODBC 3.51 ...
    Nigel CosterNigel Coster
    Mar 12, 2003 at 4:53 pm
    Mar 12, 2003 at 8:19 pm
  • Hello Venu, I have sent to the table the trace file MYODBC.ZIP so you can invetigate it. Thanks. The NEW Netscape 7.0 browser is now available. Upgrade now! ...
    Mar 3, 2003 at 11:09 am
    Mar 12, 2003 at 3:55 pm
  • How can i upgrade from 3.23 version to 4.0 in MYSQL Thanks YUGANT ********************* This e-mail (and any attachments) is confidential and may contain personal views which are not the views of ...
    Yugant KhannaYugant Khanna
    Mar 26, 2003 at 8:24 am
    Mar 29, 2003 at 8:58 am
  • Hi, We recently upgraded our database to 4.0.12-standard and now when I use the following code I am getting an error saying "-2147217911 (80040e09). [TCX][ODBC] You have an error in your SQL syntax. ...
    Andrew Berry (Ham)Andrew Berry (Ham)
    Mar 28, 2003 at 2:14 am
    Mar 28, 2003 at 4:42 pm
  • I'm using an ADO recordset to stuff data into a backend table, and have found that after a fairly large number of updates (just over 2000) the code quits with an E_FAIL runtime error when I try the ...
    Adam LawrenceAdam Lawrence
    Mar 24, 2003 at 9:01 pm
    Mar 25, 2003 at 9:49 pm
  • Hi, I am using mysql in a heavy duty website, that runs iis and mysql on windows 2000. the site gets about 30 hits/sec on the asp pages, and each hit produces several simple queries to the db. at ...
    Alex KAlex K
    Mar 24, 2003 at 11:33 pm
    Mar 25, 2003 at 2:33 pm
  • I've a table with an auto-update integer as the primary key in a mySQL database table. I'm trying to access a record and then use the value of the auto-update column in some vbscript code via ADO ...
    Mark WoollardMark Woollard
    Mar 24, 2003 at 4:31 pm
    Mar 24, 2003 at 10:02 pm
  • I am using MS Access XP to export tables to a MySQL database using ODBC. If I want to add a new column to the table, I don’t seem to be able to do that in Access and then overwrite the existing one ...
    Jean PatersonJean Paterson
    Mar 21, 2003 at 3:27 pm
    Mar 24, 2003 at 6:01 am
  • I'm having difficulty getting dynamic cursor support working under ADO (plus have another mysterious problem, to be explained later). I'm using an Access 2000 SR-2 MDE with ADO 2.7 as a front-end to ...
    Adam LawrenceAdam Lawrence
    Mar 20, 2003 at 7:33 pm
    Mar 20, 2003 at 9:01 pm
  • Good day! I try to convert my MS SQL 2000 db to same MySQL I found that strange thing: when db structure converting, some fields with varchar(255) in MS SQL converted into mediumtext MySQL... Not ...
    Galkov VladimirGalkov Vladimir
    Mar 14, 2003 at 8:15 pm
    Mar 14, 2003 at 9:19 pm
  • Hello, I am using mysql 4.0.11 and MyODBC 3.51.06 and I'm developing my project in Visual Basic 6.0 using ADO 2.7. My program has to use data from two databases and it has to be able to update ...
    Mar 11, 2003 at 8:42 am
    Mar 12, 2003 at 7:59 am
  • PLEASE forgive me if i'm posting this in the wrong list.. I am using VB and when I have a recordset, and make a change to those records elsewhere (not using the recordset).. my recordset does not ...
    Tamayo, NelsonTamayo, Nelson
    Mar 11, 2003 at 4:52 pm
    Mar 11, 2003 at 8:15 pm
  • Hi Hope somebody can help with this. When I test my site using an access database I can replace print control characters (in text and memo fields) chr(10) chr(13) with <br to preserve white spaces. ...
    Clive HendersonClive Henderson
    Mar 6, 2003 at 8:59 am
    Mar 6, 2003 at 11:39 pm
  • Hi, MySQL Connector/ODBC 3.51.06 has been released. It is now available in source and binary form for a number of platforms from the Connector/ODBC 3.51 download pages located at ...
    Mar 4, 2003 at 10:18 pm
    Mar 5, 2003 at 9:13 am
  • Hi, I ran into a problem inserting or updating a time field using the TIME_STRUCT. Times from 00:00:01 to 01:00:00 either get saved in the database with an incorrect value or for 2 specific times ...
    Alan EichmannAlan Eichmann
    Mar 25, 2003 at 8:21 pm
    Mar 27, 2003 at 9:13 pm
  • Hi All, Does the BACKUP TABLE query work over a windows network? I'm using Mysql 4.0 gamma. The query i'm using is: BACKUP TABLE table1 TO '//networkcomp/c:/data' I'm not getting any errors when i ...
    Madhavi KuttyMadhavi Kutty
    Mar 26, 2003 at 9:29 pm
    Mar 26, 2003 at 10:04 pm
  • Check -- Regards, Venu For technical support contracts, go to ___ ____ / |/ /_ __/ __/ \/ / ...
    Mar 25, 2003 at 6:44 pm
    Mar 26, 2003 at 9:34 am
  • Hello! We get weird things shown by Access using the following table: +-------------+---------------+------+-----+---------+-------+ +-------------+---------------+------+-----+---------+-------+ ...
    Scholz StefanScholz Stefan
    Mar 25, 2003 at 2:52 pm
    Mar 25, 2003 at 7:20 pm
  • [MySQL][ODBC 3.51 Driver] Lost connection to MySQL server during query Does anyone know what could be causing this error? I can see part of the connect in a log file on the mysql server, which is a ...
    J Lynch DavisJ Lynch Davis
    Mar 22, 2003 at 3:18 am
    Mar 22, 2003 at 1:08 pm
  • When I run ldd on the client I have I get the following error: reef /package/1/databases/unixodbc/2.2.5/lib 194 ldd exec(): 0509-036 Cannot load program ...
    David RitterDavid Ritter
    Mar 21, 2003 at 8:20 am
    Mar 21, 2003 at 6:25 pm
  • I would like to purpose a change to cursor.c starting around line 441. /* @type : myodbc3 internal @purpose : checks for the float comparison in where clause */ static my_bool if_float_field(STMT FAR ...
    Jim DickensonJim Dickenson
    Mar 19, 2003 at 7:55 pm
    Mar 20, 2003 at 8:59 pm
  • Hy! I'm just a beginner. I try to transfert some tables from MSAccess to MySQL. I have a problem with a table wich has two columns. The first one is an Integer and the second is a BLOB. I define a ...
    Vincent LabayeVincent Labaye
    Mar 20, 2003 at 9:21 am
    Mar 20, 2003 at 10:30 am
  • Ok... everytime I try to use MyODBC or SQLyog to log into the server i get the error "Lost connection to MySQL during query" or "Access denied to (PASSWORD = YES)" What ...
    Alex DavisAlex Davis
    Mar 19, 2003 at 3:33 am
    Mar 19, 2003 at 3:43 am
  • Is there a simple way to setup the ODBC stuff for MySQL programmatically? I would rather not go to everyones PC that will be connecting to my DB to set them up to do so.. is there command line ...
    Tamayo, NelsonTamayo, Nelson
    Mar 11, 2003 at 7:47 pm
    Mar 13, 2003 at 6:12 am
  • Hi, I'd developed the application using MySQL and MyODBC3.5 on Window2000. When I post this program to Windows98 ( Which I intent to be the clients in this system) I notice that, When I open the ...
    Thanes ChotrattanapitukThanes Chotrattanapituk
    Mar 11, 2003 at 3:52 am
    Mar 11, 2003 at 6:10 am
  • I'm totally new with MySql or whatever RDBMS. My Q is Could I connect Microsoft SQL with MySql And How is it possibly be done? tq
    Noor Hazlan HashimNoor Hazlan Hashim
    Mar 11, 2003 at 4:20 am
    Mar 11, 2003 at 4:59 am
  • Hello Venu, when enabling option "Dont Cache Results" in 3.51.06, ::SQLRowCount(hstmtquery, (SQLINTEGER*)plrowcount); returns -1 for plrowcount after a simple "SELECT..." query. Is this wanted ...
    Armin SchöffmannArmin Schöffmann
    Mar 7, 2003 at 6:09 pm
    Mar 9, 2003 at 6:59 pm
  • Hi All; Just wondering, but what is your opinion on where to open an ADO connection object. I have seen people open it with form.load, wheras I like to instanciate and open a connection object from ...
    Mike HillyerMike Hillyer
    Mar 8, 2003 at 11:34 pm
    Mar 9, 2003 at 10:21 am
  • Hello all, I am trying to get unixODBC 2.2.5 w/ MyODBC on HP-UX to work. I have successfully built unixODBC and I can connect with it to other databases. However when I try and connect with the DSN I ...
    David RitterDavid Ritter
    Mar 6, 2003 at 7:00 pm
    Mar 7, 2003 at 8:22 pm
  • I have found recently a problem using the function YEAR() quering a database. My environment is Microsoft ASP page under IIS 4.0 and ODBC 3.51 quering a database MySQL 3.23.xx on a Linux machine. If ...
    Piero ZuccaPiero Zucca
    Mar 5, 2003 at 10:52 am
    Mar 7, 2003 at 4:54 pm
  • hi all, We want to export some data from a MSSQL Database to a MySQL Database. We want to do that with a dts package in MSSQL. When the destination field type for a string is other than varchar the ...
    Kollegger GernotKollegger Gernot
    Mar 4, 2003 at 5:00 pm
    Mar 7, 2003 at 4:48 pm
  • Hello Are you sure that the type is TEXT and not TINYTEXT? I just believed to have a similiar problem but in the opposite direction while retrieving data from mysql into ado.recordsets inside asp ...
    Roman StuderRoman Studer
    Mar 3, 2003 at 8:29 pm
    Mar 3, 2003 at 9:45 pm
  • Below is the list of changes that have just been commited into a local MyODBC 3.51 repository of 'jwinstead'. When 'jwinstead' does a push, they will be propogaged to the main repository and within 2 ...
    Mar 29, 2003 at 12:32 am
    Mar 29, 2003 at 12:32 am
  • Hiya, when using ADO and Access I figure the problem that the connection wont keep alive. e.g. if I include a mysql-table in access with odbc there is a small window showing all the available tables ...
    Mar 28, 2003 at 9:34 am
    Mar 28, 2003 at 9:34 am
  • Hi, I can not submit any queries longer than 514 bytes via ODBC driver. All queries will be cut ( I checked this with a packet sniffer ) after that amount of signs. I use the Version of ...
    Hendrik HolzHendrik Holz
    Mar 28, 2003 at 7:31 am
    Mar 28, 2003 at 7:31 am
  • From: 27 March 2003 To: Subject: ODBC Data Sources dialog, USER DSN, Add error Description: (Please excuse the indentation. Hotmail Compose doesn't allow ...
    David James BrownDavid James Brown
    Mar 28, 2003 at 12:59 am
    Mar 28, 2003 at 12:59 am
  • The manual needs correcting regarding error reporting; it should reflect the latest version change in myodbc driver. 8.3.7 Reporting Problems with MyODBC 1. Ensure that you are using... a. ...
    Allen MayesAllen Mayes
    Mar 26, 2003 at 5:41 pm
    Mar 26, 2003 at 5:41 pm
  • 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 ...
    Emmanuel KARTMANNEmmanuel KARTMANN
    Mar 26, 2003 at 1:27 pm
    Mar 26, 2003 at 1:27 pm
  • Hello, I am using the production version of MYSQL with transaction support (InnoDB) on Win98. I use the following code to turn off autocommit: rc = ::SQLSetConnectAttr( m_hDbc, SQL_ATTR_AUTOCOMMIT, ...
    Jeff StemperJeff Stemper
    Mar 25, 2003 at 10:11 pm
    Mar 25, 2003 at 10:11 pm
  • Hello, I have been trying to install MyODBC-3.51.06 on RedHat Linux 8.0 with MySQL-3.23.52 and after successful install of libiodbc-3.0.6. The configure goes great and gives a success message, while ...
    Mar 25, 2003 at 6:26 pm
    Mar 25, 2003 at 6:26 pm
  • Hello I have a access 2002 table in unicode-8 format, I need to export to mysql using the odbc driver (3.51). When I link the uploaded table back to access or use a the mysqlcc to see the tables I ...
    Sacha ZempSacha Zemp
    Mar 25, 2003 at 1:17 pm
    Mar 25, 2003 at 1:17 pm
  • If I want to use mySQL 4.1, what version of myODBC do I need? Scott
    Scott BradleyScott Bradley
    Mar 23, 2003 at 5:00 pm
    Mar 23, 2003 at 5:00 pm
  • Hello again, MySQL list subscriber! We have completed the first phase of maintenance on the mailing lists, and mail should now start flowing on the lists again. Along with upgrading the hardware ...
    MySQL List AdministratorMySQL List Administrator
    Mar 23, 2003 at 1:19 am
    Mar 23, 2003 at 1:19 am
  • Hi I want to connect mysql server with IPV6 address. is it possible in mysql database? i am using mysql server version 3.23.41. am i goto any new version of mysql for IPV6 support? Please help for ...
    Sundara ramanSundara raman
    Mar 22, 2003 at 7:10 am
    Mar 22, 2003 at 7:10 am
Group Navigation
period‹ prev | Mar 2003 | next ›
Group Overview
groupodbc @

91 users for March 2003

Venu: 16 posts Adam Lawrence: 13 posts Mike Hillyer: 10 posts Roman Studer: 8 posts Rafarife: 5 posts Tom Emerson: 4 posts Adam Christopher Lawrence: 3 posts Armin Schöffmann: 3 posts David Ritter: 3 posts Mark Matthews: 3 posts Mike Nelson: 3 posts Jwinstead: 2 posts Jbonnett: 2 posts Silje: 2 posts Alan Eichmann: 2 posts Andrew Berry (Ham): 2 posts Clive Henderson: 2 posts Devore, Jacob: 2 posts Emery Fabrice: 2 posts Maarten LITMAATH: 2 posts
show more