SEO

#1 (**permalink**) 02-28-2008, 05:13 PM

We have forms written in Visual Basic 6.0. They were previously
written for an Access database which was moved to SQL Server 2000.

Here's the connect string I used:
ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQL
SERVER};DATABASE=MPPhoto

The user visualbasic and the user logged in to the computer have full
rights to the database.

When they open the form which is based on a view it is opened as read
only with an error 3027. The data control is not set to read only.
The database file is not read only. All of the permissions are set to
allow this user read, write and modify.

Can anyone hep me?

#2 (**permalink**) 02-28-2008, 05:13 PM

Julie (julie_tennyson@averydennison.com) writes:
> We have forms written in Visual Basic 6.0. They were previously
> written for an Access database which was moved to SQL Server 2000.
>
> Here's the connect string I used:
> ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQL
> SERVER};DATABASE=MPPhoto
>
> The user visualbasic and the user logged in to the computer have full
> rights to the database.
>
> When they open the form which is based on a view it is opened as read
> only with an error 3027. The data control is not set to read only.
> The database file is not read only. All of the permissions are set to
> allow this user read, write and modify.

Error message 3027 in SQL Server is

Could not find filegroup '%.*ls' in sysfilegroups for database '%.*ls'.

Somehow I suspect that your error 3027 comes from another source, as
the SQL message does not really fit in your brief description.

You probably need to track down which component is producing the error.
Even better is of course if you can find a text to that message.

I'm sorry for not being more helpful, but without any knowledge about
your application it is difficult to say anything useful.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

#3 (**permalink**) 02-28-2008, 05:14 PM

Julie:

Need more info.

-You using a bound control?
-PLease show the code that opens the connection and recordset.
-What version of ADO?

julie_tennyson@averydennison.com (Julie) wrote in message news:<a9998980.0307231235.47e8096e@posting.google. com>...
> We have forms written in Visual Basic 6.0. They were previously
> written for an Access database which was moved to SQL Server 2000.
>
> Here's the connect string I used:
> ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQL
> SERVER};DATABASE=MPPhoto
>
> The user visualbasic and the user logged in to the computer have full
> rights to the database.
>
> When they open the form which is based on a view it is opened as read
> only with an error 3027. The data control is not set to read only.
> The database file is not read only. All of the permissions are set to
> allow this user read, write and modify.
>
> Can anyone hep me?

#4 (**permalink**) 02-28-2008, 05:14 PM

Julie:

Need more info.

-You using a bound control?
-PLease show the code that opens the connection and recordset.
-What version of ADO?

julie_tennyson@averydennison.com (Julie) wrote in message news:<a9998980.0307231235.47e8096e@posting.google. com>...
> We have forms written in Visual Basic 6.0. They were previously
> written for an Access database which was moved to SQL Server 2000.
>
> Here's the connect string I used:
> ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQL
> SERVER};DATABASE=MPPhoto
>
> The user visualbasic and the user logged in to the computer have full
> rights to the database.
>
> When they open the form which is based on a view it is opened as read
> only with an error 3027. The data control is not set to read only.
> The database file is not read only. All of the permissions are set to
> allow this user read, write and modify.
>
> Can anyone hep me?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Visual Basic 6.0 connect to SQL Server 2000