Random Connection Drop With ODBC And SQL Server 2005
We have a legacy C++ application which uses ODBC to connect to SQL server. The application is a server process that opens a connection and caches it. Unfortunately on a connection drop, it does not refresh the connection. The standard installation is a 3 machine web/app/sql setup.
It has been working fine since last 4-5 years unless the SQL Server goes down. In that case, I keep seeing "Function sequence error" and "Communication link failure" errors. On one particular client installation on application server, I started getting this exception while SQL Server was up and running (on a different machine). I would see the connections randomly dropping in the activity monitor after 3-4 hrs of inactivity.
I wrote a .NET test app which uses ODBC drivers for SQL Server and makes a connection and then just waits. Out of 5 connections established by this application I saw one connection being dropped as well. Another test app used ADO.NET and it did not drop any connections. I asked the IT to check the network and they say its fine.
The servers are W2k3 SP2 and database is SQL Server 2005. IsAutoClose on all the databases is false. Nothing goes in the logs even after turning on traces using DBCC.
Since the connection drop was very random, I turned off connection pooling on "ODBC driver for SQL Server" on the application server and now it is working fine.
Can someone explain me what could be the reason? Also, is there a way to upgrade or downgrade ODBC drivers on W2K3 machines?
Thanks,
Pranav
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Making ODBC Connection....Sql-server 2005 Driver
Hi everybody I have installed SqlServer 2005 on my server but my Windows application on the client computers should connect to server via ODBC connection so what should i install on the client computers (that don't have any sql server installed) to enable them to connect? When i want to create ODBC connection on client computers through (Control panelAdministrative ToolsData Sources) i don't see SQL-Server 2005 ODBC driver in the list ....could anyone help me? Kind Regards.
View Replies !
View Related
Importing Data In MS SQL Server 2005 Using Odbc Drivers From A Remote Connection
hello there! i have a problem importing data from a remote connection using Sybase ASE ODBC driver(the sybase odbc driver is the only way we can access the database from the remote connection, we've already tried this in crystal reports). in the sql server import export wizard i chose the .net framework data provider for odbc. then below the wizard requires the following info: the connection string, DSN and driver. i specified the correct driver and dsn. in the connection string i specified the user id and the server name but it still produces error. the error says: the operation could not be completed. additional information: ERROR[01000][SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server. ERROR[01000][SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server. i need your help guys... thnx
View Replies !
View Related
How To Catch Severity Level From SQL Server 2005 In Centura 4.1 Client With ODBC-connection?
We have a client application developed in Centura 4.1 for Sybase dB. We have now migrated the DB to SQL Server 2005 and we have a problem: For several reasons we must use ODBC and when the DB raises a warning (severity level < 11 ) the Centura-client must ignore this. As it works now the client raises an error an stops execution. When using Sybase the client got the severity level from the DB and the client ignored all levels that was < 11. We now cannot do that since we do not get that info from the ODBC€¦ So I wonder: Can we stop the SQl Server from raising errors with severity level < 11 (=warnings)? How do we get the severity level and not only the ODBC number and text in the client..? We also tried using ODBC in SQL Native Client, but has not (yet) got it working with the Centura Client€¦ TIA Claes Wedin Encora AB
View Replies !
View Related
ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer
Hi All, I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine. I would now like to install my application on another workstation and connect remotely to the database located on my development machine. The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver? Thanks!
View Replies !
View Related
ODBC Connection To SQL 2005 Express
I am attempting to setup a SQL Server 2005 Express database as a backend to an Access MDB, and need to establish an ODBC data source for the backend database. On two different systems (Windows XP Pro and Windows 2003 SBS), I get an error that says I cannot connect to the SQL Server. I get a message that says: Connection failed: SQL State 08001 SQL Server Error: 2 [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server That is followed by a Login timeout expired and a suggestion that under the default settings SQL Server does not allow remote connections. I have shared memory, named pipes and TCP/IP protocols enabled, and the firewall set to allow connections on port 1433. And the Express manager seems to work OK. I see several posts about issues with ODBC, but none of the suggestions seem to help in this situation. Can anyone suggest something to try? Thanks in advance.
View Replies !
View Related
Problems With ODBC Connection To A 2005 Cluster
Here's what I hope turns out to be a quick question... I've got SQL Server 2005 SP1 w/hotfix 2153 running on a Windows 2003 R2 cluster. It's set up to accept Named Pipes and TCP/IP on port 1433. The IP of the virtual server, named MSSQLCLUSTVS01, is 10.88.244.85, the IP of the cluster is 10.88.244.52, and the two machines making up the cluster are 10.88.244.50 & .51. I'm having trouble creating ODBC connections. When I create an ODBC connection using the server name, it works correctly. When I create it using the IP (10.88.244.85), it fails. I can connect to the IP through SSMS. I can ping the server name, and it resolves to the 244.85 address; I can ping the 244.85 IP. I can open a telnet connection to MSSQLCLUSTVS01 on 1433, and I can open a telnet connection to 10.88.244.85 on 1433. I'm using the Data Sources administrative tool in Windows XP Pro to create and test the ODBC connection. I've tried using both Windows security (my login has sa rights to the server) and a SQL login I created for this purpose, both result in the same problem. This comes up because one of our developers is working on a web service that will need to connect to a DB on this server using a dedicated SQL login. For some reason, nodes on the VLAN of the server he'll be using can't resolve DNS entries on the VLAN the server is on (I'm working on getting this problem fixed, also, of course), so he needs to use the IP. When trying to open an ODBC connection to the server by IP, he gets good old error 17, "SQL Server does not exist or access denied." If anyone has an idea, I'll give him or her a cookie (yes, it will say it's from doubleclick, but trust me, it's from me).
View Replies !
View Related
Cannot Connect To SQL 2005 Using System DSN ODBC Connection
I am running SQL 2005 SP1 on Win 2003 Std x64 SP2. I get an error trying to connect using an ODBC System DSN connection. The ODBC connection gets the following error: Connection failed: SQLState:'28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' The SQL Server logs the following error: 18456, Severity: 14, State: 8. I have tried this with several SQL accounts. I am able to login to the SQL Manager with the accounts without issue. It is only when trying to connect via ODBC that I get the error. I am currently downloading SQL 2005 SP2 to see if this will help with the issue. Any other ideas would be greatly appreciated. Thanks. John
View Replies !
View Related
Creating ODBC Connection To SQL 2005 Express
Hey guys, Hope one of you can help me. I've got SQL Server 2005 Express installed on a laptop. I'm trying to create an ODBC connection to it so that I can access the database from a program locally that will be writing to it. I can connect to the SQL instance by listing the server name as DSR-XXXXXXX(ComputerName)SQLEXPRESS However... when I access that ODBC connection, it doesn't see the database DBProScout (which was created inside SQL Express on this laptop locally), and I cannot access the tables within it. The only tables that I can access are system tables associated with SQL Server Express. What could I be doing wrong? Thanks! Todd
View Replies !
View Related
Random Unique Values In SQL Server 2005
Hi I am using VS 2005 with SQL 2005. I had a Datagrid and i Need to bind data into it. I need to show Random Unique ID's based on the Parameter i pass. I wrote select top 5 * from Employee order by NEWID() for this i had created a Stored Procedure as create Proc Demo(@N int)as beginselect top @N * from Employee order by NEWID()end Its showing a syntax error near @N. How can i pass the parameter for Select Top @N * from .......
View Replies !
View Related
Random Connection Refused?
I am having a random "connection refused" error from my java application. Sometimes it's fine, apps running without any problem, but sometimes this exception comes up. I am writing this app at home and my SQL server is at office (behind a router with SPI firewall, but i have port forwarded TCP port 1433 for the connection). If I telnet to SQL server, i wont get any error message but a blank screen, it looks like the server side is waiting for my console input. IDE: NetBeans IDE 6.0 (Build 200711261600) JavaSDK: 1.6.0 build 1.6.0_03-b05 MSSQL JDBC Driver: should be latest (i downloaded off from MS website in early March) MSSQL: MS SQL 2005 Developer Edition com.microsoft.sqlserver.jdbc.SQLSe* rverException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect any help would be appreciated
View Replies !
View Related
ODBC Connection To SQL Server DB
I'm writing a VB app to read and write data to an SQL server database. I have successfully done so using ADO however I now need to do it using ODBC. I have set up the appropriate DSN and have no trouble reading data from the database but when I try to write to it I get a message indicating that the database is open for read only access. I'm no sure whether the restriction is and the VB, ODBC, or database level. Here's the code which opens the database and recordset. Set dbsWarehouseServer = OpenDatabase(ODBCDSName, _ dbDriverNoPrompt, False, _ "DSN=" & ODBCDSName) Set rstRailSet = dbsWarehouseServer.OpenRecordset("Select Store_date, SLN From " & TBName & " where Rail_set_ID = '" & RailID & "'", dbOpenDynaset) Any help is greatly appreciated.
View Replies !
View Related
ODBC Connection And MTS Server
Dear All, When trying to connect to the server outside the firewall through an ODBC connection string, we get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '[database name]'. Login fails. When trying to uncover some more information pertaining to this problem, we get the associated error number, 4060. When researching this number, we see that the number has an associated error severity code of 11. Thus Microsoft is saying that it is a problem that could be corrected at the user level. Ok, I am missing something. I give. Does anyone have a new idea or an approach on which I can begin to uncover new information? We have also checked the database login and the login for the MTSServices is in fact able to access the database through an integrated login with NT Security. Also the Domain Administrator for User Rights does not have the specific NT Group enabled to log onto the computer from the network but the 'Everyone' field is still on the server. If anyone has specific questions, email me directly. Thanks for your help in advance. Daimon
View Replies !
View Related
ODBC Connection To SQL Server
I use Business Objects XI R2 (BOXI) to report against a SQL Server 2000 database using an ODBC connection. When I query the database using Enterprise Manager on the server I can make use of all functions available within SQL Server, yet when I access it via the ODBC connection I only get a very small subset of SQL Server functions available. I can use the inbuilt BOXI functions, which work on the data locally, but would like the functions processed on the server instead. Is this constraint a property of the ODBC driver, and if so are there other drivers which would expose all of the available SQL Server functions. Any suggestions appreciated.
View Replies !
View Related
ODBC Connection To SQL Server Failing
Hi, I have an access 2003 database which connect to sql server via aDSN that goes through a VPN. The database works fine and everyone cancoonect from their normal computers but for anyone working on theirLaptops (IBM Think Pad T42's) they cannnot connect to the datasource.The DSN fails upon connection attempt with :Connection Failed:SQLState: '01000'SQL Server Error: 1326[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).Connection Failed:SQLState: '08001'SQL Server Error: 17[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not existor access is denied.This has been driving me insane as i cannot understand why it works forour desktop computers and not for our laptops. The version of MDAC isthe same on a computer that connects as it is on a laptop that doesn't.TCP/IP is enabled on the server and is using the default 1433 port.severs, desktops and laptops all patches and up to date with the latestSP's. DSN has been dropped and re-created. Domain user has been put inlocalAdmin group for laptop.I hope i'm mising something really obvious....can someone please pleaseput me out of my misery and tell me they have come accross this beforeand have a solution. Ive tried everything i can think of.CheersDan
View Replies !
View Related
BDE Connection Via ODBC To MS SQL Server Fails
Hi, I have a strange problem accessing a MS SQL Database from my network. I'm using an application that is based on BDE which uses ODBC to connect to a MS SQL DB. When I tried to connect from the network with BDE,I got this error message: BDE Error : 13059 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). On the server side I'm using W2003 EE ,MS SQL 2000 Standard with SP4, BDE5.11. On the client side it's an XP SP2 with MS SQL Client installed, same BDE 5.11 When I create an alias using ODBC and mapping to my server, it connects and the communication with the Database Server succeds: TESTS COMPLETED SUCCESSFULLY! When I'm trying to connect using BDE Admin and double clicking on the + sign of the alias I created usind ODBC admin I get the message I listed above. Any help would be appreciated, Thanks.
View Replies !
View Related
SQL Server ODBC Read-Only Connection Problem
Hi,I have two, similar SQL Server 7.0 databases (in the same SQL ServerGroup) that I use as the backend for two Access 2000 front endapplications - one is the live version, the other is the developmentversion.The live version works fine. But the other version is read-only, i.e.no changes can be made to the data in the tables, over the ODBCconnection.Both systems have similar ODBC connection properties, the permissionsettings on the SQL Server databases are the same - users, tableaccess, database access, etc. The connections use Windowsauthenication and the users are set up in SQL Server security loginswith public and db_owner selected.Has anyone seen or heard of this problem and does anyone have anyideas on how to fix it?I appreciate any comments or suggestions you may have.Thanks,Chris
View Replies !
View Related
Connection Failed - ODBC From Remote SQL SERVER
hello, im trying to create an ODBC data source from a SQL SERVER 2005 database located in a remoted pc. Client----------->PC1 : win 2000 sp4, not sql server Remote server--->PC2 : win 2000 sp4, sql server 2005 express From the Command Prompt, im typing "ping PC2" successfully. After, in the ODBC datasource administrator-->System DNS tab, i choose "sql server" as a new data source , and in the server box , i'm typing PC2/SQLEXPRESS. In the next steps, im typing the user-passwords. The error : connection failed ... [microsoft][odbc sql server driver][named pipes]ConnectionOpen(CreateFile()). Connection failed: SQLState: '08001' .. Client unable to establish connection What goes wrong? I follow the same steps locally, and everything is OK. Sorry for my bad english:cool:
View Replies !
View Related
MS SQL Server 2000 / MS Access - ODBC Connection Question
Hello all!I have such question to all of you.I have some tables linked from MS SQL Server 2000. Is time of processingquerybased on these linked tables from MS SQL Server 2000, faster or slower thanthe time of processing the same query based on tables, which are not linkedbutimported to MS Access?Can you answer this question?Thank you in advance for postsMarcin from Poland.
View Replies !
View Related
Getting ODBC Connection Errors With SQL Server 2000 On Windows XP
Hi all- I setup a new ODBC connection to MS SQL Server 2000 on Windows XP and keep getting the following errors when I try to either register a new SQL Server 2000 group within Enterprise Manager or test the new ODBC connection: Current configuration - MS SQL Server 2000 -Windows XP -ODBC 3.85.1117 Errors: I. Within SQL Server 2000 Enterprise Manager Error: SQL Server connection open II. When I test the ODBC connection: Microsoft SQL Server ODBC Driver Version 03.85.1117 Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. TESTS FAILED! Now here is what has me totally confused: I can use the command line ISQL to access the database on the server and IP is all correct and port is available. Any tips how to get this ODBC working? Thanks Ben Prusinski
View Replies !
View Related
ODBC Connection To SQL Server 2005sp2 Installed On VISTA.
Hi people i am getting a problem when im creating a dsn to sonnect the SQL server as the database for my content server.....................i tried all the tricks given by you people but its still not workin it is showins a message that ............. Connection failed. SQL State'01000' [Microsoft][ ODBC SQL Server Driver][Named Pipes]Connection Open (Connect()). Connection Failed: SQL State:'08001' SQL Server Error:17 [Microsoft ][ODBC SQL Server Driver ][Named Pipes]SQL Server doe not exists or access denied............................ Please any body can help me out with this problem..............? -------------------------------------------------------------------------------- Chetan
View Replies !
View Related
ERROR [HY000] Or ERROR [23000] At Random Times When Using Sql Native Client Via ODBC
The 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.
View Replies !
View Related
ODBC Connection Failing On 64 Version Of Windows 2003 Server
I have an application that talks to a SQL backend using an ODBC DSN connection. It works fine when running on a 32bit machine but fails in the 64bit environment. The DSN is setup properly on the 64bit box and the Test Connection returns sucess. However when my application tries to use the DSN to connect to the database I recieve the following error. IM002 - Data source name not found and no default driver specified. The data source name does exist, it's in the ODBC.INI and in registry. As mentioned above the Test Connection succeeds in the ODBC Administrator so logic would dictate that it's setup correctly. Any help would be appreciated.
View Replies !
View Related
SQL Server Express 2005 - How To Delete/drop A User Instance
Hi, I have been working around with SQL Server Express 2005 on VISTA. I created a small C++2008 application which interface with SSE 2005. When running my application, it automatically created a user instance which I would like to get rid of. I just forgot from start to set "User Instance = False" in my connectionstring. (oups...) I'm aware, from readings I did, that a couple of tables as well as log files, etc. are created under directory "utilisateurs...AppDataLocalMicrosoftMicrosoft SQL Server DataSQLEXPRESS". SQLEXPRESS is the instance name chosen during install of SSE2005. Also using following SQL Statement: select owning_principal_name, instance_pipe_name, heart_beat from sys.dm_os_child_instances I got following result: owning_principal_name: PC-DE-STEPHANEStéphane instance_pipe_name: \.pipe6172F4E8-622E-4A sqlquery heart_beat: dead (at this moment...) ==> How can I make a good cleanup of all this as well as get rid of the user instance itself? Thanks in advance for any help. Stéphane
View Replies !
View Related
Returning Random Records And NOT Similar (random Questions)
Hi,I need to extract randomly 5 records from the table "Questions". Now I useSELECT TOP 5 FROM Questions ORDERBY NEWID()And it works. The problem is that I need an additional thing: if SQLextracts record with ID=4, then it should not extract record with ID=9,because they are similar. I mean, I'd like something to tell SQL that if itextracts some questions, then it SHOULD NOT extract other ones.How can I do it?Thanks!Luke
View Replies !
View Related
Lost Connection To MySQL During Query In My ODBC Connection
I am trying to connect Visual Studio 2005 here in the Philippines to a MySQL server in CA, USA using the Connector/ODBC using the following parameters: DSN = mysqlodbc Server = host376.ipowerweb.com userid = myuid password = mypassword when i used the port 3036 i got the can't connect to MySQL on server blabla(10060) when i used the port 8087 i got the "Lost connection to MySQL during query. How do i connect successfully?
View Replies !
View Related
Error While Establishing A Connection To The SQL Server 2005 - Could Not Open A Connection To SQL Server
Hi, I had an old web application created during asp.net 1.1 and it have a connection problem with the sql server 2005 when it is mirgrated to a new webserver with dotnet framework 2.0 platform. I have enabled the remote access(TCP/IP and named pipes) in sql server 2005, did all the neccessary things, check whether the TCP/IP is enabled, named pipe is enabled... I created another web application using VS 2005. The database connection works perfectly well.This are the connectionString from the old web application.<appSettings> <add key="ConnectionString" value="Server=127.0.0.1;Database=somedb;User id=user; Password=somepassword; Trusted_Connection=False; POOLING=FALSE"/></appSettings> Thankyou in advance!
View Replies !
View Related
Connection Strings, Trusted-connection VS Username-password, SQL Server 2005 Express
All -- Please help. I have some questions about connection strings. BACKGROUND... Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005. Note that I do not want to use the "Attach a database file" type of connection string. Note that I am using the site http://www.ConnectionStrings.com as a reference. Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination. QUESTIONS... (A) What exactly does the error in Item 4 mean? (B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string? (C) Are there any alternatives? (D) What do you suggest? Please advise. Thank you. -- Mark Kamoski
View Replies !
View Related
Rounding Error: Between Flat File Connection Manager Source && OLE DB Connection Destination (SQL Server 2005)
I have a Rounding error: Between flat file connection manager Source & OLE DB Connection Destination (SQL Server 2005) in my Dataflow. File looks like this lets call column names Col A,B,C,D 70410000 RD1 1223631.92 196042.42 70329000 ICD 11025.84 3353.88 71167300 COL 104270.59 24676.96 flat file connection manager settings: first row Column names then Advanced tab Col A float , Col B float , Col C string ,Col D float , OLE DB Connection Destination (SQL Server 2005) CREATE TABLE [dbo].[PT_CUST_ABR]( [PARTY_NO] [float] NULL, [PARTY_NAME] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TELECOMABR] [float] NULL, [GENIABR] [float] NULL, Problem: ColA (Source) Rounding error to PARTY_NO (Destination) I have a field of text of in a flat file that the flat file connection manager Source picks up correctly €ś70000893€? However when it gets the OLE DB Connection Destination the data has changed to 70000896. That€™s before its even Written to the database. The only clue that something is wrong in the middle is the great Data viewer shows the number as 7.000009E+07 Other clues looking at the data it appears there is a rounding error on only the number that dont end in 00 ColA (Source) PARTY_NO (Destination) 71167300 71167296 70329000 70329000 70410000 70410000 Any ideas people? Thanks in advance Dave
View Replies !
View Related
Help. When Using Profile GetPropertyValue, I Get The Following Connection Error: An Error Has Occurred While Establishing A Connection To The Server. When Connecting To SQL Server 2005, This Failure May Be Caused By The Fact That Under The Default Sett
Hi,I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property((string)(this.GetPropertyValue("Address1")));When I look at the stack, it is coming from my ProfileWrapper class which adds user address, city, etc.. from a class which inherits fromSystem.Web.Profile.ProfileBase. From the stack, it is calling the System.Web.Profile and crashed when it tries to open a connection atSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject). I already migrated all aspnet_user, aspnet_roles, etc.. and don't get any connection errors. It is only when I try to get the profile data. This works on my pc, but throws an error on my lunarpage website.Any help is greatly appreciated.Thanks,AJAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)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: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:Line 100: public virtual string Address2 {Line 101: get {Line 102: return ((string)(this.GetPropertyValue("Address2")));Line 103: }Line 104: set {Source File: c:windowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files oot 021d50639a6858cApp_Code.54nvluyo.1.cs Line: 102Stack Trace:[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +435 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +782 System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428 System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +404 System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +117 System.Configuration.SettingsBase.get_Item(String propertyName) +89 System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36 System.Web.Profile.ProfileBase.get_Item(String propertyName) +68 System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +4 ProfileCommon.get_Address2() in c:windowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files oot 021d50639a6858cApp_Code.54nvluyo.1.cs:102 ProfileWrapper..ctor() in d:inetpubvhostsjavcentral.comhttpdocsApp_CodeProfileWrapper.cs:242 ProfileDataSource.GetData() in d:inetpubvhostsjavcentral.comhttpdocsApp_CodeProfileDataSource.cs:17[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +308 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +480 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1960 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.FormView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.FormView.EnsureDataBound() +163 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.FindControl(String id, Int32 pathOffset) +21 System.Web.UI.Control.FindControl(String id) +9 CustomerDetailsEdit.OnPreRender(EventArgs e) in d:inetpubvhostsjavcentral.comhttpdocsUserControlsCustomerDetailsEdit.ascx.cs:60 System.Web.UI.Control.PreRenderRecursiveInternal() +86 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
View Replies !
View Related
MSSQL Connection Using Castor JDO Via JDBC Always Drop!!
hi all, Currently... i'm using windows 2003, MSSQL 2000 standard edition for the database and also the castor JDO to create the object to make the socket connection via JDBC. My problem is.. the connection is always drop when i pump in a huge data such as 5000 records in the MSSQL database. It gives me this error: org.exolab.castor.jdo.PersistenceException: Nested error: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. When i try to re-connect and the connection is successful made...after certain duration, the connection will drop again and it will continuously dropping. But when i pump in a small amount of records such 500 into the database... i got no problem. I also got no problem pump in a huge data into MSSQL by using window 2003 platform. did anyone can help up or have any ideal to share?
View Replies !
View Related
Read Only ODBC To SQL SERVER 2005
I have a Login that I setup in SQL Server 2005. The only database roles given to the login are db_datareader and public. On SQL 2000 these permissions are sufficient to allow me to setup a read only ODBC connection using this login and creating an import table in Access. When using the login in SQL 2005 and creating an import table, I am able to edit the underlying data, something I am not able to do with a SQL 2000 ODBC connection. Is there something in SQL 2005 that I am unaware of that would allow this login to modify (update) the table?
View Replies !
View Related
|
TRACKER
