When trying to access an ASP page connecting to a SQL database, I receive the following error from the driver
[Microsoft][ODBC SQL Server Driver][SQL Server]Create of work table failed because the row size would be 3697. This exceeds the maximum allowable size of a row in a table, 2014.
I can't remember if one of the sp_configure options handles this or not. Can anyone refresh my memory?
Thank you,
Dale Gantz
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
I have an application that connects to SQL 2000 thru ODBC.
When our administrators login on the workstation the application
works well. But when ordinary users login they get the following error.
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
I have restarted SQL Server and IIS to no avail. We are using SQL and Windows auth mode.
Any ideas? This just started this morning.
We have an application that connects to SQL 2005 thru ODBC with the following string:
driver=SQL Server;server=server1;database=db2005;uid=serveruser;pwd=pwd1;
When our administrators login on the workstation the application works well. But when ordinary users login they get the following error. (We only have 1 domain)
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
Then the standard SQL Server Login window pops up asking for the Login ID and Password. On the window the 'Use Trusted Connection' is checked and the name of the user on the workstation appears on the LoginID. What we do is uncheck the 'Use Trusted Connection' then login using the credentials above.
Need help on this one please. Thanks.
I have a ASP.Net application. I'm trying to access access data using SQL Server
my web config has
<add key="connectionString" value="DRIVER={Sql Server};Server=(local);initial catalog=ymquizco_registration;User ID=sa;pwd=test"/>
MY CONNECTION STRING HAS THIS VALUE
"DRIVER={Sql Server};Server=localhost;initial catalog=ymquizco_registration;User ID=sa;pwd=test"
But the conn.Open();is throwing this error:
{"ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\ASPNET'.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\ASPNET'.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute" }
My SQL Server is configured at mixed mode authentication. This seems like a install issue. Can someone think of something.
I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
View 10 Replies View RelatedHi,
I am trying to connect SQL server7.0 through ODBC 3.5,when i tried to create DSN ,i am getting below error message.I added alias with server name as IP Address in client network utility,But no use.I tried to connect through query analyzer but no use. ( Client M/c and Sql Servers are on T1 network)
** But i am able to connect through ISQL
I am not understanding why i am not able to connect through ODBC and query analyzer.Can some one help me in this.
ERROR MESSAGE:
****************************************
unable to connect to the server {....IP Address....}. odbc:Msg 0, Level 16, State 1 [Microsoft][ODBC SQL Server Driver]Timeout expired
******************************************
Thanks
Ananth
"""
Hello,
I have a problem with ODBC Driver for SQL Server 6.5. The user always receive the following
message in client machine when try to access the application : "08S01 : [Microsoft][ODBC SQL
Server Driver]Communication link failure".
Anybody knows how I resolve this problem ?
Thanks....
Hi,
Has anybody had any luck using the Microsoft SQLServer ODBC drivers (Driver version: 03.81.9030, ODBC version : 03.52)
to connect to a SQL Server 2000 database and passing in a SELECT with a FOR XML clause. I keep
getting Error [Microsoft][ODBC SQL Server Driver][SQL Server]The FOR XML clause is not allowed in a CURSOR statement
., State: 42000, Error: 6819.
Is there a work around (eg putting the select in a stored procedure) or am I missing something ?
I am using SQLExecDirect() to execute the statement.
Or could any one suggest a better way to retrieve data from a standard table in XML formated string?
Please Help!!
Hi,
I'm attempting to use the SQLExecute function to make a query to a SQL Server DB through ODBC.
However, the column I am trying to retrieve is called "date". When I try and query, I get back the message, "S0022: Invalid column name 'date'".
I believe I'm getting the error because date is a sql keyword (however if I run the query directly through SQL Interactive, I do not get a problem).
If anyone knows how I can get around this problem, that would be very helpful, as it is not possible to change the column name.
Thanks in advance.
Khalid.
Hi,
When Iam browsing my website, It showing an error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbl_Users'. (this is the table name)
Why this error is comming
Please help me!
Shaji
I am experiencing the following error in a server 2003 and SQL 2005 environment.
I don't know much about SQL, and any help would be appreciated. I have been told to look at the ODBC, as well as several items in SQL. But alas I have not been able to do much with it. Software program was purchased and support for the system is extremely limited.
Here is the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'insert server name' in sysservers. Execute sp_addlinkedserver to add the server in sysservers.
I appreciate any help anyone has to offer.
I have two servers named Zulu and Zul1 with SQL Server 2000 Standard Edition.
I am trying to implement SQL Server 2000 replication. Before do this, I would like checking the connectivity between the two servers by using "ping" and "odbcping" command.
With ping command, the result is good (I get the reply from other server).
When I use odbcping, from Zulu to reach Zul1, I get this error:
“ Could not connect to sql server
SQLState: 08001 Native Error:17
Info. Message [Microsoft][ODBC SQL Server Drive][DBNETLIB]This Sql server doesn't exist or access is refused
SQLState: 01000 Native Error:1326
Info. Message [Microsoft][ODBC SQL Server Drive][DBNETLIB]ConnectionOpen <Connect<>> ”
But when I use odbcping from Zul1 to reach Zulu, I get the good message
“CONNECTED TO SQL SERVER
ODBC SQL Server Driver Version 03.80.0194
SQL Server Version: Microsoft SQL Server 2000 – 8.00.194 (Intel x86)
Aug 6 2000 00:57:48
Copyright © 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)”
Note:
* I use the same SQL Server user i.e. sa with the same password in the odbcping command.
* Zulu1 is under a firewall, Zulu is on our DMZ zone for public access.
* Zulu1 is a Windows NT 4.0, SP 5 and Zulu is a Windows 2000 server.
Thanks for reply
Rgs
Michel
Hi all,
Current (working) Environment within same domain:
Quote:
MS SQL (v8 sp3?) on windows 2000 sp3
web server on windows 2000 sp3
New (not working) Environment:
Quote:
MS SQL (v8 sp3?) on windows 2000 sp3
web server on windows 2003 sp3
when i try to connect to the remote sql db (the asp page code has remained unchanged), i get this error:
Quote:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Default.asp, line 567
line 567 is the attempt to open the connection (again, no code changes).
The ODBC reg tree has the IUSR internet guest account permissions.
When I try to create a system DSN via the ODBC manager on the current, working system, I can see a list of the SQL boxes on the network. When I try the same on the new 2003 server...our SQL server list isn't displayed.
Any ideas on why I'm getting this error in the asp page?
{UPDATE}
Creating a system DSN on the new 2003 server works, if the "Named Pipes" network libraries are choosen in the set up. If the TCP/IP network libraries are choosen...the connection fails. Named pipes uses port(s) 445 & 139. The TCP/IP libraries use port 1433.
Why would Named pipes work and not TCP/IP?
Thanks.
P.S. I posted this in the O/S forum, but it looks like no one browsing that forum can help on this, so it was suggested I post in the DB forum.
http://forums.devshed.com/showthrea...061#post1086061
Hi everyone,
I am getting the below error when I try to access the table in 2005 database through 3rd party application from the application server.
“[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt�
This database was restored from sqlserver 2000, so the ODBC connection in the application server first was pointing to 2000 database and now its dropped and recreated to point to the 2005 database.
I dont get this error message when I do the same action from my pc.
I google'd on this error message, and I am not sure if the driver has to be upgraded or if there is anything else that I am missing here.
Thanks much.
I have a weird problem.
I have an SQL Server running my database, I connect to it through a VPN, I'm linking tables with it using ODBC from my Access database. I can see the data without problems. But when I attempt to run a query in my Access which basically creates a local copy of a table I sometimes get the following error: -7776.
After having searched a bit for the error, I found out that it is an ODBC error that is concerning date/time conversion.
-7776 SQLGetData(SQL_C_TIMESTAMP)
Illegal date/time value returned.
I do not have any timestamp datatypes in my SQL server table, they are all datetime datatypes. I have checked the data, all of the dates seem legal dates, no NULL values.
The problem is not consistent, it does not occur at every attempt, it appears about every third time but not consistently. And not at the same location each time. If I stop importing my datetime column, I avoid the error.
From my home location I do not get the error, and neither if I run without my company firewall. However from within the company firewall the error occurs at random times, and at random locations (always the datetime column though).
I find this extremely weird, and even though the problem could seem to be my firewall I somewhat doubt that, since I'm able to see the data if I use a SELECT query, but not when making a Make table one. And since it is always concerning my datetime column (which is not called datetime, datetime is simply the datatype).
I am using Access 2003 and SQL Server 2005.
If you need any further details, please do not hesitate to write.
Hi all
This Job ran yester day fine,to day It got failed with this error
any suggestion to troubleshoot problem is appreciated.
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814)
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Help file: SQLDMO80.hlp
Help context: 1131
Error Detail Records:
Error: 0 (0); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
Hi everyone
I have installed SQL server on my server machine. using localsystem and mixmode option.
It is working fine.
I installed sql server with connectivity tools only option on my client computer.
now, When i try to connect to server using data source from control panel --> Administrative tools --> Data source(ODBC).
but I cant connect.It gives me error as below.
Connection Failed:
SQLState:'HYT00'
Sql Server Error:0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.
I uninstalled sql server from my client and server computer. and installed again.
I tried to ping from client computer to server computer it is working.
even i tried telnet sqlservername 1433
this one is also ok.
But same error facing
Please help me out.
Regards,
ASIF
We are trying to upgrade a SQL server 2000 to a SQL 2008 R2 (SP1) server. After migrating, the developer test code, and got an error: ERROR [HY010] [Microsoft][ODBC SQL Server Driver]Function sequence error...But this is a release for 2008, ours is already 2008 R2 SP1, so that hot fix should already be included since it is always cumulative.
View 2 Replies View RelatedI am getting an error (number -2147217887, error message "ODBC--call failed.") when I try to execute an rst.Update. I have an MS Access 2013 application using an ODBC connection to SQL Server 2008 r2. I am using a query to update a table. It is a simple Select query with no joins. I have checked to make sure the table can be updated.
I was not sure if there were any special permissions that I need to set to allow a linked table to be updated in MS Access this way?
Hello,
Until a few weeks ago I was very satisfied with my frontend/backend application Access 2003/SQL Server Express. Then I tried to build a website with Dreamweaver 8.0 and connect it to the Server DBase and everything went wrong. My problems are the following:
In trying out the connection between DW and SQL I tried and changed some things with no result. I suddenly got a problem with the Norton firewall (wurms part) and with the named instance. At this very moment I sometimes have to switch from ".SQLEXPRESS" to "<machinename>SQLEXPRESS under Windows authentication. (provider: TCP provider, error 0 - no connection because of an active refuse of the goalcomputer)(MSQL Server error 10061). How can I solve this problem?
The connection between DW (using ASP) and SQL Server always gives the same error: "ODBC drivers error 80004005 cannot open database x requested by login. The login failed". I tried everything I know (that isn't much by the way) but getting no connection between the two programs. When I test the connection and the recordset in DW everything is OK. Anyone any suggestions?
The third problem is the most important. By doing things like (1) en (2) my frontend/backend database has become very very slow (it takes minutes to get a simple query done) and in fact doesnot function at all. When I look in de SQL part everything seems OK and I can open the tables quickly, but in Access the menus work but the forms and queries don't. This problem is very essential to me and I hope there is a solution?
I hope I'll get some answers to the above questions.
Thanks in advance.
Rob
I have a report that accessed a Visual FoxPro 6.0 database via ODBC. Since I upgraded to Visual FoxPro 9.0, now I am getting the error:
Query Server Error
DMS-E-RBI_TABLE The table or view <table name> was not found in the dictionary
I've verified that the right path is setup and I've tried installing about every driver and none of them are working. I created a new database in 9.0 and the I can access it fine. Also, there are old tables that are accessible in the same path, just not the ones I need. Any ideas would be helpful..
Where i try to create stored procedure in sql server 2000 using query analyzer i'm getting an error
'[Microsoft][ODBC SQL Server Driver]Syntax error or access violation'
and the same stored procedure if i try after some time without any changes it gets created..
how is wrong?
Hi !
I'm trying to load data in sql server table with Bulk Copy Program (BCP).
I have the following errors.
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file
In my File to load i have this :
Hello1¤Hello2¤17/02/2004
TOTO1¤TOTO2¤17/02/2004
TITI1¤TITI2¤17/02/2004
My definition table is :
create table tab1
(
TABLE varchar(20) null ,
PK varchar(50) null ,
DATE datetime null
)
go
I launch bcp with this command :
bcp.exe "BASETEST.dbo.tab1" in "c: ab1.out" -c -CRAW -t¤ -m100 -Smyserver -U -P -o"c: ab1.log"
The file "table1.out" is making with a C program.
Do you have an idea ?
Thanks.
Hi guys! I am using SQL 2005 and I wonder why I am encountering the error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation" everytime I am trying to create stored procedure with temp table and table variable.
See my code below with temp table.
Any thoughts will be appreciated!
CREATE PROCEDURE DBO.SAMPLESP
(@DETAILS AS VARCHAR(8000),
@ID AS VARCHAR(15))
AS
BEGIN TRANSACTION
CREATE TABLE DBO.#TEMPTABLE
{
ASSET VARCHAR(50)
}
DECLARE @INSTINSERT AS NVARCHAR(4000)
SET @INSTINSERT= 'INSERT INTO #TEMPTABLE(ASSET)'
SET @INSTINSERT= @INSTINSERT+ @DETAILS
EXEC sp_ExecuteSQL @INSTINSERT
INSERT INTO InstDetail
(TrackNum, ASSETID)
SELECT @ID, A.ASSE
FROM #TEMPTABLE A
DROP TABLE #TEMPTABLE
IF @@ERROR != 0
BEGIN
ROLLBACK TRANSACTION
RAISERROR('There was an error in here', 11, 1)
RETURN
END
ELSE
COMMIT TRANSACTION
Hello All,I am getting the following error when attemping to open a table inSQL2kSP3a.________________________________________SQL Server Enterprise ManagerDatabase Server: Microsoft SQL ServerVersion: 08.00.0760Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format_________________________________________I cannot find it in sysmessages, or on the web.Any ideas about how to resolve this? And how it occured...Thanks,TGru*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedI apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.
I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
I created very simple table with 3 columns and one is varchar(max) datatype
When i insert records thru VC++ ADO code i am getting this error
Exception Description Multiple-step OLE DB operation generated errors. Check e
ach OLE DB status value, if available. No work was done. and Error Number:: -2147217887
ODBC Driver: SQL Native Client
SQL server 2005
Table
CREATE TABLE [dbo].[RAVI_TEMP](
[ID] [int] NULL,
[Name] [varchar](max) NULL,
[CITY] [varchar](50) NULL
)
VC++ code
#include "stdafx.h"
#include <string>
#include <strstream>
#include <iomanip>
int main(int argc, char* argv[])
{
try
{
HRESULT hr = CoInitialize(NULL);
_RecordsetPtr pExtRst = NULL;
_bstr_t bstrtDSN, bstrtSQL;
bstrtDSN = L"DSN=espinfo;UID=opsuser;PWD=opsuser;";
bstrtSQL = L"SELECT * FROM RAVI_TEMP";
_variant_t vartValueID,vartValueNAME,vartValueCITY;
_bstr_t bstrtValueID,bstrtValueNAME,bstrtValueCITY;
pExtRst.CreateInstance(__uuidof(Recordset));
hr = pExtRst->Open(bstrtSQL, bstrtDSN, adOpenDynamic, adLockOptimistic, adCmdText);
hr = pExtRst->AddNew();
bstrtValueID = L"1";
vartValueID = bstrtValueID.copy();
bstrtValueNAME = L"RAVIBABUBANDARU";
vartValueNAME = bstrtValueNAME.copy();
bstrtValueCITY = L"Santa Clara";
vartValueCITY = bstrtValueCITY.copy();
pExtRst->GetFields()->GetItem(L"ID")->Value = vartValueID;
pExtRst->GetFields()->GetItem(L"NAME")->Value = vartValueNAME;
pExtRst->GetFields()->GetItem(L"CITY")->Value = vartValueCITY;
pExtRst->Update();
pExtRst->Close();
}
catch(_com_error e)
{
printf("Exception Description %s and Error Number:: %d",(LPTSTR)e.Description(),e.Error());
return e.Error();
}
return 0;
CoUninitialize();
}
if i use regular SQL ODBC driver, no error but its truncating the data
Adv Thanks for your help
Can anyone give a quick description of the meaning of this message andwhat needs to be done to get a connection.I'm running DBArtisan with SQLServer 2000 client SP4 installed.I also get the same message with MS Enterprise Manager so this iscoming out of the actual ODBC connection attempt.Thanks in advance!
View 1 Replies View RelatedThe following (VB.Net) code causes exceptions at seemingly random times.
Any suggestions?
Not sure if the problem is in .Net's ODBC support or in Sql Native Client.
If MARS is off, usually after less than 100 loops:
Code Snippet
System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [HY000] [Microsoft][SQL Native Client]Connection is busy with results for another command"
Source="SQLNCLI.DLL"
Turning MARS is on bypasses that error, so it will sometimes survive a thousand or so runs before hitting:
Code Snippet
System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [23000] [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'Number', table 'tempdb.dbo.#TempTable___..(shortened to fit).. _________000000002F3F'; column does not allow nulls. INSERT fails.
Source="SQLNCLI.DLL"
Code here:
(Console Application, empty database,
Visual Studio 2005, .Net 2.0, Windows XP,SQL Server 2005 or SQL Express 2005, Local or Remote)
Code Snippet
Module Module1
Sub Main()
'Dim connection As New SqlClient.SqlConnection("database=TestDB;server=.sqlexpress;Integrated Security=SSPI;") 'Doesn't crash
'Dim connection As New OleDb.OleDbConnection("Provider=SQLNCLI;database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Doesn't crash
'Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Crashes
Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;MARS_Connection=yes") 'Crashes
VBMath.Randomize()
Dim run_count As Integer = 1
connection.Open()
Console.WriteLine("Connected!!")
While True
'connection.Open()
Dim testcmd As New Odbc.OdbcCommand("CREATE TABLE [#TempTable] (Number int PRIMARY KEY)", connection)
testcmd.ExecuteNonQuery()
testcmd.Dispose()
testcmd = Nothing
Dim dtTemp As New DataTable
Dim daTemp As New Odbc.OdbcDataAdapter("SELECT * FROM [#TempTable]", connection)
daTemp.MissingSchemaAction = MissingSchemaAction.AddWithKey
daTemp.Fill(dtTemp)
Dim cbTemp As New Odbc.OdbcCommandBuilder(daTemp)
Dim viewTemp As New DataView(dtTemp, Nothing, "Number", DataViewRowState.CurrentRows)
Dim i As Integer
For i = 1 To 1000
Dim test_number As Integer = CInt(Rnd() * 2000)
If viewTemp.Find(test_number) = -1 Then 'Keep it unique
Dim new_temp_row As DataRowView = viewTemp.AddNew()
new_temp_row("Number") = test_number
new_temp_row.EndEdit()
End If
Next
daTemp.Update(dtTemp)
'daTemp.Dispose()
'daTemp = Nothing
'cbTemp.Dispose()
'cbTemp = Nothing
'dtTemp.Dispose()
'dtTemp = Nothing
'viewTemp.Dispose()
'viewTemp = Nothing
Dim testcmd2 As New Odbc.OdbcCommand("DROP TABLE [#TempTable]", connection)
testcmd2.ExecuteNonQuery()
testcmd2.Dispose()
testcmd2 = Nothing
'connection.Close()
'GC.Collect()
'Console.Write(".")
run_count += 1
End While
End Sub
End Module
Usually the ".Update" triggers the exception, but sometimes the other sql commands do it.
Have tried various experiments with disposing of objects immediately when finished, but no effect.
Opening and closing the connection each loop seems to delay the errors, but it still happens eventually.
I keep getting this error:
OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000
I do not want to add the login account to sysadmin role on my production server and giving the logon account db_reader rights to my database is not working. Is there another way around it.
Hi,
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
Any help will be appreciated.
Thanks,
vtluu.