leosweden
Posts: 61
|
| Posted: 05/18/2007, 1:52 PM |
|
Hello everyone
I have uploaded a video where i explain my problem trying to use the MYSQL database that comes with CCS...
I forgot to specified that the database i want 2 use is in teh folder "exemples" with the name internet_MYsql .. you know ..
I have already uninstalled the IIS that comes with windows xp pro so, now i just have apache installed and the ODBC installed to.... but now what? i donīt know what to do....
The video explains better. PLease check it: Maybe it is easier if you download the video (swf) because i go a little bit fast.
http://www.verylogic.com/help.html
http://www.verylogic.com/help.swf
Thanks
|
 |
 |
Damian Hupfeld
|
| Posted: 05/18/2007, 3:50 PM |
|
Hi Leo,
I tried to watch your video but I got bored half way... only kidding. There
is no video - only voice - at leat on my computer.
Did you try Walter's settings in your origininal post?
Download a tool called Navicat - you can try it for 1 month. This may help
you play around with your databases and settings.
If your DB is on your localcomputer set the host as localhost
If you didnt set a password try using root and no password
You might need to read the instructions/readme for the tools you are using.
regards
Damian
"leosweden" <leosweden@forum.codecharge> wrote in message
news:5464e1213594ed@news.codecharge.com...
> Hello everyone
>
> I have uploaded a video where i explain my problem trying to use the MYSQL
> database that comes with CCS...
>
> I forgot to specified that the database i want 2 use is in teh folder
> "exemples" with the name internet_MYsql .. you know ..
>
> I have already uninstalled the IIS that comes with windows xp pro so, now
> i
> just have apache installed and the ODBC installed to.... but now what? i
> donīt
> know what to do....
>
> The video explains better. PLease check it:
> http://www.verylogic.com/ccs.AVI
>
>
> Maybe it is easier if you download the video because i go a little bit
> fast.
>
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Damian Hupfeld
|
| Posted: 05/18/2007, 4:00 PM |
|
democharge might have been a better tool to try to show the problem - it
would make much smaller files than 21MB!
"Damian Hupfeld" <damian.hupfeld@itng.com.au> wrote in message
news:f2laka$2eb$1@news.codecharge.com...
> Hi Leo,
>
> I tried to watch your video but I got bored half way... only kidding.
> There is no video - only voice - at leat on my computer.
>
> Did you try Walter's settings in your origininal post?
>
> Download a tool called Navicat - you can try it for 1 month. This may help
> you play around with your databases and settings.
>
> If your DB is on your localcomputer set the host as localhost
> If you didnt set a password try using root and no password
>
> You might need to read the instructions/readme for the tools you are
> using.
>
> regards
> Damian
>
>
> "leosweden" <leosweden@forum.codecharge> wrote in message
>news:5464e1213594ed@news.codecharge.com...
>> Hello everyone
>>
>> I have uploaded a video where i explain my problem trying to use the
>> MYSQL
>> database that comes with CCS...
>>
>> I forgot to specified that the database i want 2 use is in teh folder
>> "exemples" with the name internet_MYsql .. you know ..
>>
>> I have already uninstalled the IIS that comes with windows xp pro so,
>> now i
>> just have apache installed and the ODBC installed to.... but now what? i
>> donīt
>> know what to do....
>>
>> The video explains better. PLease check it:
>> http://www.verylogic.com/ccs.AVI
>>
>>
>> Maybe it is easier if you download the video because i go a little bit
>> fast.
>>
>> Thanks
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/19/2007, 3:18 AM |
|
ok i use another format swf instead of the original video.
thanks for the suggestion Damian.
Do you have another suggestion about the original problem now?
|
|
|
|
Damian Hupfeld
|
| Posted: 05/19/2007, 4:54 AM |
|
You make it hard for yourself - and for people trying to help you.
You havent posted a link to the new format and you do not reply to
suggestions on things to try. Walter has made suggestions and so did I and
you havent said whether they worked or whether you even tried them.
Damian
"leosweden" <leosweden@forum.codecharge> wrote in message
news:5464ecef6d8a68@news.codecharge.com...
> ok i use another format swf instead of the original video.
> thanks for the suggestion Damian.
> Do you have another suggestion about the original problem now?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/19/2007, 6:44 AM |
|
Hi Damian
Well there is no new link, because i edited the first message, so the video is already in the first message no AVI but swf and html.
Anyway, here is it again http://www.verylogic.com/help.html , and yes, i have already done everything the others have told me to do
;)
please take your time to help me
thanks
|
|
|
|
Damian Hupfeld
|
| Posted: 05/20/2007, 3:55 AM |
|
Leo - you have NO database.
Download Navicat or get a MySQL tutorial and create a database.
You have the correct settings for server, username and password. But you
still have to connect to SOMETHING.
CCS does not create databases. It creates applications that talk to
databases.
Damian
"leosweden" <leosweden@forum.codecharge> wrote in message
news:5464eff566f4ca@news.codecharge.com...
> Hi Damian
>
> Well there is no new link, because i edited the first message, so the
> vidio is
> already in the first message no AVI but swf..
>
> anyway, here is it again http://www.verylogic.com/help.html
>
> and yes, i have already done everything the others have told me to do
>
> ;)
>
> please take your time to help me
>
> thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/20/2007, 4:14 AM |
|
Hello Damian
I really appreciate your help!
You know, when you install CCS there are 2 DBs in a folder called "Examples" in my case is in C:\Archivos de programa\CodeChargeStudio3\Examples\Internet .
The DB i have there has a name: internet.sql here you can see it
http://www.verylogic.com/Internet_MySQL.sql
That is a DB right? i mean i know what a MS access DB is, but i am not sure about MYsql.
If that is the mysql DB i need, what should i do now?
Thanks
|
|
|
|
Damian Hupfeld
|
| Posted: 05/20/2007, 5:28 AM |
|
You really should read the tutorials and the doco...
The Examples and Example Packs do contain a DB. If you want to you this DB
follow the instructions in the Example Pack. If you want to create a new
project using your own database - you need to craete the database first,
then create your connectiona nd then create your project.
Damian
"leosweden" <leosweden@forum.codecharge> wrote in message
news:546502da60b0ea@news.codecharge.com...
> Hello Damian
>
> I really appreciate your help!
>
> You know, when you install CCS there are 2 DBs in a folder called
> "Examples"
> in my case is in C:\Archivos de
> programa\CodeChargeStudio3\Examples\Internet .
>
>
> The DB i have there has a name: internet.sql here you can see it
>
> http://www.verylogic.com/Internet_MySQL.sql
>
> That is a DB right? i mean i know what a MS access DB is, but i am not
> sure
> about MYsql.
>
> If that is the mysql DB i need, what should i do now?
>
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
Wkempees
|
| Posted: 05/20/2007, 5:39 AM |
|
The major point here being:
Examples supply you with the SQL scripts to create the example database
tables.
You need to have the database first, then you feed it the example SQL
(right flavor) through the use of a SQL CLI (Like Navicat)
Then the tables will be created in your Database.
Then you can wonder on the ODBC, and after that you finaly experience
the CCS capabilities.
So yes, Damian is right, read read read.
Also Google for XAMPP WAMP, to get an idea of fast installing complete
local Apache PhP Perl MySQL environments.
Walter
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/20/2007, 9:44 AM |
|
hello again
I have read a big part of the tutorial.
I agree that i need a DB.. Just answer this ... does CCS comes with a mysql DB called Internet_MySQL.sql ?
I have used the access database also called "Internet.mbd". I have used that with ASP and i have installed IIS... IT WORKS JUST FINE.
I have also done this http://www.dvrhb.com in PHP with a MySQL database in the hosting.
Now i want to know: Does CCS comes with a mysql DB called Internet_MySQL.sql ?
If yes, i want to use it
If not, is that what you call a script ?
Thanks
|
|
|
|
Damian Hupfeld
|
| Posted: 05/20/2007, 8:38 PM |
|
Leo,
You will need to read the examples and instructions or this is going to tale
a very long time.
It does contain a FILE called Internet_MySQL.sql but this is not a database.
Most databases are not accessed by accessing the file(s) directly (Access is
one exception to this). You access the database server.
You need to run the script file that you mention (as Walter suggested to you
in another post).
The easiest way to do this is to use a tool like Navicat - but you are still
going to need to read a little on how tod o this exactly - it is very
straight forward though.
Damian
"leosweden" <leosweden@forum.codecharge> wrote in message
news:546507aea08ba2@news.codecharge.com...
> hello again
>
>
> I agree that i need a DB.. Just answer this ... does CCS comes with a
> mysql DB
> called Internet_MySQL.sql ?
>
> I have used the access database also called "Internet.mbd". I have used
> that
> with ASP and i have installed IIS... IT WORKS JUST FINE.
>
> I have also done this http://www.dvrhb.com in PHP with a MySQL database
> in the
> hosting.
>
> Now i want to know: Does CCS comes with a mysql DB called
> Internet_MySQL.sql
> ?
>
> If yes, i want to use it
> If not, is that what you call a script ?
>
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Wkempees
|
| Posted: 05/21/2007, 1:14 AM |
|
Quote :
I agree that i need a DB.. Just answer this ... does CCS comes with a
mysql DB called Internet_MySQL.sql ?
NO it does not does CCS comes with a mysql DB called Internet_MySQL.sql
However it comes with a file called Internet_MySQL.sql
You feed that file to a MySQL Database and from the file it will all the
tables and fill them for you.
The MsAccess Database is supplied for severqal purposes.
It is supplied to have a common database for all CCS platforms to do the
examples.
Besides that, for some people, it is the database of choice.
Walter
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/21/2007, 3:13 AM |
|
Thank you all of you..... and first of all for your patience..
I must tell you that i think something was wrong NOT only in my head but in my computer ;)
I have reinstalled windows and downloaded the ODBC again. the same version but 4kb bigger.... strange... maybe the first problem was because of that.
I have used the file Internet_MySQL.sql in order to create a DB using XAMPP...
That was the same way i created the DB in my hosting, but in my computer as you know.
Well i have created a DB called " leomcco_dvr ", the user name is "root" and the pasword lets call it " aabbcc ".... i use the ODBC 3,51 .
and i can see the DBs
But now i recieve a message ERROR...
i will show you in the next video
http://www.verylogic.com/error.html
Leo
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/21/2007, 12:11 PM |
|
|
|
|
|
wkempees
|
| Posted: 05/21/2007, 3:17 PM |
|
XAMPP has pv.exe to control it.
You may have to start it to have it do what it does.
Look in the xampp directory for an orange icon like clover.
through pc you can also start all as service so that it will reboot with XP
No update is stopping it.
"leosweden" <leosweden@forum.codecharge> schreef in bericht
news:54651eee1328a9@news.codecharge.com...
> The worst thing....
>
> Everything was working like in the video before i update my windows... now
> it
> doesnīt respond. Any comment?
>
> Leo
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
hidran
Posts: 29
|
| Posted: 05/23/2007, 2:31 AM |
|
Hi Leo,
I answered also in spanish forum .
You have to compile in design user_name and password
otherwise CCS won't connect.
Type in the same data you typed in odbc conexion.
Regards,
Hidran
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/23/2007, 2:46 AM |
|
Thanks to all of you
You know , i have done everything that you have told me.
But i am becoming crazy. So I will continue doing my DBīs in Access and coding ASP.
Maybe i will try someother time. I will read a lot first.
Thank you very much anyway.
Leo
|
|
|
|
Damian Hupfeld
|
| Posted: 05/23/2007, 4:24 AM |
|
Leo,
If you are willing to give me some remote control on your computer I will
do it with you. Setting up remote control will take longer than showing you.
Mail me.
Damian
"leosweden" <leosweden@forum.codecharge> wrote in message
news:546540d5b14ed5@news.codecharge.com...
> Thanks to all of you
>
> You know , i have done everything that you have told me.
>
> But i am becoming crazy. So I will continue doing my DBīs in Access. Maybe
> i
> will try someother time, I had enough.
>
> Thank you very much anyway.
>
> Leo
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
leosweden
Posts: 61
|
| Posted: 05/23/2007, 10:27 AM |
|
Damian
I appreciate your help.
I have already installed IIS, is there any problem with it? i mean Wampp is not longer in my system and no ODBC either..
What is your mail or MSN ? mine isLEOMCCO@HOTMAIL.COM
Thanks for helping again
Leo
|
|
|
|
