Model Designer - ODBC Data Source

I want to create a Model against an ODBC data source.

This is not possible in the June CTP.

Will this facility be available in a future release?

Thanks,
JoeI've raised this as a call with Microsoft through our Partner Program.

Will post the result here when I get an answer.|||As promised here is Microsoft's reply:

Please find the answers to your queries below:

Query:

=======

You want to be able to create an Ad-hoc Report Model using the Model Designer in Visual Studio 2005.

You want to be able to use an ODBC data source for this model - currently the only option is to use the “SQL Client Data Provider”.

So you need to know whether this will be addressed in the final release of SQL Server 2005 (or any CTPs of SQL Server 2005 before then).

Solution:

==========

As of now only SQL and Analysis Services are directly supported as a data source for Report Builder.

However you can connect to the ODBC data source using SQL or Analysis Services. We have the following two ways to get this working:

Option I:

-

UDM (Unified Dimensional Model) is essentially a way that SQL Analysis Services 2005 can combine multiple sources of data into one model. Let’s say your “Sales” information is one an Oracle data store, your “HR” info is in SQL, and your “Inventory” is in DB2 – You would build a UDM which includes all three of these data sources, and then you could report against the UDM as if ALL of the information lived inside Analysis Services.

So, by using a UDM to point to the ODBC data source, you enable Report Builder to get at the data too, since Report Builder CAN report against Analysis Services.

Option II:

--

You could try this but the performance expected is not very good with this option:

1. create linked servers in order to reference the ODBC (or other) data sources

2. create a layer of views in a SQL Server database accessing the other database through the linked server mechanism. You could use just simple views to expose the contents of the underlying tables with 'select *'. For example:
create view MyODBCTableView as select * from LinkedServerName..SchemaOwner.TableX

3. build SQL Server views on top of these views as desired

4. build the Report Model against these SQL Views

5. use Report Builder to query the OBDC data source through this 'proxy'

The following link is useful for more information and resources on SQL Server 2005:

http://www.microsoft.com/uk/partner/sol_and_products/servers/sql/

|||Unfortunately the chaps from Partner Tech Support were misinformed.

This is a reply from MSAS newsgroup :

AS2005 is not going to support ODBC data source. However, you can try to
create a data source in SSIS project. Then, add the data source into new AS
project. You should be able to create DSV, cube and dimension, etc.

However, since this feature is not supported. Believe that this area has not
been tested enough and this may break engine or not working probably. It is
"AS IS" if you really want to use it.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Ken Kwok
SQL Server Analysis Services

Missing table

I have a SQL 7.0 server holding our Agency's most critical
database. At my deskstop, I link to this database in
Access via ODBC drivers. I am linked to a specific table
which has disappeared from the server. It does not appear
in Enterprise Manager. I can find no "hidden" attributes
to reverse...the table is simply gone. However, I can use
the Query Analyser to get a count of records in this table
and it returns the correct number of records. Furthermore,
all data prior to 5/18/04 has also disappeared. Can anyone
help me find this table AND more importantly, help me
discover why the data disappeared. No, I have no backups
going back that far..... Thanks in advance.
I am guessing that the table is "owned" by some other user.
Using Query Analyzer
Connnect to the server
switch to the appropriate database
SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM =
INFORMATION_SCHEMA.tables
SELECT crdate, name FROM sysobjects WHERE TYPE =3D 'u' ORDER BY crdate =
DESC, name
Regarding the dissapearing data, I am guessing that someone who thought =
they knew what they were doing (on or around 5/18/2004) created a new =
table (with a different owner) and dropped the old table. That is =
speculation, but based on the information that you have provided it =
sounds logical. The other possibility is that someone deleted the data =
within the table and changed the owner.
Whatever the case may be, you have some investigation to do!
--=20
Keith
"Bean" <anonymous@.discussions.microsoft.com> wrote in message =
news:1371901c44404$a95e1610$a601280a@.phx.gbl...
> I have a SQL 7.0 server holding our Agency's most critical=20
> database. At my deskstop, I link to this database in=20
> Access via ODBC drivers. I am linked to a specific table=20
> which has disappeared from the server. It does not appear=20
> in Enterprise Manager. I can find no "hidden" attributes=20
> to reverse...the table is simply gone. However, I can use=20
> the Query Analyser to get a count of records in this table=20
> and it returns the correct number of records. Furthermore,=20
> all data prior to 5/18/04 has also disappeared. Can anyone=20
> help me find this table AND more importantly, help me=20
> discover why the data disappeared. No, I have no backups=20
> going back that far..... Thanks in advance.
|||Am I to type out the 2 commands you list, as is? What am
I looking for in the results?
I executed the first one and it gave me a list of 24
items, most saying DBO, while the last ones said
INFORMATION_SCHEMA. What does this mean?

