>Mark, I was just happy to be able to connect with oracle8( with your help) and see what I can do from there such as use the oracle tables in my trusty foxpro environment. The code below is where it bogs down.
>
>STORE SQLSTRINGCONNECT('dsn=amcs;uid=amcs_guy;pwd=amcspwd');
> TO gnConnHandle
>IF gnConnHandle < 0
> = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
>ELSE
> = MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
> *= SQLDISCONNECT(gnConnHandle)
>ENDIF
>= SQLEXEC(gnConnHandle, 'SELECT noun FROM amcs_equipment ', 'MyCursor')
First, try to get a connection without passing the string:
gnConHandle = SQLSTRINGCONNECT()
Choose the data source from the dialog box. You may have to select the DSN from the Machine Data Source tab. When you get the Login form, enter the UserID, Password. The server name should already be there.
If that works, do a CREATE CONNECTION conAMCS to create a connection in your Database. Specify the Connection String option. Then click the Builder button to the right of the Connect String textbox. Select your DSN from Data Source dialog box and click OK. The Connect String it builds is what you have to pass in the SQLCONNECTSTRING function.
In the long run, you are probably better off creating a dummy remote view with a shared connection. This way you can open other view using that shared connection, and you can use CursorGetProp to get the connection handle for use in SPT [SQLExec() function].
Mark McCasland
Midlothian, TX USA