Subject Re: ADOdatabase not working in signup.prg From Gaetano <gaetanodd@hotmail.com> Date Mon, 24 Aug 2020 20:11:08 +1000 Newsgroups dbase.getting-started Good Morning Akshat, I have tried both the brackets and the option=512, no change. I tried it on my local MySQL instance and the code worked, just once, then no more... I checked the Apache logs and this may provide some info for experts: [Mon Aug 24 19:55:49.316087 2020] [win32:error] [pid 12440:tid 1884] [client 127.0.0.1:50497] AH02102: C:/xampp/cgi-bin/css/normalize.css is not executable; ensure interpreted scripts have "#!" or "'!" first line, referer: http://127.0.0.1/cgi-bin/SO2.exe [Mon Aug 24 19:55:49.316087 2020] [cgi:error] [pid 12440:tid 1884] (9)Bad file descriptor: [client 127.0.0.1:50497] AH01222: don't know how to spawn child process: C:/xampp/cgi-bin/css/normalize.css, referer: http://127.0.0.1/cgi-bin/SO2.exe Cheers, Gaetano. On 24/08/2020 17:24, Akshat Kapoor wrote: > On 24.08.2020 12:15, Gaetano wrote: >> As I was trying to create the same connection in a datamodule using a >> string for the connection, I got a similar error: "Test connection >> failed because of an error in initializing provider.[Microsoft][ODBC >> driver Manager] Data source name not found and no default driver >> specified" >> >> Hopefully that helps narrowing down the reason for the failure. >> >> Here is the connection string with sensitive elements <replaced>... >> >> "Driver=MySQL ODBC 8.0 ANSI Driver;SERVER=<serverIPaddress>;UID=<user >> ID>;PWD=<password>;DATABASE=<database name on the server>;PORT=3306" > > Good Afternoon Gaetano, > There should be curly brackets around driver. > > I use > > connectionString = "Driver={MySQL ODBC 8.0 Unicode > Driver};Server=localhost;Database=muneem;UID=root;PWD=;Port=3306;option=71303680" > > > You should probably add the option values also. > Have a look at the attached pdf for why and what I use. > > There is a link for detailed study if you want. > > Regards > Akshat