MYSQL :: Retaining Control From MyODBC

Retaining Text Formats
I have the following field "Proyecto" in my database table:

`proyecto` text NOT NULL,

I have entered the following data into the "proyecto" field of ONE record:

- Taxonomía, Sistemática, Faunística y Autoecología de Moluscos de agua dulce.

- Dirección y coordinación del Proyecto Fauna Ibérica

- Coordinación del Consejo Editorial de la serie Fauna Ibérica.

When I SELECT it to view it, the text is all run together. In other words it does not retain the line breaks between the three sentences.

How can I get it to retain the formatting and not run together.

this is the php line I am using after I run the query:

<?php echo $row_test['proyecto']; ?>

Can it be done?

MyODBC
I have a mySQL database hosted by a company. I installed the myODBC connector and need to connect to it in a vb6 program. I set up a user and password for the database i want to connect to. My string looks like this:

Dim conn As New ADODB.Connection

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=rentapar_System_Property;UID=rentapar_Client;PWD=password;"

it says it can't connect to mySQL server on 'localhost'
I am not getting where it is looking for the server. Do I need to set up a DSN? If so what do I use as server? Where do I point it to the hosted server? Please help!?? Do most hosting companies allow access from off the net like an application?

MyODBC
I have problem in using ODBC for Voice Guide (an IVR application). I can connect to MySQL database successfully. The only thing is that everytime the system tried to connect to MySQL database through ODBC the Connector/ODBC Configuration Windows Pops Up. I have tried to pass Option=16 and also tick "Don't Prompt Upon Connect" property on Flag 2 but the window still pops up.

Here is the details of my system:
OS: Windows XP Pro SP2
MySQL Server: version 4.1.11-log via TCP/IP
Client version: MySQL Client Version 5.0.11
ODBC version 3.51

I didn't have this problem before I reformat my harddrive and reinstall Windows.

MyODBC 3.51
I have a C# program which uses a remote MySQL database to store user information. It uses MyODBC 3.51. However, I find making people download and install MyODBC seperately from the application rather annoying. Is there any way I can package MyODBC with the installation package for my application

Control Flow
I am having a hard time with Control Flows which is what i think I need to solve my current problem.

Below is a sample query dynamically built based on user screen selections. Notice that it attempts to JOIN 5 tables to fscenario.

My problem is that fscenario.`fsce_comp` may or may not be NULL.
Either way I need the record retrieved if all other criteria is met.

If fscenario.`fsce_comp` is not NULL I want to display the corresponding fcomponent.`fcom_name`.

If fscenario.`fsce_comp` is NULL, I still want to retrieve the record displaying nothing for the name.

Bad explanation, so I hope you follow?

Using the manual (http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html) I have tried several IF, CASE, IFNULL structures. They all return records where fscenario.`fsce_comp` is populated and exclude the records where fscenario.`fsce_comp` is NULL.

I guess I am not understanding how to implement the syntax......

Source Control
Does anyone know if there is a program (for windows) that can help us catalog our sprocs and table setups into source control?

MySQL DB Control
How can i manage my mysql db? Example: How can i learn db size? Phpmyadmin is not installed on my hosting company.

Remote Control
I have MySQL running on a desktop computer that I log into through logmein.com and this is not the best solution. How can I connect remotely to use the MySQL Command Line Client on my desktop so I don't have to wait so long for each line to appear? I should also point out that this computer is on my LAN, so I shouldn't have to configure the router.

One problem I am running into right now is that when I try to make a new table, I keep getting error 1064 (42000) and I'm not sure why because everything looks correct. Code:

Control Center
I started using Control Center as a GUI for MySQL. Making progress but I could do better if I had the help file. It is grayed out. Is there a place to locate this?

Transaction Control
I am a recent user in mysql and I'd like to know if I need control the transactions in java when I am using mysql. I am asking it because I have read the mysql already control the transactions automatically, that is, it automatically control the commit and roolback commands.

