|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
August 26th 06, 10:12 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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") 
|
|
#2
August 28th 06, 06:43 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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")
|
|
#3
August 29th 06, 08:25 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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")
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Running a script when Outlook runs for the first time | [email protected] | Outlook - Installation | 1 | August 4th 06 01:45 PM |
| Rule 'run a script' not running my script | [email protected] | Outlook and VBA | 3 | May 30th 06 01:09 PM |
| Oultook and sql-server | Filips Benoit | Outlook - General Queries | 0 | April 3rd 06 09:06 PM |
| How do I call a stored procedure inside my sql with a vba script? | Computer Newbie | Outlook and VBA | 1 | March 14th 06 08:08 AM |
| Create a macro that runs from a Rule | CF_business_analyst | Outlook and VBA | 8 | January 13th 06 06:12 PM |
Hybrid Mode
