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. Array to String PHP?
  12. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  13. T-SQL split string
  14. Efficiently convert rows to columns in sql server
  15. Update multiple columns in SQL
  16. Nested select statement in SQL Server
  17. PDOException: SQLSTATE[HY000] [2002] No such file or directory
  18. How do I get a file extension in PHP?
  19. XAMPP Port 80 in use by “Unable to open process” with PID 4
  20. Inserting data into a temporary table
  21. CREATE VIEW must be the only statement in the batch
  22. SQL Server FOR EACH Loop
  23. Elegant way to search for UTF-8 files with BOM?
  24. Is SAJAX dead? What to replace with?
  25. How to drop all tables from a database with one SQL query?
  26. break out of if and foreach
  27. Redirect vs RedirectMatch
  28. Can curl make a connection to any TCP ports, not just HTTP/HTTPS?
  29. How can I delete using INNER JOIN with SQL Server?
  30. Error 330 (net::ERR_CONTENT_DECODING_FAILED):
  31. SQL Server: Invalid Column Name
  32. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  33. How do I fix “Undefined variable” error in PHP?
  34. How do you parse and process HTML/XML in PHP?
  35. Is there a difference between the UTC and Etc/UTC time zones?
  36. Fatal error: Call to a member function prepare() on null
  37. String or binary data would be truncated. The statement has been terminated
  38. PHP mail not working for some reason
  39. move_uploaded_file gives “failed to open stream: Permission denied” error
  40. Error converting data type varchar to float
  41. How to concatenate text from multiple rows into a single text string in SQL Server
  42. Count(*) vs Count(1) – SQL Server
  43. PHP convert XML to JSON
  44. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  45. WordPress Error : Upload folder is not writable. Export and file upload features will not be functional
  46. how to get id from URL using php
  47. Fatal error: Cannot use object of type mysqli_result
  48. mysql_field_name to the new mysqli
  49. mysqli_select_db() expects parameter 1 to be mysqli, string given
  50. Remove all special characters from a string
  51. how to convert object into string in php
  52. Call to a member function on null?
  53. how to ping ip addresses in php and give results
  54. do_shortcode not working
  55. Only variable references should be returned by reference – Codeigniter
  56. PHP Unset Session Variable
  57. “Fatal error: Cannot redeclare function”
  58. php get all url variables
  59. How to remove unused dependencies from composer?
  60. how to get date of yesterday using php?
  61. SQL: IF clause within WHERE clause
  62. How can I fetch all items from a DynamoDB table without specifying the primary key?
  63. How to extract and access data from JSON with PHP?
  64. How to convert array to SimpleXML
  65. SQL Server dynamic PIVOT query?
  66. WordPress query single post by slug
  67. TCPDF ERROR: Some data has already been output, can’t send PDF file
  68. Limit String Length
  69. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  70. Get everything after and before certain character in SQL Server
  71. How to run PHP locally on MacOS
  72. Call PHP function from jQuery?
  73. PhpMailer SMTP NOTICE: EOF caught while checking if connected
  74. What is the meaning of sprintf(): Too few arguments
  75. Paypal IPN Verification Postback with HTTPS
  76. Using PHP 7 with WAMP
  77. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? 
  78. PHP: bootstrap.php
  79. Display array values in PHP
  80. Php create a file if not exists
  81. Page redirect after certain time PHP
  82. Check if $_POST exists
  83. PHP – Fatal error: Unsupported operand types
  84. What is tableName.* in SQL
  85. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  86. $wpdb->get_results(…) returns empty array despite correct query
  87. How to display multiple Post meta_key/meta_values by SQL query
  88. Updating WooCommerce variable product stock issue
  89. Genesis framework comments broken?
  90. Databases – Submitting data from inputs to database [closed]
  91. How can I add a new row in a separate database when someone registers via WordPress?
  92. wordpress site – using custom database and PHP
  93. Use variable in SQL statement
  94. Fetching review value using wpdb class
  95. WP_Query: How to get results from both meta_key options?
  96. Database SQL query error
  97. add role on WordPress in PHP on a second database
  98. Running a PHP SQL script on a wordpress page
  99. Inserting other fields to existing registration form in a WordPress theme
  100. can’t delete a row from post_meta table

Leave a Comment