Revision Control
I've been searching the mysql forums and documentation for anwers to this
to no avail..Is there any facility for revision control within mysql? I need to be able to have
snapshots of a mysql database that users can modify, later merging those
modifications in with the main database, similar to branching in cvs.
Does something like this exist already? Is it doable by copying the database
and then logging edit transactions on the copy? What about using the storage
engine plugin for tracking modifications?

Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I
cannot seem to display more than 1000 rows in my result set when I know that
there is 1534 rows. I know that it is a setting somewhere, but is it in
MySql or in the Control Center somewhere. I am running this on a Windows
2000 machine.

Control Center
Getting the following message when I click on the MySQL shortcut on my desk
top:

Error Starting Program
The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion
numbers.

A device attached to the system is not functioning.
Have gotten both Dll's and stuck em in the system and program directory...
nothing happening there.
Would like to find out what "Rtlgetntversion numbers" is all about.

Control Panel
i'm having some problems with my MySQL install. Firstlty when I installed MySQL I never got an icon of any kind within the control panel. I've been looking at tutorials of how to create a database and many of them use the control panel option as a starting point but I can't because MySQL is not present within the cPanel. Also when I click on the MySQLadmin.exe in the bin it does not open probably. It opens briefly- shows a black screen with decending text. It then dissappears completely after several seconds. It cannot be seen or opened in the tray

Control Max Time
Does anyone know of any parameters that can be set to control the maximum time limit mysql will allow a single query to run before timing out etc?
Rather than let badly written queries run for long periods I would like to just abort them if they exceed a set amount of time.
I know the php calling script should/could handle this with defensive coding etc. However, I'm not always in control of how other users write their scripts that interact with mysql.

MyODBC To OpenOffice.org
I'm trying to connect OpenOffice.org to MySQL through MyODBC. MySQL is
set up, but I'm having problems setting up MyODBC. I checked the
documentation on the MySQL webpage, and tried to set it up that way, but
OpenOffice.org can't find MyODBC. It can't find the libodbc.so.1. I
tried to follow the set up PDF file on the OpenOffice.org webpage, but it
switches between MyODBC and UnixODBC.

I copied the libraries to /usr/lib, and made the link in /usr/local. I
set up the obdb.ini in /usr/etc. Is there something I'm missing to set up
the connection? Has anyone had luck with this?

Myodbc Error
------=_NextPart_000_000D_01C35CF0.20AC1200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

i get this msg:
Microsoft.Data.Odbc.OdbcException: NO_DATA - no error information =
available
at Microsoft.Data.Odbc.OdbcConnection.HandleError(Int Ptr hHandle, =
SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, =
Int32 cb)
at Microsoft.Data.Odbc.OdbcDataReader.internalGetStri ng(Int32 i)
at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap)
at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at Microsoft.Data.Odbc.DbCache.AccessIndex(Int32 i)
at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at Microsoft.Data.Odbc.OdbcDataReader.get_Item(String value)
at =
F=E6llesDialogbox.frmAddIngDialog.cboVaregruppe_Se lectedIndexChanged(Obje=
ct sender, EventArgs e) in C:Documents and SettingsAdministratorMy =
DocumentsVisual Studio =
ProjectsDatasystemKSF=E6llesDialogboxfrmAddIng Dialog.vb:line 357

then i try to get a row out fo the database mysql 3.23.54 run on redhat =
linux 9.0 i am acceessing it from vs.net via odbc.net.
i am using myodbc 3.51 and my code look like this:

Try
Dim plunr As Integer
Dim varenavn As String
Dim varegruppenr....................................................

MyODBC Driver
Trying to use MySql 5.0.27 with Dreamweaver MX & PHP & Apache

In "Inside Dreamweaver MX" the authors state 'If you're using MySQL as your DBMS, you need to use the MyODBC driver to create your DSN's See Appendix C for full coverage of obtaining & setting up MyODBC' Unfortunately Appendix C does not mention MyODBC although is does mention MySQL.

They are referring to an earlier version of MySQL (3.23) and show setting up the DSN in windows.

My problem is I cannot see the MyODBC driver. Is this a separate download?

