September 22nd, 2004, 02:35 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Firebird and Pocket PC
I am currently attempting to make an application for the Pocket PC that will perform queries on a remote database. However, all the solutions I have found involve SQL Server 2000, RDA, SQL Server CE. While this is all good and nice, the server I need to connect to is a Firebird server. To make things worse, the access is going to occur via a dial-up connection. Thus far I've been able to dial into the server, but I am stuck on how to communicate with the server. RDA seems too strongly linked to SQL Server and ADOCE seems to need a data provider, which I can't find for Firebird. If anyone knows how to accomplish this, please let me know. I am very interested and very stuck. I looked into the Firebird .NET Provider on the firebird homepage, however, it is not currently compatible with the .NET Compact Framework, so that was no longer an option. I was looking at something else as well. Embedded Visual C++ 4.0 comes with a C++ RDA example, which I have gotten to compile and run on my PPC successfully. In my Administrative Tools ODBC Setup, I have a System DNS that uses the latest ODBC Firebird drivers, that links to the database I want (however, I am unable to specify a client as the ssscea20.dll). I created a Microsoft DataLink file that links to that ODBC entry. The test connection on the link works. I open the link in Notepad to see the connection string the link uses. I take the information found in that link (note: the RDA program uses sqlceodb as it's provider, while the link specifies that MSDASQL.1 is the provider needed), and place in the conncetion string of the program. I get an error message about version problems. There is also a second error, but it unreadable as it out of the screens bounds. My theory is still that IIS must be able to link to the firebird database and allow sql messages to be sent to it via RDA methods
Thank you for help, if I need to clarify anything, let me know. Thanks
Ronald Hidalgo
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
