Anthony
|
| Posted: 09/15/2002, 11:14 AM |
|
Hello everybody,
I created a new project using the MS OLE DB provider for VFP. When I generate the website and I try to pull-up the home page, I get this error:
Error Type: ADODB.Connection (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Common.asp, line 25
Here is line 25:
cn.open strConn, strLogin, strPassword
******
Here is the code in Common.asp for the database connection definition
'===============================
' Database Connection Definition
'-------------------------------
' The CRE Online Edition Connection begin
Dim cn : Set cn = Server.CreateObject("ADODB.Connection")
'-------------------------------
' Create database connection string, login and password variables
'-------------------------------
Dim strConn, strLogin, strPassword
strConn = "Provider=VFPOLEDB.1;Data Source=C:\CRE\DATA\DECR.DBC;Password="";Collating Sequence=MACHINE"
strLogin = ""
strPassword = ""
'-------------------------------
' Open the connection
'-------------------------------
cn.open strConn, strLogin, strPassword
'-------------------------------
' The CRE Online Edition Connection end
I appreciate your help!
Regards,
Anthony Lang
|
|
|
 |
Timothy
|
| Posted: 09/17/2002, 1:23 AM |
|
Anthony,
try to use ODBC connection to foxpro db. I used one and it works perfectly for me. As a rule you create ODBC data source (in Control Panel/ODBC) that points to
location where your dbf files are. You should specify this datasource
in Connection properties/Design tab.
|
|
|
|
Timothy
|
| Posted: 09/17/2002, 1:23 AM |
|
Anthony,
try to use ODBC connection to foxpro db. I used one and it works perfectly for me. As a rule you create ODBC data source (in Control Panel/ODBC) that points to
location where your dbf files are. You should specify this datasource
in Connection properties/Design tab.
|
|
|
|
|
