ADO connection-recorset problems

[pacg]

Hi

I'm not a newby in programing/code but in Access-SqlServer i am.
I have all my code (and works fine) in DAO but with a connection to a mdb db.
Now i've already passed to sqlserver and need to put my code to DAO. Problems!!

I can't establish a connection into my db.
I have:
1. A DSN called DSNName;
2. A front-end app (.mde) with all my table connection;
3. My DB SQL is named SQLDataB;
4. My username and password are the same : ccdruser.

I need to create a connection ADODB, a recordset to update some records.

I have several problems reading the sintaxe.
Help

 

[Surjer]

Dim Conn as new ADODB.Connection

'DSN 
Conn.Open "DSN=mySystemDSN;" & _ 
           "Uid=myUsername;" & _ 
           "Pwd=myPassword"

 'File DSN 
Conn.Open "FILEDSN=c:\somepath\mydb.dsn;" & _ 
           "Uid=myUsername;" & _
           "Pwd=myPassword"

And then for the recordset you do this

Dim rs As New ADODB.Recordset
rs = New ADODB.Recordset
		rs.Open("Select * from MyTable where MyStringField = " & Chr(34) & MyStringCriteria & Chr(34), Conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)

Hope that helps...

 

[pacg]

It helped! Thanks.

Tell me 3 things:
1. Why do you use the NEW?
2. In the SQL string, how can i use the Me.Recordset (my form is based on a query that i whant to use)?

3. What the hell is the "Provider" ?

Newby stuff about SQL server ...

p.s. Very good rate