473,230 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

Migrated website, now ASP that access Foxpro data doesn't work

We migrated our intranet site from IIS4 NT4 (\\GHCNT8) to a Windows 2003
server with IIS6 (\\NT58) using the IIS Migration Tools. I have a few
ASP pages that access Foxpro data on a different server.

I downloaded the Visual Foxpro ODBC Driver from MSDN. I exported (from
the registry) the ODBC entries from the old server and imported them
onto the newserver. I setup the Internet user guest account with rights
where the Foxpro data is located. The data is on a different server so
we created an IUSR_NT58 account on the server that it is located and set
the password to match the what it is for NT58\IUSR_NT58.

My code makes it past the connection string:
Set cntl = Server.CreateObject("ADODB.Connection")
cntl.Mode = 8
sqlStr = "Driver=Microsoft Visual FoxPro
Driver;SourceType=DBf;SourceDB=\\Ghcnt11\mslw\MSLW DATA;BackgroundFetch=N
o;Exclusive=No"
Session("DBConnect")=sqlStr
cntl.Open sqlStr
But when I try to query the data, I get an error:
set RPrec = Nothing
set RPrec = Server.CreateObject("ADODB.Recordset")
RPrec.cursortype = 1 'adOpenKeyset
RPrec.cursorlocation = 2 'adUseServer
RPrec.locktype = 3 'adLockOptimistic
SqlStr = "SELECT dr_name, dr_id FROM cmeinf GROUP BY cmeinf.dr_name
HAVING (((cmeinf.dr_name) Is Not Null)) ORDER BY cmeinf.dr_name"
response.write sqlstr
RPrec.Open sqlStr, cntl
This is what I get:
SELECT dr_name, dr_id FROM cmeinf GROUP BY cmeinf.dr_name HAVING
(((cmeinf.dr_name) Is Not Null)) ORDER BY cmeinf.dr_name
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/physician/phycme/phys_cme.asp, line 23
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
2 2717
Stop using ODBC first off. Second check out the following sites for
some information on what to do & why not to use ODBC/DSN connections.

http://msdn.microsoft.com/library/de...components.asp

http://www.able-consulting.com/MDAC/...orVisualFoxPro

If you still insist on using ODBC follow the directions at the following
page.

http://www.able-consulting.com/MDAC/...orVisualFoxPro

Colin Colin wrote:
We migrated our intranet site from IIS4 NT4 (\\GHCNT8) to a Windows 2003
server with IIS6 (\\NT58) using the IIS Migration Tools. I have a few
ASP pages that access Foxpro data on a different server.

I downloaded the Visual Foxpro ODBC Driver from MSDN. I exported (from
the registry) the ODBC entries from the old server and imported them
onto the newserver. I setup the Internet user guest account with rights
where the Foxpro data is located. The data is on a different server so
we created an IUSR_NT58 account on the server that it is located and set
the password to match the what it is for NT58\IUSR_NT58.

My code makes it past the connection string:
Set cntl = Server.CreateObject("ADODB.Connection")
cntl.Mode = 8
sqlStr = "Driver=Microsoft Visual FoxPro
Driver;SourceType=DBf;SourceDB=\\Ghcnt11\mslw\MSLW DATA;BackgroundFetch=N
o;Exclusive=No"
Session("DBConnect")=sqlStr
cntl.Open sqlStr
But when I try to query the data, I get an error:
set RPrec = Nothing
set RPrec = Server.CreateObject("ADODB.Recordset")
RPrec.cursortype = 1 'adOpenKeyset
RPrec.cursorlocation = 2 'adUseServer
RPrec.locktype = 3 'adLockOptimistic
SqlStr = "SELECT dr_name, dr_id FROM cmeinf GROUP BY cmeinf.dr_name
HAVING (((cmeinf.dr_name) Is Not Null)) ORDER BY cmeinf.dr_name"
response.write sqlstr
RPrec.Open sqlStr, cntl
This is what I get:
SELECT dr_name, dr_id FROM cmeinf GROUP BY cmeinf.dr_name HAVING
(((cmeinf.dr_name) Is Not Null)) ORDER BY cmeinf.dr_name
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/physician/phycme/phys_cme.asp, line 23
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Jul 19 '05 #2
Well I will only be in this job for 1 more week so I don't have time to
reprogram it, I gotta get it working on the new server. So I Have to
use ODBC.

I found the article that helped me got it working on our old server:
http://support.microsoft.com/default...;en-us;Q197964

However this was for IIS 5, we have IIS6 now. There is a line that says
"De-select the "Enable Automatic Password Synchronization" option and
type in the username(IUSR_ComputerName) and the password. "
I do not find this option in IIS 6. I think this may have something
to do with it.

RIght now I am getting errors where the DBF file is not found. Again I
think it's security because of this Enable automatic password
Synchronization. I can't deselect it in IIS because I cannot find it.
Any ideas?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Simon Bailey | last post by:
I am a newcomer to databases and am not sure which DBMS to use. I have a very simplified knowledge of databases overall. I would very much appreciate a (simplifed) message explaining the advantages...
3
by: sparks | last post by:
All we are hearing at work now is we should give up on access. NO NO NO you need to go with foxpro. access is dead and can't do anything compared to foxpro It can make coffee, and forward...
2
by: Salad | last post by:
OS = WinXP & Win98. Access = A97 & AXP Q1) Where can I find the VFP ODBC driver at Microsoft. I have been working developing an app in Access that will link to some DOS FoxPro tables. I...
3
by: Mike Wilson | last post by:
Is there a way to open an OLE DB database from within Access? I would like to use the Access GUI with its table and query explorer to examine a database only available through an OLEDB provider...
0
by: Salad | last post by:
My operating system is WinXP Pro. I have 1 gig of memory and the chip is an Intel Pentium 4. I am using Access97. A table has been supplied to me from an external source createdc from Visual...
71
by: Lauren Wilson | last post by:
Hello folks, Would love yo get all informed opinions and/or facts on the following: Over the last few weeks I have spent quite a bit of time reviewing all the Access and .NET stuff I could...
15
by: sparks | last post by:
They are wanting to use word to print out some cards 4 to a page preformatted stuff from an access database. the problem with this is they don't want to do the same card twice. How can setup a...
15
by: sparks | last post by:
We get more and more data done in excel and then they want it imported into access. The data is just stupid....values of 1 to 5 we get a lot of 0's ok that alright but 1-jan ? we get colums...
3
by: HistoricVFP | last post by:
Hello, Iíve been given the task of importing .dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003). When I import the data straight to Access it errors with: ...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youíll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.