Re: how do you specify a port # when setting up a TadoConnection?

I also created an ODBC datasource and used it to access my SQL tables from
an Access 2000 mdb. It works just fine too. But if I use that same ODBC
datasource in a TAdoConnection using the ODBC settigns it doesn't work at
all. It fails.

keith

"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
news:43789880$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> I don't have an answer but a couple more questions
> First have you run the Server network utility to make sure Tcp/IP is
installed
> for SQL server

Yes it's installed. I use it for MS Access/SQL (DSN's) and unless I don't
understand something, how could I use the Network utility to change the SQL
port if TCP/IP were not installed? Is that possible?

> Second if you run the Data Link property editor and enter your server as
> <server name>.<Port#> then press the Test button does the test connection
work?

Interestingly I can do it from outside of Delphi but not in Delphi. If I
create a Test.udl object on my desktop and set the connection up it works
just fine. When I use the Data Link properties editor to create the
connection strign for the TAdoConnection object in Delphi it fails. It's the
same editor. I assume Delphi is just opening up what's in Windows. Maybe
this is a bug in D7.1? Another thing that's interesting about this is that
if I don't use the port# in the Test.udl it also works (my port is
not 1433).

> What version of MDAC are you using and have you tried updating your
version
2.81. I keep it updated when necessary.

> You may just have a corrupted MDAC. You can do an internet search and
find
> directions to replace your MDAC version

This is doubtful. My brother has the exact same problem on an entirely
different computer running Windows XP (I'm running Win2kPro) 8000 miles from
me.

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx




.

Quantcast