Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC 2k3 problem not in 2k
Message
 
To
All
General information
Forum:
Internet
Category:
Active Server Page
Title:
ODBC 2k3 problem not in 2k
Miscellaneous
Thread ID:
01036214
Message ID:
01036214
Views:
62
hi all,
I have a web app that works perfectly running on iis5 under 2k server. we are trying to migrate to iis6 under 2k3 but i am getting the following error
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Driver Manager] Driver does not support this function 
it relates to the last line of this code
Dim objConn, ConnStr
Set objConn = Server.CreateObject("ADODB.connection")
ConnStr= "Driver=Microsoft Visual Foxpro Driver; " + _
"UID=;SourceType=DBC;SourceDB=c:\Inetpub\wwwroot\pops\dbfinfo\webpurp.dbc"
objConn.Open ConnStr
This all works fine on the original setup but under the new setup i get the above error. i can type in localhost in ie and get the login page but not when i enter a username and password and click submit i get this error. google search is bringing up loads of links, most unrelated and unhelpful.
Slán
~M

UPDATE
I have noticed that on my pc and the original 2k server the version number of the odbc driver for Microsoft Visual FoxPro is 6.01.8630.01 while on 2k3 it is 1.00.02.00 despite that fact that i installed vfpoledb.exe version 8.2.160
Go raibh maith agat

~M
Next
Reply
Map
View

Click here to load this message in the networking platform