473,324 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Connection to SQL database at Client Sites

I'm beginning a project to move an Access App to .NET. The project
manager is saying that we are web hosting the .net app, but each
client site will only connect to their own sql server. Is this even
possible? Isn't there a better way to do this? We have hundreds of
clients that use our software at their sites and they all have their
own SQL server w/ System DSN that the Access app connects to.

Also, can anyone point me to some reference books I should buy? I'm a
beginner with .NET.

Thanks,
Shelley

May 24 '07 #1
2 1121

<sb*****@comcast.netwrote in message
news:11**********************@q69g2000hsb.googlegr oups.com...
I'm beginning a project to move an Access App to .NET. The project
manager is saying that we are web hosting the .net app, but each
client site will only connect to their own sql server. Is this even
possible? Isn't there a better way to do this? We have hundreds of
clients that use our software at their sites and they all have their
own SQL server w/ System DSN that the Access app connects to.
With .NET, you can set up the connection string in the config file. If this
is a web app, create an installer that allows them to pick a SQL Server to
use. With desktop apps, you have to create a method for people at the
company to embed their connection strings into the install. This involves a
custom installer project. There are examples on the MSDN site. You will want
to give them the abilty to encrypt the connection strings on install.

These concepts are probably pretty complex sounding right now, but there are
plenty of examples in the Quickstarts that install with .NET, as well as on
the MSDN site (msdn.microsoft.com). It will take a bit of a learning curve,
but you will make it through.
Also, can anyone point me to some reference books I should buy? I'm a
beginner with .NET.

For books, aim for the beginner's series from Wrox or Step-By-Step from
Microsoft Press. Both are good, easy resources for people who are just
starting out.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************************************************
Think outside the box!
************************************************
May 24 '07 #2
Thank you! Very helpful :-)

Shelley

May 24 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Matthew Wells | last post by:
FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I...
1
by: stewart | last post by:
I've got the standard SqlCacheDependency working just fine , ie. I've defined (and encrypted) the connectionStrings section in the web.config, and I've also defined an an sqlCacheDependency in the...
14
by: Brad Allison | last post by:
Sorry to repeat myself if this is the same question I asked in the past, but I have finally made a connection to our AS400 through ODBC. I tried to get the connection using the data connection...
5
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.