connecting to SQL 2000 2

[R9772]

can anyone assist me in creating a link via an editable grid to sql server 2000. i thought the following lines of code would suffice - i was wrong.

Dim ConnectionString As String = "server=(local);database=mydatabase;trusted_connection=true"
Dim SelectCommand As String = "SELECT ss#, date, codeDetail from clientListing"

 

[Alcar]

this might help you

http://www.able-consulting.com/ADO_Conn.htm

good luck! Daren J. Lahey
Just another computer guy...

 

[link9]

I find this very helpful:

http://www.connectionstrings.com/

although it will have the same one alcar has pointed you to, they keep it updated with everything.

paul