question

Upvotes
Accepted
5 4 2 6

Hi all, I am trying to connect python by pyodbc to sql data base, but I am getting this error: InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

pythondatadatastream-apidsws-apierrorsql
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@GABRIEL.ESQUIVEL, I'm accepting this answer, to remove this thread from being monitored by moderators. If you still need any help from this forum, please start a new thread.

Upvotes
Accepted
39.4k 77 11 27

@GABRIEL.ESQUIVEL
This forum is dedicated to software developers utilizing Refinitiv APIs. It's not a place where you can ask generic programming questions or get help with 3rd party products.
For Help with Microsoft products, please use appropriate Microsoft resources.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
39.4k 77 11 27

@GABRIEL.ESQUIVEL
Which SQL database are you trying to connect to? It doesn't look like you're utilizing any Refinitiv products or APIs in this instance. If I'm wrong and you are indeed using some Refinitiv product or API, then could you specify which product or API you're using? The code sample including the call that returns the error you reported would be very useful as well.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
5 4 2 6

SSMS data base. Nop I am not utilizing any refinitiv product.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.