User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
 Password:
Save Password
Forgot your Password?

     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 ODBC connection problems		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hawo69

7 Posts
Posted - Apr 14 2010 :  03:42:31  Show Profile  Reply
Hi,
after installing MLK+ODBC,
setting up a system-dsn
accessing MKL-Database through ms-Acess:
1) first run in Ms-Access, read-only (system says ~another user modified the table......)
2) second run - no odbc source found...

When setting up a new system-DSN-no errors occur

It is also not possible to re-configure with the ODBC -Admin
it says ODBC driver not found (~same as 2))

All runs under XP-SP3 + MS-ACCESS 2003
ODBC VErs. 3.3

TIA

xequte

7504 Posts
Posted - Apr 14 2010 :  21:34:45  Show Profile  Reply
Hi

Just to confirm, did you use the ODBC configuration tool to check your ODBC connections? (It's located located in the MailList King ODBC folder under the Windows Start menu).


Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Go to Top of Page

hawo69

7 Posts
Posted - Apr 14 2010 :  23:36:43  Show Profile  Reply
Yes,
did use the check, no driver found, repairing , all ok
I have the same behavior as here (in my post --> 2))

http://www.xequte.com/forum/topic.asp?TOPIC_ID=3219&SearchTerms=odbc

It is not possible to insert / change anything

Yes, I do have the DBUtility 3.3
Go to Top of Page

xequte

7504 Posts
Posted - Apr 15 2010 :  20:01:23  Show Profile  Reply
Access 2003 can't handle boolean fields with null values.

Have you updated the database to clear any NULL values?

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Go to Top of Page

hawo69

7 Posts
Posted - Apr 16 2010 :  22:48:18  Show Profile  Reply
Hi,
thank you for support.
My problem was, I want to subs/unsubs from VBA, directly adding and deleting in the MLK-DB.
Now I have another solution, I'm using a redemption.dll, faking the sender name and move the mails in right OL-folder so that MLK thinks
they came from "outside"

regards
Go to Top of Page

xequte

7504 Posts
Posted - Apr 17 2010 :  04:07:48  Show Profile  Reply
Excellent solution.

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: