Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > ASP error accessing odbc on xp from nt

Reply
Thread Tools

ASP error accessing odbc on xp from nt

 
 
kilquonk@yahoo.com
Guest
Posts: n/a
 
      03-08-2007
We have an asp script on an NT system that is trying to access a
database on an XP server. When it gets to setting up odbc, it gives an
error on that line in a particular function but doesn't give details.
I can map the network drive by providing username, but I can't use the
odbc to access the info. Any ideas? I set up security to make sure
that I can access it.

 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      03-08-2007
http://www.velocityreviews.com/forums/(E-Mail Removed) wrote:
> We have an asp script on an NT system that is trying to access a
> database on an XP server. When it gets to setting up odbc, it gives an
> error on that line in a particular function but doesn't give details.
> I can map the network drive by providing username, but I can't use the
> odbc to access the info. Any ideas? I set up security to make sure
> that I can access it.


Sorry, but my crystal ball is out for repair today. If you want help,
you will have to provide more details:
1. database type and version
2. actual error message
3. line of code that raises the error
4. intranet or internet? Cross-domain?

I can't guarantee that more questions won't be raised, but you need to
provide at least that much detail to get a meaningful reply.

In the meantime, these might be helpful:
http://www.aspfaq.com/show.asp?id=2126
http://www.aspfaq.com/show.asp?id=2009
http://www.aspfaq.com/show.asp?id=2168

Take a look at these before replying. They may contain your answer.

--
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.


 
Reply With Quote
 
 
 
 
kilquonk@yahoo.com
Guest
Posts: n/a
 
      03-09-2007
On Mar 8, 10:31 am, "Bob Barrows [MVP]" <(E-Mail Removed)>
wrote:
> (E-Mail Removed) wrote:
> > We have an asp script on an NT system that is trying to access a
> > database on an XP server. When it gets to setting up odbc, it gives an
> > error on that line in a particular function but doesn't give details.
> > I can map the network drive by providing username, but I can't use the
> > odbc to access the info. Any ideas? I set up security to make sure
> > that I can access it.

>
> Sorry, but my crystal ball is out for repair today. If you want help,
> you will have to provide more details:
> 1. database type and version
> 2. actual error message
> 3. line of code that raises the error
> 4. intranet or internet? Cross-domain?
>
> I can't guarantee that more questions won't be raised, but you need to
> provide at least that much detail to get a meaningful reply.
>
> In the meantime, these might be helpful:http://www.aspfaq.com/show.asp?id=21...ow.asp?id=2168
>
> Take a look at these before replying. They may contain your answer.
>
> --
> 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.


Thanks for the response. It's an ASI ProfitPlus database. Error
follows:
Error in ActiveX Server:C:\WINNT\SYSTEM32\INETSRV\INETINFO.EXE
Object:ASIECOMCLASS Service: DEFCUSTOMERINFO error '800a03e8'
Description: VARIABLE NOT INITIALIZED Subsystem: BASE Function:
IVARGET Argument: {(0x0000)0x00000000} CLASS
/manheim/login.asp, line 139
Code: Aok = odbservermanager.defcustomerinfo(actn, custno,
sessnid)
The ASP is on an NT machine that's accessed via the internet. The code
accesses the server that holds the database. We've had the database on
98 and have been using this for years. We're trying to move the
database to an XP machine, and the code's having a problem at that
point when it tries to access it. We called the software manufacturer,
and they were unable to help us. They got a copy of the asp code to
look at it, but they haven't gotten back to us in a week. I'm figuring
that it's a security issue, but I've made all the proper settings that
I know. I can map the XP drive from NT if I provide a username.

 
Reply With Quote
 
kilquonk@yahoo.com
Guest
Posts: n/a
 
      03-09-2007
