VB6.0 ODBC Error 3027 SQL Server 7.0 
Author Message
 VB6.0 ODBC Error 3027 SQL Server 7.0

Can someone out there please help?

I've got a consulting assignment that involves maintaining two seperate
SQL Server 7.0 databases (one named "Company" and the other named
"Company1").  The first one is used to maintain existing operations for
the company that uses several application clients written in VB6.0 that
use ODBC connectivity to the server--everything is fine.

When I go to create a new development environment to (re)write code,
(re)write the data tier, test everything, etc., I get the application
client .vbp's I've saved into a development directory to connect into
the "Company1" database, but I get the runtime error 'Error 3027 -
Database or object is read only'.

I've already gone through and overwrote all 'connect' properties'
DATABASE and DNS settings with "=Company1" in the client applications'
code and data controls, and made sure that the options and permissions
at the server are duplicated for the database and database.users.

I also ran the ODBC Data Source Administrator and set up the correct
configurations for both System DNS and File DNS for "Company1" on the
local machine I'm doing the development on.

I can connect to the database at runtime and read the tables, but I get
the runtime error when the execution of the program gets to a .Edit
method in the code for a table.

Please send me information regarding why this might happen.  Thanks in

Jess Fahland
Mathis Computer Consulting and Training, Inc.

Mon, 09 Sep 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Error 3027 writing to MS SQL Server

2. Error 3027 w/ ODBC connection

3. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

4. Error 3027, SQL Anywhere & VB5

5. Error number 3027 and SQL

6. VB 3.0 + SQL Server 7.0 + ODBC

7. Can I install SQL 7.0 on Windows 98 and Connect VB6 by using ODBC

8. ADO vs ODBC (SQL Server 7.0)

9. ODBC Error in Crystal 7.0 SQL Designer

10. VB6.0 and SQL Server 7.0 OLAP Active X components -URGENT RESPONSE NEEDED

11. Dates, VB6 and SQL Server 7.0

12. SQL Server 7.0 problem with VB6?


Powered by phpBB® Forum Software