Newbies cpatterson Posted April 9, 2001 Newbies Share Posted April 9, 2001 I have 2 questions. 1. I have a client who asked if it was OK for his database person to develop a database in FileMaker Pro 5 and then have me put it on the web for him. Users would query, add to and update this database. I know Access, but nothing about FileMaker. What are some pros and cons in using FileMaker vs Access? 2. Does anyone know the ODBC connection for FileMaker? I'm getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed for this code: Set conntemp = server.CreateObject("adodb.Connection") conntemp.Open "DRIVER={FileMaker Pro}; DBQ=e:webfpdbtest.fp5" Set RS = conntemp.Execute("SELECT * From test") Thanks for any help you can give (to either question) Christy Link to comment Share on other sites More sharing options...
Anatoli Posted April 11, 2001 Share Posted April 11, 2001 Is the test.fp5 running in FileMaker? To compare Access vs FileMaker, hmm how about VW Beetle with clutch vs latest Mercedes 600 series? Link to comment Share on other sites More sharing options...
Newbies Robarov Posted July 15, 2005 Newbies Share Posted July 15, 2005 What do you mean ? Filemaker is like a Mercedes 600 ? You think its that magnificant ? Link to comment Share on other sites More sharing options...
Lee Smith Posted July 15, 2005 Share Posted July 15, 2005 Hi Robarov, and welcome to the Forum. Anatoli hasn't been active since October of last year, so I wouldn't expect a response from Anatoli. Don't you think that FileMaker is magnificent, why else would you be here in a FileMaker Form? Lee Link to comment Share on other sites More sharing options...
Newbies Robarov Posted July 15, 2005 Newbies Share Posted July 15, 2005 Yes, I think is great for easy simple application. For that is wonderfull. I m trying to connect to a filemaker database in VB6 I can t get it working... can you get me some directions ? myConnString = "DRIVER={FileMaker Pro}; DBQ=C:test.fp5" Dim myConnection As New ADODB.Connection myConnection.ConnectionString = myConnString myConnection.Open MsgBox "ServerVersion: " & myConnection.Version & vbCrLf & "DataSource: " & myConnection.Provider & vbCrLf & "State: " & myConnection.State myConnection.Close I m lost here ... Link to comment Share on other sites More sharing options...
Garry Claridge Posted July 15, 2005 Share Posted July 15, 2005 Check the ODBC Forum. Maybe some hints there. All the best. Garry Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6831 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now