no more connection wizard for oledb in 2005 Express ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I can not find anything equivalent to the connection wizard for Oledb that is
in .NET 2003. I could navigate to an ACCESS .mdb file and a connection with
string was generated.

With 2005 Express, when I right click on the connection icon, I get a dialog
with a choice beteween an sql and an ole connection, but nothing that
generates a connection string and no way to select a database file. Do I
have to make up my own string now? That would be a step back. What am I
missing here ?
.

Relevant Pages

  • Re: Syntax
    ... tablename above except that it is an mdb rather than a table in SQL server. ... Thus my connection table is now the mdb file name minus the ".mdb" extension ... the Access mdb connection string should be the variable name as ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to Locate Server
    ... I am using the copy of SQL Express that came with Visual Studio. ... > Boolean& failoverDemandDone, String host, String failoverPartner, String ... > owningObject, SqlConnectionString connectionOptions, String newPassword, ... >> trying to make a remote database connection while you think your database is ...
    (microsoft.public.sqlserver.setup)
  • Re: Setting a combo Rowsource from SQL server
    ... Since you set the RowSource to the SQL String, ... the Connection you established is not used. ...
    (microsoft.public.access.forms)
  • Re: Im wondering about have two connections, one inside the other.
    ... consider using parameterized SQL instead of adding values to the SQL statement with string concatenation. ... Dim sds As New SqlDataSource(cts.ConnectionString, "SELECT * FROM Photos, ... The same code (new connection string) works OK with Sql 2008 Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Why wont this simple SQL statement INSERT a value?
    ... use the parameter in your SQL statements preceeded by a ?. ... problem was to do with the VS2005 built connection string DataSource=| ... Dim num, value As String ...
    (microsoft.public.dotnet.languages.vb)