Greetings,

I have been spending the last couple of days trying to get a quick
jolt on how SQL works and how I can use access as a client to connect
to an SQL databse.

I am a volunteer in Honduras helping a teacher teach students about
databases. The problem is it happends to be my weakest subject when it
comes to world of computing.

What I have done is downloaded and installed a version of MySQL on my
personal computer and installed it.

I had set up the server to use as little resources as possible since I
will not be having any more then 1 external connection into my
computer. After having everything up in running I made a very simple
database and played around with it locally on my server, but the real
task is connecting to it across the network. Once I can figure this
out I can install mysql server on an actual computer and open up
connections for the students to do work in.

The problem is this however. I had planned on using MS Access as a
client to connect to the sQL server. It isn't my idea actually it is
in the students curriculum, and not wanting to get into rediculous
Honduran politics with you all I decided not to touch the curriculum.

This all brings me to my problem, I have a horrible time trying to set
up a datasource in my computer.

In the control panel, in administrative tools, I had used the data
source menu to add a SQL server connection. I set my server to
127.0.0.1 and my port to match the port SQL is using. I verified the
connection by telneting to that IP with that port and connect (with a
bad hadnshake given but appeared to have accepted the connection). I
also verified that my computer is listening on that specific port,
which is why I was able to telnet to it.
Now when it comes to setting up this datasource I get nothing but
problems.

On the network configuration page I have the following checked...
The SQL Server will do the authenticating
Connecting to SQL will update further settings automatically.
(Here I inputed the "Root" as the user and assigned the appropriate
password."

Client Configuration
TCP/IP (127.0.0.1) Port 3306

Then I click next and get the following errors.

Connection failed:
SQLState: '01000'
SQL Server error: 10054
[Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionRead(recv()).
Connection failed:
SQLState: '08S01'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network
error. Checl your network documentation.

If I change it to use pipes and put in the pipe name I get this.
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionOpen(Connect()).
Connectioon failed:
SQLState:'08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not
exist or access denied.



What angers me is that I can pull up a telnet screen. Maybe it's not
an acurate way of testing a connection but I know the ports open and
the computer is listening. I used to do this trick to make sure I had
setup routes correctly to connect to an exchange server. Maybe its a
pour method for SQL but I have found extremely pour support on their
website unless your a paying customer. And there is no way a pour
school in Central Americas pourest country is going to spend money on
buying SQL enterprise for a small 2 month class. It's rediculous.

Any how, if any one has any idea at all where I can get more
documentation or what exactly could be wrong I would truely appreciate
it.

Cliff Rosson


MYSQL 5.0
SQL Server Driver Version 2000.85.1117.00

On Jul 4, 12:17 pm, Nis Jørgensen <n... (AT) superlativ (DOT) dk> wrote:
guess it makes sense that the microsoft driver would be for a
microsoft product! Thanks again for the quick help.

Cliff

On Jul 4, 12:17 pm, Nis Jørgensen <n... (AT) superlativ (DOT) dk> wrote:
I hate to do this to you but I can't find anything useful online.
Everything works accept I can't open a simple database. When I connect
with access I get the error..

ODBC--call failed.
[MYSQL][ODBC 3.51 Driver]Uknown database 'my_books' (#1049)

The database is created and I can view at the mysql command prompt.
There is no data however in the database, I was hoping to use access
as a client to connect to it and add data. Any thoughts?

Whats odd is I can open the 'mysq' database that comes with MySQL, but
I cannot open my own! What gives.

On 4 Jul, 19:27, Cliff <Cliff.Ros... (AT) gmail (DOT) com> wrote:
What exactly are you trying to teach - and to who?

On Jul 5, 6:01 pm, strawberry <zac.ca... (AT) gmail (DOT) com> wrote:
A highschool in Honduras. Its an advanced computer class for students
at the age of 17-18. Admitedly databases are not my specialty and I
have spent very little in the way of working with them. Up untill now
we have been working in access but soon we will start with SQL.
Nothing to heavy and if I cannot setup a server for them I will
install mysql locally on each computer for them to work on. I can
disable the network portion of mysql and they will just have to manage
their own database locally on their computer. Thanks for the help
though I will have to head over to a mysql group for more help.

Thanks for everything guys!

"Cliff" <Cliff.Rosson (AT) gmail (DOT) com> wrote in message


By an odd coincidence, I used to teach database programming and design
courses for DEC (Digital Equipment Corporation) back in the 1980s. I often
taught in Spanish, in Mexico and Puerto Rico. DEC adopted SQL as the
interface language early in those years, so I learned to teach it.

I'm very glad you're exposing your students to database work early on. Too
many people don't learn databases until they've already done ten years of
programming.

Good luck!