ado and odbc problem

[12345]

I install a update to date ODBC and running following code to connect with
DSN and get following error.
My server binds with 2 IP and hosts 2 separate web. e.g. A and B. I test the
code in web A. It is ok but fails in B. I don't know why. because the same
environment for running code. The only difference is 2 web with 2 dfiferent
IP. Please help. thx.




Set Conn = Server.CreateObject("ADODB.Connection")
//conn.ConnectionString = "DSN=connect_sql"


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

[Bob Barrows [MVP]]

12345 wrote:

> I install a update to date ODBC and running following code to connect
> with DSN and get following error.
> My server binds with 2 IP and hosts 2 separate web. e.g. A and B. I
> test the code in web A. It is ok but fails in B. I don't know why.
> because the same environment for running code. The only difference is
> 2 web with 2 dfiferent IP. Please help. thx.
>
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> //conn.ConnectionString = "DSN=connect_sql"
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified

I don't know why your problem is occurring, but I strongly suspect you would
have no problem if you would stop using ODBC. Use the native OLEDB provider
for your database instead of the deprecated OLEDB Provider for ODBC.

See [url]www.connectionstrings.com[/url] or [url]www.able-consulting.com/ado_conn.htm[/url] for
OLEDB connection string examples.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Cowboy]

Consider dropping ODBC. Either that or open the .dsn file and post the conn
string that works and the one that does not. Currently, we are shooting
blind here.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"12345" <tommychu@landsearch.com.hk> wrote in message
news:OuFA806REHA.3504@TK2MSFTNGP09.phx.gbl...

> I install a update to date ODBC and running following code to connect with
> DSN and get following error.
> My server binds with 2 IP and hosts 2 separate web. e.g. A and B. I test

the

> code in web A. It is ok but fails in B. I don't know why. because the same
> environment for running code. The only difference is 2 web with 2

dfiferent

> IP. Please help. thx.
>
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> //conn.ConnectionString = "DSN=connect_sql"
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
>
>

[12345]

Thanks.
Actually, I use asp to connect to mySQL and use the tailor-made MySQL ODBC
from mysql. My case is that I write a simple asp and connect to MySQL ODBC.
I put this page in 2 different host for test. However, one page is ok and
one fails. 2 web domain is in same server. I only setup 2 different web
domain with 2 different IP only. I tried to make DSN from this server and
test "Connection" to mySQL server. It is okey too. Thus, I don't know why.
Thx.


"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> ¼¶¼g©ó¶l¥ó·s»D
:et5NTJ8REHA.904@TK2MSFTNGP12.phx.gbl...

> 12345 wrote:

> > I install a update to date ODBC and running following code to connect
> > with DSN and get following error.
> > My server binds with 2 IP and hosts 2 separate web. e.g. A and B. I
> > test the code in web A. It is ok but fails in B. I don't know why.
> > because the same environment for running code. The only difference is
> > 2 web with 2 dfiferent IP. Please help. thx.
> >
> >
> >
> >
> > Set Conn = Server.CreateObject("ADODB.Connection")
> > //conn.ConnectionString = "DSN=connect_sql"
> >
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Driver Manager] Data source name not found and no
> > default driver specified

>
> I don't know why your problem is occurring, but I strongly suspect you

would

> have no problem if you would stop using ODBC. Use the native OLEDB

provider

> for your database instead of the deprecated OLEDB Provider for ODBC.
>
> See [url]www.connectionstrings.com[/url] or [url]www.able-consulting.com/ado_conn.htm[/url] for
> OLEDB connection string examples.
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>