>--Original Message--
>I am guessing that the table is "owned" by some other
user.
>Using Query Analyzer
>Connnect to the server
>switch to the appropriate database
>SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM
INFORMATION_SCHEMA.tables
>SELECT crdate, name FROM sysobjects WHERE TYPE = 'u'
ORDER BY crdate DESC, name
>
>Regarding the dissapearing data, I am guessing that
someone who thought they knew what they were doing (on or
around 5/18/2004) created a new table (with a different
owner) and dropped the old table. That is speculation,
but based on the information that you have provided it
sounds logical. The other possibility is that someone
deleted the data within the table and changed the owner.
>Whatever the case may be, you have some investigation to
do!
>--
>Keith
>
>"Bean" <anonymous@.discussions.microsoft.com> wrote in
message news:1371901c44404$a95e1610$a601280a@.phx.gbl...[vbcol=seagreen]
critical[vbcol=seagreen]
table[vbcol=seagreen]
appear[vbcol=seagreen]
attributes[vbcol=seagreen]
use[vbcol=seagreen]
table[vbcol=seagreen]
Furthermore,[vbcol=seagreen]
anyone[vbcol=seagreen]
backups
>.
>
|||Yes, execute the commands within Query Analyzer.
The first piece of sql displays the table owner, type (table or view), =
and the name of the table.
The second piece of sql displays the creation date for the table as well =
as the table name.
Knowing these pieces of information might help in your investigation to =
find out what happened.
You mentioned that "most" are owned by dbo. How about the one table =
that is causing problems? Is it owned by someone else?
You mentioned that it disappeared from the [tables] view within =
Enterprise Manager. Hit the "views" node. Is your "table" listed =
there? Jump out to Query Analyzer and perform=20
exec sp_helptext YourTableNameGoesHere=20
That will give you the text of the view (if there is a view with the =
same name as the table). Perhaps the view is limiting the rows (making =
it look like some data is missing).
--=20
Keith
<anonymous@.discussions.microsoft.com> wrote in message =
news:13a0501c44413$262bab40$a001280a@.phx.gbl...[vbcol=seagreen]
> Am I to type out the 2 commands you list, as is? What am=20
> I looking for in the results? =20
> I executed the first one and it gave me a list of 24=20
> items, most saying DBO, while the last ones said=20
> INFORMATION_SCHEMA. What does this mean?
>=20
> user.
> INFORMATION_SCHEMA.tables
> ORDER BY crdate DESC, name
> someone who thought they knew what they were doing (on or=20
> around 5/18/2004) created a new table (with a different=20
> owner) and dropped the old table. That is speculation,=20
> but based on the information that you have provided it=20
> sounds logical. The other possibility is that someone=20
> deleted the data within the table and changed the owner.
> do!
> message news:1371901c44404$a95e1610$a601280a@.phx.gbl...
> critical=20
> table=20
> appear=20
> attributes=20
> use=20
> table=20
> Furthermore,=20
> anyone=20
> backups=20

Missing table

