RESOLVED - automatically setup a DSN connection with application set-up

[holly]

Hi

I have used the package and deploy wizard to compile a set-up
file of my VB application. Now My application needs to be
installed on several PC's.....The problem I have is that I know the
PC's do not contain a DSN to our SQL server....What I want to
know is, is it possible I could code the set-up of a DSN??? so on
installing my application it would automatically set-up the appropriate
DSN!!!

I bet the answer is NO!!

Thanks

[Mega_Man]

Hmm, I don't think there is. In saying that, if all your connection code is in a module / class, then you could just add a DSN-less connection which would solve your problem.
I don't know the extent of your program and therefore don't know how much work this would be for you.

Mega.

[holly]

then you could just add a DSN-less connection which would solve your problem.

Could you be a bit more explicit!!

All the security information is stored in a *.ini file......You will have to excuse my ignorance but Would I still need to create a DSN if
the information is stored in a INI file? the application needs to be installed on a approx. 100 PC's... if the answer to the above is
YES then I dont fancy installing a DSN on every PC....

[Mega_Man]

Connection.Open "Driver={SQL Server};" & _ 
                            "Server=MyServerName;" & _
                            "Database=myDatabaseName;" & _
                            "Uid=myUsername;" & _
                            "Pwd=myPassword"

This is an example that doesn't need a DSN. You can still have your SQL server IP in the INI file and use what it returns in the above example.

Mega.

[holly]

Thanks a million you have answered my question!!

Thanks again Mega-Man

[Mega_Man]

No problem
Glad I could help.

Mega.