Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Including port 1433 to the conn string?
Message
 
 
À
01/02/2013 11:43:27
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01564928
Message ID:
01564932
Vues:
48
1433 is default SQL Server port. Your application should work as is.

>
>The client informed me that in order for my VFP application to connect to the SQL Server it has to be done via DSN with the option "dynamically determine port" to be unchecked since the SQL server is listening on static port 1433. My VFP 9 application connects to the SQL Server via DSN-less ODBC connection. My question, if I include the SQL Server IP and the port in the connection string, should it work just like it would with DSN? For example, if I include in the connection string the following:
>
>"ADDRESS=175.33.33.09,1433"
>
>should it work? TIA.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform