|
 |
asp_databases thread: OLE-DB FoxPro Connection
Message #1 by "Mike H." <mhaining@p...> on Wed, 29 Nov 2000 16:51:20 -0000
|
|
We just upgraded our web server to Windows 2000. We are using a FoxPro
database. Prior to the upgrade we used system DSN's to connect to the
database and create recordsets with this connection string (strConnect
"Provider=MSDASQL.1;" & _
"DATABASE=DBName;" & _
"DSN=DSNName;" & _
"User ID=Admin;" & _
"Password=pw")
. I would prefer to use OLE-DB, but don't know how the connection string
should read. Can someone help?
Message #2 by <nickm@s...> on Wed, 29 Nov 2000 13:10:11 -0500
|
|
I would be very carefull about using FOXPRO with ASP and ADO because there
is a huge bug that we were unable to resolve at the time and I don't know if
MS has resolved it. We were unable to submit and form input that contained a
' (single quote). We tried everyway to resolve this and could not and as
such if someone tried to submit a form with a name like O'reilly we would
get the SQL error. Typical to deal with this we just use a simple replace
function to escape it.
If I were you, you might go with SQL7
Stefan
www.Studioweb.com
Message #3 by "Mike H." <mhaining@p...> on Thu, 30 Nov 2000 16:09:13 -0000
|
|
Thanks for the info. Our company bought a software package and it was
written in FoxPro. We have done a lot of desktop development on it and now
we are trying to do some work with it on the Web via ASP. I don't know if
we can switch it to SQL Server easily?
So, in the meantime, I need to be able to work with the database as is,
which means I need to connect to it. Any help on a connection string will
be greatly appreciated.
Message #4 by <nickm@s...> on Thu, 30 Nov 2000 17:41:18 -0500
|
|
You should be able to connect to it as you woudl any ODBC database. Except
for the problem I mentioned it worked well. And FOXPRO is very fast. Another
option is to just set up a system DSN.
Stefan
www.studioweb.com
----- Original Message -----
From: "Mike H." <mhaining@p...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, November 30, 2000 11:09 AM
Subject: [asp_databases] Re: OLE-DB FoxPro Connection
> Thanks for the info. Our company bought a software package and it was
> written in FoxPro. We have done a lot of desktop development on it and now
> we are trying to do some work with it on the Web via ASP. I don't know if
> we can switch it to SQL Server easily?
>
> So, in the meantime, I need to be able to work with the database as is,
> which means I need to connect to it. Any help on a connection string will
> be greatly appreciated.
>
>
|
|
|
View Cart
