Any help you can provide will be greatly appreciated.
I am attempting to get my database connection/login working.
I am using SQL 2K5 with VB
Currently, I'm doing all the development on my local machine, while waiting for the main Windows 2K3 server to be built, so I can put the SQL server there. So, things will change in a week or so, but I need to get it working locally first.
I will be using mixed mode authentication.
what I am having problems figuring out is how to parse My.User so that I only pick up the information after the '\' (the user name) - I don't want the domain name (or machine name)! (For the moment, all the user accounts on the server have the same password - not good, but the current "system/network" administrator does things easy, not necessarily secure, so I am following suit.)
At some point, I hope to use integrated authentication after the domain is totally set up, but that is in the future.
Can any one help point me in the right direction?