Re: Connect to Sql server using DSN?

From: Ben (Ben_at_discussions.microsoft.com)
Date: 09/09/04

  • Next message: Dan Nash: "authentification" 
    Date: Thu, 9 Sep 2004 00:31:11 -0700

    Hi,

    Got to use the odbc .net data provider?

    Our application is already using Sql server .net data provider. Is it as
    easy as switching to the odbc .net data provider? Will the the codes for the
    Sql server .net data provider will work in the odbc .net data provider as
    well?

    Do you have a sample connection string that utilizes the DSN?

    Thanks,
    Ben

    "Ken Schaefer" wrote:

    > Yes...
    >
    > Cheers
    > Ken
    >
    > "Ben" <Ben@discussions.microsoft.com> wrote in message
    > news:04C1C471-1245-4270-A8AF-83F8A786598D@microsoft.com...
    > > Hi,
    > >
    > > Is it posssible to connect to Sql Server using DSN?
    > >
    > > Thanks,
    > > Ben
    > >
    >
    >
    >

  • Next message: Dan Nash: "authentification"

    Relevant Pages

    • Re: How to use DataReader to retrive data from the database
      ... why are you using OleDb to connect to SQL Server instead of the ... native .NET data provider? ... > it so that I can retrive the PassType information from the DataBase ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Is TDS used only if server is local?
      ... ADO.NET drivers are listed: ... In reference to SQL Server .NET Data Provider, here is what the author says, ... TDS is SQL ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Dot Net 2.0 or SQL Server 2005 problem?
      ... When connecting to SQL Server one should use the SqlClient .NET Data Provider. ... This ConnectionString will not be correct for the Odbc .NET data provider or the Oledb .NET data provider. ... not associated with a trusted SQL Server connection. ... (Incidentally I am running Windows XP Pro and my Windows login id has ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Microsoft SQL Desktop Engine - using
      ... > Or, you could use alternatives to SQL server, like mySql. ... There is an excellent native .NET data provider available from CoreLabs, ... akin to SQL Server Enterprise Manager ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Connecting Access MDBs to SQL databases
      ... >> In Control Panel you set up a DSN that points to the SQL Server ... Never tried the IN clause against ODBC. ... ISeries box and I have never been able to get DSNLess to work against those. ...
      (comp.databases.ms-access)