Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2011, 03:24 PM
PixelTech PixelTech is offline
Junior Member
 
Join Date: Jul 2011
Posts: 3
Default How to Make Ms SQL Server Ado Connection , ConnectionString details Security ?

Dear Friends , i want to make 1 client software to connect my mssql web database of my website, companyes will use this client to save products to web site and change price , so if i use ado connection string in my exe , when i open winhex editor , i can see my connection string details in hex editor , and anybody can hack my sql server database if they read connection from client , how can i hide connection string details in exe ? or i must use another way
Reply With Quote
  #2  
Old 07-06-2011, 08:11 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,333
Default

Don't set the connection @designtime, set it @runtime. Since it's not compiled in the .exe it shouldn't be readable in the hex...
And don't compile with debug information (DEBUG)
Reply With Quote
  #3  
Old 07-06-2011, 09:18 AM
PixelTech PixelTech is offline
Junior Member
 
Join Date: Jul 2011
Posts: 3
Default

how i can make it in runtime ? i dont know way to use ado connection string in runtime , i can only make it in exe , can you explain and teach me please what i must to do ?
Reply With Quote
  #4  
Old 07-06-2011, 09:19 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,333
Default

There's a property ConnectionString, just assign this in your datamodule create
Reply With Quote
  #5  
Old 07-06-2011, 09:21 AM
PixelTech PixelTech is offline
Junior Member
 
Join Date: Jul 2011
Posts: 3
Default

how i can make it ? i use ado connection , and i make build connection.string and it is all ,but when i see in winhex ediyor i can read all my details , how i can make property ConnectionString ? how i can start to make it ?
Reply With Quote
  #6  
Old 07-07-2011, 07:51 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,333
Default

have you tried the debug trick in my first post?
For the connectionstring @runtime I will refer to google, tons of examples to be found there...
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:52 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.