PC Review


Reply
Thread Tools Rate Thread

Can't create/edit DSNs?

 
 
=?Utf-8?B?SnVzdGlu?=
Guest
Posts: n/a
 
      27th Apr 2007
Have a weird issues I'm hoping someone's seen before...

I have one workstation (XP SP 2) that's having some issues creating new DSNs
or editing existing ones through the GUI.

If I try to create a new DSN, things look ok at first. I can choose the
driver (SQL, in this case) and get the screen that asks for the name of the
data source and the server. If I click Finish, I get the congratulations
screen, just like I should. However, if I click "Test Connection," the
window just disappears and the DSN doesn't appear in the list. Same thing
happens if I click Next two more times instead of clicking Finish.

I get similar results when I try to edit an existing one. If you click
Finish, the changes don't appear to get saved.

I can get around some of this by editing the registry directly to create and
edit the DSNs, but that's obviously not a solution for the user.

Oh, and if I do create a new DSN manually in the registry, it doesn't appear
in the list in the GUI right away. If, however, I try to create a new one
with the name I entered in the reg key, I get a warning that says the name
already exists and it suddenly reappears if I save the new connection....

Anybody have any ideas?

Thanks,

Justin
 
Reply With Quote
 
 
 
 
Haggis
Guest
Posts: n/a
 
      27th Apr 2007


"Justin" <(E-Mail Removed)> wrote in message
news:7114CB5F-2516-4212-9602-(E-Mail Removed)...
> Have a weird issues I'm hoping someone's seen before...
>
> I have one workstation (XP SP 2) that's having some issues creating new
> DSNs
> or editing existing ones through the GUI.
>
> If I try to create a new DSN, things look ok at first. I can choose the
> driver (SQL, in this case) and get the screen that asks for the name of
> the
> data source and the server. If I click Finish, I get the congratulations
> screen, just like I should. However, if I click "Test Connection," the
> window just disappears and the DSN doesn't appear in the list. Same thing
> happens if I click Next two more times instead of clicking Finish.
>
> I get similar results when I try to edit an existing one. If you click
> Finish, the changes don't appear to get saved.
>
> I can get around some of this by editing the registry directly to create
> and
> edit the DSNs, but that's obviously not a solution for the user.
>
> Oh, and if I do create a new DSN manually in the registry, it doesn't
> appear
> in the list in the GUI right away. If, however, I try to create a new one
> with the name I entered in the reg key, I get a warning that says the name
> already exists and it suddenly reappears if I save the new connection....
>
> Anybody have any ideas?
>
> Thanks,
>
> Justin


which ODBC SQL driver version are you using ?


 
Reply With Quote
 
=?Utf-8?B?SnVzdGlu?=
Guest
Posts: n/a
 
      27th Apr 2007
> which ODBC SQL driver version are you using ?

Looks like 3.5.



"Haggis" wrote:

>
>
> "Justin" <(E-Mail Removed)> wrote in message
> news:7114CB5F-2516-4212-9602-(E-Mail Removed)...
> > Have a weird issues I'm hoping someone's seen before...
> >
> > I have one workstation (XP SP 2) that's having some issues creating new
> > DSNs
> > or editing existing ones through the GUI.
> >
> > If I try to create a new DSN, things look ok at first. I can choose the
> > driver (SQL, in this case) and get the screen that asks for the name of
> > the
> > data source and the server. If I click Finish, I get the congratulations
> > screen, just like I should. However, if I click "Test Connection," the
> > window just disappears and the DSN doesn't appear in the list. Same thing
> > happens if I click Next two more times instead of clicking Finish.
> >
> > I get similar results when I try to edit an existing one. If you click
> > Finish, the changes don't appear to get saved.
> >
> > I can get around some of this by editing the registry directly to create
> > and
> > edit the DSNs, but that's obviously not a solution for the user.
> >
> > Oh, and if I do create a new DSN manually in the registry, it doesn't
> > appear
> > in the list in the GUI right away. If, however, I try to create a new one
> > with the name I entered in the reg key, I get a warning that says the name
> > already exists and it suddenly reappears if I save the new connection....
> >
> > Anybody have any ideas?
> >
> > Thanks,
> >
> > Justin

>
> which ODBC SQL driver version are you using ?
>
>
>

 
Reply With Quote
 
