iHunter1895
*.Open() works with Windows Auth, but not SQL Auth. Credentials correct.
About EntityFramework. I've read I should learn ADO.NET before using something like that. Do you have any thoughts on that? How do I know I've "learned ADO.NET?" (I am bad at attaching names to things and find I learn to do/use stuff without learning what the stuff actually is)
17 replies
*.Open() works with Windows Auth, but not SQL Auth. Credentials correct.
Thank you for going deeper into it. I believe I have an understanding of those four points now.
I want joe bloe to use it. Kinda like how a game has a save file locally, but I'm just practicing it with SQL at the moment. I'm very green at this.
I thought the credentials were needed for what I'm trying to do. 😅 I don't remember the example now, but at some point I got a login error for Windows Auth despite having admin privileges. I'm sure I just wrote the code wrong for that.
So in my case, try SQLite. Is this the correct page? https://www.sqlite.org/index.html
17 replies
*.Open() works with Windows Auth, but not SQL Auth. Credentials correct.
Hi vice. Im not sure I undestand. I read through it, and was able to get the pipeline and connect to it in SSMS, but how does that translate into my solution? Unless I'm misunderstanding, the post appears to be doing what you say I can't do. I also don't understand how to use the pipeline.
My intention is for "example guy" to be able to download this file and use it immediately without having to download SQL on their end. Why? To practice saving/loading object data in the db.
Could you expand on this a little bit?
17 replies
*.Open() works with Windows Auth, but not SQL Auth. Credentials correct.
I successfully log in when using the uncommented connString var, but not when using the commented connString var. Why? (Error below the code)
Intention: Keep DB local to the application so it is portable to any machine.
I swear my credentials are correct. In SSMS, I use this:
CREATE LOGIN [REDACTED-But Im using what's here for User ID] WITH PASSWORD = '[REDACTED]';
CREATE USER LocalDBUser FOR LOGIN [THE LOGIN];
What am I doing wrong? And yes, I am new, and learning. Thank you in advance for your help.
17 replies