ASP error accessing odbc on xp from nt

**Bob Barrows [MVP]** · Mar 8 '07, 03:45 PM

Re: ASP error accessing odbc on xp from nt

kilquonk@yahoo. com 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.

**kilquonk@yahoo.com** · Mar 9 '07, 02:15 PM

Re: ASP error accessing odbc on xp from nt

On Mar 8, 10:31 am, "Bob Barrows [MVP]" <reb01...@NOyah oo.SPAMcom>
wrote:

kilqu...@yahoo. com 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\INETS RV\INETINFO.EXE
Object:ASIECOMC LASS Service: DEFCUSTOMERINFO error '800a03e8'
Description: VARIABLE NOT INITIALIZED Subsystem: BASE Function:
IVARGET Argument: {(0x0000)0x0000 0000} CLASS
/manheim/login.asp, line 139
Code: Aok = odbservermanage r.defcustomerin fo(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.

**kilquonk@yahoo.com** · Mar 9 '07, 02:25 PM

Re: ASP error accessing odbc on xp from nt

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 odbservermanage r = server.createob ject( "asiecom.object " )
Aok = odbservermanage r.defcustomerin fo(actn, custno, sessnid)

**Bob Barrows [MVP]** · Mar 9 '07, 03:05 PM

Re: ASP error accessing odbc on xp from nt

kilquonk@yahoo. com wrote:

On Mar 8, 10:31 am, "Bob Barrows [MVP]" <reb01...@NOyah oo.SPAMcom>
wrote:

>kilqu...@yahoo .com 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\INETS RV\INETINFO.EXE
Object:ASIECOMC LASS Service: DEFCUSTOMERINFO error '800a03e8'
Description: VARIABLE NOT INITIALIZED Subsystem: BASE Function:
IVARGET Argument: {(0x0000)0x0000 0000} CLASS
/manheim/login.asp, line 139
Code: Aok = odbservermanage r.defcustomerin fo(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.

**lmlaster** · Mar 9 '07, 07:15 PM

Re: ASP error accessing odbc on xp from nt

On Mar 8, 9:06 am, kilqu...@yahoo. com 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?

**kilquonk@yahoo.com** · Mar 12 '07, 02:55 PM

Re: ASP error accessing odbc on xp from nt

>

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.

**kilquonk@yahoo.com** · Mar 12 '07, 03:05 PM

Re: ASP error accessing odbc on xp from nt

On Mar 9, 3:01 pm, "lmlaster" <lmlas...@yahoo .comwrote:

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

**John Blessing** · Mar 13 '07, 08:45 AM

Re: ASP error accessing odbc on xp from nt

<kilquonk@yahoo .comwrote in message
news:1173711351 .673429.191170@ v33g2000cwv.goo glegroups.com.. .

On Mar 9, 3:01 pm, "lmlaster" <lmlas...@yahoo .comwrote:

>>
>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_servernam e access it?

I set permission for Everyone to access.
Thanks.

Everyone <IUSR_servernam e

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

**kilquonk@yahoo.com** · Mar 13 '07, 07:05 PM

Re: ASP error accessing odbc on xp from nt

>

Everyone <IUSR_servernam e
>

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.

ASP error accessing odbc on xp from nt

ASP error accessing odbc on xp from nt

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment