Hey, its me again, same problem, but with more (strange) information...
What I am doing, in a ASP.NET application:

create new dataset
drag a tableadapter
select my connectionstring
Advance with default values

When it asks me to enter a SQL statement, I insert into query builder a simple SQL:

SELECT      TASKID, NAME, COMPLETE
FROM          TASKS
WHERE [EMAIL PROTECTED]


If I click on "Execute Query", it works ok, showing the data on my database.

When I click "FINISH", it shows:

[WARNING] Generated SELECT statement.
    Failed to find or load the registered .Net Framework Data Provider.


That behaviour happen in ASP.Net or a winform application. I tried to see with regmon (http://www.microsoft.com/technet/sysinternals/utilities/Regmon.mspx)
(an amazing free app that shows what registry entries are being read) what VS2005 are looking for when I click FINISH (right before the error) and what caught my attention was this 3 lines:

devenv.exe:2548    OpenKey    HKLM\SOFTWARE\Microsoft\Fusion\PublisherPolicy\Default\policy.9.0.IBM.Data.DB2__7c307b91aa13d208    NOT FOUND       
devenv.exe:2548    OpenKey    HKLM\SOFTWARE\Microsoft\Fusion\PublisherPolicy\Default\policy.9.0.IBM.Data.DB2__7c307b91aa13d208    NOT FOUND       
devenv.exe:2548    OpenKey    HKLM\SOFTWARE\Microsoft\Fusion\PublisherPolicy\Default\policy.9.0.IBM.Data.DB2__7c307b91aa13d208    NOT FOUND  
     

I then opened Filemon (http://www.microsoft.com/technet/sysinternals/utilities/filemon.mspx) (same as regmon, but for files being acessed) and more surprising things:

QUERY INFORMATION    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\Arquivos de programas\Microsoft.NET\ADOMD.NET\90\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\Arquivos de programas\ComponentOne Studio.NET\bin\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\Arquivos de programas\ComponentOne Studio.NET\bin\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\Arquivos de programas\CastleProject\Bin\net-1.1\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\Arquivos de programas\thinktecture\WSCF 0.6\Shared\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\WINDOWS\Microsoft.NET\DirectX for Managed Code\1.0.2911.0\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   
QUERY INFORMATION    C:\Arquivos de programas\FirebirdClient\IBM.Data.DB2.dll    NOT FOUND    Attributes: Error   


... (the list goes on for every path VS looks for assemblies, always looking for IBM.Data.DB2.dll).

Any ideas? I even try to rename "FirebirdSQL.Data.FirebirdClient" to "IBM.Data.DB2" (stupid, I know), but doesn't work.

In c:\windows\assembly\ it shows FirebirdSql.Data.FirebirdClient 2.1.0.0
And I can connect in VS2005 to it OK, my only problem is working with datasets... I need your help, have to start a ASP.NET application ASAP if I can't make firebird work, will have to use another database or choose other technology (like PHP)...
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to