Re: How to set the network protocol using dsnless connection to SQL Se

Peter,
If you check the string value of a DSN connection with SQLGETPROP(lnConn,
"ConnectString") are those settings included?
-Anders

"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:44237A96-326B-4DC5-A8CF-8B4FA894200A@xxxxxxxxxxxxxxxx
I'm switching from using ODBC System DSN to DSNless connection to
communicate
with MS SQL Server. When I'm using ODBC System DSN, I can set the
network
protocol and specify port number for TCP/IP. How can I do that with
SQLStringConnect?



.

Relevant Pages

  • GUID not allowed in Find Method
    ... We are currently are using Access 2003 and going to start using SQL Server ... DSN connection The connection seems to work fine and for the most part the ... ' Find the record that matches the control. ... The value of me!has the correct guid information ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Multiple Apps on System DSN on Server from One PC
    ... > Should I use the same Active-X server for the same in a MS SQL Server ... > DSN connection or is it ok to have multiple apps from the same pc using ... You don't need the ActiveX work-around for SQL Server. ...
    (comp.databases.ms-sqlserver)
  • Ole connection not open sql server
    ... i am using CR 8.0 and vb 6.0 and data base is sql server 2000 my application ... work fine with DSN connection and with ole connection the report is not ...
    (microsoft.public.vb.crystal)
  • DSN connection fails when Basic authentication turned on
    ... When I switch on Basic Authentication, ... that pull information from the SQL server fail to make the ... DSN connection with the following message:- ...
    (microsoft.public.inetserver.iis.security)