Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old June 17th, 2004, 03:47 AM
paul ankho paul ankho is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 5 paul ankho User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Connecting to FireBird without network thru .NET Provider

Hi,
I am using FireBird server 1.5 with FireBird .NET provider 1.5 to access to it.
Iīm using this string connection to connect with the server:

string connectionString =
"User=SYSDBA; " +
"Password=masterkey; " +
"Database=D:\\SYSTEM\\SYSTEM.GDB;" +
"DataSource=localhost;" +
"Port=3050; " +
"Dialect=3; " +
"Charset=NONE; " +
"Role=; " +
"Connection lifetime=15; " +
"Pooling=true; " +
"Packet Size=8192";

I need to use Firebird .NET Provider without network services. I have used before ODBC drivers but the performance of them are not the same than the .NET one.
Iīm having troubles with the DataSource parameter when there is no net.
Is there any way to use this provider without network services?
Thanks

Reply With Quote
  #2  
Old June 18th, 2004, 02:04 AM
upscene upscene is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 223 upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 14 m 50 sec
Reputation Power: 8
Hi,

Doesn't it work with "localhost"?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com
__________________
Martijn Tonies
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
Upscene Productions
http://www.upscene.com

Reply With Quote
  #3  
Old June 18th, 2004, 03:24 AM
paul ankho paul ankho is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 5 paul ankho User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
No... It doesnīt work. Localhost is resolved by TCP/IP as 127.0.0.1. We donīt have TCP/IP installed in the machine... thus FbConnection canīt resolve Datasource location and throws an exception.
Weīre trying now to connect the application to an embedded firebird server but we canīt connect with the Firebird .NET provider 1.5.4. version. We are using this connection string now:

string connectionString =
"User=SYSDBA; " +
"Password=masterkey; " +
"Database=D:\\SISTEM\\SISTEM.GDB;" +
"Dialect=3; " +
"ServerType= 1;";

This connection string works perfectly with the 1.6. .NET provider version but when we use it with 1.5.4. version the FbConnection object throws this message:
"Unable to complete network request to host \"D\".\n"
Is there any way to connect with an embedded firebird version with the 1.5.4. Firebird .NET Provider connection?

Reply With Quote
  #4  
Old June 18th, 2004, 03:58 AM
WayneB WayneB is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2004
Location: Cape Town, South Africa
Posts: 51 WayneB User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 42 m 31 sec
Reputation Power: 5
Send a message via Skype to WayneB
I thought the 1.5.4 .Net Provider can't be used embeded only 1.6?

Reply With Quote
  #5  
Old June 18th, 2004, 08:12 AM
upscene upscene is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 223 upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 14 m 50 sec
Reputation Power: 8
You might want to check if connecting to Embedded is new for 1.6 ... that might give you a clue.

Anyway, apparently, it doesn't work with v < 1.6 - so you're out of luck with that.

--

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com

Reply With Quote
  #6  
Old June 21st, 2004, 07:53 AM
carlosga carlosga is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Posts: 13 carlosga User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by paul ankho
Is there any way to connect with an embedded firebird version with the 1.5.4. Firebird .NET Provider connection?


No embedded server support is new in v1.6

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Connecting to FireBird without network thru .NET Provider


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway