Installing mSQL version 2.0.10.1 (found on aminet)

[sim085]

Hi

I have installed mSQL and mSQL-administrator. However when I run the latter I get the following error:

"Could not find cando.library"

Does anyone know why I am getting this error? From where I can get cando.library and where I have to put it?

Regards,
Sim085

[sim085]

Ok, I managed to make it work. However when I try to create a new database the admin tools gives me an error telling me:

"Could not found >>msqladmin<Executable belongs to >> mSQL:bin<
Does anyone know what this means?

[tone007]

Is there an assign set up for mSQL:? It might want one of those.

[sim085]

Is there an assign set up for mSQL:? It might want one of those.

How do you do that?

[tone007]

Assign: Amiga Shell command that allow to create logical names for drives or directory.

Example: assign FONTS: wb3.1:fonts  

Generally used at CLI.

[sim085]

Example: assign FONTS: wb3.1:fonts  

Is there a way to remove the assign after I do it? Also is there some place I can find all these command?

[kolla]

Is there a way to remove the assign after I do it? Also is there some place I can find all these command?

Are you sure you're really a cult member? :roflmao:

Sorry, that was perhaps a bit rude

Anyways, yes, you can remove assigns "assign msql: remove" for example (or just "assign msql:")
In general you can type "command ?" (followed by enter) to see what flags/options they support, and then just continue to type them in, maybe press "?" and enter again etc. till you're done. Properly written commands also accept ctrl-C (and enter) at the ?-prompt to break the command before it's even really run.

[sim085]

Are you sure you're really a cult member? :roflmao:

Sorry, that was perhaps a bit rude

Anyways, yes, you can remove assigns "assign msql: remove" for example (or just "assign msql:")
In general you can type "command ?" (followed by enter) to see what flags/options they support, and then just continue to type them in, maybe press "?" and enter again etc. till you're done. Properly written commands also accept ctrl-C (and enter) at the ?-prompt to break the command before it's even really run.

Well for sure I am learning to become one Thanks for the help. I can't get the thing working and do not wish to leave unwanted stuff on my environment.

[tone007]

Rebooting your machine would also undo the assign, they aren't persistent unless you put them in your startup-sequence.

[sim085]

Rebooting your machine would also undo the assign, they aren't persistent unless you put them in your startup-sequence.

... and where is that? I am asking because when booting I am getting an error so I think the installer might have edited that!

[tone007]

The startup-sequence file is in S:

You can edit it with ed.

[sim085]

The startup-sequence file is in S:

You can edit it with ed.

Thanks I found it in user-startup file.

[sim085]

I managed to make things work. However still have problems to manage the msql database from the administration tool.

Each time I am trying to create a new database (or do any other action) I get an error that the administration tool is not connected to the database!

I was thinking to try and use the database from the command line interface. Does anyone has experience on this and therefore knows how this is done?

[TheMagicM]

uhh.. create a database directly in mySQL instead of using mysql admin.  use google to search for tips on how to create using sql.

[sim085]

uhh.. create a database directly in mySQL instead of using mysql admin.  use google to search for tips on how to create using sql.

I know how to create a database using SQL but can't understand how to interact with mSQL from Shell (if that is how it is done). Also tried to read the readme files on Aminet and did not find much there.