louderthanu
Programmer
I'm a .NET/MSSQL guy and can connect and push/pull data with my eyes closed.... until asked to do the same with FileMaker Pro using .NET!
I'll have to admit, I'm totally lost. I want to connect to a FileMaker Pro 10 Server database using a front-end written in .Net.
Here's the setup as the client has explained it to me:
There are two servers involved:
Server A:
Windows Server 2008 running FileMaker Pro 10 Advanced Server that hosts several databases that contain the data I need.
Server B:
Windows Server 2003 running as a webserver (IIS 6). It has the FileMaker Pro 10 Advanced IWP, PHP and Remote Adminstration components installed. This is the box that will serve the .Net application I am building.
On server A I have confirmed that the databases exist and can be opened using the FileMaker Pro client locally. I can also open them on the server itself.
On server B I have confirmed that the FileMaker Pro Management Interface and IWP are functioning. Though not being used for this project, I have also confirmed that the PHP components were correctly installed and IIS will serve PHP requests.
From the FM management interface, I have confirmed that ODBC is turned on. Additionally IWP and Remote Administration are also turned on.
Server B properly serves vanilla ASPX, PHP and HTML pages
I would perfer to connect DSN-less for portablility. The databases won't move, the web portion of FM won't but the ASPX application WILL be moving to another server.
My questions are:
1. Is the FileMaker ODBC driver on server A (database) or B (webserver/FM web components)? What is it's name?
2. When I make an ODBC connection, am I connecting to server A (database) or B (webserver/FM web components) with my connection object?
3. What is the connection string for a DSN-less connection to a remote FileMaker Pro 10 database? I have tried the ones I found online, but using the driver named "FileMaker Pro" and the ip address of the Server A (database) fails because "No FileMaker Pro driver is installed". Pointing the address to the webserver has the same results.
4. In the connection strings I've found online, there are no "dataLocation", "userName" or "password" parameters. What is the syntax to pass these values?
*This is the example I've found most online:
5. If I'm not using IWP does it need to be on? If it is- (in the case of another database using it) is it interferring from the ODBC connection?
I think I'm most confused about how the "database server" and "web publishing" FileMaker components interact with interact a front end not served by IWP.
Thank you for your time and most of all for your assistance!
Sincerely,
Kevin Howell
Briefcase of Talent
Austin, Texas
I'll have to admit, I'm totally lost. I want to connect to a FileMaker Pro 10 Server database using a front-end written in .Net.
Here's the setup as the client has explained it to me:
There are two servers involved:
Server A:
Windows Server 2008 running FileMaker Pro 10 Advanced Server that hosts several databases that contain the data I need.
Server B:
Windows Server 2003 running as a webserver (IIS 6). It has the FileMaker Pro 10 Advanced IWP, PHP and Remote Adminstration components installed. This is the box that will serve the .Net application I am building.
On server A I have confirmed that the databases exist and can be opened using the FileMaker Pro client locally. I can also open them on the server itself.
On server B I have confirmed that the FileMaker Pro Management Interface and IWP are functioning. Though not being used for this project, I have also confirmed that the PHP components were correctly installed and IIS will serve PHP requests.
From the FM management interface, I have confirmed that ODBC is turned on. Additionally IWP and Remote Administration are also turned on.
Server B properly serves vanilla ASPX, PHP and HTML pages
I would perfer to connect DSN-less for portablility. The databases won't move, the web portion of FM won't but the ASPX application WILL be moving to another server.
My questions are:
1. Is the FileMaker ODBC driver on server A (database) or B (webserver/FM web components)? What is it's name?
2. When I make an ODBC connection, am I connecting to server A (database) or B (webserver/FM web components) with my connection object?
3. What is the connection string for a DSN-less connection to a remote FileMaker Pro 10 database? I have tried the ones I found online, but using the driver named "FileMaker Pro" and the ip address of the Server A (database) fails because "No FileMaker Pro driver is installed". Pointing the address to the webserver has the same results.
4. In the connection strings I've found online, there are no "dataLocation", "userName" or "password" parameters. What is the syntax to pass these values?
*This is the example I've found most online:
Code:
Driver=FileMaker Pro;AllAsText=0;ApplicationUsingThreads=1;FetchChunkSize=100;FileOpenCache=0; IntlSort=0;MaxTextlength=255;ServerAddress=127.0.0.1; TranslationOption=0;UseRemoteConnection=1;5. If I'm not using IWP does it need to be on? If it is- (in the case of another database using it) is it interferring from the ODBC connection?
I think I'm most confused about how the "database server" and "web publishing" FileMaker components interact with interact a front end not served by IWP.
Thank you for your time and most of all for your assistance!
Sincerely,
Kevin Howell
Briefcase of Talent
Austin, Texas