I have a SQL 7.0 server holding our Agency's most critical
database. At my deskstop, I link to this database in
Access via ODBC drivers. I am linked to a specific table
which has disappeared from the server. It does not appear
in Enterprise Manager. I can find no "hidden" attributes
to reverse...the table is simply gone. However, I can use
the Query Analyser to get a count of records in this table
and it returns the correct number of records. Furthermore,
all data prior to 5/18/04 has also disappeared. Can anyone
help me find this table AND more importantly, help me
discover why the data disappeared. No, I have no backups
going back that far..... Thanks in advance.I am guessing that the table is "owned" by some other user.
Using Query Analyzer
Connnect to the server
switch to the appropriate database
SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM =
INFORMATION_SCHEMA.tables
SELECT crdate, name FROM sysobjects WHERE TYPE =3D 'u' ORDER BY crdate =
DESC, name
Regarding the dissapearing data, I am guessing that someone who thought =
they knew what they were doing (on or around 5/18/2004) created a new =
table (with a different owner) and dropped the old table. That is =
speculation, but based on the information that you have provided it =
sounds logical. The other possibility is that someone deleted the data =
within the table and changed the owner.
Whatever the case may be, you have some investigation to do!
--=20
Keith
"Bean" <anonymous@.discussions.microsoft.com> wrote in message =
news:1371901c44404$a95e1610$a601280a@.phx
.gbl...
> I have a SQL 7.0 server holding our Agency's most critical=20
> database. At my deskstop, I link to this database in=20
> Access via ODBC drivers. I am linked to a specific table=20
> which has disappeared from the server. It does not appear=20
> in Enterprise Manager. I can find no "hidden" attributes=20
> to reverse...the table is simply gone. However, I can use=20
> the Query Analyser to get a count of records in this table=20
> and it returns the correct number of records. Furthermore,=20
> all data prior to 5/18/04 has also disappeared. Can anyone=20
> help me find this table AND more importantly, help me=20
> discover why the data disappeared. No, I have no backups=20
> going back that far..... Thanks in advance.|||Am I to type out the 2 commands you list, as is? What am
I looking for in the results?
I executed the first one and it gave me a list of 24
items, most saying DBO, while the last ones said
INFORMATION_SCHEMA. What does this mean?

>--Original Message--
>I am guessing that the table is "owned" by some other
user.
>Using Query Analyzer
>Connnect to the server
>switch to the appropriate database
>SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM
INFORMATION_SCHEMA.tables
>SELECT crdate, name FROM sysobjects WHERE TYPE = 'u'
ORDER BY crdate DESC, name
>
>Regarding the dissapearing data, I am guessing that
someone who thought they knew what they were doing (on or
around 5/18/2004) created a new table (with a different
owner) and dropped the old table. That is speculation,
but based on the information that you have provided it
sounds logical. The other possibility is that someone
deleted the data within the table and changed the owner.
>Whatever the case may be, you have some investigation to
do!
>--
>Keith
>
>"Bean" <anonymous@.discussions.microsoft.com> wrote in
message news:1371901c44404$a95e1610$a601280a@.phx
.gbl...
critical[vbcol=seagreen]
table[vbcol=seagreen]
appear[vbcol=seagreen]
attributes[vbcol=seagreen]
use[vbcol=seagreen]
table[vbcol=seagreen]
Furthermore,[vbcol=seagreen]
anyone[vbcol=seagreen]
backups[vbcol=seagreen]
>.
>|||Yes, execute the commands within Query Analyzer.
The first piece of sql displays the table owner, type (table or view), =
and the name of the table.
The second piece of sql displays the creation date for the table as well =
as the table name.
Knowing these pieces of information might help in your investigation to =
find out what happened.
You mentioned that "most" are owned by dbo. How about the one table =
that is causing problems? Is it owned by someone else?
You mentioned that it disappeared from the [tables] view within =
Enterprise Manager. Hit the "views" node. Is your "table" listed =
there? Jump out to Query Analyzer and perform=20
exec sp_helptext YourTableNameGoesHere=20
That will give you the text of the view (if there is a view with the =
same name as the table). Perhaps the view is limiting the rows (making =
it look like some data is missing).
--=20
Keith
<anonymous@.discussions.microsoft.com> wrote in message =
news:13a0501c44413$262bab40$a001280a@.phx
.gbl...[vbcol=seagreen]
> Am I to type out the 2 commands you list, as is? What am=20
> I looking for in the results? =20
> I executed the first one and it gave me a list of 24=20
> items, most saying DBO, while the last ones said=20
> INFORMATION_SCHEMA. What does this mean?
>=20
> user.
> INFORMATION_SCHEMA.tables
> ORDER BY crdate DESC, name
> someone who thought they knew what they were doing (on or=20
> around 5/18/2004) created a new table (with a different=20
> owner) and dropped the old table. That is speculation,=20
> but based on the information that you have provided it=20
> sounds logical. The other possibility is that someone=20
> deleted the data within the table and changed the owner.
> do!
> message news:1371901c44404$a95e1610$a601280a@.phx
.gbl...
> critical=20
> table=20
> appear=20
> attributes=20
> use=20
> table=20
> Furthermore,=20
> anyone=20
> backups=20

Missing table

I have a SQL 7.0 server holding our Agency's most critical
database. At my deskstop, I link to this database in
Access via ODBC drivers. I am linked to a specific table
which has disappeared from the server. It does not appear
in Enterprise Manager. I can find no "hidden" attributes
to reverse...the table is simply gone. However, I can use
the Query Analyser to get a count of records in this table
and it returns the correct number of records. Furthermore,
all data prior to 5/18/04 has also disappeared. Can anyone
help me find this table AND more importantly, help me
discover why the data disappeared. No, I have no backups
going back that far..... Thanks in advance.I am guessing that the table is "owned" by some other user.
Using Query Analyzer
Connnect to the server
switch to the appropriate database
SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM =INFORMATION_SCHEMA.tables
SELECT crdate, name FROM sysobjects WHERE TYPE =3D 'u' ORDER BY crdate =DESC, name
Regarding the dissapearing data, I am guessing that someone who thought =they knew what they were doing (on or around 5/18/2004) created a new =table (with a different owner) and dropped the old table. That is =speculation, but based on the information that you have provided it =sounds logical. The other possibility is that someone deleted the data =within the table and changed the owner.
Whatever the case may be, you have some investigation to do!
-- Keith
"Bean" <anonymous@.discussions.microsoft.com> wrote in message =news:1371901c44404$a95e1610$a601280a@.phx.gbl...
> I have a SQL 7.0 server holding our Agency's most critical > database. At my deskstop, I link to this database in > Access via ODBC drivers. I am linked to a specific table > which has disappeared from the server. It does not appear > in Enterprise Manager. I can find no "hidden" attributes > to reverse...the table is simply gone. However, I can use > the Query Analyser to get a count of records in this table > and it returns the correct number of records. Furthermore, > all data prior to 5/18/04 has also disappeared. Can anyone > help me find this table AND more importantly, help me > discover why the data disappeared. No, I have no backups > going back that far..... Thanks in advance.|||Am I to type out the 2 commands you list, as is? What am
I looking for in the results?
I executed the first one and it gave me a list of 24
items, most saying DBO, while the last ones said
INFORMATION_SCHEMA. What does this mean?
>--Original Message--
>I am guessing that the table is "owned" by some other
user.
>Using Query Analyzer
>Connnect to the server
>switch to the appropriate database
>SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM
INFORMATION_SCHEMA.tables
>SELECT crdate, name FROM sysobjects WHERE TYPE = 'u'
ORDER BY crdate DESC, name
>
>Regarding the dissapearing data, I am guessing that
someone who thought they knew what they were doing (on or
around 5/18/2004) created a new table (with a different
owner) and dropped the old table. That is speculation,
but based on the information that you have provided it
sounds logical. The other possibility is that someone
deleted the data within the table and changed the owner.
>Whatever the case may be, you have some investigation to
do!
>--
>Keith
>
>"Bean" <anonymous@.discussions.microsoft.com> wrote in
message news:1371901c44404$a95e1610$a601280a@.phx.gbl...
>> I have a SQL 7.0 server holding our Agency's most
critical
>> database. At my deskstop, I link to this database in
>> Access via ODBC drivers. I am linked to a specific
table
>> which has disappeared from the server. It does not
appear
>> in Enterprise Manager. I can find no "hidden"
attributes
>> to reverse...the table is simply gone. However, I can
use
>> the Query Analyser to get a count of records in this
table
>> and it returns the correct number of records.
Furthermore,
>> all data prior to 5/18/04 has also disappeared. Can
anyone
>> help me find this table AND more importantly, help me
>> discover why the data disappeared. No, I have no
backups
>> going back that far..... Thanks in advance.
>.
>|||Yes, execute the commands within Query Analyzer.
The first piece of sql displays the table owner, type (table or view), =and the name of the table.
The second piece of sql displays the creation date for the table as well =as the table name.
Knowing these pieces of information might help in your investigation to =find out what happened.
You mentioned that "most" are owned by dbo. How about the one table =that is causing problems? Is it owned by someone else?
You mentioned that it disappeared from the [tables] view within =Enterprise Manager. Hit the "views" node. Is your "table" listed =there? Jump out to Query Analyzer and perform exec sp_helptext YourTableNameGoesHere That will give you the text of the view (if there is a view with the =same name as the table). Perhaps the view is limiting the rows (making =it look like some data is missing).
-- Keith
<anonymous@.discussions.microsoft.com> wrote in message =news:13a0501c44413$262bab40$a001280a@.phx.gbl...
> Am I to type out the 2 commands you list, as is? What am > I looking for in the results? > I executed the first one and it gave me a list of 24 > items, most saying DBO, while the last ones said > INFORMATION_SCHEMA. What does this mean?
> > >--Original Message--
> >I am guessing that the table is "owned" by some other > user.
> >
> >Using Query Analyzer
> >Connnect to the server
> >switch to the appropriate database
> >
> >SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM > INFORMATION_SCHEMA.tables
> >
> >SELECT crdate, name FROM sysobjects WHERE TYPE =3D 'u' > ORDER BY crdate DESC, name
> >
> >
> >Regarding the dissapearing data, I am guessing that > someone who thought they knew what they were doing (on or > around 5/18/2004) created a new table (with a different > owner) and dropped the old table. That is speculation, > but based on the information that you have provided it > sounds logical. The other possibility is that someone > deleted the data within the table and changed the owner.
> >
> >Whatever the case may be, you have some investigation to > do!
> >
> >-- > >Keith
> >
> >
> >"Bean" <anonymous@.discussions.microsoft.com> wrote in > message news:1371901c44404$a95e1610$a601280a@.phx.gbl...
> >> I have a SQL 7.0 server holding our Agency's most > critical > >> database. At my deskstop, I link to this database in > >> Access via ODBC drivers. I am linked to a specific > table > >> which has disappeared from the server. It does not > appear > >> in Enterprise Manager. I can find no "hidden" > attributes > >> to reverse...the table is simply gone. However, I can > use > >> the Query Analyser to get a count of records in this > table > >> and it returns the correct number of records. > Furthermore, > >> all data prior to 5/18/04 has also disappeared. Can > anyone > >> help me find this table AND more importantly, help me > >> discover why the data disappeared. No, I have no > backups > >> going back that far..... Thanks in advance.
> >.
> >

Missing Records in Linked Table

I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in
an MDB file. The db is used by about 30 users on a LAN, and an additional 10
or so on a WAN.
Recently, one of the WAN users complained of intermittently not being able
to find certain customers in the customers table (contains around 40,000
records). There are specific "problem records" of customers that can't be
found, and they all start with the letter "F" (the table has a numeric
customer ID as its primary key).
For these three or four customers that have been identified so far as
problem records, the customer exists in the customer list (a drop-down based
on a front-end table), but, when trying to go to the record, are told that
the record's not found.
Similarly, when the user searches for one of these problem records using the
custom search function, which searches the linked tables, the search
function says the record cannot be found.
Note that this is an intermittent problem with this single WAN user, and no
other users (on WAN or LAN are having this problem).
Any ideas about what might be causing it, or what can be done to this single
user's machine to alleviate the problem?
Thanks!
NeilAre they accessing the table directly or through a View that might be
limiting records?
--
KARL DEWEY
Build a little - Test a little
"Neil" wrote:

> I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in
> an MDB file. The db is used by about 30 users on a LAN, and an additional
10
> or so on a WAN.
> Recently, one of the WAN users complained of intermittently not being able
> to find certain customers in the customers table (contains around 40,000
> records). There are specific "problem records" of customers that can't be
> found, and they all start with the letter "F" (the table has a numeric
> customer ID as its primary key).
> For these three or four customers that have been identified so far as
> problem records, the customer exists in the customer list (a drop-down bas
ed
> on a front-end table), but, when trying to go to the record, are told that
> the record's not found.
> Similarly, when the user searches for one of these problem records using t
he
> custom search function, which searches the linked tables, the search
> function says the record cannot be found.
> Note that this is an intermittent problem with this single WAN user, and n
o
> other users (on WAN or LAN are having this problem).
> Any ideas about what might be causing it, or what can be done to this sing
le
> user's machine to alleviate the problem?
> Thanks!
> Neil
>
>|||No, directly, the entire table. Also, note that the functionality is fine,
and on one (and now I found out two) computers the data for those records is
intermittently not there. But on other computers it's there. Nothing in the
functionality that would be limiting it.
"KARL DEWEY" <KARLDEWEY@.discussions.microsoft.com> wrote in message
news:3D9F901F-12EB-479D-9981-AE808A4E76EB@.microsoft.com...[vbcol=seagreen]
> Are they accessing the table directly or through a View that might be
> limiting records?
> --
> KARL DEWEY
> Build a little - Test a little
>
> "Neil" wrote:
>|||hi Neil,
Neil wrote:
> Note that this is an intermittent problem with this single WAN user, and n
o
> other users (on WAN or LAN are having this problem).
Check thw WAN connection and the service packs (OS, Office, MDAC/Jet) of
the client.
mfG
--> stefan <--|||Hi, Stefan. I am tracking the version of Windows, Access (msaccess.exe), Jet
(msjet40.dll), and the SQL driver (sqlsrv32.dll), and they are all the same
as the other users. Are there any other files you suggest I check?
The fact that these records all have names starting with "F" leads me to
wonder if it's a paging issue, even though the PK is the customer ID, not
name, though there is an index on last name.
Thanks,
Neil
"Stefan Hoffmann" <stefan.hoffmann@.explido.de> wrote in message
news:uEy7$tM2HHA.4004@.TK2MSFTNGP05.phx.gbl...
> hi Neil,
> Neil wrote:
> Check thw WAN connection and the service packs (OS, Office, MDAC/Jet) of
> the client.
>
> mfG
> --> stefan <--|||hi Neil,
Neil wrote:
> Hi, Stefan. I am tracking the version of Windows, Access (msaccess.exe), J
et
> (msjet40.dll), and the SQL driver (sqlsrv32.dll), and they are all the sam
e
> as the other users. Are there any other files you suggest I check?
No.

> The fact that these records all have names starting with "F" leads me to
> wonder if it's a paging issue, even though the PK is the customer ID, not
> name, though there is an index on last name.
Can you browse the linked table on that specific client?
mfG
--> stefan <--|||
>
> Can you browse the linked table on that specific client?
>
> mfG
Good question. I'll have to check on that tomorrow.
BTW, what's mfG?

> --> stefan <--|||hi Neil,
Neil wrote:
> BTW, what's mfG?
"mit freundlichen Gren" means "with kind regards"
mfG
--> stefan <--

Missing Records in Linked Table

I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in
an MDB file. The db is used by about 30 users on a LAN, and an additional 10
or so on a WAN.
Recently, one of the WAN users complained of intermittently not being able
to find certain customers in the customers table (contains around 40,000
records). There are specific "problem records" of customers that can't be
found, and they all start with the letter "F" (the table has a numeric
customer ID as its primary key).
For these three or four customers that have been identified so far as
problem records, the customer exists in the customer list (a drop-down based
on a front-end table), but, when trying to go to the record, are told that
the record's not found.
Similarly, when the user searches for one of these problem records using the
custom search function, which searches the linked tables, the search
function says the record cannot be found.
Note that this is an intermittent problem with this single WAN user, and no
other users (on WAN or LAN are having this problem).
Any ideas about what might be causing it, or what can be done to this single
user's machine to alleviate the problem?
Thanks!
Neil
Are they accessing the table directly or through a View that might be
limiting records?
KARL DEWEY
Build a little - Test a little
"Neil" wrote:

> I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in
> an MDB file. The db is used by about 30 users on a LAN, and an additional 10
> or so on a WAN.
> Recently, one of the WAN users complained of intermittently not being able
> to find certain customers in the customers table (contains around 40,000
> records). There are specific "problem records" of customers that can't be
> found, and they all start with the letter "F" (the table has a numeric
> customer ID as its primary key).
> For these three or four customers that have been identified so far as
> problem records, the customer exists in the customer list (a drop-down based
> on a front-end table), but, when trying to go to the record, are told that
> the record's not found.
> Similarly, when the user searches for one of these problem records using the
> custom search function, which searches the linked tables, the search
> function says the record cannot be found.
> Note that this is an intermittent problem with this single WAN user, and no
> other users (on WAN or LAN are having this problem).
> Any ideas about what might be causing it, or what can be done to this single
> user's machine to alleviate the problem?
> Thanks!
> Neil
>
>
|||No, directly, the entire table. Also, note that the functionality is fine,
and on one (and now I found out two) computers the data for those records is
intermittently not there. But on other computers it's there. Nothing in the
functionality that would be limiting it.
"KARL DEWEY" <KARLDEWEY@.discussions.microsoft.com> wrote in message
news:3D9F901F-12EB-479D-9981-AE808A4E76EB@.microsoft.com...[vbcol=seagreen]
> Are they accessing the table directly or through a View that might be
> limiting records?
> --
> KARL DEWEY
> Build a little - Test a little
>
> "Neil" wrote:
|||hi Neil,
Neil wrote:
> Note that this is an intermittent problem with this single WAN user, and no
> other users (on WAN or LAN are having this problem).
Check thw WAN connection and the service packs (OS, Office, MDAC/Jet) of
the client.
mfG
--> stefan <--
|||Hi, Stefan. I am tracking the version of Windows, Access (msaccess.exe), Jet
(msjet40.dll), and the SQL driver (sqlsrv32.dll), and they are all the same
as the other users. Are there any other files you suggest I check?
The fact that these records all have names starting with "F" leads me to
wonder if it's a paging issue, even though the PK is the customer ID, not
name, though there is an index on last name.
Thanks,
Neil
"Stefan Hoffmann" <stefan.hoffmann@.explido.de> wrote in message
news:uEy7$tM2HHA.4004@.TK2MSFTNGP05.phx.gbl...
> hi Neil,
> Neil wrote:
> Check thw WAN connection and the service packs (OS, Office, MDAC/Jet) of
> the client.
>
> mfG
> --> stefan <--
|||hi Neil,
Neil wrote:
> Hi, Stefan. I am tracking the version of Windows, Access (msaccess.exe), Jet
> (msjet40.dll), and the SQL driver (sqlsrv32.dll), and they are all the same
> as the other users. Are there any other files you suggest I check?
No.

> The fact that these records all have names starting with "F" leads me to
> wonder if it's a paging issue, even though the PK is the customer ID, not
> name, though there is an index on last name.
Can you browse the linked table on that specific client?
mfG
--> stefan <--
|||
> Can you browse the linked table on that specific client?
>
> mfG
Good question. I'll have to check on that tomorrow.
BTW, what's mfG?

> --> stefan <--
|||hi Neil,
Neil wrote:
> BTW, what's mfG?
"mit freundlichen Gren" means "with kind regards"
mfG
--> stefan <--

Missing ODBC drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.|||

Did you ever get this fixed? I have a staff member that has the same problem and is running XP SP2 with no ODBC Drivers at all.

|||Have you referred to the link above to get the relevant drivers?

Missing ODBC Drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Replied to one of similar posts in other section.

Missing ODBC drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.|||

Did you ever get this fixed? I have a staff member that has the same problem and is running XP SP2 with no ODBC Drivers at all.

|||Have you referred to the link above to get the relevant drivers?

Missing ODBC drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.

Missing ODBC drivers - please help!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.

Missing ODBC Drivers

I'm trying to connect a NT 4.0 Workstation to a ODBC database (SQL 2000). Wh
en I use the the ODBC Data Administrator on the WS to create a new DSN there
are no ODBC drivers available. How to install the missing driver?
Thanks for help!
DirkYou can download MDAC from the support.microsoft.com and install it. Pick a
version 2.6 or greater. By default, a SQL SErver ODBC driver is not
istalled on Windows NT 4.0. If an application has not been installed to
install the driver it probably will not be on the system. Installing MDAC
will install the ODBC driver.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for help.

>Dirk

Missing ODBC Driver

I have a Windows 2000 development server with multiple instance of SQL Server 2000 Dev Edition installed. Recently, i encounter an error on Enterpise Manager.

"A connection could not be established to SERVERNAME\INSTANCENAME.
Reason : Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the SERVERNAME\INSTANCENAME node) and try again."

I tried to use Query Analyser on the server to connect to instance. And receive this error

"Unable to connect to server SERVERNAME\INSTANCENAME:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified"

I tried connecting using IPAddr\InstanceName and it return the same error.
But if I use another machine (not the Development Server), I can connect to the instance sucessfully using Query Analyser.
Opening up the ODBC Data Source Adminsitrator, under the Drivers tab page, it is empty. So I tried re-installing MDAC 2.8 and also SP1, the installation completed sucessfully but the drivers is still missing. Tried searching on the MSDN site, shows, ODBC Driver cannot be un-installed.
Anybody can help on this ?
Have you changed anyhting on your PC recently? Any updates to the Windows or server? Have you tried to run Component Checker that comes with MDAC to see what could be corrupted in MDAC installation?|||Component Checker reported that I have MDAC 2.8 SP1 ON WINDOWS XP SP2.
But my OS is Windows 2000 SP4|||Does it show any error for the installed drivers/providers?|||I ran the check against the SP and it shows 3 files with mismatch

File : odbcjt32.dll
Mixmatch Fields : Expected : version = 4.0.6304.0
Path : C:\WINNT\system32\
Version : 4.0.6200.0
FileVersion : 4.06200.0
FileDescription : Microsoft ODBC Desktop Driver Pack 3.5
CodePage : 1252
Size : 270608
Date : 06/19/2003

File : msxml3.dll
Mixmatch Fields : Expected : version = 8.50.2162.0
Path : C:\WINNT\system32\
Version : 8.70.1104.0
FileVersion : 8.70.1104.0
FileDescription : MSXML 3.0 SP7
CodePage : 1200
Size : 1049088
Date : 02/18/2005

File : odbcji32.dll
Mixmatch Fields : Expected : version = 4.0.6304.0
Path : C:\WINNT\system32\
Version : 4.0.6200.0
FileVersion : 4.06200.0
FileDescription : Microsoft ODBC Desktop Driver Pack 3.5
CodePage : 1252
Size : 53520
Date : 07/22/2002|||I ran the check against "MDAC 2.8 SP1 ON WINDOWS XP SP2."|||Is the problem i am facing related to SQL Server Data Access or should i post this in Windows 2000 forum instead ?|||It is more related to the Windows installation rather than Data Access to SQL Server. In my opinion MDAC is corrupted somehow|||Thanks for replying.