MyOdbc and MySQL question

------=_Part_89724_26534548.1152495186734
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On the website it said that if you were to want to use C# to interface that
I would need this line of code: csc /r:System.Data.dll
I was just curious what I do with that, in other words where do I type it or
put it in.

I also have another question if you could help.. When I install Mysql it
goes fine, and then it prompts me for the option to
'Configure the MySQL now' and so I check the box and I proceed

I choose standard configuration, then developer machine, multifuctional
database, for number of connections I say manual and
choose the default of 15, the networking options are default with port 3306,
standard character set, I Install as a windows service, with everything else
default, The security options box comes up and I choose Modify Security
Settings, and so I make a password, and leave everything else default, and
then I click execute, it says I could start the service Mysql Error:0 so I
am stuck there.

Also when I do the connecting for ODBC and the System DNS I fill the stuff
out, and then I click the drop down box and I get an error which says that
it cannot connect to the local host with a number in parenthesis - (10061)
that is the number.. any help would be great.

PS I'm doing this for a Sr Project, I'm wanting to connect to mysql via C#
and create a GUI and all of that kind of stuff, it may help I don't know

------=_Part_89724_26534548.1152495186734--

RE: MyOdbc and MySQL question

That line of code=20

csc /r:System.Data.dll

invokes the C# compiler from a command line. The /r switch includes the
System.Data.dll as a reference, meaning that other code files you are
going to include on the same command line uses classes defined in the
DLL. A more complete command line would be: -

csc /r:System.Data.dll myprog.cs

which compiles the C# file myprog.cs with references to System.Data.dll.

" it says I could start the service Mysql Error:0 "

I presume you mean you could NOT start the service. There may be a log
file created in the data folder of your mysql installation folder that
may give you some clues. You can also start the server program (mysqld)
used in the service from a command prompt. If you try that you may also
get some error messages that tell you why it is not starting. Mysqld is
in the bin folder of your MySQL installation folder. The MySQL manual
has some help for getting started and dealing with errors like these.

If the service is not running you will not be able to connect to it,
which may explain your other error with ODBC.

John B.


-----Original Message-----
From: Mike Crocker [mailto:mikaelcrocker@gmail.com]=20
Sent: Monday, 10 July 2006 11:03 AM
To: myodbc@lists.mysql.com
Subject: MyOdbc and MySQL question

On the website it said that if you were to want to use C# to interface
that
I would need this line of code: csc /r:System.Data.dll
I was just curious what I do with that, in other words where do I type
it or
put it in.

I also have another question if you could help.. When I install Mysql it
goes fine, and then it prompts me for the option to
'Configure the MySQL now' and so I check the box and I proceed

I choose standard configuration, then developer machine, multifuctional
database, for number of connections I say manual and
choose the default of 15, the networking options are default with port
3306,
standard character set, I Install as a windows service, with everything
else
default, The security options box comes up and I choose Modify Security
Settings, and so I make a password, and leave everything else default,
and
then I click execute, it says I could start the service Mysql Error:0 so
I
am stuck there.

Also when I do the connecting for ODBC and the System DNS I fill the
stuff
out, and then I click the drop down box and I get an error which says
that
it cannot connect to the local host with a number in parenthesis -
(10061)
that is the number.. any help would be great.

PS I'm doing this for a Sr Project, I'm wanting to connect to mysql via
C#
and create a GUI and all of that kind of stuff, it may help I don't know

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

myODBC issue - changed table name

Dear all,

Any clarity on this problem would be appreciated.

The setup:
----------
I've got a client program running MS Access 2003 (on Win XP), connecting to
a linux server (running Fedora 5) running MySQL 5.0 Community Edition. At
the moment, there's only the one client connecting - later there will be
many more. Connection is made using myODBC 3.51.12

The problem:
------------
Halfway through a data-entry process the other day, Access threw up an ODBC
error. After much debugging, it turns out it couldn't find a certain table,
called textbank_account_name00000152. I know that this table had existed in
the past, so I deleted the link from Access's database window, then tried to
relink the table. The table bank_account_name00000152 appeared when I
selected my DSN from the list, but when I then tried to link it, it said
that the Jet Database engine couldn't find table bank_account_name00000152.
Further investigation in MySQL administrator revealed that the table
bank_account_name00000152 was not present in the database, but one called
bank_account_name00000144 *was* present. Slightly confused, I then tried to
rename this table to bank_acount_name00000152 using the built-in MySQL Table
Editor. Error: "table bank_account_name00000152 already exists"
To further these problems, I'm currently doing all this querying "blind"
over the phone to a fairly non-technical user, while I wait for a VPN to be
set up. So for the moment, I don't have printouts of the information_schema,
etc.

The questions:
--------------
1. Has anyone else had this issue using myODBC?
2. Is there any way that I can change the table name without issuing a ALTER
TABLE statement (I can't see one in my code)?
3. Although this may be an issue for a separate list, does anyone have any
experience of this internal inconsistency within MySQL server - ie a table
which appears to have one name but "actually" has another?
4. The user I speak to over the phone has limited abilities and limited
patience. Can you suggest any information that would be really useful to
get? I think an information_schema readout is probably going to be pretty
high on that list, but are there any other things I haven't thought of?

Any help you can offer would be gratefully appreciated, and might save me
from further hair loss...

Thanks!

Al McNicoll
Integritec Ltd


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org