ODBC Readonly (viewonly) Linked Tables....
Hi,
I have a prod database (main bread & bread DB) and have a small access
database that sales team is using... I created a login inside SQL 2000
and gave db_read permission and SELECT permissions... and public.
Role of public is EXEC store procs and view some systables...
I linked those tables that I gave permissions through ODBC link into
access db with the user that I created inside SQL as readonly user...
but to my surprise when I ran a insert query from access on SQL
tables... I was able to update and insert data... if my ODBC link is
only for readonly.. why was I able to unpdate & insert data into SQL
table?
I don't want to give write/update/insert permissions for SQL tables to
sales team... or anyone outside SQL 2000 server DB.
Is there any easy way to create viewonly users inside SQL?
I created users like this: security -logins -new login...
select none serverrole.. db access (bread & butter DB)
Thank you,
hj
******
Pardon my English...
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
ODBC Linked Tables
In order to use Access 97 as your frontend and SQL 7 as your backend on a network (where the frontend is located on the same computer as the backend and people just map to Access frontend) where security for the data is recognized by your domain login account and what domain group you belong to..do you have to have the same System DSN on everyone's computer for linking? I am still having problems with people linking to the SQL server through the network and only my account is working correctly from my desktop. Everyone else who tries to link gets an ODBC failure error message when trying to open one of the linked tables. I have heard from one person that you must have the same system DSN on every client's computer but to me that makes no sense as I do not have the DSN listed on my individual computer...I am just going through the network as myself..not as an admin..and getting directly to the data. Everyone else can get to the shared folder on the server but cannot get to the linked tables. Any ideas?
View Replies !
View Related
ODBC Linked Tables Go Read Only
Hi, I have an Access database Front End which use SQL server as a Back End. The two are connected using ODBC. Occasionally, some of the linked tables in Access go read only. I can't add or edit records. The only way I know to get round the problem is to delete the link and re-create it. Refreshing the link does not work. Can anybody suggest why this would happen, and the best way to fix it when it does occur? Edited 12:10 06/14/07 Some extra info. At the same time it goes read only, the link loses it's primary key. Thanks Colin
View Replies !
View Related
Linked Tables W/ ODBC From SQLServer 6.5 To Access
Background of what I am doing: I am linking the tables from SQLServer 6.5 into Access through ODBC using translator code page 1252 selected in the configuration of my datasource. The tables that I need to update is simple: delete the old data and insert or append with the new data. My ODBC connection is failing when I try to insert a string (datatype memo) from Access into SQLServer. I determined the length of one string to be 1829 characters long & the other to be 2044 as a sample. The table has 3 fields, Id & type which should not be giving me any greef but the last field (memo datatype) is giving me problems and causing the ODBC failure. Also, please note that in SQLServer the last field is Text(16). I'm new to this field so whoever responds to this message, please keep your answer as simple but detailed as possible. Thanks in advance!!!
View Replies !
View Related
Bad Performance In Queries With Jet4.0 And Linked ODBC-tables To SQL-Server 2000
I changed from Access97 to AccessXP and I have immense performanceproblems.Details:- Access XP MDB with Jet 4.0 ( no ADP-Project )- Linked Tables to SQL-Server 2000 over ODBCI used the SQL Profile to watch the T-SQL-Command which Access ( whocreates the commands?) creates and noticed:1) some Jet-SQL commands with JOINS and Where-Statements aretranslated very well, using sp_prepexe and sp_execute, including thesimilar SQL-Statement as in JET.2) other Jet-SQL commands with JOINS and Where-Statements aretranslated very bad, because the Join wasn´t sent as a join, Accesscollects the data of the individual tables seperately.Access sends much to much data over the network, it is a disaster!3) in Access97 the same command was interpreted wellCould it be possible the Access uses a wrong protocol-stack, perhapsJet to OLEDB, OLEDB to ODBC, ODBC to SQL-Server orJet to ODBC, ODBC to OLEDB and OLEDB to SQL-Server instead ofJet to ODBC and ODBC direct to SQL-ServerDoes anyone knows anything about:- Command-Interpreter of JetODBC, Parameters, how to influence thecommand-interpreter- Protocol-Stack of a Jet4.0 / ODBC / SQL-Server applicationThanks , Andreas
View Replies !
View Related
Trouble Using ADOX To Create Linked Tables In Jet Database From An ODBC Datasource
Hai, I am using ADOX to create linked tables in a jet database from an ODBC datasource. The tables in the ODBC data source does not have a primary key. so I am only able to create read only linked tables.But I want to update the records also. I tried adding a primary key column to the linked table while creating the link. but I am getting an error while adding the table to the catalog. The error message is "Invalid Argument". I use the following code for creating the linked table Sub CreateLinkedTable(ByVal strTargetDB As String, ByVal strProviderString As String, ByVal strSourceTbl As String, ByVal strLinkTblName As String) Dim catDB As ADOX.Catalog Dim tblLink As ADOX._Table Dim ADOConnection As New ADODB.Connection ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strTargetDB & ";User Id=admin;Password=;") catDB = New ADOX.Catalog catDB.ActiveConnection = ADOConnection tblLink = New ADOX.Table With tblLink ' Name the new Table and set its ParentCatalog property ' to the open Catalog to allow access to the Properties ' collection. .Name = strLinkTblName .ParentCatalog = catDB ' Set the properties to create the link. Dim adoxPro As ADOX.Property adoxPro = .Properties("Jet OLEDB:Create Link") adoxPro.Value = True adoxPro = .Properties("Jet OLEDB:Link Provider String") adoxPro.Value = strProviderString adoxPro = .Properties("Jet OLEDB:Remote Table Name") adoxPro.Value = strSourceTbl End With 'Adding primary key, '***** the source column name is "Code" ****** tblLink.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "Code") 'Append the table to the Tables collection. '******The exception occurs on the following line*********** catDB.Tables.Append(tblLink) 'Append the primary index to table. catDB = Nothing End Sub If I avoid the line for adding the primary key,everything works fine,but the table ctreated is readonly. Thanks in advance Sudeep T S
View Replies !
View Related
Readonly Access On Tables
Hi, We have a SQL server database on remote server. We are using ODBC connection to read and write into the table. But we have another user wants to retrieve(readonly access) our data on his pages. How can we create a user on our database and grant readonly access to that user? Thanks..
View Replies !
View Related
MS ACCESS Query Returns Empty Recordset From Odbc Linked Sql Server Tables
Hi,I'm developing a asp.net application with a MS Access 2000 database (for reporting purposes etc.) using an ODBC link. Some tables of it are linked (another ODBC link) to a SQL Server 2005 database. I need to show some records in my application coming from a MS Access query running on LINKED tables (not imported tables) from the SQL database.Problem: when I IMPORT the tables, recordset is complete, when I LINK the tables, the recordset is empty (no records, only colum heads, no error message). Probably this is caused by the differences in SQL syntax (thank you Bill ;-)).This is my query in Access:SELECT IIf([dbo_cicntp.cnt_email]="",LCase([dbo_cicmpy.cmp_e_mail]),LCase([dbo_cicntp.cnt_email])) AS EMAIL, UCase(CStr([dbo_cicmpy.ID])) AS CODE, dbo_cicmpy.cmp_name AS BEDRIJF, [cnt_l_name] & " " & [cnt_f_name] AS FAMILIENAAM, dbo_cicntp.Gender AS MVJ, IIf(UCase([dbo_cicntp.taalcode])="NL","NL",IIf(UCase([dbo_cicntp.taalcode])="FR","F","E")) AS TAAL, IIf([dbo_cicntp].[active_y]=1,True,False) AS ACTIEF, dbo_cicmpy.SubSector AS VESTIG, "CATEGORIE" AS CAT, dbo_cicntp.cnt_f_tel AS TEL, Trim([dbo_cicmpy.cmp_fadd1] & " " & [dbo_cicmpy.cmp_fadd2] & " " & [dbo_cicmpy.cmp_fadd3]) AS STRAAT, dbo_cicmpy.cmp_fpc AS POSTNR, dbo_cicmpy.cmp_fcity AS GEMEENTE, dbo_cicmpy.cmp_fctry AS LAND, etc...FROM (dbo_cicmpy INNER JOIN dbo_cicntp ON dbo_cicmpy.cnt_id = dbo_cicntp.cnt_id) INNER JOIN dbo_pred ON dbo_cicntp.predcode = dbo_pred.predcodeWHERE (((dbo_cicmpy.DivisionCreditorID) Is Null));Is there any solution?Could this be a solution: make an first query to the SQL database just to gather the "clean" fields (I mean, without IIFs, Lcases, Ucases and other functions unknown by SQL Server I use now) and then adapt my query here above mentioned, and apply my IIF, Lcases and Ucases on the recordset returned by my first query?Thanks a lot for your time.Cl.
View Replies !
View Related
Replicated Readonly Db And Temporary Tables
I have two replicated databases i.e. 1. Database 1 is a live database where all live applications point 2. Database 2 is a replica of Database 1 and all reporting / BI applications point to this db. This is read-only. Is it possible for reporting applications, pointing to Database 2, to create temporary tables in the read-only database? Thanks
View Replies !
View Related
Why Would Tables Pulled In From ODBC In Access Be Different Than Tables In SQL 2005 Tables?
I'm new to my company, although not new to SQL 2005 and I found something interesting. I don't have an ERD yet, and so I was asking a co-worker what table some data was in, they told me a table that is NOT in SQL Server 2005's list of tables, views or synonyms. I thought that was strange, and so I searched over and over again and still I couldn't find it. Then I did a select statement the table that Access thinks exists and SQL Server does not show and to my shock, the select statement pulled in data! So how did this happen? How can I find the object in SSMS folder listing of tables/views or whatever and what am I overlooking? Thanks, Keith
View Replies !
View Related
Linked Server ODBC
Hi! I have a Problem with MS SQL Server 2000. I created a linked Server to an Oracle-Database via ODBC with the following syntax: EXEC sp_addlinkedserver @server = 'SRCLINKWORLD', @srvproduct ='ODBC', @provider = 'MSDASQL', @provstr = 'Provider=MSDASQL;DSN=vldbxxx;UID=dbadmin Name;PWD=media;' vldbxxx is an ODBC-node, i created, with the 'Microsoft ODBC Driver for Oracle' The creation of the server was sucessful, but if i execute a select-statement on the linked server, i get the following message: Der OLE DB-Provider 'MSDASQL' meldete einen Fehler. [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben] OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]. What is the problem?
View Replies !
View Related
Linked Server To ODBC
Hi,, I am trying to create linked server in sql2000 using odbc which point to foxpro free files. I tryed a lot but the following errro message is displayed: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]File 'data1020.dbf' does not exist.] thanks
View Replies !
View Related
Linked Server For Dbf W/o Odbc
pardon for this amateur question but can someone help me in setting up a linked server for dbf files without defining an odbc connection? can i use a similar script like BOL's text linked server: EXEC sp_addlinkedserver txtsrv, 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:datadistqry', NULL, 'Text' GO only for dbase files indicating the proper provider (w/c i don't know) instead of "TEXT"? thx in advance... chev
View Replies !
View Related
Linked Server - ODBC
I have a linked server set up to a FoxPro database. I have used the 'Microsoft OLE DB Provider for ODBC' as the Provider name, the datasource name is 'TestFoxPro' and the Catalog is AssetTracker. I have set it up and I am able to see the table objects in the Enterprise manager, but I am unable to select from the tables in the Query analyzer. I I have tried select * from Test2.assettracker.dbo.assets but i get the following error Server: Msg 7312, Level 16, State 1, Line 1 Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema. So i have tried three part name, but then it does not find the object. Any suggestions?? paull
View Replies !
View Related
ODBC Connection To A Linked Database
I'd like to set up an ODBC DSN to a table in a linked SQL Server, viamy local SQL Server.I'm having a few problems:1. When I use Enterprise Manager to link the remote SQL Server, itdoesn't allow me to select the database in the remote server. It onlyshows one database.2. When I use the Data Sources program to set up the ODBC DSN, it onlyshows databases in the local SQL Server, not in the linked one. If Itry typing it in: [NAMEOFLINKEDSERVER].databasename - it tells me thatit is an invalid table.
View Replies !
View Related
Connecting To A Linked Server With ODBC
I'm currently trying to access data from a Cache DB using MSSQL. I havelinked the Cache server through an ODBC connection. I can see in the LinkedServerexpansion all the tables in Cache for the File(?) I want to access.Here is my problem: Normally to access a linked sever I would do thefollowing:select *from ServerName.DatabaseName.dbo.TableNameI have triedselect *from ServerName.DSN.dbo.TableNameselect *from ServerName.DSN.SQLUser.TableName ("SQLUser" is the owner in Cache)None have worked (error no such object...)What is the syntax to select data on a linked sever via an ODBC connection?In the Linked server set up I have also check the RPC and RPC Out options...My ultimate goal is join tables in Cache and MSSQL into MSSQL.Any help would be greatly appreciated!Thanks,-p
View Replies !
View Related
SQL Express Linked Server With ODBC
I have SQL Server 2005 I have a linked server using an ODBC System DSN setup. A DB with a view to access on of the table from the Acomba DB. This view work just fine when I logged in using the Windows Authentification. If I create a user (bla) with "sysadmin" as server roles the user bla is the owner of the DB (he also created the DB) He can't access that view. But can access any tables from the same DB The error I keep having is the following : Executed SQL statement : SELECT * FROM OPENQUERY(ACOMBABD, 'SELECT * FROM Customer') AS derivedtbl_1 Error Source: .NEt sqlClient DataProvider Error Message: Cannot initialize the data srouce object of OLE DB prodiver "MSDASQL" for linked server "ACOMBA" Major over and out
View Replies !
View Related
Linked Server ( Not Able To Access Any Tables Under LINKED SERVER From My DESKTOP Enterprise Manager
Hi , On my Desktop i registered Production Server in Enterprise Manager on that Server if i go to SecurityLinked Servers There is another Server is already mapped, when i am trying to see the Tables under that one of the Linked Server i am getting the Error message saying that "Error 17 SQL Server does not exist or access denied" if i went to Production Server location and if i try to see the tables i am able to see properly, no problems why i am not able to see from my Desk top i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER) And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem What might the Problem how can i see the Tables in Linked Server from my DESKTOP Thanks
View Replies !
View Related
Linked Server Via ODBC And Stored Procedure
HiWe're trying to use call a stored procedure to update information in aremote Ingres database. We've linked the server, and can readinformation using SELECT * FROM OPENQUERY (..........), but we can'tfind a suitable syntax for executing a procedure.Using SELECT * FROM OPENQUERY and passing the EXEC statement in astring gives a message about not returning any columns - not surprisingas there aren't any, and trying to execute the procedure more directlyusing:-EXECUTE abrs..vipdba.ats_reader_pi0 ........Gives the errorCould not execute procedure 'ats_reader_pi0' on remote server 'abrs'.[OLE/DB provider returned message: Parameter type cannot be determinedfor at least one variant parameter.]Any bright ideas?Chloe
View Replies !
View Related
ODBC / Oracle Linked Server Problem
I have a SQL server that I am trying to link to a number of Oracle environments. After much tuning, we managed to achieve this although the four-part naming was not possible and we had to use Openquery and run pass throughs. Nothing in our configuration has changed and SQL Server is no longer able connect to the linked databases. The Oracle client on the PC is fine and is able tnsping any of the remote databases. I am also able to create ODBC connections to the remote databases on the SQL box that are fine. Using a datalink in DTS, I can connect to the remote databases. This suggests to me that there is something wrong within the actual database links. I have set them up using the working ODBC DSN's on the SQL box. If I try and run a query against them in Query Analyser, I get the following error message : Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name ] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]. If I click on the tables icon in EM to view the remote catalogues I get the following error : Error 7399: OLE DB provider 'MSDORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]. Any help that could be give on this would be greatly appreciated.
View Replies !
View Related
Troubleshooting Linked Server Connecting Via ODBC
I have created a linked server to a Visual FoxPro free table directory via ODBC usinng the following commands (The system DSN requires no authentication and I can access the data with Excel using this DSN): sp_addlinkedserver 'MyDb','','MSDASQL','MySystemDSN' EXEC sp_addlinkedsrvlogin 'MyDb', 'false', 'sa', NULL, NULL I tried a simple select from MyTable as below: SELECT * FROM MyDb...MyTable Query analyzer returns: OLE DB provider 'MyDb' does not contain table 'MyTable'. The table either does not exist or the current user does not have permissions on that table. What have I done wrong?
View Replies !
View Related
ODBC - Update On Linked Table Failed
I have upgraded a SQL Server 6.5 database to version 7.0 and trying to access it via MS Access linked table and getting the above error + time out. I have added a non clustered index on the timestamp column and while this worked briefly, it has regressed to failing with the same error again. Has any one encountered this problem/resolved this problem? Cheers ss
View Replies !
View Related
AS/400 Linked Server - ODBC And Query Syntax
Hi, I'm having a problem accessing tables in the as/400 using a linked server. SQL Server versions are SQL Server 2005 Developer SP2 (32 bit) and SQL Server 2005 Enterprise SP2 (64 bit). I've started with the developer edition (test environment), creating a dsn with both the iSeries Access ODBC Driver and Client Access ODBC Driver. I can then create a linked server with the Microsoft OLE DB Provider for ODBC. I want to select data from several libraries (which are added in the odbc connection), and I can select them with this syntax: SELECT * FROM OPENQUERY(DSN, 'SELECT COUNT(*) FROM LIB.TBL') If I take out the LIB part, I see the tables in the default library, but if I try the same with the other libraries I get an error. I understand that the reason is that those tables are not in the default library, but I thought it would go to the list I configured in the driver and try to find one with that name. Is there a way of getting data from tables that are not in the default library without using the library.table syntax with this or any other driver? Has someone got this to work in SQL Server 2000? (I think we had it working on this version, but I'm not sure) Thank you
View Replies !
View Related
Odbc Error Linked Table Access
I have access97 front end , with linked tables to sql server 2005. when i change a table ID column (type int) to primary key so it is updatable, then try open the table i get odbc error with no msg, if i alter table again to remove primary key option table opens fine but is not updateable. any ideas would be a great help
View Replies !
View Related
Odbc-timeout Error On A Linked Table From Access2k
Hi.I have the problem that some records in a ms sqlserver table is unableto update from Access.I get the error message odbc-time out error in linked table......I tried to copy this table to another database, where none but me wasaktive.And then it worked quit ok when I try to save the record.I am thinking about if there is some trigger och restraint that Idon't know about, but I don't know how to se all of this in thedatabase.I have changed the odbc-timeout settings in Access but that doesn'tseed to make any differenceSo what's the problem?Does anyone have an idea?/regards BigOlle
View Replies !
View Related
Performance Issues With Linked Server's With OLEDB && ODBC
Hello, I have a SQL Server instance on my local computer and an Oracle Database on a remote server. I want to run queries from tables within both databases and am using linked servers to accomplish this. I configure my linked server in SQL Server using the Microsoft OLE DB Provider for Oracle and can run queries using sql server tables and oracle tables. However, even the simplest queries take more than 10 minutes to run. I have the Oracle 9 Client Installed and MDAC 2.7. I configured my registry settings to match oracle 9's settings. However nothing i do improves the performance of the queries through the Microsoft OLEDB Provider for Oracle. When I use MS Access, or use an ASP page with the following string: Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "dsn=Oberon;uid=mfs;pwd=mfs;" I implement the ODBC driver that I configured in my system DSN and both run the same queries very fast. The data comes back without a problem. So i believe I have narrowed down my problem to the OLEDB Provider. However, SQL Server does not give me a choice to use the ORACLE native ODBC Provider. So then I tried using Pass-Through Queries and this worked alot faster in SQL Server...I am completely confused as to whats going on. Linked Server Query that takes over 10 minutes: SELECT * FROM OBERON..LOGS.DATA_PHOTO ldp where Machine=301 AND C3='I051097'; Pass-Through Query that works faster: select * from Openquery(OBERON, 'SELECT * FROM LOGS.DATA_PHOTO ldp where MACHINE=301 AND C3=''I051097''') From researching pass through queries, my understanding is that it actually uses ODBC to give the whole query to the remote database where the query is then run and the results are passed back as a table, thats why you say select * from (query)...however if my understanding is correct, then you cant combine tables in different databases very easily. And will it work with .asp and .aspx pages? Anybody have any insight as to whats going on?
View Replies !
View Related
Queries Against Linked Server To Informix Via ODBC Errors
What can be the reason(s) why I can't get data from a linked server using an ODBC datasource that works fast & fine from MS Access? I have an ODBC connection (System DSN) configured for an Informix ODBC driver. The Test button (belonging to this driver-setup) reports a successfull connection test. Getting data from this database by linking tables in MS Access works fast and easy. But I have tried for many days now to setup a linked server from SQL Server (2005) Creation goes fine, but as soon as I issue a query, (e.g. 'select * from infrem723...remotetable' or using 'openquery') I get the following error: --- Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "infrem723" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "infrem723". --- Why is Access able to read what "MSDASQL" cannot? I am desperate - can anybody help?Thanks a lot!
View Replies !
View Related
Linked Server To Oracle Via ODBC, Return Less Records
I have an Oracle 9i server. To access the data in Oracle, I setup an ODBC connection to it and am able to return data from it using WinSQL (a general ODBC database client). The SQL statement is simply "SELECT * FROM COLOR" and all 133 records returned properly. I need to copy the data from the Oracle server to SQL Express, therefore I set up linked server (by Microsoft ODBC provider) using the same ODBC connection as described above. The problem is: only 32 records returned. May I ask if there is any problem to this linked server setup? Thanks.
View Replies !
View Related
Return Records Through A Linked Server That Uses ODBC Data Source
Hi,I used sp_addlinkedserver to link to a remote server through ODBC.When I execute select count(*) from LinkSrv.SI.DBO.SIHeader in SQL QueryAnalyzer. It returns 13705 records. But when I execute select * fromLinkSrv.SI.DBO.SIHeader. It only return 885 records. If I specify somecolumns, select ODCOMP, ODPONO, ODVDCD from LinkSrv.SI.DBO.SIHeader.It returns more records, 1213 records.I guess there is something limit the return storage, but I can notfind it.Any suggestion will be appreciated. Thank you
View Replies !
View Related
Newbie: Why Do I Have To Use OPENQUERY To A Linked Server? (ODBC To Firebird Database)
Hello, pls. let me know where I could post if this is the wrong place. I have a Firebird 1.5 application. I created a linked server from my SQL Server 2000 to the firebird database. In SQL Server Query Analyzer I get errors from various ODBC drivers with "normal" queryies like SELECT LVNR FROM LINKEDSRV...LVVERW Pls. note, this all works perfectly in MS Access databases with ODBC-Links to Firebird! From a programmer of a commercial ODBC driver I heard that this problem may be caused internally by SQL Server, there may be no solution possible in the ODBC driver. One workaround would be to use the OPENQUERY-Syntax like SELECT * FROM OPENQUERY(LINKEDSRV, 'select LVNR from LVVERW ') Are there any other solutions? Are there any known issues with firebird odbc-drivers and sql server? Are there any known good drivers for the use with sql-server? What is the purpose of OPENQUERY - workaround ODBC problems? Are there any settings in SQL Server 2000 (2005 Express) that could help? Are there any settings in ODBC DSN that would help? regards arno PS: Here are my favorite error messages Error -2147217900 [OLE/DB provider returned message: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 89 "Col1014"] (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7312)Error -2147217900 OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005: ]. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' meldete einen Fehler. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 7399) This "tricky" query does not work: SELECT LVNR FROM LINKEDSRV...LVVERW; Error -2147217900 OLE DB-Fehlertrace [Non-interface error: Column 'ERHALTENABSCHLAG' (compile-time ordinal 35) of object 'LVVERW' was reported to have a DBTYPE of 5 at compile time and 131 at run time]. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' hat inkonsistente Metadaten für eine Spalte übergeben. Die Metadateninformationen wurden zur Ausführungszeit geändert. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 7356)
View Replies !
View Related
Readonly SA
I need to create a User who can see what SA can see. (No write acesss) If i create a user with data_readaccess to all the databases, that user could'nt see the old jobs, alerts etc. Any suggestion/ideas? -MAK
View Replies !
View Related
Database Readonly
I copied over a small website to 2003 Web Server and got: Exception Details: System.Data.SqlClient.SqlException: Failed to update database "D:INETPUBWWWROOTLUNCHCOUNTAPP_DATALUNCHCOUNT.MDF" because the database is read-only. It works just fine in VS - what to do? Thanks
View Replies !
View Related
ASPNETDB.MDF Is Readonly
I have downloaded and installed ASP.NET Ajax Sample applications from http://ajax.asp.net/default.aspx?tabid=47&subtabid=471 I am trying to run the AJAX TaskList example under C:ProgramMicrosoft ASP.NETASP.NET AJAX Sample Applicationsv1.0.61025TaskList First I moved the content of the TaskList folder to a virtual IIS directory, making it possible to debug the website on my local IIS server. When I run the example I get prompted to Login or register as a new user. When I submit the registration form I receive the following error message: Failed to update database "C:INETPUBWWWROOTTASKLISTAPP_DATAASPNETDB.MDF" because the database is read-only. How can I modify the permissions for ASPNETDB.MDF in order to run the TaskList example. Thanks
View Replies !
View Related
Readonly Setting For Database
we have a database that only serves Select requests (no OLTP) for our very high traffic websites. what are the benefits of turning on read-only setting for the database if there are no transactions occuring in the database? does sql server put locks on tables for SELECT statements? is it the same as using HINT (NOLOCK) ? thanks stephane
View Replies !
View Related
Execl Connection In ReadOnly
I am having a SSIS package which imports data from Excel (2003) files on the netoprk. Its so happenning that one of those files are opened by someone else & package is giving AcquireConnection error. As Package is only reading data from the files, i want to open the files in ReadOnly mode How can remove this error ?
View Replies !
View Related
Database Is ReadOnly When I Attach It...
Using SQL Express in this case, I have a database on one machine using one instance of SQLExpress that I detach. I then copy the database to a USB drive and take it to a different machine and attach it to a different SQL Express instance and it comes in as ReadOnly and I know of no way to change it. One difference is that I have different users on the two systems, is that the cause? I wouldn't think that this would cause the database to show as ReadOnly, thoughI would just think that I may not be able to access it aside from using sa. What is the likely cause of this? Thanks
View Replies !
View Related
MSDE And ODBC Tables
I have a MSDE database and I need to delete the contents of the exitingtables and then import new data on a scheduled basis from an ODBC datasource (preferable through a system DSN). This was easy to do in SQL2000 Enterprise given the DTS tools and then just scheduling a job thruthe agent.Is there an example of how I could do this just using scripts and MSDE(like a stored proc)? It looks like I have the agent still in MSDE touse.Help appreciated.Thanks,Frank*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
View Related
Updatable Cursor Claims To Be READONLY
Can anyone tell me why this might return that the cursor is readonly? As you will notice, I am using the FOR UPDATE OF property. DECLARE @txtStudentID varchar(50) DECLARE @lngStudentID int DECLARE @SiteLast tinyint DECLARE @txtStudentID_Last varchar(50) SELECT @SiteLast = 0 DECLARE txtStud_cursor SCROLL CURSOR FOR SELECT txtStudentID, lngStudentID FROM tblStudentASECertification# FOR UPDATE OF lngStudentID OPEN txtStud_cursor FETCH LAST FROM txtStud_cursor INTO @txtStudentID_Last, @lngStudentID FETCH FIRST FROM txtStud_cursor INTO @txtStudentID while @SiteLast != 1 BEGIN SELECT @lngStudentID = (SELECT DISTINCT lngStudentID from tblStudent WHERE txtStudentID = @txtStudentID) UPDATE tblStudentASECertification# SET lngStudentID = @lngStudentID WHERE CURRENT OF txtStud_cursor if (@txtStudentID = @txtStudentID_Last) Select @SiteLast = 1 FETCH NEXT FROM txtStud_cursor INTO @txtStudentID END CLOSE txtStud_cursor DEALLOCATE txtStud_cursor
View Replies !
View Related
ScriptComponent With Multiple ReadOnly Variables
I'm having trouble with a script component in which I'm trying to use two ReadOnlyVariables. If I use only one of the two variables, everything works without issue. If I use both of the variables (as part of a comma-delimited list) I get the following: The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created. I don't believe the variables themselves are the problem. Both are scoped to the package level and I can use either of them if I have it as the only variable. Seems bug-like, but thought I'd get some ideas before pursuing that route.
View Replies !
View Related
ODBC Connection - Lost Tables
I have a SQL Server database that I connect a front end to using an ODBC connection. Our LAN folks upgraded the server recently and now I can no longer see any of the tables through the ODBC connection that the user used for login has permission in SQL Server Enterprise Manager to see - throught the ODBC connection the user can only see things like: dbo.spt_datatype_info dbo.spt_datatype_info_ext dbo.spt_fallback_db dbo.spt_fallback_dev dbo.spt_fallback_usg . . . INFORMATION_SCHEMA.CHECK_CONSTRAINTS INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE etc. I've tried deleting the user for the connection and re-establishing it with owner permissions. I've tried deleting the dsn and re-establishing that as well but nothing so far. Please help!!!
View Replies !
View Related
Import Into Access Tables Using ODBC
Hi, I want to import into an MDB table a csv file. I'm trying to use the bulk copy table. my function is: SQL = "SELECT * INTO [my_table] FROM [ODBC;Driver=Micrsoft text driver (*.txt; *csv) ;Dbq=c:\;Extensions=asc,csv,tab,txt;].table.csv" db.OpenEx( "Driver=Microsoft Access Driver .mdb);DBQ=c:\access.mdb;", CDatabase::noOdbcDialog ); db.ExecuteSQL( SQL ); when i run this function i get an error : "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database" when i try to import in the same way a dbf file (insted the csv file) with VFP it's working well. what seems to be the problem? how can i fix it? or if some one know how can i import a large csv file into access DB in an efficient diffrent way? thanks ishay
View Replies !
View Related
Linked Tables
I have access tables which are linked to SQL database by ODBCconnection. By using Access, i can easily see my table contents. butwhen i am using ASP, i con not. I am getting this error messageMicrosoft JET Database Engine (0x80004005)ODBC--connection to 'SQL ServerMYDATABASE' failed.windows 2000, access XP, and sql 2000Please help me.Thank you
View Replies !
View Related
SQL Linked Tables
I have two SQL Server 2005 Databases running on the same server. I am working in a third database that needs to contain a union query to display data from one table in each of the other databases. In other words, within Database 3, I need to create View C.. This view will show takes Fields W & X from Table A in Database 1.. and union those values with Fields Y & Z from Table B in Database 2.. a) Does this make any sense? b) What is the best way to do this? (I searched, but anything with the phrase 'linked table' brought up results almost exclusively from the Access forums..) Thanks!
View Replies !
View Related
|
TRACKER
