Can't connect to database when the servername has a backslash in it

Question

James McBrearty 2023-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988798-can-t-connect-to-database-when-the-servername-has-a-backslash-in-it

回答： James McBrearty 2023-7-3

I am using JDBC to connect to various databases, and as whole everything is working incredibly smooth - However, there is another database located on a server where the servername is something like "PART1\PARTB", when I use this as the servername, the backslash is used as an escape character, and there is a message given as:

"JDBC Driver Error: The TCP/IP connection to the host PART1, port x has failed etc."

This however works for every other database and server, and works on other applications.

The code I use to connect, which I have changed some of the name is:

conn = database('DB1','','','Vendor','Microsoft SQL Server', ...
'Server','PART1\PART2','AuthType','Windows');

Can anyone help me figure out what the issue is here, and what the workaround/fix for this is?

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

James McBrearty 2023-7-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988798-can-t-connect-to-database-when-the-servername-has-a-backslash-in-it#answer_1266328

在 MATLAB Online 中打开

So after a bit of work, I managed to get connect to this database:

jdbcDriver = 'com.microsoft.sqlserver.jdbc.SQLServerDriver';
serverName = 'Server';
databaseName = 'DBName';
instanceName = 'Instance';
url = ['jdbc:sqlserver://' serverName ';instanceName=' instanceName ';databaseName=' databaseName ';integratedSecurity=true;'];
conn = database(databaseName,'','',jdbcDriver,url);

So, as can be seen, I just made the URL itself, as the JDBC connection does have an instance property in it, however, MATLAB's database function doesn't so you have to manually do it.

It may be good if @MathWorks Support Team could add this functionality to the existing database code.

Thanks,

James

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Jon 2023-6-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988798-can-t-connect-to-database-when-the-servername-has-a-backslash-in-it#answer_1263578

There may be a much cleaner way to deal with this. I'm not sure of the details of why you get this error. Are you on a windows machine? If so you can map your network drive and then just use the mapped drive location without the slashes

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

James McBrearty 2023-6-28

So it is an internal server, but the permissions involved may not allow me to map it as a drive, as it is not a network drive. I have tried this on 2023a, and have had the same issues.

I'm assuming it will be a Java issue, due to backslash being an escape character.

请先登录，再进行评论。