4 replies
by kaleey666 Accepted solution
by robaaaaaa2 Accepted solution
The best way to do this is to change your connection method - I presume you open the database connection in sub Main() ? put your executable in a server shared folder (so the users run the .exe from the server) and use a .udl file (Universal Dat Link), so in my sub Main() I have:
Set cnCP = New ADODB.Connection
cnCP.Open "file name=" & App.Path & "\MyDatabase.udl"
This method will then work with *any* odbc database, access, SQLServer, Oracle....
by steve.ingle Accepted solution
IMHO, using udl's is a glaring security hole.
However, if your network environment is well locked down, it's quick and easy
by unni_kcpm Accepted solution
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer
You need to use the given connection string with the required parameters for getting connected to the Server/SQL Server.
Trust above helps.
Best Wishes
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending