MS SQL Server ODBC - Foxpro 2.6 connectivity

Author

Foxpro 2.6 connectivity

Eve

2005-05-11, 9:23 am

Hi,
I am trying to upload some data from Foxpro2.6 for Windows into Oracle.
I don't have Foxpro Connectivity instruction book, so I was searching
the web and trying to figure it out. When I run foxpro command
handle = DBConnect(HOracle,"username","password","") to connect through
ODBC
It came back with the message "DBconnect.prg" not found.
Could anyone please help me with this? Thank you very much.
E.

*** Sent via Developersdex http://www.droptable.com ***

Cindy Winegarden

2005-05-11, 8:23 pm

Hi Eve,

I'm confused. This is a SQL Server group. Are you using SQL Server at all?

What language are you writing your upload program in? FoxPro 2.6? DBConnect
is a function in one of the Connectivity Kit programs. Have you used "Set
Procedure To C:\MyPath\MyProgramW
ithDBConnectInIt.prg" to tell FoxPro where
to look for the DBConnect function?

If you have more problems I suggest you post to microsoft.public.fox.*.

Have you considered joining the 21st century? The latest version of FoxPro
is Visual FoxPro 9 (came out this winter) and it is compatible with all
versions of FoxPro tables. With VFP9 the connectivity features are built in
so you don't need any extra software.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"Eve" <eve@needhelp.com> wrote in message
news:eNzKzMjVFHA.548@tk2msftngp13.phx.gbl...
> Hi,
> I am trying to upload some data from Foxpro2.6 for Windows into Oracle.
> I don't have Foxpro Connectivity instruction book, so I was searching
> the web and trying to figure it out. When I run foxpro command
> handle = DBConnect(HOracle,"username","password","") to connect through
> ODBC
> It came back with the message "DBconnect.prg" not found.
> Could anyone please help me with this? Thank you very much.
> E.
>
>
> *** Sent via Developersdex http://www.droptable.com ***

Eve

2005-05-23, 11:23 am

Hi Cindy,
Thanks for your response. I figured it out. I copied the FPSQL.fll
file to my foxpro dir. and the error message was gone, but it still
didn't work (because foxpro is 16-bit and oracle is 32-bit). I had
tried to do it from Oracle side but ran into problem with initialization
file with the DBA. I still have a small Foxpro program to maintain
until we coorperate it into our existing Oracle system (and we won't go
into Visual Foxpro). I am doing the data uploading to save users' data
entry time while working on the new development.
Anyway, I have found a way to go around that problem (user will spill
data from foxpro and we will run a scheduled sql loader to load data
in).
Thanks (and yes, I am in the 21st century ;-)) Sorry if I posted to the
wrong group, but I was desperate and I thought my problem had smth to do
w/sqlldr too so...
Eve

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links