C# - SQLDriverConnect

**Jeffrey Tan[MSFT]** · Nov 15 '05, 12:07 PM

RE: C# - SQLDriverConnec t

Hi Dale,

Do you hard-coded your data source connection string into your application?
If so, in .Net I think you can use System.Data.Odb c.OdbcConnectio n class
instead.
Also, you can place your connection into the config file to add some
facility.

Hope this helps,
Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| Subject: C# - SQLDriverConnec t
| Date: Fri, 26 Sep 2003 06:30:59 -0700
| Lines: 12
| Message-ID: <202301c38432$6 bea6320$a101280 a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOEMmvqB0Mbm2o cQS66yGg4H3ryJg ==
| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
| Path: cpmsftngxa06.ph x.gbl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.csharp:1875 38
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
|
| Does anyone know what API I need to include to be able to
| use the SQLDriverConnec t function with C#? I was given a
| code example on how to setup my DSN-less connection and I
| keep getting a pop-up dialog box to configure my
| connection. I want to use the SQLDriverConnec t function
| so that I can utilize the SQL_DRIVER_NOPR OMPT parameter.
|
| If anyone has any insight to this it would be greatly
| appreciated.
|
| Thanks,
| Dale
|

**Dale Magnuson** · Nov 15 '05, 12:09 PM

RE: C# - SQLDriverConnec t

The problem that I am having with
System.Data.Odb c.OdbcConnectio n is that it doesn't seem to
contain a SQL_DRIVER_NOPR OMPT parameter anywhere. The
SQLDriverConnec t has an option for this parameter, but I
cannot find one in the ODBC class.

Any suggestions?

[color=blue]
>-----Original Message-----
>
>Hi Dale,
>
>Do you hard-coded your data source connection string into[/color]
your application?[color=blue]
>If so, in .Net I think you can use[/color]
System.Data.Odb c.OdbcConnectio n class[color=blue]
>instead.
>Also, you can place your connection into the config file[/color]
to add some[color=blue]
>facility.
>
>Hope this helps,
>Best regards,
>Jeffrey Tan
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and[/color]
confers no rights.[color=blue]
>
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
>| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
>| Subject: C# - SQLDriverConnec t
>| Date: Fri, 26 Sep 2003 06:30:59 -0700
>| Lines: 12
>| Message-ID: <202301c38432$6 bea6320$a101280 a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Thread-Index: AcOEMmvqB0Mbm2o cQS66yGg4H3ryJg ==
>| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
>| Path: cpmsftngxa06.ph x.gbl
>| Xref: cpmsftngxa06.ph x.gbl[/color]
microsoft.publi c.dotnet.langua ges.csharp:1875 38[color=blue]
>| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
>| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
>|
>| Does anyone know what API I need to include to be able[/color]
to[color=blue]
>| use the SQLDriverConnec t function with C#? I was given[/color]
a[color=blue]
>| code example on how to setup my DSN-less connection and[/color]
I[color=blue]
>| keep getting a pop-up dialog box to configure my
>| connection. I want to use the SQLDriverConnec t[/color]
function[color=blue]
>| so that I can utilize the SQL_DRIVER_NOPR OMPT parameter.
>|
>| If anyone has any insight to this it would be greatly
>| appreciated.
>|
>| Thanks,
>| Dale
>|
>
>.
>[/color]

**Jeffrey Tan[MSFT]** · Nov 15 '05, 12:11 PM

**Dale Magnuson** · Nov 15 '05, 12:12 PM

RE: C# - SQLDriverConnec t

Thank you very much for your response - this is good
news. I assume this means that there is something wrong
with my connection string because I keep getting the
dialog box. I am trying to use a driver to connect to a
Tandem NonStop SQL box and I am getting the dialog box
everytime. I haven't found a lot of resources for what
the connection string should look like.

For a workaround I wrote a function to build the DSN in
the registry on the fly - this seems to work fine, but I
don't know if it is the best solution or not.

Thanks again,
Dale

