Jump to content

Access vs FileMaker


This topic is 6831 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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) smile.gif" border="0

Christy

Link to comment
Share on other sites

  • 4 years later...

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

  • Newbies

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.