[MDEV-15952] SQL Server linked server to MariaDB - getting error 7303 Created: 2018-04-20  Updated: 2020-09-05  Resolved: 2018-05-31

Status: Closed
Project: MariaDB Server
Component/s: Configuration
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Willie Calove Assignee: Lawrin Novitsky
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Linked server from SQL Server to Mariadb.

Issue Links:
Blocks
is blocked by MDEV-23249 __builtin_readcyclecounter in include... Closed

 Description   

I installed MySQL 5.1 odbc 64-bit, 32-bit, mariadb driver to no avail, keep getting the same error.
Cannot initialize the data source object of OLE DB provider 'MSDASQL" for linked server MARIADBLINKED
OLDE DB Provider "MSDASQL" for linked server "MARIADBLINKED" returned message
"Microsoft" [ODBC Driver Manager] Data source name not found and no default driver specified".
(Microsoft SQL Server, Error: 7303)
I googled all the resolution and tried but still getting the same error.

ODBC MariaDB connection was successful.

 Comments   
Comment by Lawrin Novitsky [ 2018-05-31 ]

Could you please elaborate on the problem and why do you think it is a bug in mariadb server?

According to the error text, the DSN you are trying to use does not exist(in your architecture). So neither ODBC connector hadn't got into the play, nor MariaDB server. And this looks like link to MariaDB server is mis-configured. MariaDB server has nothing to do with that.

JIRA is a bugtracker, it is not a place to seek help, please use public forums instead. You might also want to consider acquiring a support contract.

I am closing the ticket so far. If you still think this is a bug with MariaDB server - feel free to re-open it, but please provide more data proving your point.
p.s. You can download MariaDB ODBC connector from http://mariadb.com - they are available.

Generated at Thu Feb 08 08:25:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.