[color=blue]
>-----Original Message-----
>
>Hi Dale,
>
>For System.Data.Odb c.OdbcConnectio n class, it encapsulats[/color]
the ODBC[color=blue]
>functions.
>It will not prompt the dialog box for connection string,[/color]
so you can use it.[color=blue]
>
>Btw: for Sql Server version upper 7.0, it is recommended[/color]
that use ".NET[color=blue]
>Framework Data Provider for SQL Server",
>it is optimized for Sql Server.
>
>Best regards,
>Jeffrey Tan
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and[/color]
confers no rights.[color=blue]
>
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
>| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
>| References: <202301c38432$6 bea6320$a101280 a@phx.gbl>
><rNjK9DjhDHA.2 676@cpmsftngxa0 6.phx.gbl>
>| Subject: RE: C# - SQLDriverConnec t
>| Date: Mon, 29 Sep 2003 05:40:10 -0700
>| Lines: 72
>| Message-ID: <202701c38686$d 2545e30$a301280 a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| Thread-Index: AcOGhtJUWcvJN4M bTR+LQVNMTrRx8g ==
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
>| Path: cpmsftngxa06.ph x.gbl
>| Xref: cpmsftngxa06.ph x.gbl[/color]
microsoft.publi c.dotnet.langua ges.csharp:1879 68[color=blue]
>| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
>| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
>|
>| The problem that I am having with
>| System.Data.Odb c.OdbcConnectio n is that it doesn't seem[/color]
to[color=blue]
>| contain a SQL_DRIVER_NOPR OMPT parameter anywhere. The
>| SQLDriverConnec t has an option for this parameter, but[/color]
I[color=blue]
>| cannot find one in the ODBC class.
>|
>| Any suggestions?
>|
>|
>| >-----Original Message-----
>| >
>| >Hi Dale,
>| >
>| >Do you hard-coded your data source connection string[/color]
into[color=blue]
>| your application?
>| >If so, in .Net I think you can use
>| System.Data.Odb c.OdbcConnectio n class
>| >instead.
>| >Also, you can place your connection into the config[/color]
file[color=blue]
>| to add some
>| >facility.
>| >
>| >Hope this helps,
>| >Best regards,
>| >Jeffrey Tan
>| >Microsoft Online Partner Support
>| >Get Secure! - www.microsoft.com/security
>| >This posting is provided "as is" with no warranties[/color]
and[color=blue]
>| confers no rights.
>| >
>| >--------------------
>| >| Content-Class: urn:content-classes:message
>| >| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
>| >| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
>| >| Subject: C# - SQLDriverConnec t
>| >| Date: Fri, 26 Sep 2003 06:30:59 -0700
>| >| Lines: 12
>| >| Message-ID: <202301c38432$6 bea6320$a101280 a@phx.gbl>
>| >| MIME-Version: 1.0
>| >| Content-Type: text/plain;
>| >| charset="iso-8859-1"
>| >| Content-Transfer-Encoding: 7bit
>| >| X-Newsreader: Microsoft CDO for Windows 2000
>| >| X-MIMEOLE: Produced By Microsoft MimeOLE[/color]
V5.50.4910.0300[color=blue]
>| >| Thread-Index: AcOEMmvqB0Mbm2o cQS66yGg4H3ryJg ==
>| >| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
>| >| Path: cpmsftngxa06.ph x.gbl
>| >| Xref: cpmsftngxa06.ph x.gbl
>| microsoft.publi c.dotnet.langua ges.csharp:1875 38
>| >| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
>| >| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
>| >|
>| >| Does anyone know what API I need to include to be[/color]
able[color=blue]
>| to
>| >| use the SQLDriverConnec t function with C#? I was[/color]
given[color=blue]
>| a
>| >| code example on how to setup my DSN-less connection[/color]
and[color=blue]
>| I
>| >| keep getting a pop-up dialog box to configure my
>| >| connection. I want to use the SQLDriverConnec t
>| function
>| >| so that I can utilize the SQL_DRIVER_NOPR OMPT[/color]
parameter.[color=blue]
>| >|
>| >| If anyone has any insight to this it would be[/color]
greatly[color=blue]
>| >| appreciated.
>| >|
>| >| Thanks,
>| >| Dale
>| >|
>| >
>| >.
>| >
>|
>
>.
>[/color]

**Jeffrey Tan[MSFT]** · Nov 15 '05, 12:18 PM

RE: C# - SQLDriverConnec t

Hi Dale,

Just as I original said, the suggested .NET Framework Data Provider for SQL
Server uses its own protocol to communicate with SQL Server. It does not
support the use of an ODBC data source name (DSN) when connecting to SQL
Server because it does not add an ODBC layer.

For System.Data.Odb c, if you do not use the DNS, you can specify the user
id and password in connection string, for more details, please refer to the
link below:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/

frlrfSystemData OdbcOdbcConnect ionClassConnect ionStringTopic. asp

