FiveTech Software tech support forums

So this is going to sound very simple to those of you who use sql but I've have never used sql so here goes....

All I need to do is:
-Connect to the SQL server
-Add a new record
-Add the data to the record (2 fields "Name" and "ID")
-Save and close

I've looked at some posts but I see different people doing things different ways and now I'm confused
I should also mention that I've been out of the programming game for a while and am a bit rusty.

Can anyone point me in the right direction?

Forgot to mention that it's a Microsoft SQL server I need to connect to.

Hi, Jeff, nice to see you again. It seems like you haven't been here for a long time.
I've often wondered if you're still working on your program. Unfortunately,
I've shut down all my SQL servers and haven't done anything with them for a long time. But I'm happy to see you.
Best regards,
Otto

Hi Otto,

Nice to see you again too

I retired back in 2020 but still do a bit of programming here and there.
Glad to see your still going

This is our recommendation:

Code: Select all  Expand view

function TestMsSql()

   local oCn, cSql, oRs
                                       // server      // db     // user   // pwd
   oCn := FW_OpenAdoConnection( "MSSQL,208.91.198.196,gnraore3_,fwhmsdemo,fwh@2000#", .t. )
   if oCn == nil
      ? "failed to connect"
   else
      cSql := "INSERT INTO [STATES] ( [CODE], [NAME] ) VALUES ( 'JB', 'Jeff Barnes' )"
      oCn:Execute( cSql )
      //
      // Now test
      oRs   := FW_OpenRecordSet( oCn, "SELECT * FROM [STATES]" )
      XBROWSER oRs
      oRs:Close()

      oCn:Close()
   endif

return nil
 

You can test this program from your computer.
This program connects to a FWH's MsSql server in the cloud. This server is provided for testing by our users.
After testing this, you can use similar logic on your Server.

Thank you sir. That works when I leave your sample alone.

When I add my connection info, it will not connect.
At least now I know it should work. Not sure why the connection isn't working on my end.
The big issue is me, I just don't know enough about the SQL Server.
Even if I create logins on the server (ie: User=Jeff), It will not let me connect unless I use "Windows Authentication". I think this is where my issue is.

I will keep on trying.

Got it working. It was a setting in MS-SQL. I had to enable both Windows Authentication and SQL user authentication.

Thanks again for the help.