Re: trouble creating DSN



Well further research seems to indicate that the SQLConfigDataSource
function does not allow one to actually create the DSN with the UID or PWD.
But I have another problem. When I run the same code (with very slight
modifications) in MS Access it does create the system DSN with sql
authentication but of course no UID and PWD which I can live with. But when
I run the below in D7 it actually pops up the DSN creation window for me to
finish filling things in. I don't want that. I want it to do what it does in
MS Access. Not sure why it would behave differently. Any ideas?

Keith


.



Relevant Pages

  • Re: How-to add ODBC to MSVS 2005 setup project
    ... create the dsn, default uid, default pwd etc... ... I added a setup project to my solution using the wizard... ...
    (microsoft.public.vc.language)
  • Create DSN with UID and PWD
    ... i am trying to modify some VBA code that create a DSN that use trusted ... connection to accept a UID and PWD instead: ...
    (microsoft.public.access.gettingstarted)
  • Re: Changing connection details
    ... change the DSN, UID and DBQ. ... If someone knows how to just display the dsn part of the connection ...
    (microsoft.public.excel.programming)
  • Re: caching problem
    ... >I am new to asp.net I coded simple login form and placed two textboxes and ... I want to verify the uid and pwd in my databasewith the user ... You'll have to edit, compile, and then refresh the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Create DSN Programmatically
    ... AFAIK you have to use yet the ODBC APIs (SQLCOnfigDataSource) to do that, ... Do a search in Google or MSDN about these DSN-less connections. ... > (DSN) Is Valid and if not, ...
    (microsoft.public.vsnet.general)