From: Michael S. <mic...@on...> - 2004-09-30 09:16:01
|
Hi, i have read an article in this newsgroup about a problem in executing an SQL-Query. I have exactly the same problem, but unfortunately there was no solution posted. So i will make a new attempt. Im using VC# with .NET Vers. 1.1 and try to execute an SQL-Query via the .NET-Provider for Firebird 1.6.2. The Database resides on a remote Windows PC and is connected via NetBEUI. I'm able to succesfully test the connection, but i cannot execute any kind of SQL-Command. I always get the same Error Code: "Dynamic SQL Error; SQL Error Code = -901; Feature is not supported." In Fact i get this error message if i use ANYTHING as the Commandstring, even if it doesn't resemble SQL at all. Some Further Information: It is possible to execute the queries using the odbc-Provider on the same Database. I also noticed the following: when i use the CommandTextEditor which is integrated in PropertiesPage of an FbCommand-Object, the same error message returns, but the whitespaces in the error message are not correctly interpreted. Charset? Here's some code which doesn't execute: //Created a Connection 'Verbindung' Verbindung.Open(); string sqlCom = "Select * from RECHNER"; FbCommand Kommando = new FbCommand(sqlCom, Verbindung); //The following Statement raises Error -901 FbDataReader Reader = Kommando.ExecuteReader(); //Using the Reader It's certainly all the same if i use a dataAdapter instead. I'm quite new to DB-Programing, so it might be something very dumb, nevertheless i would be glad if s.o. could help with that. Thanks in Advance Michael |