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

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

#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?

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

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

Thank you.

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

Hi, again.

I still have same msg. Must be something else.

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

Yes I have one more driver than user (Microsoft ODBC Driver for Oracle).

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

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.

Hmm...

What was the exact error message? -e2

"Invalid Data Source"
On empty data report form.

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

Ok,I will reinstall MDAC.
Thank you!!!!

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!

Hi, PDF.

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

Bye. -e2

Thank you!

Yes !!!!

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 ....