sql server connection

I have a VFP) app that uses MS sqlserver as backend. The SQL Server is located in a web provider The connection is achieved by creating a DSN throught the ODBC driver in my PC I need to deploy this app to several clients. But none of them should use their ODBC driver to create the connection, or

Re: sql server connection

Rafael, They'll have to have the driver installed in order to talk to SQL Server. The best way is to provide them with an Installer program (use InnoSetup - free and easy) that installs your app as well as the driver. It can add a DSN too, although you may want to consider hardcoding that connecti

Re: sql server connection

Hi Eric, I was afraid they would need to install the driver. I'll try innosetup as you suggest In any case, thank you both, Eric and Vince Best regards Rafael El jue, 11 feb 2021 a las 11:17, Eric Selje () escribió: > Rafael, > > They'll have to have the driver installed in order to talk to SQ

Re: sql server connection

On 02/11/21 9:20 AM, Rafael Copquin wrote: Hi  Vince I understand your example. Actually I used it and my test worked like a charm. However, wouldn't it require that my clients have the SQL Server Native Client version already installed in their computers? Rafael The drivers, yes, but those ca

Re: sql server connection

Here is a powershell script example that will install the client on your workstation(s). https://www.server-world.info/en/note?os=Windows_Server_2019&p=mssql2019&f=4 I would skip ODBC at all costs and just use the client directly. On Thu, Feb 11, 2021 at 8:17 AM Eric Selje wrote: > Rafael, >

Invaluable Job opportunity

Hello Profoxers, My company is looking to hire someone to help us with the web-based version of our vertical market application. It is built on VFP9 using Westwind Web Connection framework, MS SQL Server, HTML/CSS/JS. If you think you might be interested, please shoot me your CV/resume at r k

RE: MemberClass update

I believe I found my problem. I need to update the Properties of the baseGrid to set the name of Column to be BaseColumn, and the Methods to correctly reference the new names. Then I need to update the Class to baseheader, and the Parent to reference the new column name on the records that are hea

RE: sql server connection

Really? All you have to do is set trusted=yes in the conn string, afaik. But I could be wrong. We only use SQL security accounts in our environment. I'm sure it's been mentioned before but this is a good resource for connection strings - https://www.connectionstrings.com/sql-server/ -- rk ---

RE: sql server connection

And installing the 64 bit driver will include the 32 bit driver. -- rk -Original Message- From: ProfoxTech On Behalf Of Richard Kaye Sent: Thursday, February 11, 2021 1:05 PM To: profoxt...@leafe.com Subject: RE: sql server connection Really? All you have to do is set trusted=yes in th

Re: MemberClass update

GoFish may be able to do this replacement. On Thu, Feb 11, 2021 at 11:39 AM Tracy Pearson wrote: > I believe I found my problem. > I need to update the Properties of the baseGrid to set the name of Column > to > be BaseColumn, and the Methods to correctly reference the new names. > Then I need t

Re: sql server connection

-Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, February 11, 2021 12:05 PM To: profoxt...@leafe.com Subject: RE: sql server connection Really? All you have to do is set trusted=yes in the conn string, afaik. But I could

RE: sql server connection

I do this with multiple applications and we handle it using a DSN-less connection. The only requirement for the pc is a 32-bit MS SQL ODBC driver must be installed, but no DSN needs to be created on the computer. Also, you must have SQL Credentials configured on the SQL Server as you cannot use Win

RE: sql server connection

I've not been able to make Windows Authentication work in the past, but I'll keep that in mind and try it again sometime. So far, my clients have been accommodating in terms of creating SQL Credentials. I also only need Read/Only rights for the work I do, so that helps with their security concerns

Re: MemberClass update

May I advise you to *backup* before you do this replacement procedure with Thor? Koen Op do 11 feb. 2021 om 21:05 schreef Eric Selje : > GoFish may be able to do this replacement. > > On Thu, Feb 11, 2021 at 11:39 AM Tracy Pearson > wrote: > > > I believe I found my problem. > > I need to update