F
Fred Jacobowitz
What is the ADO connection string used to open Outlook 11 with JET?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Slovak - [MVP - Outlook]
See http://www.slipstick.com/dev/database.htm.
I assume you mean you want to connect to Outlook using an ODBC
connection? Just remember that many fields aren't available when doing
that (you only get 44 fields from a contact item for example) and that
field names in the recordset don't match the Outlook property names in
many cases.
I assume you mean you want to connect to Outlook using an ODBC
connection? Just remember that many fields aren't available when doing
that (you only get 44 fields from a contact item for example) and that
field names in the recordset don't match the Outlook property names in
many cases.
F
Fred Jacobowitz
Ken - thanks for the tip. The problem I have is that most of the articles
reference exchange server like this code fragment.
With ADOConn
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Exchange 4.0;" _
& "MAPILEVEL=Mailbox - James Smith|;" _
& "PROFILE=MS Exchange Settings;" _
& "TABLETYPE=0;DATABASE=C:\WINDOWS\TEMP\;"
.Open
End With
Do you know what the connection string should look like for a 'home' pc
running Outlook?
Thanks,
Fred Jacobowitz
reference exchange server like this code fragment.
With ADOConn
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Exchange 4.0;" _
& "MAPILEVEL=Mailbox - James Smith|;" _
& "PROFILE=MS Exchange Settings;" _
& "TABLETYPE=0;DATABASE=C:\WINDOWS\TEMP\;"
.Open
End With
Do you know what the connection string should look like for a 'home' pc
running Outlook?
Thanks,
Fred Jacobowitz
K
Ken Slovak - [MVP - Outlook]
I use something like this:
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Outlook 9.0;" _
& "MAPILEVEL=Mailbox - Ken Slovak|;" _
& "PROFILE=Ken Exchange;" _
& "TABLETYPE=0;DATABASE=C:\TEMP\;"
But that refers to an Exchange mailbox and an Exchange profile. You
can try replacing the mailbox name with "Personal Folders" and replace
the profile name and see if that works. And make sure that the Temp
folder location is correct for your setup or create a new Temp folder
where you want and reference that in the connection string.
The Exchange string might also work if you replace the mailbox name
with "Personal Folders" and fix the profile name.
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Outlook 9.0;" _
& "MAPILEVEL=Mailbox - Ken Slovak|;" _
& "PROFILE=Ken Exchange;" _
& "TABLETYPE=0;DATABASE=C:\TEMP\;"
But that refers to an Exchange mailbox and an Exchange profile. You
can try replacing the mailbox name with "Personal Folders" and replace
the profile name and see if that works. And make sure that the Temp
folder location is correct for your setup or create a new Temp folder
where you want and reference that in the connection string.
The Exchange string might also work if you replace the mailbox name
with "Personal Folders" and fix the profile name.