Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MS SQL Server connection string #39

Open
SilverZippo opened this issue Jun 16, 2024 · 1 comment
Open

MS SQL Server connection string #39

SilverZippo opened this issue Jun 16, 2024 · 1 comment

Comments

@SilverZippo
Copy link

SilverZippo commented Jun 16, 2024

From the comments you added support for MSSQL in 2019 and init does indeed recognise connection strings such as:

sqlsrv://user:pass@server/db

However whenever I try and spin up the container, I get the following error:

In SQLSrvException.php line 57:
SQLSTATE [IMSSP, -8]: An invalid connection option key type was received. Option key types must be strings.

I have tried various combinations of connection string such as:
sqlsrv://user:pass@server\db
sqlsrv://user:pass@server\\db
sqlsrv://user:pass@server:port/db
sqlsrv://user:{pass}@server/db

and also variations of

sqlsrv://server/db;username=user;password=pass;

But I keep getting the same error.

Please can you add an example for sql server to the README.md ?

@SilverZippo
Copy link
Author

As pointed out by @AdvanceGeneric in another issue (if only I had read it 2 days ago), the format mssql://user:pass@server:port/db does allow a connection, but it also comes up with "Unknown database type timestamp requested, Doctrine\DBAL\Platforms\SQLServer2012Platform may not support it." so I am not much further forward.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant