Adolfo wrote:Rimantas
I don't use TSqlite
I use an ODBC Client for SqLite, so I connect to it via ADO![]()
And is as fast as any dbf used locally.
Adolfo
Hello Adolfo ,
![Sad :(](./images/smilies/icon_sad.gif)
![Smile :)](./images/smilies/icon_smile.gif)
With best regards !
Adolfo wrote:Rimantas
I don't use TSqlite
I use an ODBC Client for SqLite, so I connect to it via ADO![]()
And is as fast as any dbf used locally.
Adolfo
Rick Lipkin wrote:Rimantas
...
I worked for a large state Agency with over 5k users .. you think I want to make sure all 5k desktops have ODBC configured .. or have the correct version of .net framework .. I would be doing nothing but answering help desk calls on configuration connectivity issues ..
For me .. SQL Server and ADO is a perfect match .. just compile your .exe and distribute it .. burn in your connection string credentials into your app .. and you are done ..
...
Rick Lipkin wrote:Rimantas
Here is the link that will explain it all .. has connections and syntax for .mdb ( access ) as well as Sql Server:
http://wiki.fivetechsoft.com/doku.php?i ... uffs&s=ado
Rick Lipkin
anserkk wrote:Dear Mr.Rimantas,
To connect to Database server on a remote server the follwing has to be considered.
1) Internet connection should be available on the PC running the database server
2) Instead of localhost or 127.0.0.1, the connection string on your client PC app should have either the Internet IP or Domain name
3) If the network (Database server network) has firewall, then you may have to do a port forwarding on the firewall.
Regards
Anser
Adolfo wrote:Rimantas
I use an ODBC Client for SqLite, so I connect to it via ADO![]()
Adolfo
Rimantas wrote:Adolfo wrote:Rimantas
I use an ODBC Client for SqLite, so I connect to it via ADO![]()
Adolfo
Adolfo ,
Please help me again . In SqLite.org site they are providing only SqLite ODBC for connection . I downloaded this , hoping that with ODBC drivers will be and OLE DB Provider . Sorry , but here was only ODBC install package . So at this moment I can't understand what you are using . ODBC it's one thing , ADO - another . Both I know and want to accurate - you are talking about something that : cConnectionString := "DSN=odbc name ;UID=YOURUSERID;PWD=YOURPASSWORD;" ?
With best regards !
TRY
oCn:= CreateObject( "ADODB.Connection" )
oCs:= "DRIVER={SQLite3 ODBC Driver};Database=" + Alltrim(cPathDb) + "Tele.db"
oCn:Open(oCs)
Retorno:=.T.
CATCH oErr
MSGAlert( "Error: " + oErr:Operation + " -> " + oErr:Description )
Retorno:=.F.
END
In fact, you can configure you application install, to do both things, Install the Odbc Client in silent mode and your application, and there'll be no need to configure anything else.
The reason I like SQL Server is because you do NOT need .net framework .. you do NOT need any client like Oracle, dB2 or some other SQL flavors which REQUIRE a run-time client. If I have to develop an application that needs to run on any Windows computer .. I do not want to have to make sure there is an ODBC or a run-time ( .net framework ) client configured on each pc .. All windows operating systems have native connectivity to MS Sql server .. right out of the box .. nothing to configure .. it just runs with your ADO code.
reinaldocrespo wrote:Adolfo;
...I can't see how SQLite offers any advantage over ADS-local ...
Return to FiveWin for Harbour/xHarbour
Users browsing this forum: No registered users and 136 guests