Live DB Connection: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Hi .

"I’m getting an error when running the bot, please help me,

Live DB Connection: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Thanks

@damodar99

as per error looks like in your db activities you did not specify the drivers or the connection string is wrong

cheers

Hi @damodar99

Make sure you have installed correct ODBC driver. Even the 64 Bit/ 32 Bit matters as per your system. & also make sure you use the right connection string, build using connection builder.

You can check if the driver is installed or not in ODBC Data Source Administrator
in windows.

To download ODBC driver - Download ODBC Driver for SQL Server - ODBC Driver for SQL Server | Microsoft Learn

Hope this helps :slight_smile: