ADO Connection VB6 to SQL Server 2000

[hblabonte]

I'd appreciate some input on this. I'm not a VB programmer, but have been given an application to correct. (I work with SQL Server & Access)

I have an application with VB 6 front-end connecting to SQL Server 2000. The programmer has his SQL ID & Password saved in the application, so that each time it opens it is verifying his ID against SQL Server. The problem is that he no longer works here & so the ID is no longer valid. (Nice programming eh?)

His documentation says " this project is built on dataproject ado technology so no need to create a DSN for this". That's all I've got.

When I go to the data view window, under the data enviornment connections, there is a connection1 listed. When I double click that, the SQL Server login box pops up with his ID & password. This is what I need to change & save with a valid ID.

Can someone point me in the right direction as to where he's saved this information in the application? Again, I'm brand new to VB, so I'd appreciate VERY specific responses.

Thanks in advance,
Heather

 

[ChetShah]

Couple of suggestions to lokk under:

1) The DSN information could have been stored directly withing Windows Registry
2) You could activate the data environment objects and try changing the connection properties programmatically
3)Why not just create a new login which SQL Server can recognise and change it in your data environment hence getting a successful connection

Chet

 

[hblabonte]

"You could activate the data environment objects and try changing the connection properties programmatically"

How?

I do have a valid login to use, but it holds on to the old one somewhere. I have no idea where it's stored or how to force it to remember the one I use to log in with.

I'm trying to figure out where he had it stored to change it.

I know how to do it easily in Access, but that's another story.

thanks,
Heather