New topic: Trusted connections to SQL Server via ADSI
<http://forums.realsoftware.com/viewtopic.php?t=47344> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message FrankEinstein Post subject: Trusted connections to SQL Server via ADSIPosted: Wed Mar 20, 2013 7:45 am Joined: Fri Dec 22, 2006 7:24 pm Posts: 7 How do I go about setting up a trusted connection to a remote SQL Server database authenticated via ADSI? There is no username and password, it's your ADSI authentication that determines whether you get in or not. I did this when evaluating Real BASIC about five years ago using SQL Server authentication, but that's no longer an option. It's Windows Authentication or bust, now. I tried passing my uid and pwd in the connection string as a test, but that doesn't work, either. Is this doable? 'This fails at the cnDatabase.Open statement. Dim cnDatabase As New OLEObject("ADODB.Connection") Dim rsTable As New OLEObject("ADODB.Recordset") cnDatabase.Open "Provider=SQLOLEDB; Persist Security Info=True;Trusted_Connection=True;Data Source=ServerIPAddress;Initial Catalog=TestDB;" rsTable.Open "SELECT LastName FROM People WHERE UID = 17113351", cnDatabase While Not rsTable.EOF MsgBox rsTable.Fields("LastName").Value rsTable.MoveNext Wend rsTable.Close cnDatabase.Close Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
