Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #11848
| Newsgroups | comp.lang.clipper.visual-objects |
|---|---|
| Date | 2018-08-29 03:13 -0700 |
| Message-ID | <e3dcfd4e-9289-490c-a2be-c15b26ff3ec0@googlegroups.com> (permalink) |
| Subject | VO2ADO SQL Connection |
| From | simon@abersoftware.co.uk |
Hope someone can help me with an example connection string to an SQL Express database.
I've been using the VO2ADO classes to open MS Access databases over the years but was trying out connecting to SQL tables.
I've looked through Roberts help files etc but cant seem to get the correct connection string in place.
My latest attempt
oConn := AdoConnection{}
oConn:ConnectionTimeout := 30
oConn:Properties:[item, "Prompt"]:Value := AdPromptComplete
oConn:Open("Provider=sqloledb;Network Library=DBMSSOCN;"+;
"Data Source=C:\SQLDatabases\SRPTestSQL2.mdf;"+;
"Initial Catalog=dbo.tblHostels;" ;
,NIL,NIL,NIL)
This returns an unknown error.
Any examples would be helpful.
Simon
Back to comp.lang.clipper.visual-objects | Previous | Next — Next in thread | Find similar | Unroll thread
VO2ADO SQL Connection simon@abersoftware.co.uk - 2018-08-29 03:13 -0700 Re: VO2ADO SQL Connection gianluca.pinoli@proximacentauri.it - 2018-08-29 03:58 -0700 Re: VO2ADO SQL Connection simon@abersoftware.co.uk - 2018-08-29 05:56 -0700
csiph-web