Btw: The .NET Framework Data Provider for ODBC is not included in the .NET
Framework version 1.0. If you require the .NET Framework Data Provider for
ODBC and are using the .NET Framework version 1.0, you can download the
.NET Framework Data Provider for ODBC at
http://msdn.microsoft.com/downloads. The namespace for the downloaded .NET
Framework Data Provider for ODBC is Microsoft.Data. Odbc.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| References: <202301c38432$6 bea6320$a101280 a@phx.gbl>
<rNjK9DjhDHA.26 76@cpmsftngxa06 .phx.gbl>
<202701c38686$d 2545e30$a301280 a@phx.gbl>
<R86VqRyhDHA.25 56@cpmsftngxa06 .phx.gbl>
| Subject: RE: C# - SQLDriverConnec t
| Date: Tue, 30 Sep 2003 06:12:41 -0700
| Lines: 149
| Message-ID: <1c5a01c38754$8 7715520$a101280 a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcOHVIduMaArTtk KT7urNfAfpXwUwQ ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
| Path: cpmsftngxa06.ph x.gbl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.csharp:1881 91
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
|
| Thank you very much for your response - this is good
| news. I assume this means that there is something wrong
| with my connection string because I keep getting the
| dialog box. I am trying to use a driver to connect to a
| Tandem NonStop SQL box and I am getting the dialog box
| everytime. I haven't found a lot of resources for what
| the connection string should look like.
|
| For a workaround I wrote a function to build the DSN in
| the registry on the fly - this seems to work fine, but I
| don't know if it is the best solution or not.
|
| Thanks again,
| Dale
|
|
| >-----Original Message-----
| >
| >Hi Dale,
| >
| >For System.Data.Odb c.OdbcConnectio n class, it encapsulats
| the ODBC
| >functions.
| >It will not prompt the dialog box for connection string,
| so you can use it.
| >
| >Btw: for Sql Server version upper 7.0, it is recommended
| that use ".NET
| >Framework Data Provider for SQL Server",
| >it is optimized for Sql Server.
| >
| >Best regards,
| >Jeffrey Tan
| >Microsoft Online Partner Support
| >Get Secure! - www.microsoft.com/security
| >This posting is provided "as is" with no warranties and
| confers no rights.
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| >| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| >| References: <202301c38432$6 bea6320$a101280 a@phx.gbl>
| ><rNjK9DjhDHA.2 676@cpmsftngxa0 6.phx.gbl>
| >| Subject: RE: C# - SQLDriverConnec t
| >| Date: Mon, 29 Sep 2003 05:40:10 -0700
| >| Lines: 72
| >| Message-ID: <202701c38686$d 2545e30$a301280 a@phx.gbl>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| Thread-Index: AcOGhtJUWcvJN4M bTR+LQVNMTrRx8g ==
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
| >| Path: cpmsftngxa06.ph x.gbl
| >| Xref: cpmsftngxa06.ph x.gbl
| microsoft.publi c.dotnet.langua ges.csharp:1879 68
| >| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| >| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
| >|
| >| The problem that I am having with
| >| System.Data.Odb c.OdbcConnectio n is that it doesn't seem
| to
| >| contain a SQL_DRIVER_NOPR OMPT parameter anywhere. The
| >| SQLDriverConnec t has an option for this parameter, but
| I
| >| cannot find one in the ODBC class.
| >|
| >| Any suggestions?
| >|
| >|
| >| >-----Original Message-----
| >| >
| >| >Hi Dale,
| >| >
| >| >Do you hard-coded your data source connection string
| into
| >| your application?
| >| >If so, in .Net I think you can use
| >| System.Data.Odb c.OdbcConnectio n class
| >| >instead.
| >| >Also, you can place your connection into the config
| file
| >| to add some
| >| >facility.
| >| >
| >| >Hope this helps,
| >| >Best regards,
| >| >Jeffrey Tan
| >| >Microsoft Online Partner Support
| >| >Get Secure! - www.microsoft.com/security
| >| >This posting is provided "as is" with no warranties
| and
| >| confers no rights.
| >| >
| >| >--------------------
| >| >| Content-Class: urn:content-classes:message
| >| >| From: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| >| >| Sender: "Dale Magnuson" <magnuson.dale@ mayo.edu>
| >| >| Subject: C# - SQLDriverConnec t
| >| >| Date: Fri, 26 Sep 2003 06:30:59 -0700
| >| >| Lines: 12
| >| >| Message-ID: <202301c38432$6 bea6320$a101280 a@phx.gbl>
| >| >| MIME-Version: 1.0
| >| >| Content-Type: text/plain;
| >| >| charset="iso-8859-1"
| >| >| Content-Transfer-Encoding: 7bit
| >| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| >| X-MIMEOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| >| Thread-Index: AcOEMmvqB0Mbm2o cQS66yGg4H3ryJg ==
| >| >| Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
| >| >| Path: cpmsftngxa06.ph x.gbl
| >| >| Xref: cpmsftngxa06.ph x.gbl
| >| microsoft.publi c.dotnet.langua ges.csharp:1875 38
| >| >| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| >| >| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
| >| >|
| >| >| Does anyone know what API I need to include to be
| able
| >| to
| >| >| use the SQLDriverConnec t function with C#? I was
| given
| >| a
| >| >| code example on how to setup my DSN-less connection
| and
| >| I
| >| >| keep getting a pop-up dialog box to configure my
| >| >| connection. I want to use the SQLDriverConnec t
| >| function
| >| >| so that I can utilize the SQL_DRIVER_NOPR OMPT
| parameter.
| >| >|
| >| >| If anyone has any insight to this it would be
| greatly
| >| >| appreciated.
| >| >|
| >| >| Thanks,
| >| >| Dale
| >| >|
| >| >
| >| >.
| >| >
| >|
| >
| >.
| >
|

C# - SQLDriverConnect

C# - SQLDriverConnect

Comment

Comment

Comment

Comment

Comment