VB and VBA Users Source Code: Re: Adding and Deleting DSNs

VB/VBA Source Code
Re: Adding and Deleting DSNs

By:	roni
Email (spam proof):	Email the originator of this post
Date:	Monday, January 23, 2006
Hits:	473
Category:	Database/SQL/ADO

Article:
Dear Andrew, Hi Andrew, I'm roni, I am hoping that u can help me with sqlconfigdatasource function, especially the lpszattributes props. I want to make as system DSN on the fly, connecting to sql server using driver "SQL Server", no trusted connection, and supplying the login and password I have try all the suggestion, but I still got an error, saying that invalid keyword-value pairs. Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed. Can help me? Thank you Regards, roni
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder