Creating sql 2000 connection to vb6

[Stripes1283]

I have created the neccesary steps to connect to the server at least but now it gives me an error where
Datagrid1.Datasource= rs

it says that "Method or Datamember not found"

and it highlights the Datasource.

Please help

 

[Stripes1283]

This is my current code:

Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub Form_Load()

Set con = New ADODB.Connection
Set rs = New ADODB.Recordset

Dim sqlstr As String
Dim str As String

sqlstr = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=TDFDEV;" & "Initial Catalog = FRSSA"
con.ConnectionString = sqlstr
con.Open sqlstr

str = "SELECT FltNo from tblTargetSpendPerHead where FltNo = 123"
rs.Open str, con, adOpenDynamic, adLockPessimistic, adCmdText
DataGrid1.DataSource = rs

End Sub

 

[ArtieChoke]

Why are you using an Access driver to connect to SQL Server?

Are you sure the connection and recordset actually connect and return something?

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[JoeAtWork]

Why use Jet as the provider? SQL Server's OLEDB provider is "sqloledb". Suggest you look at

http://www.connectionstrings.com.

 

[BobRodes]

I also suggest that you read the explanation I gave you of the Jet provider, and OLE DB providers in general, in your other thread thread222-1377711. Sure looks from what you're saying here that you haven't take the trouble to read it.

Bob