When we deploy applications, we have been using DSN's set up on the
users systems. Then in the sqlconnection string, we go "dsn = xyz". I
tried this with our new application, which is the first to be done
with ADO.net and I get the following run time problem:
"An exception 'System.Argumen tException' has occured in <Myapp>".
I do the run time debugging and it tells me: "Keyword not supported:
'dsn'.
For those who have migrated to .Net, how do you handle this issue? I
mean, we are going to distribute this application, and our users will
have different names for their servers, so how do we specify a data
source dynamically.
The way we have it for the moment is that we read the information from
a config file. But it seems like there must be a better way. What
happened to dsn?
Any help on this would greatly appreciated.
Thanks,
Ed Hawkes ol************* @nospamplease-hotmail.com 2  4326 
Ed Hawkes (ol************ *@hotmail.com) writes: When we deploy applications, we have been using DSN's set up on the
users systems. Then in the sqlconnection string, we go "dsn = xyz". I
tried this with our new application, which is the first to be done
with ADO.net and I get the following run time problem:
"An exception 'System.Argumen tException' has occured in <Myapp>".
I do the run time debugging and it tells me: "Keyword not supported:
'dsn'.
For those who have migrated to .Net, how do you handle this issue? I
mean, we are going to distribute this application, and our users will
have different names for their servers, so how do we specify a data
source dynamically.
The way we have it for the moment is that we read the information from
a config file. But it seems like there must be a better way. What
happened to dsn?
If you despearately need DSN, I would suppose you could use OleDb
client rather than SqlClient.
As for what happened, I guess DSN got of fashion, and I can't say that
I miss it. Our application - which is VB6 - once used DSN, but now you
can specify server and database on the login form (and the values are
saved in registry between invocations), which I very much like. Of course,
end users normally use the same server and database, and it's only
developers like me, who change all the time. But nevertheless, DSNs
is just one more thing that has to be configured, and which could buy
settings you did not expect.
IF you don't want to prompt your users, a config file seems like a
good way to go.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland Sommarskog <es****@sommars kog.se> wrote in message news:<Xn******* *************** @127.0.0.1>... Ed Hawkes (ol************ *@hotmail.com) writes: When we deploy applications, we have been using DSN's set up on the
users systems. Then in the sqlconnection string, we go "dsn = xyz". I
tried this with our new application, which is the first to be done
with ADO.net and I get the following run time problem:
"An exception 'System.Argumen tException' has occured in <Myapp>".
I do the run time debugging and it tells me: "Keyword not supported:
'dsn'.
For those who have migrated to .Net, how do you handle this issue? I
mean, we are going to distribute this application, and our users will
have different names for their servers, so how do we specify a data
source dynamically.
The way we have it for the moment is that we read the information from
a config file. But it seems like there must be a better way. What
happened to dsn?
If you despearately need DSN, I would suppose you could use OleDb
client rather than SqlClient.
As for what happened, I guess DSN got of fashion, and I can't say that
I miss it. Our application - which is VB6 - once used DSN, but now you
can specify server and database on the login form (and the values are
saved in registry between invocations), which I very much like. Of course,
end users normally use the same server and database, and it's only
developers like me, who change all the time. But nevertheless, DSNs
is just one more thing that has to be configured, and which could buy
settings you did not expect.
IF you don't want to prompt your users, a config file seems like a
good way to go.
Erland,
much obliged! I really appreciate the response, and this will help
move our project along. Thanks again.
Cheers,
Ed Hawkes This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ed Hawkes |
last post by:
When we deploy applications, we have been using DSN's set up on the
users systems. Then in the sqlconnection string, we go "dsn = xyz". I
tried this with our new application, which is the first to be done
with ADO.net and I get the following run time problem:
"An exception 'System.ArgumentException' has occured in <Myapp>".
I do the run time debugging and it tells me: "Keyword not supported:
'dsn'.
For those who have migrated to .Net,...
|
by: Manu |
last post by:
I would like to gather data from the user in the startup phase. Then
to create a Configuration variable from which connection objects will
read their connection string. (Dynamic binding)
How can I assign a value to a configuration variable during deployment
phase ?
Is there another way to configure the connection strings of connection
objects during deployment? Where do I write the code?
Is there an example explaining this?
|
by: Vai2000 |
last post by:
Hi All, I have a doubt on WS. Initial deployment of an asp.net app which
calls a websvc includes copying all the webreferences and proxy files
(including the .cs files of the proxy)
If I build a new version of the asp.net app and don't change anything in the
underlying WS or the way it calls it, do I have to copy over all the
webreferences again to the production box? or I can just copy the .dll file
of asp.net app in the bin? (if no aspx...
|
by: Carl Howarth |
last post by:
Hello again everyone..... I'm a real pain and keep posting re the same
thing, but it is possibly the most frustrating issue I've come across.
Please see my original post - can anybody think of a solution to this? The
main error I experience is an sqlexception saying 'General Network Error',
but as this is sporadic, and due to the fact that asp3 apps work fine I am
at a total loss as to what the issue can be.
In addition to this I...
|
by: James Goodman |
last post by:
In VB6 I used to set my applications to automatically look for the source DB in the program installation directory. If it wasnt found it was fairly easy to pop a dialog asking the user to specify the path.
I am writing an app at the moment which will require the user to connect to the DB over a network connection. I am not sure of the connection address at present.
I have created my data-bound forms using server explorer to create the...
| | |
by: Chris Rennert |
last post by:
Hey all, we have a project that we would like to use ClickOnce
deployment on, and although it all seems straightforward we are having a
few issues concerning SQL Server Express and clickonce. We are using C#
for our development language, and the application itself runs fine until
we get to a part that accesses the database. When it tries to hit the
database it bombs saying it can't find it. We even created a connection
string that...
|
by: Brad Isaacs |
last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database.
I am using Visual Studio 2005 and developing on my Local machine. I am
working with Login controls ASP.Configuration, I wanted to move my work
and needed to place it on the server.
Using VS 2005 , went to BUILD
-Publish Web Site
Checked the box for :: Alow this precompiled site to be updatable.
|
by: fniles |
last post by:
I am using VS2003 and connecting to MS Access database.
When using a connection pooling (every time I open the OLEDBCONNECTION I use
the exact matching connection string),
1. how can I know how many connection has been used ?
2. If the maximum pool size has been reached, what happens when I call the
method Open to open the connection ? Will I get an error ? MSDN says the
request is queued, but will I get an error in the open method ?
...
|
by: =?Utf-8?B?UHVuaXQgS2F1cg==?= |
last post by:
Hi,
I am developing a windows application in VS.NET 2005. The application is
database driven and I need to deploy it on a client's pc. How should I go
about developing such an application. I remember I did something once long
back .. like including .mdf files into my project in the solution explorer of
VS 2005 and then used Click Once deployment tool ... to make sure that the
database and tables were created when the client installed my...
|
by: broken472000 |
last post by:
Hi,
i developed one web application using visual studio 2005. before deployment it runs perfectly. when i deployed and try to access pages, i get the following errors. i am using sql server 2005 management studio.what i have to do for avoiding this problem. plz help me.
Server Error in '/' Application.
--------------------------------------------------------------------------------
ExecuteReader requires an open and available...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
