Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange experience in SQL 2008 when connecting
Message
 
 
À
29/06/2009 14:08:21
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
Application:
Desktop
Divers
Thread ID:
01408945
Message ID:
01409153
Vues:
54
I'm confused. It's exactly connection string I suggested to you to try in my first message. I guess you didn't read my first message at all because it also explains why you cannot use default port with a named instance.

> Yes I have a default instance of SQL Server, but it's a SQL 2000, and during installation of SQL 2008, the only option was to use a instance other than the default.
>
>But I came out with a way to connect to the SQL 2008 instance without a error and SQL prompt form for the connection.
>I got it using this string
>
>cStringConnect =("Driver={SQL Server Native Client 10.0}; Server=192.168.1.2\SQL10; UID=sa; PWD=zqt321ploc; 
Database=AdventureWorks; Network Library=DBMSSOCN")
>nID = SQLStringConnect(cStringConnect)
>?nid
>=SQLDISCONNECT(0)
>
>
>I see it as an inconsistence of MS, now we have to remove "Address=192.168.1.2,1433" to establish a connection...
>My only question is, and if someone wants to use other port?
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform