http://www.microsoft.com/downloads/details.aspx?familyid=3Db34a83f1-8fd3-= 4a1e-a423-e2cb0c16c0a8&displaylang=3Den
Could someone explain where this application goes wrong and let me know = where to set it right. It does not work as written. The VBCOM+SQL = part. Thanks.
-- George Hester
__________________________________Hi George.
That's a very open question - could you perhaps define it a bit by
describing the actual problem you're experiencing?
Keep in mind that this is a SQL Server newsgroup & perhaps any VB/COM
aspects of your question may be better asked in their respective newsgroups.
Otherwise, seasons greetings!
Regards,
Greg Linwood
SQL Server MVP
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
http://www.microsoft.com/downloads/details.aspx?familyid=b34a83f1-8fd3-4a1e-a423-e2cb0c16c0a8&displaylang=en
Could someone explain where this application goes wrong and let me know
where to set it right. It does not work as written. The VBCOM+SQL part.
Thanks.
--
George Hester
__________________________________|||Hi Greg thanks for responding. I wish I could tell you something that =went wrong. I can't. There were no errors of any kind. None. So I =assume from that all the SQL Server connections were correct. But I =have no products at all. I looked in the table in SQL and they are all =like Product1, Product2,... and so on. But in any case I get nothing =the login doesn't work (I can login by chossinng add a user and just hit =submit) at all and all in all it just doesn't work. Oh well I thought =maybe someone here may have tried this example in the past and could =tell me what they did to get it to work. If they said, "Well I followed =the directions" then actually that would be enough for me since I did =change the connection string to allow IUSR_MachineName to connect. But =since I am not getting any connection errors I assume the issue is not =there.
-- George Hester
__________________________________
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message =news:OEgMFnbyDHA.540@.tk2msftngp13.phx.gbl...
> Hi George.
> > That's a very open question - could you perhaps define it a bit by
> describing the actual problem you're experiencing?
> > Keep in mind that this is a SQL Server newsgroup & perhaps any VB/COM
> aspects of your question may be better asked in their respective =newsgroups.
> > Otherwise, seasons greetings!
> > Regards,
> Greg Linwood
> SQL Server MVP
> > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
> =http://www.microsoft.com/downloads/details.aspx?familyid=3Db34a83f1-8fd3-=
4a1e-a423-e2cb0c16c0a8&displaylang=3Den
> > Could someone explain where this application goes wrong and let me =know
> where to set it right. It does not work as written. The VBCOM+SQL =part.
> Thanks.
> > -- > George Hester
> __________________________________
> >|||Hi George.
I feel for you brother! I've been through similar experiences with products
that you download, hoping that things will just work straight up & more
times than not, there's something that bites you in the ass.. I guess it at
least helps us appreciate when things work as they should.
One thing I'd suggest is to use SQL Profiler to peek into the background SQL
Server activity. That way you'll at least get the opportunity to see what's
going on (if anything) at the SQL level. Other options may be to attach the
Win32 debugger to the VB process or other debuggers such as VC++, softice
etc - these will give you some insight into the VB executable's activity.
COM+ has a few GUI features that let you view activity within it's runtime
as well.. Perhaps using these tools, you might be able to at least glean at
what component levels things are / aren't happening.
HTH
Regards,
Greg Linwood
SQL Server MVP
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:emCrfRcyDHA.2148@.TK2MSFTNGP12.phx.gbl...
Hi Greg thanks for responding. I wish I could tell you something that went
wrong. I can't. There were no errors of any kind. None. So I assume from
that all the SQL Server connections were correct. But I have no products at
all. I looked in the table in SQL and they are all like Product1,
Product2,... and so on. But in any case I get nothing the login doesn't
work (I can login by chossinng add a user and just hit submit) at all and
all in all it just doesn't work. Oh well I thought maybe someone here may
have tried this example in the past and could tell me what they did to get
it to work. If they said, "Well I followed the directions" then actually
that would be enough for me since I did change the connection string to
allow IUSR_MachineName to connect. But since I am not getting any
connection errors I assume the issue is not there.
--
George Hester
__________________________________
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:OEgMFnbyDHA.540@.tk2msftngp13.phx.gbl...
> Hi George.
> That's a very open question - could you perhaps define it a bit by
> describing the actual problem you're experiencing?
> Keep in mind that this is a SQL Server newsgroup & perhaps any VB/COM
> aspects of your question may be better asked in their respective
newsgroups.
> Otherwise, seasons greetings!
> Regards,
> Greg Linwood
> SQL Server MVP
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
>
http://www.microsoft.com/downloads/details.aspx?familyid=b34a83f1-8fd3-4a1e-a423-e2cb0c16c0a8&displaylang=en
> Could someone explain where this application goes wrong and let me know
> where to set it right. It does not work as written. The VBCOM+SQL part.
> Thanks.
> --
> George Hester
> __________________________________
>|||OK thanks you gave me some ideas on where to "poke" or "peek" as the =case may be. I hate it when we run something that is errorless but =don't work. If there was an error I'd at least know where to start. It =might be in the COM dll. The directions were a little vague in that =part. I basically wung it.
-- George Hester
__________________________________
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message =news:eiLnehcyDHA.1908@.TK2MSFTNGP10.phx.gbl...
> Hi George.
> > I feel for you brother! I've been through similar experiences with =products
> that you download, hoping that things will just work straight up & =more
> times than not, there's something that bites you in the ass.. I guess =it at
> least helps us appreciate when things work as they should.
> > One thing I'd suggest is to use SQL Profiler to peek into the =background SQL
> Server activity. That way you'll at least get the opportunity to see =what's
> going on (if anything) at the SQL level. Other options may be to =attach the
> Win32 debugger to the VB process or other debuggers such as VC++, =softice
> etc - these will give you some insight into the VB executable's =activity.
> COM+ has a few GUI features that let you view activity within it's =runtime
> as well.. Perhaps using these tools, you might be able to at least =glean at
> what component levels things are / aren't happening.
> > HTH
> > Regards,
> Greg Linwood
> SQL Server MVP
> > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:emCrfRcyDHA.2148@.TK2MSFTNGP12.phx.gbl...
> Hi Greg thanks for responding. I wish I could tell you something that =went
> wrong. I can't. There were no errors of any kind. None. So I =assume from
> that all the SQL Server connections were correct. But I have no =products at
> all. I looked in the table in SQL and they are all like Product1,
> Product2,... and so on. But in any case I get nothing the login =doesn't
> work (I can login by chossinng add a user and just hit submit) at all =and
> all in all it just doesn't work. Oh well I thought maybe someone here =may
> have tried this example in the past and could tell me what they did to =get
> it to work. If they said, "Well I followed the directions" then =actually
> that would be enough for me since I did change the connection string =to
> allow IUSR_MachineName to connect. But since I am not getting any
> connection errors I assume the issue is not there.
> > -- > George Hester
> __________________________________
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:OEgMFnbyDHA.540@.tk2msftngp13.phx.gbl...
> > Hi George.
> >
> > That's a very open question - could you perhaps define it a bit by
> > describing the actual problem you're experiencing?
> >
> > Keep in mind that this is a SQL Server newsgroup & perhaps any =VB/COM
> > aspects of your question may be better asked in their respective
> newsgroups.
> >
> > Otherwise, seasons greetings!
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "George Hester" <hesterloli@.hotmail.com> wrote in message
> > news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
> >
> =http://www.microsoft.com/downloads/details.aspx?familyid=3Db34a83f1-8fd3-=
4a1e-a423-e2cb0c16c0a8&displaylang=3Den
> >
> > Could someone explain where this application goes wrong and let me =know
> > where to set it right. It does not work as written. The VBCOM+SQL =part.
> > Thanks.
> >
> > -- > > George Hester
> > __________________________________
> >
> >
> >|||Did you add IUSR_machinename as a valid SQL login?
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23V3HDGbyDHA.2620@.TK2MSFTNGP09.phx.gbl...
http://www.microsoft.com/downloads/details.aspx?familyid=b34a83f1-8fd3-4a1e-a423-e2cb0c16c0a8&displaylang=en
Could someone explain where this application goes wrong and let me know
where to set it right. It does not work as written. The VBCOM+SQL part.
Thanks.
--
George Hester
__________________________________
No comments:
Post a Comment