MyODBC And Citrix
My client (and hence I!) need to install MyODBC on a Citrix server, but
when the MyODBC installation .exe is run, it fails. The .msi also fails.

Investigation on the web indicates that this might have something to do
with the Citrix environment not liking "hardcoded" paths in installation
programs, but naive fumbling with Orca on the .msi didn't really help.

Has anyone succeeded in installing MyODBC in a Citrix environment, and
if so, how?

Uninstall MyODBC
How do I uninstall myODBC from wind98? everything was working, then badness at the shop so... I have reloaded wind98,mySQL now mySQL works OK but I cant setup myODBC (setup says myODBC installed ok but when I try to make data source it says drivers no good, reinstall...

looks to me like I need to uninstall, but myODBC has no uninstall Alas! does anyone know whaich registry entries to delete?

MyODBC Time
recenlty I wanted to migrate my app from MySQL 3 to MySQL4.1.19, conector: MyODBC 3.51.06 into MyODBC 3.51.11-1win.

Now I have a problem with time values from my database. In a field I have the value '00:00:01'. When I retrieve this value in my app (via MyODBC) i get a null value. I don't want that null value, I vant my '00:00:01'.

Before the migration, I hadn't this problem ... everything worked fine. Is there a setting in MyODBC that I must check to solve this? If not, how can I solve this problem ... quick?

MyODBC Mapping
I have an VB frontend that can't be changed for various reasons, and have
been attempting to move the database (access) out to MySQL (for various
other reasons ;). I haven't been able to successfully read True/False
fields, and after much research it appears that I need to map any true/false
or yes/no to 1/0 in the MyODBC source code.

I've downloaded the source code, but I haven't been able to determine what
and how to change the mapping. Any assistance would be GREATLY appreciated!

FYI: I tried treating the MySQL side as an enum field, but the VB front end
won't accept the result.

MyODBC VB6 Problem
I have made a program that runs off the task scheduler. It connects to a web database using MyODBC. This works most of the time, but once in a while i'll get the MyODBC DSN connection window. I'm not sure why this pops up. should i upgrade the MyODBC from version 2.5 to the newest version? If this is not the case, is there a way to hide this in code or through settings.

MyODBC Driver
I have winxp as OS & my php folder is located in c:XXXXphp.

I am getting these errors while running a php code-

Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user 'ODBC'@'localhost' (using password: NO) in C:wampwwwprosenjitOODatabase.class on line 16

Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch mysqli in C:wampwwwprosenjitOODatabase.class on line 32
Database is not available. Try again later

Will installing 'MyODBC Driver' solve my problem? What other things should i ensure so as not to get these error.I have WAMP5 installed.

Connector MyODBC
Can I using MyODBC to connect to MySQL Server through A Proxy Server ?

MySQL / MyODBC
I installed MySQL v4.0.20d and MyODBC v2.50.39 on a Windows 2000 workstation SP4. When I go to StartProgramsAdministrative Tools I don't see the Data Sources menu option. When I installed the same software on a Windows 2000 Server, I do see the Data Sources menu option.

MyODBC And DB Access
I setup Apache, PHP, and Mysql on our internal server probably 5 years ago. It works so good I NEVER have to do anything so I've gotten really rusty. The problem is we use UPS through MyODBC to add shipping data to our DB. We recently got a new computer to run the UPS stuff. I can't get MyODBC to connect from the new computer to save my life.

I joined our domain restarted a bunch of time and still when I setup the system I get an error to the effect of "Matt@MASTER" password =yes access denied. Now here is the kicker. the computer name isn't master its been renamed. I removed the 3.5 MyODBC driver and installed the 2.5 like the old computer had just to be sure. It is doing the same thing. So I found a way thanks to google to grant access to that username in a range of IP addresses.

here it is: "GRANT ALL PRIVILEGES ON db.* TO matt@'192.168.0.0/255.255.255.0';

which has a result of 0 rows effected!?

I have tried a different user when using the mysql program on the server machine and been able to login with it and the matt user mentioned above. However still nothing at the MyODBC end with the UPS system.

Configuring MyODBC
I am using MyODBC 3.51 with Borland BDE, and was having a problem whereby Blob result fields were being restricted to a maximum size of 32k. Now, in the BDE control panel, I can set configuration variables for the MyODBC driver, and I was able to change the value of BLOB SIZE from 32 to 128, which solved the problem. However, there are many other configuration variables there (TRACE MODE, BATCH COUNT, BLOBS TO CACHE, ENABLE SCHEMA CACHE, ROWSET SIZE, etc.) for which I have not been able to find any documentation. Does anybody know where I can find documentation for these settings?

MyODBC Install
For the fourth day I'm trying to install MyODBC. I installed the old 2.5 ver as well as the newest 3.5.The install completes successfully but when I go to the ODBC admin and try to add a new DSN, mysql is not in the driver list. I checked the registry and it is there- but not in the list.

Please someone help, I've never been pushed this far back in development by something that seems so simple / are there any 3rd part MySQL drivers I can use?

MyODBC And Remote
I'm conected to server and my app works just fine, and I was connecting to MySQL over ODBC (my app is running on winXP)! It was good while I was using only USERNAME with blank PASSWORD in MySQL! But when I put password, I can't connect, and of course my USER/PASS combination is OK! I try to search for known MySQL bug in this version but with no results!

Views And MyODBC
well i just installed MySQL "5.0.1-alpha-nt-max" to play around with the new Features on my local PC.reating and accessing Views seems to work, but as it seems MyODBC 3.51.09 cant handle Views.
Are there any plans to support Views also via MyODBC ?
If so, is that Feature currently in the Bitkeeper-Repository of "MySQL Connector/ODBC 3.52" ?

MySql Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I
cannot seem to display more than 1000 rows in my result set when I know that
there is 1534 rows. I know that it is a setting somewhere, but is it in
MySql or in the Control Center somewhere. I am running this on a Windows
2000 machine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=...sie.nctu.edu.tw

Mysql Control Center
I'm trying to get the GUI to connect to a remote mysql database from my
client machine. What is the proper syntax for this in the GUI? I have
tried everything with no luck: using the ip of the host, using the complete
dns hostname of the host, using root as the user, using root@hostname as the
user. I keep getting access denied for every attempt. I'm sure I am using
the correct password.

MySQL Control Center
I can access my MySQL database with MySQL Control Center from a computer with a direct connection to the internet, but I can't do it from my other computer on a network. Is there a way to use MySQL Command Center through a network/router? I'm unable to find any connection settings options in the program.

Start Control Center
Getting the following message when I click on the MySQL shortcut on my desk
top:

Error Starting Program
The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion
numbers.

A device attached to the system is not functioning.

Have gotten both Dll's and stuck em in the system and program directory...
nothing happening there.
Would like to find out what "Rtlgetntversion numbers" is all about.

MySQL Control Center
I have installed MySQL Database Server 4.0 and MySQL Control Center, but i can't still use MySQL CC to create new database or other feature.

MySQL Control Center
I am trying to install MySQL Control Center for the first time (the latest
version). I am using Windows XP. When I try running the setup routine, I
get through all the prompts and when it starts to install, it gets stuck at
the 'Initializing... ' screen. And it does not go any further. I cannot
even cancel. the operation.

Mysql Control Center
Quote: ERROR 1109: Unknown table '1' in information_schema
Quote: [stuff] ERROR 1146: Table 'cdcol.1' doesn't exist
Quote: [stuff] ERROR 1146: Table 'mysql.1' doesn't exist
Quote: [stuff] ERROR 1146: Table 'webauth.1' doesn't exist

I get that error when ever i try to access any tables in mysql control centre. The error is almost the same, except for the database name. It does this even on a clean install.
Im using xampp

MySQL Control Center
how can i declare a Vendor-Specific
attribute in MySQL Control center. In the regular radius i declare it
well.
I check the radtest and its write : radclient:WARNING: Malformed
RADIUS packet from host 10.0.1.16: Vendor specific attributes do not
exactly fill Vendor-Specific

MyODBC - Updating Joins
I am using MyODBC (35017) in VB and i get an error when I try and update a recordset which involves a join. Surely one isnt limited to only single tables?

Recordset.CursorLocation = adUseServer

Recordset.Open "SELECT pd.products_name 'Product Name', p.products_quantity 'Product Stock' FROM products p, products_description pd WHERE p.products_id = pd.products_id;", Connection, adOpenForwardOnly, adLockOptimistic

Recordset(1) = 5
Recordset.Update
Recordset.Close

Gives me the following error: "Query clause can not be updated because the FROM clause is not a single simple table name"

Linking MyODBC Drivers
Could someone please help me with the linker options for linking the MySQL ODBC drivers. I'm running on Redhat Linux, with gcc 3.4.6.

Myodbc 3.51 Connector Freezes
I just installed mysql server 5.0 and myodb driver 3.51. Now I'm trying to make a DSN on my system. When I enter the Data Source Name, Server, User and Password, then when I click the Database drop-down menu, the program freezes. It does not do anything, just sits there. I set up the database properly, and it is configured and ready to go but I cannot get past this.

Slow Performance Using MyODBC
I am creating a pair of applications that essentially transfer data from a remote client to a local server. The trick is that "remote" in this application means "way out in the mountains where it takes an hour by four wheel drive to reach the nearest paved road and don't even talk to me about a cell tower for another hour or so of driving".

Because of this, we are using shoe-leather-net to communicate between the client and the server. The client is collecting data into a MySQL table. Every so often, a person will use the client application to copy the data onto a thumb drive and carry it down the mountain to the server, where the partner application will copy the data into an identical MySQL table. These are distinctly non-technical people I am talking about here - typing a file name is a high-skill activity - so this needs to be a dead-simple user interface.

The data is sensitive, so it is encrypted going on to the thumb drive and decrypted coming off.

Here is the question: The copy process that I have programmed is very slow - on average 2 seconds per row - on both ends of the transaction and this does not seem right. What can I do to improve it?

When the process is running, Task Manager shows that mysqld-nt is using as much of the CPU as it can get and the actual application is only using CPU time once in a while.

The basic client task is this:
-- Read a row from the local table
-- Encrypt the row
-- Write the encrypted row to the file
-- Repeat until all of the unexported data has been copied

The basic server task is the inverse:
-- Read a line from the file
-- Decrypt the line and construct a corresponding INSERT statement
-- Execute the INSERT
-- Repeat until end-of-file

Other possibly pertinent information:
-- Windows XP Pro
-- Visual Basic.Net
-- MySQL 4.1.14-nt
-- MyODBC 3.51.13 Dave Gee

MyODBC Mapping Question
I have an VB frontend that can't be changed for various reasons, and have
been attempting to move the database (access) out to MySQL (for various
other reasons ;). I haven't been able to successfully read True/False
fields, and after much research it appears that I need to map any true/false
or yes/no to 1/0 in the MyODBC source code.

I've downloaded the source code, but I haven't been able to determine what
and how to change the mapping. Any assistance would be GREATLY appreciated!

FYI: I tried treating the MySQL side as an enum field, but the VB front end
won't accept the result.

MyODBC Command Syntax
I'm trying to do what I thought was a fairly simple thing, select a group of
records from a mySQL database.
I'm not much of an SQL guy. The syntax I would use for Microsoft SQL is
shown on the "query =" line.
A myODBC error message indicates this is not supported syntax.
Can anyone help me?

{ ADO Startup Values and Creation using the .Open method}

{Create a COM object reference to ADO Recordset.}
recordset = COM_CreateObject("ADODB.Recordset");

{ Open a Recordset }
query = "SELECT * FROM t_course_date
WHERE(modified>=CONVERT(DATETIME,'1999-07-31 00:00:00',102))";
("modified" field above is a mySQL field name)

recordset.Open(query, 'connection id', adOpenDynamic,adLockOptimistic); <--
This statement fails.