Re: Weird problem with DSN

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"Someone" <nobody@xxxxxxx> wrote in message
news:1zo%e.60659$ct5.20288@xxxxxxxxxxxxx
> You probably have the connection string hardcoded in one of the properties
> of Data Control, ADO Control, or the DataEnvironment. You may have one of
> these controls hidden from view, so open your forms in design mode, and go
> to the property window. Select the drop down list that shows the list of
> objects and make sure that you check anyone of these controls when you
find
> them.
>
> If you do a text search on the files using Windows Explorer, you might be
> able to see the hardcoded DSN name, if any. Note that Windows XP with no
> service packs will skip VB6 source files, so it might report that nothing
> was found. Try searching for the word "End" to see if your OS supports
> searching VB source files. You could also use Notepad if you don't have
too
> many files.
>
>
> "Luiz Horacio" <lhoracio@xxxxxxxxx> wrote in message
> news:Oe1ksUjxFHA.2960@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > I have an app written in VB6 that uses a DSN to connect to the database.
> > Worked fine and perfect at home and at my work. Each place has a DSN
with
> > a
> > different name.
> >
> > Well, made some changes in the app, compiled and took it to work. It did
> > not
> > work, and I received a message that the connection was closed and could
> > not
> > be used... Uhh... After being sure I did not hardcoded the DSN name, I
> > changed the DSN in .INI file to use the same name I had at home, created
> > another DSN with that name and the app ran perfectly.
> >
> > Back home, I double checked and there is no DSN name in the project. So
I
> > created another DSN, changed .INI file and it does not work.
> >
> > Looks like my app will only work with an specific DSN name, but this
> > weird... What is happening?
> >
> > Thanks,
> >
> > Luiz Horacio
> >

You can also use the command line utilities "find" and "findstr".
Open a console window ("DOSPrompt") and type
find /?
findstr /?

or visit...
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/ntcmds.mspx

-ralph


.

Relevant Pages

  • Re: SendKeys Method when Computer is Locked
    ... "handle" of the child window you are interested in. ... unless the control has focus, ... app to respond. ... Personally I prefer the system api approach. ...
    (microsoft.public.scripting.wsh)
  • Re: Automated GUI testing
    ... Having this ideas in mind you can succeed if you control the program ... naming can make your job of locating the proper window and control ... >1) Window Definitions Scripts ... This definition must be 'tied' to the actual app windows, ...
    (microsoft.public.vc.mfc)
  • Re: MORE Lyle Blake Info......
    ... >control with a static window beside it to show the percentage. ... The lightweight controls will be part of the DLL ... unloaded - the DLL might be unloaded without the App terminating ...
    (comp.lang.pascal.delphi.misc)
  • Re: Window closed event?
    ... You can then add a method to notify the user control ... >>> In a windows forms app how do you know a window is closing? ... >>> I have timer object that appears to be firing after the window is ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Weird problem with DSN
    ... >> of Data Control, ADO Control, or the DataEnvironment. ... >> to the property window. ... >> searching VB source files. ... Each place has a DSN ...
    (microsoft.public.vb.general.discussion)