Btukfyl

I want to transfer my ODBC interface from Rapidminer to Python.
In Rapidminer it all works very well, but my implementation in Python can't connect to the server. My question: How do I declare the server exactly? What is the name of my database?

Shortly to my current Rapidminer implementation:

1. Manage Database Drivers



2. 
   

   I declare a Oracle Driver with my ojdbc7.jar-File:
   Name:Oracle_ODBC, URL-prefix: jdbc:oracle:thin:@, Port:1709

   
   
   

   My Implementation in Python: driver= '{ODBC Driver 17 for SQL Server}' -> cnxn = pyodbc.connect('DRIVER='+driver+...

   
   



3. Manage Database Connection: I guess here is the problem.




4. Type in the data (It works for RapidMiner: Question is: How to declare it in Python): Host: myhost.address.net, Port:1709, User: myUser, Password: mypassword




5. Implementation in Python:

import pyodbc



server = 'myhost.address.net' ???



database = '?what is my database here?' 



username = 'myuser' 



password = 'mypassword' 



driver= '{ODBC Driver 17 for SQL Server}'



cnxn =

pyodbc.connect('DRIVER='+driver+';PORT=1709;SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

Now it says that there is no connection to the server in python: I used my host as server. The rest is exactly named like in RapidMiner. (Issue 53)

Question: How can I transform the already working ODBC interface from RapidMiner to Python correctly?

I would be very grateful for help. I've tried everything and I'm desperate right now.