"I get Key not valid for use in specified state" whenever I try to preview
data in my database (Access). This in spite that the connection string works
when I test the connection.
The connection string is Microsoft Jet 4.0 OLE DB Provider, User name =
Admin, and no password is used.
What is going on?
rogsonl
PS. This program does not work in a Win 2K server, it works properly in an
XP prof. system (latest version!).
Re: Change Connection String at runtime. ... easily moved to another database, or have versions for each database. ...connection string to the connectionobject before the connection opens. ... *The Server IP number is different for every deployment.... It appears that the generated code uses the application settings to ... (microsoft.public.dotnet.framework.adonet)
Re: Change Connection String at runtime. ... exposes custom objects that are implemented to use the custom data access... easily moved to another database, or have versions for each database. ... and protocols each data source exposes....connection string to the connectionobject before the connection opens. ... (microsoft.public.dotnet.framework.adonet)
Re: Please help, linking VB to Access ... If you are going against a Jet database and will never change then ...Dim DB as ADODB.Connection ' specifying the library.object format helps ... you can use the Data Environment in VB to build a connection string (don't ... use the data environment in any actual applications, ... (microsoft.public.vb.general.discussion)
Re: How can I connect this database? ... Sorry for writing ISS for IIS. ... I know surely that ASP cannot connect to a database itself. ... have to add to connection string of ASP. ... (microsoft.public.inetserver.asp.db)
asp.net 2.0 login control ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ... (microsoft.public.dotnet.languages.vb)
