Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

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

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
PDF
Asked:
PDF
  • 10
  • 10
1 Solution
 
q2eddieCommented:
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
 
PDFAuthor Commented:
#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
 
q2eddieCommented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
PDFAuthor Commented:
Yes I have "AccessToSQLServer" & I will tray to put odbc.ini in sync.

Thank you.
0
 
q2eddieCommented:
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
 
PDFAuthor Commented:
Hi, again.

I still have same msg. Must be something else.
0
 
q2eddieCommented:
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
 
PDFAuthor Commented:
Yes I have one more driver than user (Microsoft ODBC Driver for Oracle).
0
 
q2eddieCommented:
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
 
PDFAuthor Commented:
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
 
q2eddieCommented:
Hmm...

What was the exact error message? -e2
0
 
PDFAuthor Commented:
"Invalid Data Source"
On empty data report form.
0
 
q2eddieCommented:
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
 
PDFAuthor Commented:
Ok,I will reinstall MDAC.
Thank you!!!!
0
 
PDFAuthor Commented:
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
 
q2eddieCommented:
Hi, PDF.

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

Bye. -e2
0
 
PDFAuthor Commented:
Thank you!
0
 
q2eddieCommented:
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
 
PDFAuthor Commented:
Yes !!!!
0
 
q2eddieCommented:
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 Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 10
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now