The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

SQL Server Database Connection

KellyMKellyM Member Posts: 21 Maven
edited November 2018 in Help

Hello,

 

I'm having trouble connecting to a Microsoft SQL Server (JTDS) database using RapidMiner Studio 7.6.  It connects to the master database but we are trying to connect to a specific database within. I have included the database name in the "Database scheme" box but it still won't work even though it says connection is good. Is there a specific format or setting that I am missing? 

 

 

Thank you for any help! 

 

Kelly

Tagged:

Answers

  • kaymankayman Member Posts: 662 Unicorn

     

    Did you try to set it as below ?

     

    myserver;instance=mydatabase

  • KellyMKellyM Member Posts: 21 Maven

    Hi kayman,

     

    Yes, I did. The connection seems to be set up just fine since I can pull from the master database.  But I'm trying to connect to a database within the master database and that's where it seems to fail.

     

    Here is a screenshot of my connection details (hiding the specific server and database names). It seems that no matter what I put in the Database scheme box, the connection won't go any farther than the master database. 

     

    RM_ODBC.png

     

  • kaymankayman Member Posts: 662 Unicorn

    I can only state how it works for my SQL settings, but I did it as follows :

     

    the host field only contains my server IP (or server name), nothing else

    the database scheme is databasename;instance=instance

     

    But, i only need to use the instance for dbases where it is defined, for most of my connections it is enough to use only the database name as schema entry (so excluding the instance part), which works both using JTDS and Microsoft server.

     

  • KellyMKellyM Member Posts: 21 Maven

    Thank you for the reply.

     

    The database I'm trying to connect to isn't housed on my machine so using the server name or IP address won't work in this case. I appreciate the help though!

Sign In or Register to comment.