Data Source name not found

[Ralph8]

A couple of days ago, my projects started giving me

"Error -2147467259 in Microsoft OLE DB Provider for ODBC Drivers
Reason [Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified", on every Form Load. Usually 2 messages per form. The forms average about six adodcs each.

The form finishes loading after the messages, but the drop down lists are all empty on the datacombos. I have checked all the properties on the datacombos and the adodcs and they are all OK (Unchanged from when they were working fine.).

EM functions well on navigating the DBs. Windows XP Pro appears to be OK, although I am not strong in that area.

I am using VB 6 w/SQL Server 7 on a Windows XP Pro machine (VS 6 Enterprise).

Got me stumped. Any one have any ideas why it went south?

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[Sheco]

Did you happen to either reinstall windows or move the program to another machine?

The message seems pretty clear that it cant find the expected DSN.

 

[Ralph8]

No, but what I did do was copy a project from another machine into a unique folder on this machine, and then copy some individual objects (Forms and Mods) into my development directory (VB98). I then "added" them to the projects that are getting the messages.

If this is causing the problem, how can I fix it?

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[johnwm]

Go into Control Panel and set up the appropriate DSN

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[Ralph8]

Did that. I am still getting the same results. I compared to the DSN setup on the machine that the "Copied" project came from and I don't see any thing really different.

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[bjd4jc]

what is the offending code?

 

[Ralph8]

Wish I knew. The problem as described in my first submission shows up during form load.

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[bjd4jc]

Have you stepped through the program and found where the error is? Do you not have the source code?

 

[Ralph8]

Yes. I have stepped thru every thing that I can think of.

Also, I have a routine that loads the connection strings for all the adodcs in the Form_load. I set up a series of msgBoxs just prior to end sub in the form load and all connections are just as they should be.

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[Ralph8]

Still have not figured this out.

I have experimented every way that I can think of in WIN XP Pro Control Panel and haven't made any difference.

I have confirmed that the connection strings(s) and Record Source(s) are setting up properly as described above.

I have found one project that works fine that is designed the same way as the ones that do not work right, so it is apparently not a Windows problem.

At this point, I don't even know what the "Offending code" is, so I do not know what to offer for trouble shooting.

If any one has any ideas, PLEASE let me know!

TIA

Ralph D. Meredith

http://www.merecosoftware.com