Subject Re: ADOdatabase not working in signup.prg From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 24 Aug 2020 12:54:54 +0530 Newsgroups dbase.getting-started Attachment(s) connection string parameters final.pdf 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