I do not have my laptop with me, but I am sure there is a registry key which show where the path is, but as you know that would only be on the SQL Server. I think there is some sql code that will display the Path of the SQL
I get a lot of scripts from http://www.sqlservercentral.com/Scripts/ Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of soonhuat ong Sent: 22 September 2005 01:53 To: [email protected] Subject: RE: [delphi-en] MsSQL + Delphi Ok .. Now the login part is done. What i do is just change the setting to Mixed mode, then it start to works .. But for the database path, that's part of the requirement. I need to show to the users what's the path of the Database that particular users connect to. Anyone ? Steve <[EMAIL PROTECTED]> wrote: Hi Why do you need the path of the MDF? Are you using Full SQL or the MSDE, if you are using the Full SQL there is a setting to change the mode to Mixed Mode Authentication Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of soonhuat ong Sent: 21 September 2005 08:12 To: [email protected] Subject: [delphi-en] MsSQL + Delphi Hi, I'm too new with MsSQL + Delphi application. And here's several problem i've encounter so far, hope someone can help to sort that out. 1) I can only login and connect to MsSQL using the Window Authentication, but not the Mixed Mode Authentication when provided with correct username and password. 2) As far as i know, we can get the connection string, and the sample of the connection string is like the following: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=DataServer;Initial Catalog=DelphiWeb;uid=sa;pwd=adminpwd; Since i can get the connection string, so is that any possible for me to get the path of database that i currently connect to ? What i mean here is the path of the database that i connec to . For example : C:\Program Files\Database\MyDB.MDF Thanks in advance. --------------------------------- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] SPONSORED LINKS Basic programming language C programming language Computer programming languages The c programming language C programming language List of programming languages --------------------------------- YAHOO! GROUPS LINKS Visit your group "delphi-en" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
