Ok cheers for that, I'll give it a go. I think I may also cause myself
more problems by not having a username or password for the ODBC
connection.
more problems by not having a username or password for the ODBC
connection.
--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:
>
> This may help:
>
> Sample of my 'odbc' conn string, using in vb 6.0, merant driver,
Progress:
>
> adoConnect.ConnectionString =
"DSN=eeVantage_Mfg;HOST=eevantage;PORT=6150;DB=mfgsys;UID=odbcuser;PWD=odbcuser;Mode=Read"
>
>
>
> jonnyfatman666 <jonathan.waines@...> wrote:
> Hi All,
>
> Bit of a long shot this, but I wanted to try and create a Data View
> for some tables in our DB in Sharepoint designer. Unfortunately, it
> need the ODBC connection information in a long string.
> I've tried looking at various sources including help and cannot get
> it to work. ODBC is set up and working on all the machines involved.
>
> Any ideas?
>
> Info
> ============
> Server name:enigma
> database name: vantage
> odbc port:2960
> entry in SERVICES file: odbc40
> database connection method:Direct
> Database location:f:\epicor\vantage\db\
>
> Cheers,
>
> Jonathan
>
>
>
>
>
>
> ---------------------------------
> Get the Yahoo! toolbar and be alerted to new email wherever you're
surfing.
>
> [Non-text portions of this message have been removed]
>