Menu
▾
▴
firebird-net-provider
|
From: Jim M. <jim...@co...> - 2003-08-27 21:12:39
|
Using Visual Studio C#, .net 1.0, Firebird 1.03, firebird net provider =
1.0.1241.28320.
I'm trying to copy an application over to a new machine (New). I have =
it working on my development machine (Dev). I installed .Net, Visual =
Studio, Firebird, net provider. I can access the database on the New =
machine from the Dev machine using net-provider by pointing my =
connection string to it. The same connection string fails on the New =
machine (I have tried LOCALHOST instead of the 192.168.1.3!
On the New machine I can access the db using IB_SQL or IBExpert.
However, when I run the app from the New machine with Visual Studio, I =
get the "invalid PInvoke metadata format" exception on the connect. =
Here is my connection code:
FbConnection dbcon =3D new =
FbConnection("Database=3DC:\\cpt\\cpt.gdb;User=3DSYSDBA;Password=3Dmaster=
key;Dialect=3D3;Server=3D192.168.1.3");
dbcon.Open(); //exception thrown here
The new machine runs Win XP professional, same as my development =
machine. I am at a loss as to what to look for next. Tried everthing I =
can think of, but it must be some configuration problem. I made sure =
that the ASP.NET User account has proper rights.
Thanks for your help! I've had very few problems with your net provider =
until now.
|
|
From: Carlos G. A. <car...@te...> - 2003-08-27 21:38:55
|
Hello: > firebird net provider 1.0.1241.28320. Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused for a bad installation of the .NET or for use the provider build for a version of the .net framework with a different version. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Jim M. <jim...@co...> - 2003-08-27 21:45:56
|
The Visual Studio about box says 1.0. How do you check? I think you may be
right because I got the same result with the example code:
private void cmdConnect_Click(object sender, System.EventArgs e)
{
string myConnectionString;
FbConnection myConnection;
FbTransaction myTransaction;
string commandText;
myConnectionString =
"User=SYSDBA;" +
"Password=masterkey;" +
"Database=C:\\Program Files\\Firebird\\examples\\employee.gdb;" +
"DataSource=localhost;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=ISO8859_1;" +
"Role=;" +
"Connection lifetime=30;" +
"Pooling=true;" +
"Packet Size=8192";
myConnection = new FbConnection(myConnectionString);
myConnection.Open();
myTransaction = myConnection.BeginTransaction();
lblStatus.Text = "Connection succeful";
myConnection.Close();
}
"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F4...@te......
> Hello:
>
> > firebird net provider 1.0.1241.28320.
>
> Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused for a bad
> installation of the .NET or for use the provider build for a version of
> the .net framework with a different version.
>
>
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Carlos G. A. <car...@te...> - 2003-08-27 21:49:18
|
Hello: > The Visual Studio about box says 1.0. How do you check? I think you may be > right because I got the same result with the example code: Well i don't know a way for see with what version of the .net framework was built an assembly, but you an try to install the .net data provider 1.0 for ms .net 1.0 :) : http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-NF1.0.exe?download -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Jim M. <jim...@co...> - 2003-08-27 21:52:29
|
It looks like 1.0 and 1.1 are installed. I will uninstall 1.1 and reinstall 1.0? Does that sound right. Thanks very much Carlos! "Carlos Guzman Alvarez" <car...@te...> wrote in message news:3F4...@te...... > Hello: > > > firebird net provider 1.0.1241.28320. > > Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused for a bad > installation of the .NET or for use the provider build for a version of > the .net framework with a different version. > > > > > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jim M. <jim...@co...> - 2003-08-27 21:55:37
|
Went to Add or Remove Programs and sure enough, 1.1 got installed somehow. Maybe it was already there as XP came installed. Removing it now and will retest. Thanks again! "Carlos Guzman Alvarez" <car...@te...> wrote in message news:3F4...@te...... > Hello: > > > firebird net provider 1.0.1241.28320. > > Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused for a bad > installation of the .NET or for use the provider build for a version of > the .net framework with a different version. > > > > > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jim M. <jim...@co...> - 2003-08-28 02:31:56
|
Carlos, I looked at my working Dev machine, and the References to System use 1.0.3300.0, BUT in IIS the Mappings for the .asax file is pointing to Framework\v1.1.4322\aspnet_isapi.dll. Because I'm using Visual Studio 1.0, and it only works with Net 1.0, I don't see why it works. I thought I would have to change the mapping of .aspx to Framework\v1.0.xxxx\aspnet_isapi.dll. Can you shed any light on this? ""Jim Maguire"" <jim...@co...> wrote in message news:bij937$j8n$1...@ne...... > Went to Add or Remove Programs and sure enough, 1.1 got installed somehow. > Maybe it was already there as XP came installed. Removing it now and will > retest. Thanks again! > > "Carlos Guzman Alvarez" <car...@te...> wrote in message > news:3F4...@te...... > > Hello: > > > > > firebird net provider 1.0.1241.28320. > > > > Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused for a bad > > installation of the .NET or for use the provider build for a version of > > the .net framework with a different version. > > > > > > > > > > > > > > > > -- > > Best regards > > > > Carlos Guzmán Álvarez > > Vigo-Spain > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: stevyn d. <sr...@ya...> - 2003-08-28 04:39:14
|
Hello Jim: If you are using Visual Studio 2002, it (VS) is rev-locked to Framework 1.0. However if you install Framework 1.1, the installation will upgrade any applications in IIS to run with Framework 1.1 . Then when you use the web application, the application will recompile automatically under 1.1. I have the exact same situation because I am still doing web app development in Visual Studio (2002) and having my applications run in FrameWork 1.1. Works just fine -- this is the great side-by-side feature of assemblies and forward version compatibility). Had to do this because COM Interop in Framework 1.0 is buggy. Most applications should upgrade to 1.1 without problems, however if you must run under 1.0 because of version dependencies then change the IIS mappings(.aspx,etc) for your application back to 1.0 framework. some helpful links for you: http://msdn.microsoft.com/netframework/technologyinfo/versioncomparison/default.aspx http://msdn.microsoft.com/library/en-us/dnnetdep/html/sidexsidenet.asp?frame=true regards, stevyn r dembo Jim Maguire <jim...@co...> wrote: Carlos, I looked at my working Dev machine, and the References to System use 1.0.3300.0, BUT in IIS the Mappings for the .asax file is pointing to Framework\v1.1.4322\aspnet_isapi.dll. Because I'm using Visual Studio 1.0, and it only works with Net 1.0, I don't see why it works. I thought I would have to change the mapping of .aspx to Framework\v1.0.xxxx\aspnet_isapi.dll. Can you shed any light on this? ""Jim Maguire"" wrote in message news:bij937$j8n$1...@ne...... > Went to Add or Remove Programs and sure enough, 1.1 got installed somehow. > Maybe it was already there as XP came installed. Removing it now and will > retest. Thanks again! > > "Carlos Guzman Alvarez" wrote in message > news:3F4...@te...... > > Hello: > > > > > firebird net provider 1.0.1241.28320. > > > > Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused for a bad > > installation of the .NET or for use the provider build for a version of > > the .net framework with a different version. > > > > > > > > > > > > > > > > -- > > Best regards > > > > Carlos Guzmán Álvarez > > Vigo-Spain > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software |
|
From: Jim M. <jim...@co...> - 2003-08-30 00:19:43
|
Thanks for your reply. I looked at the links, had googled them before I = think. I have the problem fixed, but not sure exactly why. I had = uninstalled .NET 1.1, but that caused problems where my app could not = find System and other derived classes. It looked like a config file = problem, so rather than wade thru that I reinstalled 1.1. My app then = worked!. I'm still not sure exactly what went wrong, but I do = understand that there was a conflict with the firebird provider and 1.1. = I guess I need to get a better understanding of how all the = machine.config and others work! "stevyn dembo" <sr...@ya...> wrote in message = news:200...@we...... Hello Jim: If you are using Visual Studio 2002, it (VS) is rev-locked to = Framework 1.0. However if you install Framework 1.1, the installation will upgrade any applications = in IIS to run with Framework 1.1 . Then when you use the web application, the application will recompile = automatically under 1.1. I have the exact same situation because I am still doing web app = development in Visual Studio (2002) and having my applications run in = FrameWork 1.1. Works just fine -- this is the great side-by-side = feature of assemblies and forward version compatibility). Had to do = this because COM Interop in Framework 1.0 is buggy. Most applications should = upgrade to 1.1 without problems, however if you must run under 1.0 = because of version dependencies then change the IIS mappings(.aspx,etc) = for your application back to 1.0 framework. some helpful links for you: = http://msdn.microsoft.com/netframework/technologyinfo/versioncomparison/d= efault.aspx = http://msdn.microsoft.com/library/en-us/dnnetdep/html/sidexsidenet.asp?fr= ame=3Dtrue regards, stevyn r dembo Jim Maguire <jim...@co...> wrote: Carlos, I looked at my working Dev machine, and the References to System use 1.0.3300.0, BUT in IIS the Mappings for the .asax file is pointing = to Framework\v1.1.4322\aspnet_isapi.dll. Because I'm using Visual = Studio 1.0, and it only works with Net 1.0, I don't see why it works. I thought I would have to change the mapping of .aspx to Framework\v1.0.xxxx\aspnet_isapi.dll. Can you shed any light on this? ""Jim Maguire"" wrote in message news:bij937$j8n$1...@ne...... > Went to Add or Remove Programs and sure enough, 1.1 got installed = somehow. > Maybe it was already there as XP came installed. Removing it now = and will > retest. Thanks again! > > "Carlos Guzman Alvarez" wrote in message > news:3F4...@te...... > > Hello: > > > > > firebird net provider 1.0.1241.28320. > > > > Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused = for a bad > > installation of the .NET or for use the provider build for a = version of > > the .net framework with a different version. > > > > > > > > > > > > > > > > --=20 > > Best regards > > > > Carlos Guzm=E1n =C1lvarez > > Vigo-Spain > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________ ________ > > Firebird-net-provider mailing list > > Fir...@li... > > = https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Firebird-net-provider mailing list Fireb ird...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider This message is intended only for the use of the individual or entity = to which it is addressed, and may contain information that is = privileged, confidential and exempt from disclosure under applicable = law. If the reader of this message is not the intended you are hereby = notified that any dissemination, distribution or copying of this=20 communication is strictly prohibited. -------------------------------------------------------------------------= ----- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X