Interbase and ADO.NET

Thread View: borland.public.interbase.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Lucio Macellari Thu, 05 Dec 2002 13:11

#11166

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads