Solved

Urgent !!!Data Environment & DataReporter on user's PC

Posted on 2001-06-04
20
265 Views
Last Modified: 2012-08-13
Urgent !!!Data Environment & DataReporter on user's PC.
Report.exe is working fine on my PC but from another PC I get error "Invalid Data Source" because Connection never happen!
Provider:MS  OLE DB provider for SQL Server (database is on SQL Server 7).
Thank you in advance!:)
0
Comment
Question by:PDF
  • 10
  • 10
20 Comments
 
LVL 7

Expert Comment

by:q2eddie
ID: 6153072
Hi, PDF.

#Questions
1. What is your connection string?
2. If you are using an ODBC Data Source (DSN), has that data source been set up on the second PC?
3. Is the connection string pointing to the correct server location?
4. Are the two PCs mapped to the network drives the same way?

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6153158
#1.On Conn tab:
 Server name is selected & DB name & conn is succeeded.
Comparing file odbc.ini & odbcins.ini  only difference is "AccessToSQLServer" missing on user PC.
#4.How I can check that?
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6153206
Hi, again.

for #1: The odbcinst.ini has a list of the odbc drivers (dlls) on the machine.  On the other hand, the odbc.ini lists all the "data sources" that the PC is linked to.
I believe that the user's PC is missing the "AccessToSQLServer" data source.

Do you have the "AccessToSQLServer" ODBC data source set up on your PC?  Can you set it up on the user's PC?

for #4: Right-click on the "Start" button, select the "Explore" menu item, and click-to-collapse the "C:\" tree.

This is probably not your problem unless you used a drive letter to specify where your data source is and that letter doesn't show up on the user's PC.

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6153253
Yes I have "AccessToSQLServer" & I will tray to put odbc.ini in sync.

Thank you.
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6153342
Hi, PDF.

It might be more complicated than simply copy-and-pasting into the user's PC.  (I don't actually know because I've never done it that way before.)  Nevertheless, I hope it works.

If it doesn't, then you'll need to set it up through the Control Panel->ODBC Data Source dialog.  I can help you with that.

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6159774
Hi, again.

I still have same msg. Must be something else.
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6160291
Good Morning, PDF.

Something that you stated earlier caught my attention.
>Provider:MS  OLE DB provider for SQL Server (database is
>on SQL Server 7).

Is the "OLEDB driver for SQL Server" installed on your user's PC?

Goto your PC's control panel, open the ODBC data sources dialog, and take a note of all the drivers on the "Drivers" tab-page.  Now goto your user's PC and do the same.

Are they different?
Do you have a driver that your user doesn't?

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6160597
Yes I have one more driver than user (Microsoft ODBC Driver for Oracle).
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6160668
Well... that particular driver probably won't make much difference.

You probably need to set up the data source through the "Control Panel->ODBC Data Source" dialog.

#Instructions
Goto your PC's control panel, open the ODBC data sources dialog, and look for the "AccessToSQLServer" data source in either the "User DSN" or the "System DSN" tab-pages.  Once you find it, write down the driver that it uses.  Click on the data source name and click the Configure or modify button.  A form totled something like "ODBC ... Setup" should appear.  Write down any information that is on this form.

Setup an exact copy of this data source on the user's PC.

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6160792
Hi g2eddie,
I don't think is driver.I just run it from 3rd PC & it is working fine. This PC does not have "AccessToSQLServer".
Thanks.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 7

Expert Comment

by:q2eddie
ID: 6160894
Hmm...

What was the exact error message? -e2
0
 

Author Comment

by:PDF
ID: 6160917
"Invalid Data Source"
On empty data report form.
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6161150
Hi, PDF.

There are only a few sources deal explicitly with this issue.  However, I have found something that might help you.

Either you need to install MDAC on that PC or you need to reinstall the software itself.  If you decide to reinstall it, take note of any errors that occur.

#Links
1. "Microsoft Data Access Components 2.5 SP2 (2.52.6019.2) Now Available"
http://www.microsoft.com/data/download.htm#252info

2. "Welcome to the Universal Data Access Web Site"
http://www.microsoft.com/data/

3. "datareport"
http://www.beadsandbaubles.com/wwwboard5/messages/855.shtml

4. "Pass A value to a data report"
http://161.58.186.97/showthread.php?s=9401584df3ca9bd762e6334611244b23&threadid=57570&highlight=datareport+and+invalid

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6163635
Ok,I will reinstall MDAC.
Thank you!!!!
0
 

Author Comment

by:PDF
ID: 6248694
Hi g2eddie,

Thanks a lot!:>)

I reinstall:
    * ie5setup.exe(ver. 5.50.4522.1800IC; update ver.SP1)
    * mdac_typ.exe(ver. 2.60.6526.3)
    * jet40spr_comp.exe(ver. 4.0.2927)
& now is working.

PS:
Sorry for the dalay!
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6248716
Hi, PDF.

Cool!  :)
That was a strange error.  I'm glad that you got it working again.

Bye. -e2
0
 

Author Comment

by:PDF
ID: 6248744
Thank you!
0
 
LVL 7

Accepted Solution

by:
q2eddie earned 200 total points
ID: 6248885
Hey, PDF.

Did you mean to select one of my comments as the answer?
(Like the one on 06/06/2001 12:49PM PST)

Just wondering.  -e2
0
 

Author Comment

by:PDF
ID: 6249680
Yes !!!!
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6260413
well....
Are you able to select it as the answer?
Are you waiting for me to "submit" an answer-comment?

I hate to keep bugging you about it, but ....
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now