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 doesnt work.Can you tell me samething I dont 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 doesnt 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