Haggis
Guest
Posts: n/a
 
      27th Apr 2007


"Justin" <(E-Mail Removed)> wrote in message
news:78E67F69-2270-494A-8ECC-(E-Mail Removed)...
>> which ODBC SQL driver version are you using ?

>
> Looks like 3.5.
>
>
>
> "Haggis" wrote:
>
>>
>>
>> "Justin" <(E-Mail Removed)> wrote in message
>> news:7114CB5F-2516-4212-9602-(E-Mail Removed)...
>> > Have a weird issues I'm hoping someone's seen before...
>> >
>> > I have one workstation (XP SP 2) that's having some issues creating new
>> > DSNs
>> > or editing existing ones through the GUI.
>> >
>> > If I try to create a new DSN, things look ok at first. I can choose
>> > the
>> > driver (SQL, in this case) and get the screen that asks for the name of
>> > the
>> > data source and the server. If I click Finish, I get the
>> > congratulations
>> > screen, just like I should. However, if I click "Test Connection," the
>> > window just disappears and the DSN doesn't appear in the list. Same
>> > thing
>> > happens if I click Next two more times instead of clicking Finish.
>> >
>> > I get similar results when I try to edit an existing one. If you click
>> > Finish, the changes don't appear to get saved.
>> >
>> > I can get around some of this by editing the registry directly to
>> > create
>> > and
>> > edit the DSNs, but that's obviously not a solution for the user.
>> >
>> > Oh, and if I do create a new DSN manually in the registry, it doesn't
>> > appear
>> > in the list in the GUI right away. If, however, I try to create a new
>> > one
>> > with the name I entered in the reg key, I get a warning that says the
>> > name
>> > already exists and it suddenly reappears if I save the new
>> > connection....
>> >
>> > Anybody have any ideas?
>> >
>> > Thanks,
>> >
>> > Justin

>>
>> which ODBC SQL driver version are you using ?
>>
>>
>>

I had the same sort of problem using versions higher than 3.51.9 , so that
is what I stuck with (I never did find a resolution for the problem)

you try that :>


 
Reply With Quote
 
=?Utf-8?B?SnVzdGlu?=
Guest
Posts: n/a
 
      27th Apr 2007
Nuts...

I was hoping for a "Hey, knucklehead, just uncheck the 'Make DSNs no workie'
box" type of answer... Guess I'm out of luck, huh?

Of course, here's the funnest part of this: it's only happen on one
workstation, and, of course, it happens to be the boss's computer. Nice...

Thanks,

Justin

"Haggis" wrote:

>
>
> "Justin" <(E-Mail Removed)> wrote in message
> news:78E67F69-2270-494A-8ECC-(E-Mail Removed)...
> >> which ODBC SQL driver version are you using ?

> >
> > Looks like 3.5.
> >
> >
> >
> > "Haggis" wrote:
> >
> >>
> >>
> >> "Justin" <(E-Mail Removed)> wrote in message
> >> news:7114CB5F-2516-4212-9602-(E-Mail Removed)...
> >> > Have a weird issues I'm hoping someone's seen before...
> >> >
> >> > I have one workstation (XP SP 2) that's having some issues creating new
> >> > DSNs
> >> > or editing existing ones through the GUI.
> >> >
> >> > If I try to create a new DSN, things look ok at first. I can choose
> >> > the
> >> > driver (SQL, in this case) and get the screen that asks for the name of
> >> > the
> >> > data source and the server. If I click Finish, I get the
> >> > congratulations
> >> > screen, just like I should. However, if I click "Test Connection," the
> >> > window just disappears and the DSN doesn't appear in the list. Same
> >> > thing
> >> > happens if I click Next two more times instead of clicking Finish.
> >> >
> >> > I get similar results when I try to edit an existing one. If you click
> >> > Finish, the changes don't appear to get saved.
> >> >
> >> > I can get around some of this by editing the registry directly to
> >> > create
> >> > and
> >> > edit the DSNs, but that's obviously not a solution for the user.
> >> >
> >> > Oh, and if I do create a new DSN manually in the registry, it doesn't
> >> > appear
> >> > in the list in the GUI right away. If, however, I try to create a new
> >> > one
> >> > with the name I entered in the reg key, I get a warning that says the
> >> > name
> >> > already exists and it suddenly reappears if I save the new
> >> > connection....
> >> >
> >> > Anybody have any ideas?
> >> >
> >> > Thanks,
> >> >
> >> > Justin
> >>
> >> which ODBC SQL driver version are you using ?
> >>
> >>
> >>

