![]() The Knime DB connector doesn’t work if I specify the instance without the port name, e.g. Jdbc:jtds:sqlserver://MY_COOL_SERVER:49732/my_database The Knime DB connector works if I specify the port name, e.g. If I specify server name, instance and port (which is redundant), it does NOT work. The Knime SQL Server Connector requires the port - it doesn’t let you specify the instance without the port if I specify server name and port, it works. If my server name is MY_COOL_SERVER, a typical instance name would be SQLEXPRESS, so the URL in P圜harm would be jdbc:sqlserver://MY_COOL_SERVER\SQLEXPRESS With other software using other JDBC drivers, I can specify the instance name, with no need to specify the port. I had been having issues connecting to a Microsoft SQL Server Express database. I have solved my problem, so this is an FYI for other people. ![]() I took the liberty of creating another thread because I think this title is more representative if the moderators agree, I’d appreciate it if they could merge the old thread Trying to import a CSV into SQL Server - how do I do it? can't get the database to connect in here. I am not sure if the same applies to full versions of SQL Server It would be good to add this in some kind of FAQ and in the official documentation. I present below some information on how to connect to a Microsoft SQL Server Express database unlike most other software relying on JDBC, Knime requires you to input the port number, not the instance name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |