Visual Basic 6 - FileMaker Pro 6 1

[noviceprg]

Hi,
I am new to File Maker.I downloaded the FileMaker Pro 6 trial version from the FileMaker website.I would like to connect to File Maker database from a VB interface, using ODBC.During the ODBC connection setup,at the time of creating the DSN for the FM Database, there seems to be no provision to specify the FM database that the DSN is to be associated with.Any help with this is greatly appreciated.

Thanks in advance

 

[lebisol]

http://www.fmcdn.com/downloadForm.cfm

all the best!

> need more info?
:: don't click HERE ::

 

[noviceprg]

Thanks lebisol for the link.I shall look into and get back if i have some problems.

Thanks in advance

 

[lebisol]

just a side note:
built in ODBC in FM ir reeeeeealy *bliiip* "not so good" especially for the web stuff. I have heard that people like fmconnector...I have not tested it though.
anyhow, give it a try and see how it goes...I know that the developer(s) will get back to you on ztevekowsky@hotmail.com
Good Luck!

> need more info?
:: don't click HERE ::

 

[noviceprg]

Hi,
I did go through the website suggested by lebisol and had a look at the component.However, if there is another way to connect to the FileMaker DB , I really would prefer that.

Let me explain my problem.I have a VB application which currently connects to the appropriate backend Database (ORACLE/SQL/Access),using ODBC, and retieves data .I am using ADODB connection String.The connection string is created at runtime using the selected DSN,Provider, userID and password and connection is made to the required Database.I would just like to incorporate FileMaker support using the existing set up if possible, instead of bringing a new component in for FileMaker exclusively.

I gather that FileMake ODBC support is not good.But I just need simple Database activity.Is there a way to create a DSN and associate it with FileMaker Database while setting up the ODBC?That way, I could just use the DSN and connect to the database from within VB by forming the ADODB connection string.

I did look up a couple of websites and people have claimed to use ODBC connection to the database.I haven't been successful in it however.

I hope I have stated the problem statement clear.Any help would be greatly appreciated.

Thanks

 

[lebisol]

ok in that case (old post):
I have managed to connect to FM6 Pro using ASP(win2000pro) and Dreamwaver.If you are intersted please follow this link:

http://www.macromedia.com/support/dreamweaver/ts/documents/filemakerdw.htm

or if you just need a connection string:
------------------------------------------------
AllAsText=0;ApplicationUsingThreads=1;Driver=FileMaker Pro;FetchChunkSize=100;
FileOpenCache=0;IntlSort=0; MaxTextlength=255;ServerAddress=127.0.0.1;
TranslationOption=0;UseRemoteConnection=1
------------------------------------------------
FM needs remote connection anabled...
all the best!

> need more info?
:: don't click HERE ::