by I have just installed version 7 of SQL Server and am having some
problems.
Background info:
I installed version 7 and then used the import/export data feature to
upsize some Microsoft Access tables to SQL. I have checked the tables
once imported into SQL and they all look ok.
I then created an ODBC connection to this database in SQL. This ODBC
connection would then be used by some of our other software.
These same steps were done in version 6.5 and I managed to get SQL to
connect to our software.
However, with version 7 I get an error message saying that I cannot
connect to the database and create/insert some records in a SQL table.
I have checked that the database and table has permissions set to add
data to the tables.
Can anyone tell me how I can set up a database to allow users to
connect to it and insert data into the tables. I can read data from
the SQL tables without any problems. Therefore, I am sure it is some
setup issue that is not allowing external programs to connect to SQL
to append data to the tables.
I am not an SQL expert but am just trying to set it up in the same way
as I set up SQL 6.5. The changes between the 2 versions means that I
need to do something else to setup read/write permissions, but what?