Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00557845
Message ID:
00561386
Views:
37
>>>You can also get this registry class and .H file by downloading my Epson POS class in UT Downloads. I recently obtained permission from Rick to bundle his registry class with my freeware classes that use it. I just have not updated my other stuff here with that class.
>>
>>ok, I got the registry. I plugged in :
>>#DEFINE PATH_TO_DBC "P:"
>>#DEFINE DATABASE_NAME "data1.dbc" in the odbc.prg then ran odbcdemo
>>and then it asks me for registry.fxp b4 it bombs out. Am I getting close?
>
>The Registry class is the Registry.PRG file and must be located in your VFP search path or in the same folder as the ODBC class. Yes you are getting close.

OK I got it to work, the results:!!

MS ODBC for Oracle Installed - .T.
MS ODBC for Oracle Version - 02.50
DSN 'VFP DBC Test' Created - .T.
DSN 'VFP DBC Test' Removed - .T.
DSN 'Oracle Test' Created - .T.
DSN 'Oracle Test' Current Description = Test Addition of DSN
DSN 'Oracle Test' Modified - .T.
DSN 'Oracle Test' New Description = Descript Modified
DSN 'Oracle Test' Removed - .T.

Now, what can I do to make this useful, do I use my connection string to connect?

Since on my PC, the control panel/ODBC mgr had already been in place and configured so my prg(see below) already worked. What I want to do is have it work on other systems.

{lnHandle = SQLConnect("connect1")

IF lnHandle > -1
SQLExec(lnHandle,"SELECT * FROM amcs_equipment","Result1")
SELECT Result1
BROWSE
SQLDisconnect(lnHandle)
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform