Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11848

VO2ADO SQL Connection

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

Show all headers | View raw


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


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