DATABASE PROBLEM

2002-09-26 Thread Thomas Edison Jr.
HI! there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text

Provider reqd. for myODBC

2002-07-29 Thread Thomas Edison Jr.
Glory! I'm looking for a Provider for the myODBC Driver to connect my Visual Basic code with my mySQL database. I have in kknowledge one such provider known as MSADSQL..but niether do i know where to find it nor do i know whether it's the right thing or not. T. Edison Jr.

How to Connect two mySQL Tables

2002-07-10 Thread Thomas Edison Jr.
Hi, If i have two seperate mySQL Tables in my database, with some information.. and i would like to connect the two tables so as to get Relevant Data picked up from the relevant Table and it's relevant fields. Do we need to use a Foriegn/Primary key for this purpose? If so, how do you use

Connectiing mySQL db on Localhost to mySQL DB on Server

2002-07-09 Thread Thomas Edison Jr.
Hi, I would like to export Table Data which is on my localhost mySQL Server, to a Table in mySQL on the Internet Web Server. How can i do that? Basically it's just moving mySQL Table Data from localhost to web server on the internet! Is it possible? if so, how? Thanks, T. Edison Jr.

Remote Host Connection/Software on Web : Accessing mySQL

2002-07-08 Thread Thomas Edison Jr.
Hi, Basically we have created a Software in Visual Basic. Now the software uses mySQL on the internet as Backend. However, our server does not allow Remote Host Connection, which means we cannot access our mySQL Database on the Internet by our Software on a local client. We need the mySQL

using .dat SQL Data in mySQL DB

2002-04-17 Thread Thomas Edison Jr.
Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418 02003IN00100213200207320020416200204162002041910002002041920020419

Excel to MySQL

2002-03-27 Thread Thomas Edison Jr.
How do i import MS Excel Data into MySQL Tables?? T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124

Importing Tables Data into MySQL from Access

2002-03-26 Thread Thomas Edison Jr.
Hi, I'm looking to Import complete MS Access Table with Data into a MySQL Database. How can i do that? Especially if i have to do it for a site on the internet... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th

RE: Importing Tables Data into MySQL from Access

2002-03-26 Thread Thomas Edison Jr.
separated values files. Use phpMyAdmin to insert text files into each table. Voila! Andrew Hazen -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: Importing Tables Data into MySQL from