Data encryption for results of query using ADO

Hi,
I'm using ADO to connect to a SQL Server.
I want to execute a query which reads sensistive information and ensure that
the results of the query cannot be sniffed on the network
Can I enable encryption for a specific connection to the SQL Server without
forcing either the client machine or sql server to enable
full fledged encryption. I have only one query which returns sensitive
information, hence I do not wish to enable encryption for the all sql server
connections/
using certificates via 'Force Protocol Encryption'
Thanks,
Alwyn
Alwyn,
Take a look at this site: http://www.activecrypt.com/index.htm. You might
want to test the xp_crypt procedures.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Alwyn Pereira" <alwynpereira@.hotmail.com> wrote in message
news:ucXSc9sqEHA.3748@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'm using ADO to connect to a SQL Server.
> I want to execute a query which reads sensistive information and ensure
that
> the results of the query cannot be sniffed on the network
> Can I enable encryption for a specific connection to the SQL Server
without
> forcing either the client machine or sql server to enable
> full fledged encryption. I have only one query which returns sensitive
> information, hence I do not wish to enable encryption for the all sql
server
> connections/
> using certificates via 'Force Protocol Encryption'
> Thanks,
> Alwyn
>

Data encryption for results of query using ADO

Hi,
I'm using ADO to connect to a SQL Server.
I want to execute a query which reads sensistive information and ensure that
the results of the query cannot be sniffed on the network
Can I enable encryption for a specific connection to the SQL Server without
forcing either the client machine or sql server to enable
full fledged encryption. I have only one query which returns sensitive
information, hence I do not wish to enable encryption for the all sql server
connections/
using certificates via 'Force Protocol Encryption'
Thanks,
Alwyn
There isn't anything built-in to support this. I'm afraid you're going
to have to roll your own.
--Mary
On Mon, 4 Oct 2004 19:11:49 +0530, "Alwyn Pereira"
<alwynpereira@.hotmail.com> wrote:

>Hi,
>I'm using ADO to connect to a SQL Server.
>I want to execute a query which reads sensistive information and ensure that
>the results of the query cannot be sniffed on the network
>Can I enable encryption for a specific connection to the SQL Server without
>forcing either the client machine or sql server to enable
>full fledged encryption. I have only one query which returns sensitive
>information, hence I do not wish to enable encryption for the all sql server
>connections/
>using certificates via 'Force Protocol Encryption'
>Thanks,
>Alwyn
>
sql

data connection to fox pro file

Hi,
I have to connect to a foxpro file. What I've attempted thus far is set up a
System DSN. It's pathed to the .dbf file, and I selected the Free Table
Directory option under Database Type. In RS, I choose ODBC driver for my
Provider and for Connection, I choose the DSN I set up. When I try to choose
the Initial catalog, I get an error. The first says The Parameter is
Incorrect and the second says Login failed. Catalog Info cannot be retrieved.
Any suggestions?
Thanks!Try specifying NT user credentials in report data source (or in Report
Manager/Report properties/Datasources if report is already published)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3BDA72CF-9772-4459-9B2C-BDB7F7A850D7@.microsoft.com...
> Hi,
> I have to connect to a foxpro file. What I've attempted thus far is set up
a
> System DSN. It's pathed to the .dbf file, and I selected the Free Table
> Directory option under Database Type. In RS, I choose ODBC driver for my
> Provider and for Connection, I choose the DSN I set up. When I try to
choose
> the Initial catalog, I get an error. The first says The Parameter is
> Incorrect and the second says Login failed. Catalog Info cannot be
retrieved.
> Any suggestions?
> Thanks!|||Hi Clutch,
Try with leaving the Catalog, UserName and Password blank.
Have you considered using the FoxPro and Visual FoxPro OLE DB data provider?
It's downloadable from msdn.microsoft.com/downloads/updates .
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3BDA72CF-9772-4459-9B2C-BDB7F7A850D7@.microsoft.com...
> Hi,
> I have to connect to a foxpro file. What I've attempted thus far is set up
> a
> System DSN. It's pathed to the .dbf file, and I selected the Free Table
> Directory option under Database Type. In RS, I choose ODBC driver for my
> Provider and for Connection, I choose the DSN I set up. When I try to
> choose
> the Initial catalog, I get an error. The first says The Parameter is
> Incorrect and the second says Login failed. Catalog Info cannot be
> retrieved.
> Any suggestions?
> Thanks!

data connection behind firewall

Hello,

I am trying to connect a web app to a SQL 2005 that is behind a firewall.

The challenge is this, the SQL is behind a firewall and the webserver is at a different location. From my desktop development environment, I connect through a VPN first and then can point to the internal IP of the DB server. This works fine as long as the VPN is connected.

But how do I do this from a hosted web application that is not on my local machine or using my VPN?

Is there some sort of tunneling Connection that I can use within code?

thanks

As you are going to deploy the web site to a remote location, to have SQL Connection via Tabular Data Stream would require opening up extra ports (1433 and 1434) - since the days of the Slammer worm, I doubt if any person in charge of a company network would allow these ports to be opended up to the outside world.

Can you deploy a copy of the database to the remote site? You could use SQL Express provided the database size was within 2Gb. Alternatively you write a web service, which only require Port 80 to be open through the firewall from your external host into your DMZ.

|||

Thanks for the reply. The challenge is that there is a database collecting live survey data...and that DB is in a different physical location behind a firewall, etc.

The application I am writting is on a different server/ different building, etc. The DB server has VPN access to it but I don't know how to include that in my code so that my app can talk to it and pull the live data.

(and you are correct, just opening those ports would be dangerous.)

|||

In which case you need to have the database both on the remote server on within your LAN. As it is a survey database, would i be correct to asume that data is only every inserted (unlil a survey is deleted en-mass)?

In which case include a web service on your remote server, set only to respond to the IP address of your LAN. Depending on the senitivity of your data you may elect to run HTTPS for the web service.

The key point is identifying batches of records to copy. Without knowing your database, I cannot comment of the best means of setting up the database to do this. If only inserting as I have suggested that you need a method that will return a manageable block of records. This method will be called by a Windows Service on a machine within your LAN which will then call a "make it so" stored procedure on your local database.

The required ports will be already open from your LAN out and into your remote IIS server.

Data access from multiple datasources

Hi,
How to data access from multiple datasources in a crystal report designer?
For one datasource : we can go for connection and connect to our system DSN via ODBC or Native driver connection.Hi,

You can use subreports to access different datasources, if you want to link data from seperate data sources in one query you can obviously not use this approach. Instead I would use a database link from one database to the other data sources.

- Jukka

Data Access Error - ConnectionString property

Hi guys,

I'm getting this error:

System.InvalidOperationException: The ConnectionString property has not been initialized

when I'm trying to connect to an SQL database using the following code:

Dim mySelectQuery As String = "SELECT [tabl_id] FROM [myTable]"
Dim myConnection As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("myConnString"))
Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
While myReader.Read()
Response.Write(myReader("tabl_id") & "<br/>")
End While
myConnection.Close()

and in web.config:

<appSettings/>
<connectionStrings>
<add name="myConnString" connectionString="Data Source=100.100.100.100;Initial Catalog=myDatabase;User ID=me;Password=password" providerName="System.Data.SqlClient"/>
</connectionStrings>

If I place the actual connection string inside instead of trying to reference the web.config setting it works, but using 'System.Configuration.ConfigurationManager.AppSettings' returns the error. Is there something I'm doing wrong?

Ferox:

Dim myConnection As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("myConnString"))
and in web.config:

<appSettings/>
<connectionStrings>
<add name="myConnString" connectionString="Data Source=100.100.100.100;Initial Catalog=myDatabase;User ID=me;Password=password" providerName="System.Data.SqlClient"/>
</connectionStrings>

hi there,

the connection stirng element in your webconfig is actually not a child node of the appSettings but its on the same level instead. So maybe you wanna get the ConnectionStrings node instead of the AppSettings node out of the web.config.

System.Configuration.ConfigurationManager.ConnectionStrings("myConnString").ConnectionString

see if the above line works.

|||

Thanks a lot, that works perfectly! :)

Data Access Application Block for SQLClient

I download the DAAB CF version. However, most of them use SQLCEClient to connect to the database. Is there any DAAB that use SQLClient?
One workaround that I made is I replaced all SQLCEClient objects with the SQLClient objects. I only test one method "ExecuteDataset" and it works so far. However, my question is "does my workaround a good solution?"

Thanks,
Hendra

You might want to explore the new Mobile Client Software Factory. I believe it has data access blocks for both SQL CE/Mobile and SqlClient contained in the framework. http://msdn.microsoft.com/mobility/default.aspx?pull=/library/en-us/dnpag2/html/mcsflp.asp

Darren