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--