Moving from SQL connection to a DSN...

Carlos Sosa Albert · Joined: 08 Aug 2007 Posts: 3

Hi guys,

I have a website that was working using a Microsoft SQL Server (SqlClient)
and XSDs.
Now it has to be moved to a DSN connection (that also points to a SQL
Server).

But I'm clueless about what should I change and where... Or even if is still
going to work...

Any help please?

Archived from group: microsoft>public>dotnet>framework>odbcnet

Paul Clement · Joined: 08 Aug 2007 Posts: 154

On Tue, 26 Jun 2007 14:45:48 -0300, "Carlos Sosa Albert" wrote:

¤ Hi guys,
¤
¤ I have a website that was working using a Microsoft SQL Server (SqlClient)
¤ and XSDs.
¤ Now it has to be moved to a DSN connection (that also points to a SQL
¤ Server).
¤
¤ But I'm clueless about what should I change and where... Or even if is still
¤ going to work...

You're really moving backwards with respect to technology here. The use of a DSN is strictly ODBC
(and dated) technology which means that you will have to use the System.Data.Odbc library with the
SQL Server ODBC driver instead of the native .NET SQL Server library.

Paul
~~~~
Microsoft MVP (Visual Basic)

AS/400 connection problems For years we have been using Microsoft Access to transfer data to/from an AS400 using the Client Access ODBC connection. We are now having problems with the connections where the data looks garbled when you open a table, or it will say #DELETED in the f

mysql connection with C#.net Can anybody tell me how to connect mysql server in C#.NET? From: Nivrutti Khandade Posted by a user from .NET 247

Open connection Hi I have an application working with Sybase 12.5. They don't be in the same computer. When I disconnect my application from the network I receive an exception: Sybase network connection has terminated. If a transaction was in progress it has been aborted

Connection Issue - .NET and Oracle I'm having a very strange issue with an application I'm building. The applicaiton has multiple users, each with their own connection to the database. However, when one of these connections closes then all the other users connections seem to close. This

pervasive data connection hi I create a System DSN which connect to the Pervasive database located on a computer in the network. How can I write the code to connect to the database? or is there a namespace that I can use? Thanks a lot