VB.NET with Firebird
I want to connect tot an Firebird Database with visual basic 2005, i′ve followed the following tutorial:http://www.firebirdtutorial.net/firebird-and-visual-studio-net-2005.html
I want to use the data source configuration wizard to add the new datasource, when i choose the Firebird datasource as new datasource the "add connection form" appears, but when I try to fill in the form the form closes itself.
I wan′t to view the firebird tables in the data source window like í′m used to with access databses.
Please help me!
[725 byte] By [
Gied] at [2007-12-28]
Gied,
What is your problem when you connect to the database and what is your DBMS? SQL Server or Access? If you use the SQL Server, just choose the SqlConnection control or write your code like: dim connectionString as String="Initial Catalog=DatabaseName; Data Source=(local); Integrated Security=SSPI;" If you use the access database, please use the data provider and Jet engine, the connectionString should be like this "Privider=Microsoft.Jet.OLEDB.4.0; Persist Security info=false; Data Source=mdb file path;"
I'm having the same problem as Gied with the Add Connnnection Dialog Box disappearing as soon as you try to enter anything. Giovanni Giorgio's blog does not have anything on installing the Firebird data provider.
Gied, did you find a solution? Anyone?
Thanks.
