VB.Net SQL ADO problem

[sheldontitcher]

I am using VB.Net Standard ver 2003.

The basic questions I have are:
1) Does the Standard edition support connections to client-server databases since the "connect to server" icon is not present in Server Explorer?
2) I am able to connecr to Access using the Jet database engine. I can also fill the Dataset from the OleDbDataAdapter and display my data.
3) When I connect to SQL Server using the SQLDataAdapter and generate the DataSet, I can't fill the Dataset from the SQLDataAdapter. I receive an error - "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error."

I am able to preview the data in the adapter and fill the dataset that way, but not programmatically.

Am I doing something wrong, or does the standard edition not support client server?

The code I wrote is in the Form_Load proc.

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
SqlDataAdapter1.Fill(DataSet11)
End Sub

 

[ca8msm]

The standard edition does support connections to databases. I suggest you create a simple example by following faq855-5662. Also, I'm not sure that you actually asked a question in #2!


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[chrissie1]

1) yes
2) see ca8msm
3) standard edition only supports access and msde when you use the wizard, but if you do it the right way (coding) it will make the connection.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]