Mladen

archer_coal ConnectionString worked. Now only thing left is to try to solve the problem with the Wizard. thanks for your patience

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

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?

Intersolve.

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

peet, it works great. Where are you,I want to buy you a drink? I tried the exact same string only with the single quotes. You saved me a lot of trouble thanks

That doesn't solve the problem.Does anyone have another solution?

The error I get is: "Cannot start your application. The workgroup information file is missing or opened exclusively by another user" Can anyone help?

Can someone tell me how can I connect to an Accsses 2000 database protected with password.It seems that I cannot write the ConnectionString wright.

Robby I figured it out. Jast adding Print dialog and selecting WinFax from the combo with instaled printers solves the problem. I thought it would be much harder so I asked for help. Thanks for trying to help

Can someone tell me how can I send the page which I want to print directly to another program like WinFax,without printing it?

I solved the problem like this: created a connection in server explorer. drag-and-drop oledbconnection1 and oldataadapter1 on to the project. changed the select command text "SELECT * from Table1 where field4 = true" And it worked like I wanted to work. But still it doesn't work if I want to do it programaticly. If someone can still help me with that I'll be wery happy. I'll work like this until someone shows me the way to do it. Thanks to all of you who showed intrest to help stupid me with the smallest of problems with jast a few lines of code . But what hapens when the projects start to get big?

The return value is a checkbox. My problem is that I want to select only the checked items in the database .Simple ,but not efective.

Private Sub First_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim com As String = "SELECT field1,field2,field3,field4 FROM(Table1) WHERE (((Table1.field4)= True)); Dim ole As New OleDbDataAdapter(com, OleDbConnection1) ole.Fill(Ds1, "Table1") End Sub The SELECT query was generated from MS Accsses ,I inserted it like it came from SQL View and still nothing happens. I have selected, in properties window, the DataSource property and it is set to Table1.

how can I use the stored procedures created in this way?