Data source name not found, and no default driver specified

Very simple!

On server:

SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQL

Delete the USER data source name and define it as a SYSTEM data source name. Go to -> Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC): – User DSN : delete the specified User DSN – System DSN : create a new System DSN

Else try to install same 32bits or 64bits version as locally installed.

Locally:

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

32bit/64 bit conflict – either you install a 32bit driver version or you use/configure the 32bit under C:\Windows\SysWoW64\

Try to install same 32bits or 64bits version as locally installed.

Related Posts:

  1. PDO with INSERT INTO through prepared statements
  2. Creating a search form in PHP to search a database?
  3. How can I do ‘insert if not exists’ in MySQL?
  4. Commands out of sync; you can’t run this command now
  5. Cannot simply use PostgreSQL table name (“relation does not exist”)
  6. How can I do ‘insert if not exists’ in MySQL?
  7. Fatal error: Call to undefined function sqlsrv_connect()
  8. PHP Fatal error: Call to undefined function mssql_connect()
  9. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  10. Fatal error: Call to a member function query() on null
  11. Replace ' and similar html codes with their correspondent character?
  12. Google Calendar API event update always return 404 “not found” error
  13. How to prevent the “Confirm Form Resubmission” dialog?
  14. navigate back with PHP form submission
  15. How to set 777 permission on a particular folder? [closed]
  16. How do I make a redirect in PHP?
  17. Selecting COUNT(*) with DISTINCT
  18. List of All Locales and Their Short Codes?
  19. Case in Select Statement
  20. What is a stored procedure?
  21. Difference between “as $key => $value” and “as $value” in PHP foreach
  22. How do I get a YouTube video thumbnail from the YouTube API?
  23. What is a slug?
  24. Visual list of all installed fonts with respective pangram phrase?
  25. Inserting multiple rows in a single SQL query? [duplicate]
  26. How to avoid Request Entity Too Large 413 error
  27. How to log in to phpMyAdmin with WAMP, what is the username and password?
  28. Array to String PHP?
  29. Conversion failed when converting date and/or time from character string while inserting datetime
  30. Self Join to get employee manager name
  31. How do I UPDATE from a SELECT in SQL Server?
  32. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  33. SQL query to select dates between two dates
  34. count() parameter must be an array or an object that implements countable in laravel
  35. regex match any whitespace
  36. Conversion failed when converting date and/or time from character string while inserting datetime
  37. When should I use CROSS APPLY over INNER JOIN?
  38. Insert Data Into Temp Table with Query
  39. SQL query to get the employee name and their manager name from the same table
  40. What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
  41. error, string or binary data would be truncated when trying to insert
  42. How to fix “Headers already sent” error in PHP
  43. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  44. NOT IN vs NOT EXISTS
  45. How can I do an UPDATE statement with JOIN in SQL Server?
  46. Must declare the scalar variable
  47. T-SQL split string
  48. currently unable to handle this request HTTP ERROR 500
  49. Must declare the scalar variable
  50. PHP page redirect
  51. Rename column SQL Server 2008
  52. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  53. Efficiently convert rows to columns in sql server
  54. Whoops, looks like something went wrong. Laravel 5.0
  55. The SQL OVER() clause – when and why is it useful?
  56. Update multiple columns in SQL
  57. PHP “or” Syntax
  58. Nested select statement in SQL Server
  59. Fatal error: Call to undefined function mysql_connect()
  60. How to fix “Headers already sent” error in PHP
  61. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  62. “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP
  63. What are namespaces?
  64. How do I escape a single quote in SQL Server?
  65. Get the full URL in PHP
  66. SQL Server IF EXISTS THEN 1 ELSE 2
  67. PDOException SQLSTATE[HY000] [2002] No such file or directory
  68. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  69. PDOException SQLSTATE[HY000] [2002] No such file or directory
  70. T-SQL split string based on delimiter
  71. Mysql query- How to use contains?
  72. How do I get PHP errors to display?
  73. SQL Query with SUM with Group By
  74. S_SESSION variable (user role) not recognised
  75. What are the main differences between PHPExcel and PhpSpreadsheet?
  76. Is SAJAX dead? What to replace with?
  77. How do I resolve a HTTP 414 “Request URI too long” error?
  78. Get the full URL in PHP
  79. How do I check if a string contains a specific word?
  80. PDOException: SQLSTATE[HY000] [2002] No such file or directory
  81. xajax expanding list query
  82. Drop a temporary table if it exists
  83. How do I perform an IF…THEN in an SQL SELECT?
  84. How do I escape a single quote in SQL Server?
  85. How to force file download with PHP
  86. How do I get a file extension in PHP?
  87. How to Set Category Page as Home Page in Prestashop
  88. Get the full URL in PHP
  89. How Stuff and ‘For Xml Path’ work in SQL Server?
  90. IDENTITY_INSERT is set to OFF – How to turn it ON?
  91. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  92. SQL update from one Table to another based on a ID match
  93. Invalid column count in CSV input on line 1 Error
  94. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  95. How to copy a file from one directory to another using PHP?
  96. How to check if a string starts with a specified string?
  97. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  98. what does PHP die() return
  99. Invalid column count in CSV input on line 1 Error
  100. how to replace quotation marks with \”

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)