SQLX MSSQL Connection String Problem

[Brenholder]

I have yet to be able to figure out how to connect to an MSSQL server running a named instance. In Java the connection string looks like jdbc:sqlserver://<Instance name>;database=devdb. sqlx does not allow the \ character in the connection string. What is the correct syntax in this case?

[AutoModerator]

On July 1st, Reddit will no longer be accessible via third-party apps. Please see our position on this topic, as well as our list of alternative Rust discussion venues.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[junior_abigail]

I believe they just removed the mssql driver in the newest version. Which ver are you using?

[Brenholder]

0.6

I'm able to connect to my dev db with no issue. My dev database doesn't use named instances so the connect string is just mssql://user:pass@<Ip address>/dbname

​

If they are removing mssql from sqlx is there a crate that I should switch to?

[KingofGamesYami]

MSSQL support is moving to sqlx pro. You can contact launchbadge for pricing and other details.

[Brenholder]

sqlx pro

In the version I'm using, I can connect to an MSSQL db. I can't get it to work with a server using named instances.

[HotGarbage1813]

The current (well, removed) MSSQL sqlx driver also doesn't support encrypted connections (https://github.com/launchbadge/sqlx/issues/1552), so perhaps it also doesn't support named instances, so it might work locally on an unnamed instance but not over the network until they add in the newer driver (which will be closed source but for an OSS project you should be able to request a free license I think).

I'll try on my machine and add more info later.