Rule that runs an script that should call an SQL Server sentence
 

Hello all, I made an script that runs with a rule and I would like to get
database info from SQL server DB (not from an Access DB). I've added
Microsoft DAO 3.6 Object LIvary reference to be able to get the info.

So I wrote the following data but without thinking that will not work
because it does not say anything about the server and username/password
info...

Maybe someone can explain me wich are the options or correct functions in
order to get info from an SQL server DAtabase.

Thanks in advance
Carlos

Dim db As Database
Dim table As Recordset
Set db = OpenDatabase("QualitySurvey")
Set table = BDD.OpenRecordset("Test")
table.OpenRecordset ("SELECT * FROM Autos WHERE Patente = 589975")

Rule that runs an script that should call an SQL Server sentence
 

Am Sat, 26 Aug 2006 13:12:02 -0700 schrieb Carlos:

SQLServer know two ways of authentication. Please google for
"connectionstring sqlserver dao" or ask in an SQLServer related group.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Hello all, I made an script that runs with a rule and I would like to get
database info from SQL server DB (not from an Access DB). I've added
Microsoft DAO 3.6 Object LIvary reference to be able to get the info.

So I wrote the following data but without thinking that will not work
because it does not say anything about the server and username/password
info...

Maybe someone can explain me wich are the options or correct functions in
order to get info from an SQL server DAtabase.

Thanks in advance
Carlos

Dim db As Database
Dim table As Recordset
Set db = OpenDatabase("QualitySurvey")
Set table = BDD.OpenRecordset("Test")
table.OpenRecordset ("SELECT * FROM Autos WHERE Patente = 589975")

Rule that runs an script that should call an SQL Server senten
 

Thanks for the tip...

Rgds,

"Michael Bauer [MVP - Outlook]" wrote:

Am Sat, 26 Aug 2006 13:12:02 -0700 schrieb Carlos:

SQLServer know two ways of authentication. Please google for
"connectionstring sqlserver dao" or ask in an SQLServer related group.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Hello all, I made an script that runs with a rule and I would like to get
database info from SQL server DB (not from an Access DB). I've added
Microsoft DAO 3.6 Object LIvary reference to be able to get the info.

So I wrote the following data but without thinking that will not work
because it does not say anything about the server and username/password
info...

Maybe someone can explain me wich are the options or correct functions in
order to get info from an SQL server DAtabase.

Thanks in advance
Carlos

Dim db As Database
Dim table As Recordset
Set db = OpenDatabase("QualitySurvey")
Set table = BDD.OpenRecordset("Test")
table.OpenRecordset ("SELECT * FROM Autos WHERE Patente = 589975")