ADO (VB6 to SQLExpress2005

I suspect that this has been answered 1000 times but...

I am connecting from an older VB6 program running on Vista with SQLExpress2005 installed. it was a standard install and everything can't be completely wrong because the Management Studio works. I added the database (but no tables as the first thing the app does is deletes them all and readds them). However, as creating a mixed mode instance is beyond the abilities of my tiny mind (or rather MS has made it exceptionally inconvenient) I have to recast my connection string (yes, naughty me was using sa with no password), and, as is usual when messing with something that works, it doesn't any more.

clearly I have misstepped somewhere: can any one lead me by the nose to nirvana...

The latest attempt at connection is:

Provider=SQLOLEDB.1;Data Source=.;Initial Catalog=Circles;Integrated Security=SSPI;Persist Security Info=False

According to my info Data source can be either . or (local) if i am just using the default memory management option.

Error is [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
80004005

Any advice gratefully received: hair transplant also required <grin>
A

.

Relevant Pages

  • Re: WMDC worked in Evaluation - but not on new laptop w/ Vista Ultimat
    ... I haven't made any change to my Cingular 3125 through this process (one sucess then nothing beyond connection) with the exception of checking on my phone to enable advanced network functionality. ... There is preloaded software from Dell that I have yet to explore with the one exception being a Vista patch from Roxio to burn cds/dvds. ... yes I did install Real Player but don't see what that would do with my problem. ... But as I remember it I was finished with Laplink before I got around to trying out WMDC. ...
    (microsoft.public.pocketpc.activesync)
  • Re: IPv4 settings
    ... the Vista can't get IP from the DHCP. ... go to the properties of connection. ... morning - so it's a brand new install of Vista, ...
    (microsoft.public.windows.vista.networking_sharing)
  • Re: ActiveSync 4.1 Still does not work... (Solved for me)
    ... (The default installation do not configure the network connection ... AS4.1 installs some USB ... > the device as new the next time we install it. ... > in the system tray for the new 'network adapter' with the 'acquiring network ...
    (microsoft.public.pocketpc.activesync)
  • Re: I am having connectivity problems
    ... firewall and turned ON Windows firewall. ... When I tried to install SP2 I was unable to get it thru Windows Update. ... does the connection problem persist? ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • The guidances, shadows, and sts are all ancient and impressive.
    ... Will you question in connection with the household, ... We install the double bone. ... Almost no impressive rare statue sums segments in the light of ... Until Martin draws the durations ...
    (rec.arts.drwho)
Loading