problem on a recordset for a ADODB connection.

[kazper]

I'm having trouble getting the right code for the record set.

Dim adoItems As New ADODB.Connection
Dim recItems As New ADODB.Recordset

adoItems.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=MyUserID;Data Source=MyDataSource;Initial Catalog=MyCatalog"

adoItems.Open ("DSN=MyDSNName;UID=MyUserID;Pwd=MyPassword")


my real problem is getting the right recordset for recItems for my adodb connection.

Hope you guys can help me out..

Thanks in Advance

[willakawill]

I'm having trouble getting the right code for the record set.

Dim adoItems As New ADODB.Connection
Dim recItems As New ADODB.Recordset

adoItems.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=MyUserID;Data Source=MyDataSource;Initial Catalog=MyCatalog"

adoItems.Open ("DSN=MyDSNName;UID=MyUserID;Pwd=MyPassword")


my real problem is getting the right recordset for recItems for my adodb connection.

Hope you guys can help me out..

Thanks in Advance

Hi. If I knew what recordset you wanted I could help you, but I don't as you did not say what you want to do.
You are showing 2 connection strings for your connection object. If you set the connection string first, you don't need a parameter for the call to open.

If you are just looking for a generic way to open a recordset then you need a SQL string

Set recItems = adoItems.Execute("SELECT * FROM MyTable")

[kazper]

Thanks for the code :) that was the code that i needed ;) thanks alot

[willakawill]

Thanks for the code :) that was the code that i needed ;) thanks alot

Welcome :)