Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > C#
|
C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 18th, 2004, 06:27 PM
Authorized User
 
Join Date: Jun 2003
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default How can I reading InterBase database

I'm just start reading C#. I have InterBase 7.0 and XTG ODBC driver installed. I already tried database access example script of Beginning C# book but it didn't really work out. It didn't understand connection string which works on ASP script.

How can I connect and show result of InterBase database on C#?

Please advice,
 
Old September 19th, 2004, 05:09 AM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Here is a connection string I used to connect to an Interbase machine. I didn't use DSN though I used full connection details and You need server licence on the database server. I had the lcpi provider installed, there is a free version but I ended up buying the full version from the Russian manufacturers at:

http://www.ibprovider.com/eng/

OleDbConnection oConn = new OleDbConnection("Provider=LCPI.IBProvider;" +
          "data source=<my server name>:<past on datbase to gdb file>;" +
          "ctype=win1251;user id=sysdba;password=masterkey");

--

Joe
 
Old September 21st, 2004, 12:51 AM
Authorized User
 
Join Date: Jun 2003
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you.





Similar Threads
Thread Thread Starter Forum Replies Last Post
reading image from database reza_ahmadi Java Espanol 4 March 8th, 2009 09:35 AM
Reading from database larry101 Classic ASP Databases 5 September 23rd, 2004 03:43 PM
Interbase isql allang SQL Language 1 July 31st, 2004 07:20 AM
Reading data from database... Thomas82 Classic ASP Databases 3 February 25th, 2004 03:58 PM
ASP code for inserting BLOB field in Interbase pyc Classic ASP Databases 0 June 4th, 2003 12:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.