Interbase and ADO.NET

Article View: borland.public.interbase.sql

Article #11166

Back to borland.public.interbase.sql Previous Next

#11166

From: Lucio Macellari
Date: Thu, 05 Dec 2002 13:11

24 lines
1680 bytes

I'm having some problems on interfacing Interbase 6 OpenSource with ADO.NET.

I get odbc driver from Easysoft and set up a system DSN.

Now, if I use "Server Exploren" in the .NET IDE, I can verify and test the
connection.

The problem arise when I try to make the connection.

What connection class have I to use (OleDbConnection, SqlConnection...)?
What is the correct connection string to use?
What have I to do if I do not want to use DSN connection?
I found (on the net) some DSN-less connections strings, but they do not seem
to work:
oConn.Open "Driver={Easysoft IB6 ODBC};" & _
           "Server=myMachineName;" & _
           "Database=myMachineName:C:\Home\Data\Mydb.gdb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
What is the type of oConn?

Regards

Lucio

Technical Details

Message-ID: <3def5094@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,dd7096f791bd4c72,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-05 05:18:42 PST
From: "Lucio Macellari" <lmacellari@libero.it>
Newsgroups: borland.public.interbase.sql
Subject: Interbase and ADO.NET
Date: Thu, 5 Dec 2002 14:11:39 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 80.21.86.90
Message-ID: <3def5094@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039093908 80.21.86.90 (5 Dec 2002 05:11:48 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail