List from Data Source

[pootwaddle]

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!

[pootwaddle]

Any help here at all?

[MailEnable-Ian]

Hi,

You mentioned the following:

Query: select * from Active
(Active is a view that returns only the email address from
the records that have the active flag set true)

You need to ensure that the column "emailaddress" is present within the view. So try this as the query:

Code: Select all

select emailaddress from Active

[pootwaddle]

Hi, Ian -

Well, your suggestion didn't work either.
The log shows "no users" so it doesn't find
anyone to send the email to.

Is there a test facility for this? I hate to test
to a list of 1k+ users.

I also need to get this working asap. I may
have to use a support ticket...

Thanks!
Bryan