Here's the odbc code. It works if we refer it to the database on 98 or
a copy of it on the NT machine. It just won't work when accessing the
XP.
set odbservermanager = server.createobject( "asiecom.object" )
Aok = odbservermanager.defcustomerinfo(actn, custno, sessnid)

 
Reply With Quote
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      03-09-2007
(E-Mail Removed) wrote:
> On Mar 8, 10:31 am, "Bob Barrows [MVP]" <(E-Mail Removed)>
> wrote:
>> (E-Mail Removed) wrote:
>>> We have an asp script on an NT system that is trying to access a
>>> database on an XP server. When it gets to setting up odbc, it gives
>>> an error on that line in a particular function but doesn't give
>>> details. I can map the network drive by providing username, but I
>>> can't use the odbc to access the info. Any ideas? I set up security
>>> to make sure that I can access it.

>>


> Thanks for the response. It's an ASI ProfitPlus database.


I've never heard of this database. I suspect your chances of getting
help for this will be slim.

> Error
> follows:
> Error in ActiveX Server:C:\WINNT\SYSTEM32\INETSRV\INETINFO.EXE
> Object:ASIECOMCLASS Service: DEFCUSTOMERINFO error '800a03e8'
> Description: VARIABLE NOT INITIALIZED Subsystem: BASE Function:
> IVARGET Argument: {(0x0000)0x00000000} CLASS
> /manheim/login.asp, line 139
> Code: Aok = odbservermanager.defcustomerinfo(actn, custno,
> sessnid)
> The ASP is on an NT machine that's accessed via the internet. The code
> accesses the server that holds the database. We've had the database on
> 98 and have been using this for years. We're trying to move the
> database to an XP machine, and the code's having a problem at that
> point when it tries to access it. We called the software manufacturer,
> and they were unable to help us. They got a copy of the asp code to
> look at it, but they haven't gotten back to us in a week. I'm figuring
> that it's a security issue, but I've made all the proper settings that
> I know. I can map the XP drive from NT if I provide a username.


You need to remember that ASP is not running under your security
context, so your ability to map a drive is totally irrelevant.

I haven't a clue what security is required for this database, but
reading the articles I cited in my previous post might shed some light
for you as to what user account needs those rights.

--
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.


 
Reply With Quote
 
lmlaster
Guest
Posts: n/a
 
      03-09-2007
On Mar 8, 9:06 am, (E-Mail Removed) wrote:
> We have an asp script on an NT system that is trying to access a
> database on an XP server. When it gets to setting up odbc, it gives an
> error on that line in a particular function but doesn't give details.
> I can map the network drive by providing username, but I can't use the
> odbc to access the info. Any ideas? I set up security to make sure
> that I can access it.


A couple of comments:
Are you using an system ODBC dsn. It has to be a system dsn or else
your web can't use it.

If you put the Access db on the web server and changed your odbc dsn
to point to that location, would the web work then. It doesn't really
matter that the USER logged into the server can access it. Can
IUSR_servername access it?



 
Reply With Quote
 
kilquonk@yahoo.com
Guest
Posts: n/a
 
      03-12-2007
>
> I've never heard of this database. I suspect your chances of getting
> help for this will be slim.
>

That's what I figured, but I figured that it wouldn't hurt to ask. The
vendor's having a hard time with it.
Thanks.

 
Reply With Quote
 
kilquonk@yahoo.com
Guest
Posts: n/a
 
      03-12-2007
On Mar 9, 3:01 pm, "lmlaster" <(E-Mail Removed)> wrote:
>
> A couple of comments:
> Are you using an system ODBC dsn. It has to be a system dsn or else
> your web can't use it.

Doesn't appear to be using one.

>
> If you put the Access db on the web server and changed your odbc dsn
> to point to that location, would the web work then. It doesn't really
> matter that the USER logged into the server can access it. Can
> IUSR_servername access it?

I set permission for Everyone to access.
Thanks.

 
Reply With Quote
 
kilquonk@yahoo.com
Guest
Posts: n/a
 
      03-13-2007
>
> Everyone <> IUSR_servername
>

I setup IUSR_servername, and that didn't do it, either. I found the
NETWORK item in the list of groups/users, and that let me through. It
works now.

Thanks again for the responses.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: The ODBC resource DLL is a different version than the ODBC driver manager beenthere Computer Support 12 10-17-2006 07:11 PM
Re: The ODBC resource DLL is a different version than the ODBC driver manager tenkbabe@yahoo.com Computer Support 0 10-16-2006 01:11 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM



Advertisments