> I had the same sort of problem using versions higher than 3.51.9 , so that
> is what I stuck with (I never did find a resolution for the problem)
>
> you try that :>
>
>
>

 
Reply With Quote
 
Haggis
Guest
Posts: n/a
 
      27th Apr 2007



"Justin" <(E-Mail Removed)> wrote in message
news:BD20E202-8CD6-475F-BF0A-(E-Mail Removed)...
> Nuts...
>
> I was hoping for a "Hey, knucklehead, just uncheck the 'Make DSNs no
> workie'
> box" type of answer... Guess I'm out of luck, huh?
>
> Of course, here's the funnest part of this: it's only happen on one
> workstation, and, of course, it happens to be the boss's computer.
> Nice...
>
> Thanks,
>
> Justin
>
> "Haggis" wrote:
>
>>
>>
>> "Justin" <(E-Mail Removed)> wrote in message
>> news:78E67F69-2270-494A-8ECC-(E-Mail Removed)...
>> >> which ODBC SQL driver version are you using ?
>> >
>> > Looks like 3.5.
>> >
>> >
>> >
>> > "Haggis" wrote:
>> >
>> >>
>> >>
>> >> "Justin" <(E-Mail Removed)> wrote in message
>> >> news:7114CB5F-2516-4212-9602-(E-Mail Removed)...
>> >> > Have a weird issues I'm hoping someone's seen before...
>> >> >
>> >> > I have one workstation (XP SP 2) that's having some issues creating
>> >> > new
>> >> > DSNs
>> >> > or editing existing ones through the GUI.
>> >> >
>> >> > If I try to create a new DSN, things look ok at first. I can choose
>> >> > the
>> >> > driver (SQL, in this case) and get the screen that asks for the name
>> >> > of
>> >> > the
>> >> > data source and the server. If I click Finish, I get the
>> >> > congratulations
>> >> > screen, just like I should. However, if I click "Test Connection,"
>> >> > the
>> >> > window just disappears and the DSN doesn't appear in the list. Same
>> >> > thing
>> >> > happens if I click Next two more times instead of clicking Finish.
>> >> >
>> >> > I get similar results when I try to edit an existing one. If you
>> >> > click
>> >> > Finish, the changes don't appear to get saved.
>> >> >
>> >> > I can get around some of this by editing the registry directly to
>> >> > create
>> >> > and
>> >> > edit the DSNs, but that's obviously not a solution for the user.
>> >> >
>> >> > Oh, and if I do create a new DSN manually in the registry, it
>> >> > doesn't
>> >> > appear
>> >> > in the list in the GUI right away. If, however, I try to create a
>> >> > new
>> >> > one
>> >> > with the name I entered in the reg key, I get a warning that says
>> >> > the
>> >> > name
>> >> > already exists and it suddenly reappears if I save the new
>> >> > connection....
>> >> >
>> >> > Anybody have any ideas?
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Justin
>> >>
>> >> which ODBC SQL driver version are you using ?
>> >>
>> >>
>> >>

>> I had the same sort of problem using versions higher than 3.51.9 , so
>> that
>> is what I stuck with (I never did find a resolution for the problem)
>>
>> you try that :>
>>
>>
>>


heh heh , always the way :> as I said I never did get a resolution to my
problem ..it involved installing a different driver..

you could un-install and re-install ....are you logged in as a Admin on the
computer ?

alternately can you copy a working DSN from another computer to this one and
see it ? copy to > "C:\Program Files\Common Files\ODBC\Data Sources"


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel and DSNs trakrats@gmail.com Microsoft Excel Misc 0 26th Feb 2008 04:44 PM
Enumerate DSNs =?Utf-8?B?WFA=?= Microsoft Excel Programming 2 22nd May 2007 06:47 PM
How to detect use of DSNs? Paul Martin Microsoft Excel Programming 0 30th May 2006 02:43 AM
DSNs via VBscripts Tony Microsoft Windows 2000 CMD Promt 2 8th Jul 2004 07:43 PM
DSNs Tom Lewis Windows XP Setup 1 27th Aug 2003 03:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:11 AM.