Re: URGENT HELP ADODB VbScript vs ADODB.ConnectionClass() C#
From: Silvia Brunet Jones (SilviaBrunetJones_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Random: "Deserializing arrays"
- Previous message: Feroze [msft]: "Re: HttpWebRequest and local IPEndPoint"
- In reply to: Cowboy \(Gregory A. Beamer\) [MVP]: "Re: URGENT HELP ADODB VbScript vs ADODB.ConnectionClass() C#"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 13:48:02 -0700
yes the dsn is set up. I am not sure though how could I get away from it since that is the only way I am able to connect to the db
"Cowboy (Gregory A. Beamer) [MVP]" wrote:
> Did you set up the DSN on the server, as well.
>
> NOTE: If you can move away from DSNs, it is the wisest option, as they are
> perf pigs.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ************************************************
> Think Outside the Box!
> ************************************************
> "Silvia Brunet Jones" <SilviaBrunetJones@discussions.microsoft.com> wrote in
> message news:AA4539E5-2BF6-4B20-9C6F-B71E2371D6FD@microsoft.com...
> > ok this is the craziest thing every. I have a piece of code that connects
> to a dsn database. I have tested the connection two different ways
> >
> > ************************ONE
> > using ADODB;
> > ADODB.Connection dbSupra = new ADODB.ConnectionClass();
> > dbSupra.Open("DSN=112","urs","pss",0);
> > ************************TWO
> > using System.Data.OleDb;
> > OdbcConnection dbSupra = new OdbcConnection();
> > dbSupra.ConnectionString = "DSN=112;UID=urs;PWD=pss";
> > dbSupra.Open();
> >
> > run the web page from my development web server which is inside our
> network and works like a charm. PERFECT
> >
> > now I upload the exact same code to my production web server which is in
> between our network and a pix and =( doesnt work error
> > Exception Details: System.Runtime.InteropServices.COMException:
> Unspecified error WHY??????????!!!!!!!!!!
> >
> > now I did this crazy test I build an asp page using vbscript
> > <%@ language=VBSCRIPT%>
> > <%
> > set db=Server.CreateObject("adodb.Connection")
> > dbSupra.Open("DSN=112","urs","pss",0);
> >
> > this WORKS both in my dev web server and my production web server.
> >
> > So first i thought is was the firewall setting but then why does the
> vbscript code can connect to the server.
> >
> > PLEASE some enlightening would be appreciated
> >
> > Silvia Brunet Jones
> > Programmer Analyst, MCSD.NET\MCDBA
> >
>
>
>
- Next message: Random: "Deserializing arrays"
- Previous message: Feroze [msft]: "Re: HttpWebRequest and local IPEndPoint"
- In reply to: Cowboy \(Gregory A. Beamer\) [MVP]: "Re: URGENT HELP ADODB VbScript vs ADODB.ConnectionClass() C#"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
