Advertisement

05.16.2008 at 05:07PM PDT, ID: 23410037
[x]
Attachment Details

Connection string for FileMaker Server using Windows Integrated Security?

Asked by jameso99 in FileMaker Pro Database, C# Programming Language, Microsoft Visual C#.Net

Tags: C#, FileMaker Server 9

I'm connecting to a FileMaker Server 9 database using a C# application so I can perform SQL actions on it but I want to integrate the domain account I'm using since I can have FileMaker recognize Active Directory objects.

I can successfully connect using a FileMaker account I've set up on the database but I want to take it further and connect using Integrated Security, like you can in SQL Server.

Is this possible to do with FileMaker Server (or Pro) 9?  I get ODBC errors that there's no password passed.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

string myDriver = "DSN=FMServer_Sample;Uid=Admin;Pwd=";
 
/*
 * SQl way to do this:
 * myDriver = "DSN=FMServer_Sample;Integrated Security=True;";
 * or
 * myDriver = "DSN=FMServer_Sample;Trusted_Connection=yes;";
*/
 
OdbcConnection conn = new OdbcConnection(@myDriver);
conn.Open();
OdbcDataAdapter da = new OdbcDataAdapter("select * table bla bla bla", conn);
OdbcCommandBuilder cmdBldr = new OdbcCommandBuilder(da);
[+][-]05.16.2008 at 09:38PM PDT, ID: 21588010

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 09:45PM PDT, ID: 21588024

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 10:42AM PDT, ID: 21599913

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 11:33AM PDT, ID: 21600301

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: FileMaker Pro Database, C# Programming Language, Microsoft Visual C#.Net
Tags: C#, FileMaker Server 9
Sign Up Now!
Solution Provided By: jameso99
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.19.2008 at 02:25PM PDT, ID: 21601762

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628