Dreamweaver and MySQL

[crypto]

I'm trying to make a login page in dreamweaver using a data base to cheack to see if the username and password are correct, I'v made the data base in MySQL and got 3 files for 1 table a .frm, .MYD and .MYI I understand what these 3 files are for the collumn, index and data files or sumthing like that anyway it dosen't matter, my problem is that dreamweaver dosen't see any of these as database files or tables. Can any one tell me why its not seeing them? I'm useing ASP with JavaScript if anyone wants to know.

[PeOfEo]

Why are you trying to use mysql with asp #1. In order for it to work you are going to need to screw with the my.ini etc. Did you mean mssql server? mysql is sort of designed to work w/ php more then asp.

[crypto]

I'm new to all this stuff I'm used to using just HTML but I'm trying to expand my knolage so thanks for that. I was using ASP cause dreamweaver said in the help file to use it. Anyway i'v got coldfusion now so I'll try that one.

[PeOfEo]

You can use php asp asp.net jsp cgi cf etc but you should pick the proper data bases, like php and cgi would be used with mysql usually, whereas asp.net and asp would be used with mssql server, access, and msde.

[crypto]

Ok thankyou for your help ill try using php to do it cause i couldn't get coldfusion to work properly

[crypto]

Ok i got a php site and adding a database from MySQL but it dosn't work please read my post on -PHP- about Dreamweaver And MySQL.

Thanks again for your help.

[PeOfEo]

I don't know php so...

[piersk]

Originally posted by PeOfEo
You can use php asp asp.net jsp cgi cf etc but you should pick the proper data bases, like php and cgi would be used with mysql usually, whereas asp.net and asp would be used with mssql server, access, and msde.

You can use MySQL dbs with ASP. However, you need MyODBC (http://www.mysql.com/downloads/api-myodbc-3.52.html) to be able to connect to it.

[PeOfEo]

Originally posted by piersk
You can use MySQL dbs with ASP. However, you need MyODBC (http://www.mysql.com/downloads/api-myodbc-3.52.html) to be able to connect to it. I am familiar with running mysql off of a windows machine, using the my.ini you sort of emulate a unix machine or linux. But when you do this the fact that you are having to emulate is going to slow the whole thing down, it would still be faster then using an access data base but mssql server will run a whole lot smoother and faster then mysql. If you are looking for price effectiveness you could just use msde, it is just a free/cheap version of sql server, it is not supposedly 'professional grade' but it works just as well as mssql server a majority of the time.So using mysql with asp and asp.net is not often a viable option because msde is available, however if your host only hosts mysql as a hosted data base then I guess you would have to make due with it.

[piersk]

Actually, accessing a MySQL db is faster than Access, even with windows. This is testing using a search that has to root through about 1200 records, both using the same code, just different databases (I had to do this to persuade my super that MySQL was a good idea ;) )

[PeOfEo]

I said that it was faster then access in my post
But when you do this the fact that you are having to emulate is going to slow the whole thing down, it would still be faster then using an access data base but mssql server will run a whole lot smoother and faster then mysql
But mssql server and msde put it to shame on ms based machines.

[piersk]

Sorry, I misread it. My bad.

IIRC, access was never developed for web use. It was originally meant for standalone databases.

[PeOfEo]

thats why it sucks :D, It has its fair share of problems, and not just slow speed, it also locks up after 10 users login and has size issues. But its suitable for small applications, I prefer it to xml data.