This is a cryptographically signed message in MIME format. --------------msE86101F6F83808092E8EA106 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
http://www.mysql.com/downloads/index.html You need MySQL & MyODBC and optionally MySQLGUI. Once you have MySQL installed, you should see a Traffic Light in your system tray. This is WinMySQLadmin. If the light is green, then mysql is running. You can use this to stop or start mysql there, rather than checking your Services menu. WinMySQLadmin has a databases tab that lets you browse the table structures of your dbs. MyODBC gives you the connctivity to CF you want on Windows. (CF on Linux has native drivers for MySQL.) Once you install it, go to your Control Panel > Administrative Tools > Data Sources (ODBC). Create a System Datasource here using the MySQL driver. Make sure you fill out the dialog box completely including name, ID & PWD for the db. Once this is created, it will show up in CF Admin in your list of available datasources. If it doesn't verify, then make sure all your settings in your Win2k DataSources panel are correct. MySQLGUI is a decent UI for creating and running SQL in your MySQL db. One question, is your production site running on Linux or on Windows? If you're on Linux, then MySQL is case-sensitive to datasource, database, and table names. Column names aren't case sensitive, but the rest are because they're tied to the file system. MySQL is not case-sensitive on the Windows platform. Let me know if you have any other questions. All my CF sites run on MySQL. Adrian J. Moreno North Texas Web Design --------------msE86101F6F83808092E8EA106 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIH9QYJKoZIhvcNAQcCoIIH5jCCB+ICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BcgwggKIMIIB8aADAgECAgMGDB4wDQYJKoZIhvcNAQECBQAwgZIxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhh d3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwg RnJlZW1haWwgUlNBIDIwMDAuOC4zMDAeFw0wMTExMDcxODQ2MTBaFw0wMjExMDcxODQ2MTBa MEkxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxJjAkBgkqhkiG9w0BCQEWF2Ft b3Jlbm9AbnR3ZWJkZXNpZ24uY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDBKxYs eLKmuTrRev2fcEE50jp6GQbYVQeB6u7dis/ArYexzTyvbea+utL3oLEehRSzykmuJ0GoC7Yv lvhx+YfgdCI+3B+xWnXyqvaKpLf2R9FHRgfi5HepUm5Q5CvTe/dwr9cbT6LnIoRA5+FKy9Ej ov4pTWTFabruLP95N1g/6wIDAQABozQwMjAiBgNVHREEGzAZgRdhbW9yZW5vQG50d2ViZGVz aWduLmNvbTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBAgUAA4GBAMA7736puSY9Mmwb6Zhr IlyvNVpwlVbGrkho65i/vfJge9Xz3EtJpZqhbof3dGVkdWSIBw/HU7zzSzDXBKUPhIFFs240 SX2FOTYMpCtQpfcF3/lxYL4mhI73/YfwCVAhuOAjYFZwmdNjQAz159F0FUSJBH1BcTchXt2U 2dk8RredMIIDODCCAqGgAwIBAgIQZkVyt8x09c9jdkWE0C6RATANBgkqhkiG9w0BAQQFADCB 0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBU b3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlmaWNhdGlv biBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWls IENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTAw MDgzMDAwMDAwMFoXDTA0MDgyNzIzNTk1OVowgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwg UlNBIDIwMDAuOC4zMDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA3jMypmPHCSVFPtJu eCdngcXaiBmClw7jRCmKYzUqbXA8+tyu9+50bzC8M5B/+TRxoKNtmPHDT6Jl2w36S/HW3WGl +YXNVZo1Gp2Sdagnrthy+boC9tewkd4c6avgGAOofENCUFGHgzzwObSbVIoTh/+zm51JZgAt CYnslGvpoWkCAwEAAaNOMEwwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJl bDEtMjk3MBIGA1UdEwEB/wQIMAYBAf8CAQAwCwYDVR0PBAQDAgEGMA0GCSqGSIb3DQEBBAUA A4GBADGxS0dd+QFx5fVTbF151j2YwCYTYoEipxL4IpXoG0m3J3sEObr85vIk65H6vewNKjj3 UFWobPcNrUwbvAP0teuiR59sogxYjTFCCRFssBpp0SsSskBdavl50OouJd2K5PzbDR+dAvNa 28o89kTqJmmHf0iezqWf54TYyWJirQXGMYIB9TCCAfECAQEwgZowgZIxCzAJBgNVBAYTAlpB MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMG VGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29u YWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDBgweMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwMzI2MjE1NjE0WjAjBgkqhkiG 9w0BCQQxFgQUqtjlv8+5y/RnaHESwA6BcVYgs0cwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG 9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZIhvcNAwICAUAwDQYIKoZIhvcN AwICASgwDQYJKoZIhvcNAQEBBQAEgYCp9/VlKNZAMBjt64cRzC0quxVRuBC5iF8ef6uGf9An 0bj3bo/JNwK5pW/K0zyfuTaKzGRdg2JCTvZEB046hlOHzPS0E10G4Bc4JFO2n9ts5Z/HvXzq +p3z6SoqhBQzrL1re1XVF+0fsrIXPxtNF1MC+XERGlGQaJCB2lXTBNWC0g== --------------msE86101F6F83808092E8EA106-- Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
