SQL Backend

[ranen]

Hello! this is my first time to use sql as backend i don;t know how to use connectionstring and how it works... PLEASE HELP ME!!!!

 

[pdx_man]

Need more detail, please.

 

[ranen]

Hi pdx_man,

Thank you for the reply. I fixed it already by searching all over the net and test all the info I've searched. Thanks so much. I do appreciate the response.

 

[pdx_man]

What was the problem and the fix. Please post so the next person searching for connection string issues can perhaps use your research. That is what we are all about here.

 

[ranen]

Hi guys, this is the code that I think I also got in this forum, anyway, i hope this will help someone someday

Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String



Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "driver={SQL Server};server=x.x.x.x;database=databasename;trusted _connection = yes;"
conn.Open

enjoy...