Connecting to InterBase

[Mladen]

Can someone help me to conect an InterBase database from within Visual Basic .Net?

[archer_coal]

re:

 

What driver?

Easysoft or intersolve?

[Mladen]

Intersolve.

[Madz]

Does it support ODBC, if yes then download

 

Microsoft .NET ODBC Data Provider

 

it will do your work , it could be found form MSDN download section.

[archer_coal]

re

 

it does support ODBC

get the driver and use the data adapter wizard to get your connection string

then you can copy paste it into whatever form you want

 

below is NOT your connection string, just proof that Interbase supports ODBC

 

"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password"

[Mladen]

I downloaded Microsoft .NET ODBC Data Provider from Microsoft,

but DataAdapter Wizard doesn't work.Can you tell me samething I don't know or am I doing something wrong?

[archer_coal]

re:

 

when you click on oledbdataadapter from the toolbar and click anywhere on the form... what happens? nothing?

[Mladen]

Yes.DataAdapter wizard doesn't start like it does with the other adapters.Am I stupid or what.Another way is if you can send me the whole ConnectionString from your example so I can work around something.

Thanks for all your help so far

you helped me a lot

[archer_coal]

re: Connection String

 

Here are the connection strings but before you use these try adding a new connection in the "server explorer" window.

For local machine

oConn.Open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};" & _
          "Server=localhost;" & _
          "Database=localhost:C:\Home\Data\Mydb.gdb;" & _
          "Uid=myUsername;" & _
          "Pwd=myPassword" 

 

for remote machine

 

oConn.Open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};" & _
          "Server=myMachineName;" & _
          "Database=myMachineName:C:\Home\Data\Mydb.gdb;" & _
          "Uid=myUsername;" & _
          "Pwd=myPassword" 

[Mladen]

archer_coal ConnectionString worked.

Now only thing left is to try to solve the problem with the Wizard.

thanks for your patience