I'm trying to create a list that uses a SQL database for the entries.
I created a System DSN (using SQL Server Native Client 10.x) pointing to
the database and the table.
DSN name: Educators
Description: (blank)
SERVER: CURLY/SQLEXPRESS
With Integrated Windows Authentication
And Connect to SQL Server to obtain default settings for additional configuration options. is checked.
I changed the default database to the database I desire.
Use ANSI Quoted Identifiers is checked.
Use ANSI Nulls, padding, warning is checked.
Perform Translation for character data is checked.
Finish, and Test Connection - Connection tests good.
Now in MailEnable, List Mode is "List Members come from database"
Configure...
Data Source: Educators
Username: (username)
Password: (password)
(note, username is checked as dbo_owner)
Query: select * from Active
(Active is a view that returns only the email address from
the records that have the active flag set true)
When I test the list using the test button, it passes, but when I send an
email to the list I see "no list entries." in the log file.
Can someone point me to an example of the correct setup for this?
Thanks!
List from Data Source
-
- Site Admin
- Posts: 9738
- Joined: Mon Mar 22, 2004 4:44 am
- Location: Melbourne, Victoria, Australia
Hi,
You mentioned the following:
You mentioned the following:
You need to ensure that the column "emailaddress" is present within the view. So try this as the query:Query: select * from Active
(Active is a view that returns only the email address from
the records that have the active flag set true)
Code: Select all
select emailaddress from Active
Regards,
Ian Margarone
MailEnable Support
Ian Margarone
MailEnable Support
-
- Posts: 49
- Joined: Thu Oct 02, 2008 11:06 pm
- Location: Texas