Solved

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

Posted on 2001-06-04
20
279 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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
 
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 Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Adding to a VBA? 6 78
vb6 connector to SQL Server 2 37
Exit a vb6 apps when a calling it apps closes 15 52
fso.FolderExists("\\server\HiddenFolder$") 4 78
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

856 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