Hi,

I'm using a connection string what has this DataSource :
"PCNAME\INSTANCENAME,1884".

In my application if I don't use name instance and port, it works fine, but
if I use instancename and port don't work.

SQL Server is configured correctly, and Delphi applications works fine with
it.

What is wrong?

Thanks,

Josep

Josep - try using the IP Address ie:

"Data Source=192.168.1.120,1433;
"Josep Solà" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I'm using a connection string what has this DataSource :
> "PCNAME\INSTANCENAME,1884".
>
> In my application if I don't use name instance and port, it works fine,
> but
> if I use instancename and port don't work.
>
> SQL Server is configured correctly, and Delphi applications works fine
> with
> it.
>
> What is wrong?
>
> Thanks,
>
> Josep
>
>

Hi William,

I use IP Address too, but it doesn't work.

Thanks

"W.G. Ryan - MVP" <(E-Mail Removed)> escribió en el mensaje
news:uN2S$(E-Mail Removed)...
> Josep - try using the IP Address ie:
>
> "Data Source=192.168.1.120,1433;
> "Josep Solà" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > I'm using a connection string what has this DataSource :
> > "PCNAME\INSTANCENAME,1884".
> >
> > In my application if I don't use name instance and port, it works fine,
> > but
> > if I use instancename and port don't work.
> >
> > SQL Server is configured correctly, and Delphi applications works fine
> > with
> > it.
> >
> > What is wrong?
> >
> > Thanks,
> >
> > Josep
> >
> >
>
>

Is that port opened? I use that syntax daily and haven't had any problems..
What specific error are you getting?
"Josep Solà" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi William,
>
> I use IP Address too, but it doesn't work.
>
> Thanks
>
> "W.G. Ryan - MVP" <(E-Mail Removed)> escribió en el mensaje
> news:uN2S$(E-Mail Removed)...
>> Josep - try using the IP Address ie:
>>
>> "Data Source=192.168.1.120,1433;
>> "Josep Solà" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm using a connection string what has this DataSource :
>> > "PCNAME\INSTANCENAME,1884".
>> >
>> > In my application if I don't use name instance and port, it works fine,
>> > but
>> > if I use instancename and port don't work.
>> >
>> > SQL Server is configured correctly, and Delphi applications works fine
>> > with
>> > it.
>> >
>> > What is wrong?
>> >
>> > Thanks,
>> >
>> > Josep
>> >
>> >
>>
>>
>
>

Bill,

>I'm not following you here, where does SelectedValue fit in?

Because that the messages you are answering have the same subject as the
original it is in OE probably attached to the one from No So Clever, who
uses a combobox to set his different connectionstrings in the strings (I
have seen that probably you have advised that in far history, I would advise
in such a situation of course always a config.sys).

:-))

He is now moving the SelectedIndex into the connectionstring, probably is
here needed the selectedvalue.

I had not seen it if you had not answered that other question, I found it
all so strange and than I saw this problem as well.

Clear?

:-)

Cor

gotcha
"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Bill,
>
>>I'm not following you here, where does SelectedValue fit in?
>
> Because that the messages you are answering have the same subject as the
> original it is in OE probably attached to the one from No So Clever, who
> uses a combobox to set his different connectionstrings in the strings (I
> have seen that probably you have advised that in far history, I would
> advise in such a situation of course always a config.sys).
>
> :-))
>
> He is now moving the SelectedIndex into the connectionstring, probably is
> here needed the selectedvalue.
>
> I had not seen it if you had not answered that other question, I found it
> all so strange and than I saw this problem as well.
>
> Clear?
>
> :-)
>
> Cor
>

I think I found the solution.

To use instance name I must use ".

For example Data Source = "PCNAME\INSTANCENAME,1884". it works fine.

Thanks to all.

Have a nice XMAS.


"Josep Solà" <(E-Mail Removed)> escribió en el mensaje
news:(E-Mail Removed)...
> Hi,
>
> I'm using a connection string what has this DataSource :
> "PCNAME\INSTANCENAME,1884".
>
> In my application if I don't use name instance and port, it works fine,
but
> if I use instancename and port don't work.
>
> SQL Server is configured correctly, and Delphi applications works fine
with
> it.
>
> What is wrong?
>
> Thanks,
>
> Josep
>
>