473,387 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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.

Thanks in advance,

David McKay
da********@mckaygroup.com

Jul 19 '05 #1
0 1004

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: dave | last post by:
hi I want to install mysql odbc driver 3.51 and downloaded MyODBC-3.51.06-dll.zip from the mysql.com. but when i unzipped it, it shows only dll file.. I m very confused how to install odbc...
3
by: Tim Hastings | last post by:
Hello, I am using MyODBC from VB and I want to submit a batch of insert statements in one call from my App. This is more efficient than making multiple calls from code because of the...
0
by: Bob | last post by:
Has anyone tried (and succeded?) in specifying the appropriate connect string for a hierarchical dataset using MyODBC? It's where you specify MSDATASHAPE as your "Provider" but then need to...
0
by: David McKay | last post by:
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...
0
by: Dominikus Zimmerer | last post by:
Hello, i want to install the MyODBC driver for windows. i donwloaded the newest installer from the mysql website. -> MyODBC-3.51.06.exe now i know the command line parameter for a silent...
0
by: qhe | last post by:
Dear All: I'm using MyODBC 3.51.06 and MySQL 4.0.18. My table has a mediumblob field, but I can't update/insert data larger than 64K. The test application is created by VC6 appwizard, here is...
0
by: Bill Davidson | last post by:
Hello: I have a thin C++ database access library that can be used with MySQL *only* through MyODBC. I would like to use this database access library with embedded mySQL server. Would that be...
0
by: I & L Fogg | last post by:
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...
1
by: Matthias HALDIMANN | last post by:
When importing data into MS SQL Server 2000 from a MyODBC (v3.51) data source using Data Transformation Services, special characters like öäüéàè are not imported correctly. However, when the MyODBC...
6
by: Dave | last post by:
Ok I have an interesting problem. I have written a database in Access to connect to our web shop and update prices etc from a supplier feed. It works almost perfectly! The prices are doubles, I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.