Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange experience in SQL 2008 when connecting
Message
 
 
To
29/06/2009 14:08:21
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
Application:
Desktop
Miscellaneous
Thread ID:
01408945
Message ID:
01409153
Views:
53
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform