search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 63 forks source link

Error: Genereates EF-Model from Database with VS2008 don't work [DNET245] #253

Closed firebird-automations closed 14 years ago

firebird-automations commented 15 years ago

Submitted by: MaikPabel (killavirus)

If I add a new http://ADO.Net Entity Data Model (edmx) to my project with Visual Studio 2008 and generates the model from a database I get allway this Error:

"An error occurred while connecting to the database. The database might be unavaiable. An exception of type 'System.Data.EntityCommandExecutionException' occurered. the error message is: An error occurred while preparing the command definition. See the inner exception for details. The inner exception caught was of type 'FirebirdSql.Data.FirebirdClient.FbEception', withe this error message: 'Dynamic SQL Error SQL error code = -104 Tokenunknown - line 6, column 8 SELECT'."

firebird-automations commented 15 years ago
Modified by: MaikPabel (killavirus) security: Developers \[ 10012 \] =\>
firebird-automations commented 15 years ago

Commented by: @cincuranet

You have to use 2.5 server for model generation.

firebird-automations commented 15 years ago
Modified by: @cincuranet status: Open \[ 1 \] =\> Closed \[ 6 \] resolution: Won't Fix \[ 2 \]
firebird-automations commented 14 years ago

Commented by: @cincuranet

Reopen to mark it as duplicate.

firebird-automations commented 14 years ago
Modified by: @cincuranet status: Closed \[ 6 \] =\> Reopened \[ 4 \] resolution: Won't Fix \[ 2 \] =\>
firebird-automations commented 14 years ago

Commented by: @cincuranet

Duplicates DNET203.

firebird-automations commented 14 years ago
Modified by: @cincuranet status: Reopened \[ 4 \] =\> Closed \[ 6 \] resolution: Duplicate \[ 3 \]
firebird-automations commented 14 years ago

Commented by: @cincuranet

Ups. Wrong issue.

firebird-automations commented 14 years ago
Modified by: @cincuranet status: Closed \[ 6 \] =\> Reopened \[ 4 \] resolution: Duplicate \[ 3 \] =\>
firebird-automations commented 14 years ago
Modified by: @cincuranet status: Reopened \[ 4 \] =\> Closed \[ 6 \] resolution: Won't Fix \[ 2 \]
firebird-automations commented 14 years ago

Commented by: Richard Clarke (conhulio2000)

Hi,

I have a similar problem, but im using Interbase 7.1. i changed the client so it can work ok with Interbase 7.1, the firebird client is working perfectly, but when i use the DDEX, it simply fails????

"An Error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.ProviderIncompatibleException' occurred. The error message is: 'The provider did not return a ProviderManifestToken string.

The inner exception caught was of type 'System.FormatException' with this message : 'Input was not in correct format.' I have no idea what this means. All I know is that in FirebirdSql.Data.FirebirdClient.DLL, I changed the GetServerVersion to return "7.1.0.0", instead of calling the necessary Firebird call in the GdDatabase v10 code block.

The Dialect is 1 for Interbase. Im using the http://Firebird.net client assembly fine otherwise, so im confused why the DDEX is now reporting a problem, very strange.

firebird-automations commented 14 years ago

Commented by: @cincuranet

This a Firebird project. Not InterBase. These two products are more and more different.