Code to verify DSN

[Jeremy]

Does anyone have a simple code that will verify whether or not the DSN
I had the ISP set up is working? I can't seem to get it right...
Thanks,

Jeremy

[Bob Barrows [MVP]]

Jeremy wrote:

> Does anyone have a simple code that will verify whether or not the DSN
> I had the ISP set up is working? I can't seem to get it right...
> Thanks,
>
> Jeremy

Don't bother. Use DSN-less connection strings, preferably with the native
OLEDB provider for your database. MS has deprecated the OLEDB Provider for
ODBC, so the use of DSN's is discouraged.

See [url]www.connectionstrings.com[/url] or [url]www.able-consulting.com/ado_conn.htm[/url] for
details.

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Jeremy Zifchock]

Bob Wrote:

> Don't bother. Use DSN-less connection strings, preferably > with the

native OLEDB provider for your database. MS has > deprecated the OLEDB
Provider for ODBC, so the use of > DSN's is discouraged.


I'm having trouble with that because the ISP server has, from what they
tell me, a UNIX file structure This is what I get when I do a
server.mappath:

\\H-FILER01\Webfolder\weburl\folder\..

Since there isn't a clear windows path, I don't think I have a choice
but to go via DSN, right??

Jeremy

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows [MVP]]

Jeremy Zifchock wrote:

> Bob Wrote:

>> Don't bother. Use DSN-less connection strings, preferably > with the

> native OLEDB provider for your database. MS has > deprecated the OLEDB
> Provider for ODBC, so the use of > DSN's is discouraged.
>
>
> I'm having trouble with that because the ISP server has, from what
> they tell me, a UNIX file structure This is what I get when I do a
> server.mappath:
>
> \\H-FILER01\Webfolder\weburl\folder\..
>
> Since there isn't a clear windows path, I don't think I have a choice
> but to go via DSN, right??
>

I've no experience with Unix boxes, but have you tried using the path you
get from MapPath in a connection string?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Aaron Bertrand - MVP]

That looks like a UNC path, not a "UNIX file structure"... ask the web host
again. Are you sure you are running ASP pages on a Unix server (using
ChiliSoft, ...?)? I think it is more likely that the file server is
referenced differently, using a UNC share. See [url]http://www.aspfaq.com/2168[/url]
for some information about connecting to an Access database on a separate
share. Or, just upload the MDB file to your web root somewhere, and refer
to it relatively. This other nonsense sounds like a real hassle.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eac#nAROEHA.1644@TK2MSFTNGP09.phx.gbl...

> Jeremy Zifchock wrote:

> > Bob Wrote:

> >> Don't bother. Use DSN-less connection strings, preferably > with the

> > native OLEDB provider for your database. MS has > deprecated the OLEDB
> > Provider for ODBC, so the use of > DSN's is discouraged.
> >
> >
> > I'm having trouble with that because the ISP server has, from what
> > they tell me, a UNIX file structure This is what I get when I do a
> > server.mappath:
> >
> > \\H-FILER01\Webfolder\weburl\folder\..
> >
> > Since there isn't a clear windows path, I don't think I have a choice
> > but to go via DSN, right??
> >

>
> I've no experience with Unix boxes, but have you tried using the path you
> get from MapPath in a connection string?
>
> Bob Barrows
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Aaron Bertrand - MVP]

Sorry Bob, that reply was meant for Jeremy, not you.

[Bob Barrows [MVP]]

Aaron Bertrand - MVP wrote:

> Sorry Bob, that reply was meant for Jeremy, not you.

NP - it made me take another look, which made me realize that you were
right.
Bob
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.