Unix Technical Forum

General problem with ODBC Data Sources

This is a discussion on General problem with ODBC Data Sources within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi! I have a problem with using my registred data sources. The registration i Control Panel works fine and ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:23 PM
Johan Elfman
 
Posts: n/a
Default General problem with ODBC Data Sources

Hi!
I have a problem with using my registred data sources. The
registration i Control Panel works fine and I have seven
registred data sources (including Excel Files, dBASE etc.).

The problem is that I can't use them when I try to access
them in Excel.
When I choose 'Data' --> 'Get Extarnal Data' --> 'New Data
Base Query' in Excel, my only option in the 'Choose Data
Source'-window is '<New Data Source>'. I would like to
have a list with my seven registred data sources instead!

What might be the problem? How can I get my data sources
visible in Excel?

Info: WIN NT SP6, Excel97

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 08:23 PM
Sue Hoegemeier
 
Posts: n/a
Default Re: General problem with ODBC Data Sources

You will probably do better posting this in one of the excel
newsgroups. Try: microsoft.public.excel

-Sue

On Wed, 17 Sep 2003 02:31:16 -0700, "Johan Elfman"
<swejoe@swe.sas.com> wrote:

>Hi!
>I have a problem with using my registred data sources. The
>registration i Control Panel works fine and I have seven
>registred data sources (including Excel Files, dBASE etc.).
>
>The problem is that I can't use them when I try to access
>them in Excel.
>When I choose 'Data' --> 'Get Extarnal Data' --> 'New Data
>Base Query' in Excel, my only option in the 'Choose Data
>Source'-window is '<New Data Source>'. I would like to
>have a list with my seven registred data sources instead!
>
>What might be the problem? How can I get my data sources
>visible in Excel?
>
>Info: WIN NT SP6, Excel97


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:44 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com