ADO connection

Yahoo Archive
1
DSN=Vantage 51;HOST=ace-
apps01;PORT=3550;DB=vantage;UID=SYSPROGRESS;PWD=sysprogress;OLE DB
Services = -2"

This connection string uses an existing system DSN already
configured to use the SQL92 driver. Your string calls out a
provider that isn't needed if you use a DSN. In your case Vtrain.
The Vtrain already has the provider. Other connection string
properties aren't valid with the ODBC driver, but will not cause any
errors. You need to use the proper port numbers in your sting.
Your string shows 1234. Is that the actual port number you have
configured for the ODBC server on your training database?

--- In vantage@yahoogroups.com, "joeyloken" <joeyloken@y...> wrote:
> I am trying to connect to Vantage using ADO and really need help
with
> the connection string! I want to connect through Excel to pull out
> the Part Master table for other uses. This is what I have (doesn't
> work):
>
> cn.Open "Provider=MSDASQL.1";Persist Security Info=False;User
> ID=something;Extended
>
Properties="DSN=Vtrain;HOST=Vntg;PORT=1234;DB=Vantage;UID=something"
>
> If you can help me figure out this string or if you have similar
code
> and would n't mind sharing, I'd appreciate it!
>
> TIA,
> J
2
I am trying to connect to Vantage using ADO and really need help with
the connection string! I want to connect through Excel to pull out
the Part Master table for other uses. This is what I have (doesn't
work):

cn.Open "Provider=MSDASQL.1";Persist Security Info=False;User
ID=something;Extended
Properties="DSN=Vtrain;HOST=Vntg;PORT=1234;DB=Vantage;UID=something"

If you can help me figure out this string or if you have similar code
and would n't mind sharing, I'd appreciate it!

TIA,
J