Connection ODBC Closed
That is an app ACCESS 2000 wih Named Pipe ODBC to SQL Server 6.5.
After 10 minutes without use this app, the connection closed !
Have-you idea for correct this probleme ?
Regards
Alain
View Complete Forum Thread with Replies
Related Forum Messages:
ExecuteReader Requires An Open And Available Connection. The Connection's Current State Is Closed.
I am accessing SQL2005 with C# code using OleDbConnection. A try and catch block catches the following error once a while between the Open() and Close() of the connection: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. I do not even have any idea where to start to debug this. The ExecuteNonQuery() runs a delete SQL query. It works 99.9% of the time. I do not see anything wrong when this error happens. Any hint would be greatly appreciated.
View Replies !
The Connection Gets Closed Right After It Opens.
I have the Function, that fires from onLoad even of one of the asp:Label controls on my main page. Here is it's code: SqlConnection conn = new SqlConnection(); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkraineConnectionString"].ToString(); SqlCommand comm = new SqlCommand("SELECT [Greeting] FROM [Misc]", conn); try { conn.Open(); } catch { Response.Write("Error opening connection in Page_Load of default.aspx to retrieve the greetings"); } string MyGreet = (string)comm.ExecuteScalar(); Greetings.Text = MyGreet; try { conn.Close(); } catch { Response.Write("Error closing connection in Page_Load of default.aspx after retrieving the greetings"); } } When it gests to conn.Open() in the debugging mode I see that the ServerVersion = 'conn.ServerVersion' threw an exception of type 'System.InvalidOperationException'. The most interesting thing is that it used to work before. Here is the connection string it retrieves fine. "Data Source=MDM1;AttachDbFilename=|DataDirectory|Ukraine.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" As I said it used to work, but one day I tried to access the web site and it said this error that I get, that the connection is closed. Then I was using the SQL Server Express. When in the Visual studio if I would run this same site in debug, everything was working fine. I decided to uninstall the SQL Express and installed the SQL Server. If I open the SQL Server Managment Studio in the Server name field I see MDM1(this is the name of the PC, but probably it is the same name for the Server. Well, in the MAnagment Studio it conects fine to the MDM1 so it is no probably the naming problem. Ithink it has something to do with permisssions. If someon can - please help. Thanks.
View Replies !
TCP Connection Forcibly Closed
Hello, My first issue is with errors that I'm getting from SQL stating that the connection was forcibly closed. After googling this error as well as searching this forum, I haven't been able to find much. I've had our IT guys check the network configuration and everything seems to be fine. I tried the SynAttackProtect key and it still kicks back the error even after restarting the server. I've also checked the SQL logs as well as Event Viewer and have yet to find anything useful. Does anyone have any other ideas/solutions for me to try? Thanks in advance. I'm running SQL 2005 SP 1 on a Win2k3 SP2 server.
View Replies !
This Connection Cannot Be Used To Perform This Operation. It Is Either Closed Or Inv
I'm trying to create a connection string to access SQL Server 2000 stored procs from MS Access 2003. I created a connection string using UDL and attempted to execute a stored proc. When the stored proc executes, I get the following error. This connection cannot be used to perform this operation. It is either closed or invalid in this context. I know the connection is open. Any thoughts about what could cause this? Thanks in advance for your help.
View Replies !
DB Connection Is Closed After It Is Idle For Some Time
I am using MS JDBC driver 2005 1.2 and in-house written connection pooling that was working fine for a number of years. This combination worked OK with SQLserver 2000. But recently we switched to SQLServer 2005 (x64) on WIN Server 2003 Standard x64 eddition. Everything seems work OK during business hours, however, after business hours when there are lesser users and connection stays idle for sometime, I am getting the following error: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source) at com.nms.serverframework.dbaccess.OnlineTransactionManager.freeConnection(OnlineTransactionManager.java:420) at com.nms.serverframework.dbaccess.OnlineTransactionManager.releaseConnection(OnlineTransactionManager.java:707) at com.nms.serverframework.dbaccess.OnlineTransactionManager.releaseConnection(OnlineTransactionManager.java:688) at com.nms.serverframework.dbaccess.OnlineTransactionManager.finalize(OnlineTransactionManager.java:399) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) at java.lang.ref.Finalizer.access$100(Finalizer.java:14) Any help would be appreciated thanks in advance
View Replies !
The Underlying Connection Was Closed - Localhost Vs Machine Name ?
Someone Im helping is having trouble getting reports to be viewable from BOTH his machine and another developer on the same domain. The problem is seen when we enter the url, using the machine name. When we use "localhost" things work ok and the report comes up when viewed locally. The error we are getting is the following "The underlying connection was closed: An unexpected error occurred on a send. Authentication failed because the remote party has closed the transport stream. " Now, after digging around on google and msdn for a while, im still stuck on a resolution. I seen references in other articles talking about long running requests being closed etc, but this request doesnt take very long, and besides it works at least when using localhost in the address.
View Replies !
The Underlying Connection Was Closed: The Remote Name Could Not Be Resolved
Our system administrators have renamed the server that our Reporting Service 2000 runs on. The database that RS2000 uses is on the same server. Now when I navigate to the Report Manager, the following error appears: The underlying connection was closed: The remote name could not be resolved Obviously I need to tell Reporting Services 2000 the name of the new server (even though it's just the same server??). Where do I do that?
View Replies !
User Instance Db File Not Get Detached After Connection Has Been Closed
Hi experts, I have sql express installed on my machine and i'm using visual studio to create database files. After i've build a connection to my database file thru Server Explorer (choose Add attach files) i opened Management Studio Express and found that the new database has been attached to sqlexpress database engine----technically speaking it's under the user instance which i use to run my visual studio. right?? that's totally fine.My question is, after i'v closed the connection in visual studio, that attached database file still exist.I want it to be detached immediately after i've closed the connection in visual studio.How can i do that? I've searched through internet and was told that sp_config can solve this problem by setting the user instance time out. I ran sp_config against my database but did not find that item. Could anybody give me some directions? thanks in advance.
View Replies !
An Existing Connection Was Forcibly Closed By Remote Host
Hi all I have run a stranger issue: I use ADO.NET 2.0 to access sql2000 database. during the whole process, I need stop sql server service which the program is connecting. my setup is like following: 1.Open a conection to access table and then close the connection; 2.restart sql server service ; 3.Re-open a connection to access table and then an exception was thrown out: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed bythe remote host.) 4. try re-open a connection to access table and then no exception was thrown out. I think this maybe related with connection pool. any guy know the detail, please give me a response. Thank you very much!
View Replies !
An Existing Connection Was Forcibly Closed By The Remote Host
Hi, I'm running a website using MSSQL 2000. Sometimes (not always) I get this error message on the website: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) I have also websites running with MySQL and those don't have this problem.I searched google but I couldn't find usefull information on this problem. Someone who knows what's going on here ?
View Replies !
The Underlying Connection Was Closed: Could Not Establish Secure Channel For SSL/TLS.
Help. Today while trying to get the Windows NT security working i upgraded my reporting services IIS server to a domain controller and it screwed up all of my settings. First it changed password for ASPNET user and so I reinstalled .net framework. Now i get the The underlying connection was closed: Could not establish secure channel for SSL/TLS. error message. I do not want to use an SSL certificate for I do not have one right now. How can I configure my SQL Server 2000 Reporting services to not use SSL. I see they added something to SQL Reporting Services 2005 in the configuration tools but I cant find out how to modify the config files with SQL 2000 RS to eliminate the SSL. Please help, my company is down waiting for me to get this back up. Thanks a ton, deep
View Replies !
EM Error 'connection Forcibly Closed By The Remote Host' (ouch)
I am getting this error in Enterprise Manager: TCP Provider: An existing connection was forcibly closed by the remote host. But, my web app can still connect just fine to the db, so it's still in the same place with the same login/password. And my registration in EM was working just fine (for years) until yesterday I got this error. I've tried deleting the registration and re-creating it but the same thing. What could have gone wrong to cause this to happen? Thanks for any pointers, I have no idea where to start looking on this one, the host says they haven't changed anything...
View Replies !
Sql Server Reporting Services Error The Underlying Connection Was Closed
Hi, We have a mature instance of SQL Server 2000 reporting services that has stopped working for no apparent reason. When browsing to http://reportserver/reports we receive the following error Error The underlying connection was closed: Unable to connect to the remote server. Home The installation is running on three servers - 1 sql cluster (sql 2000 sp4) and two IIS servers all running windows 2000 sp4. The Reportserver website runs using identity impersonation using the .net machine.config file pointing to an encrypted registry key entry holding the userid and password. It has been moved from the default website to it's own website but has been working with no issues for years. No obvious patches have been applied or security changes made that could effect the application When browsing to http://reportserver/reportserver we can view the loaded reports and even run them with no issues, only ther report manager isn't working. I have tried changing the impersonation registry key ( using aspnet_setreg ) and the account the reportserver web service runs under ( using the rsconfig utiltity) to be a domain admin to no effect and I have checked and set specififc permission for the reportserver database on all registry keys to no effect. None of the online solutions for this issue have worked for me. Any help or ideas would be greatly appreciated Cheers Daniel Worby Database Administrator AMP Capital Investors (p) +61 2 9257 1746 (m)+61 434 327 150 (f) + 61 2 9257 1090 (e) daniel.worby@ampcapital.com (w) www.ampcapital.com.au
View Replies !
3709-The Connection Cannot Be Used To Perform This Operation. It Is Either Closed Or Invalid In This Context
We have a nagging issue here in our application side, which I was trying to troubleshoot and reach no where. Can I have your valuable inputs for resolving/understanding the root cause of the issue? 3709-The connection cannot be used to perform this operation. It is either closed or invalid in this context This error is not coming regularly (twice it happened and after the program is running successfully with out any problem). Problem having exe is running every 2 minutes interval. Most of the sites saying this is something related to code written in the application but if that is the case why this error is not happening continuously? The problem having exe is running past 4 months with 2 minutes interval and suddenly thrown this error. I found one MS site describing about this error but not able to find any fixes for this issue (http://support.microsoft.com/kb/839428). We are on the process of upgrading the operating system with SP2; will this help us to resolve this issue? Please advice. Details 1. Windows 2003 with SP1 2. MDAC 2.8 3. SQL 2005 with SP1 4. VB Application.
View Replies !
The Underlying Connection Was Closed: Could Not Establish Trust Relationship With Remote Server
I am getting the above error on a windows 2003 server when I go to report manager(https://localhost/Reports) . I have installed a self-signed SSL certificate on this machine so that it can be accessed using https over the internet. Does anyone know how to fix this. I did get the following message at the end of SQL Report Services installation: Setup could not initialize the report server. You must manually initialize the report server before using it for the first time. For more information, see the Reporting services setup documentation. Thanks for all the help.
View Replies !
TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host
We are getting a problem when the below error Log Server: SQL Server 2005 and SP1. Then, All the Web Servers will drop all connections and stop the network service. Later, the network service will start up automatically but all the before service is dropped. We would like to know the error coming from? Error Log ================ TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 4/29/2006 Time: 10:48:47 AM User: N/A Computer: 88DBWEB0 Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 4/29/2006 10:48:47 AM Event time (UTC): 4/29/2006 2:48:47 AM Event ID: 77910e6688484582bb1c29808feef883 Event sequence: 128 Event occurrence: 13 Event detail code: 0 Application information: Application domain: /LM/W3SVC/24978983/Root/ph-3-127907437121075328 Trust level: Full Application Virtual Path: /ph Application Path: D:DB88ph Machine name: 88DBWEB0 Process information: Process ID: 1568 Process name: w3wp.exe Account name: NT AUTHORITYNETWORK SERVICE Exception information: Exception type: SqlException Exception message: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Request information: Request URL: http://88db.jobsdb.com/ph/Views/MediaUpload.aspx?PostID=50202&Type=I&panelid=postimagediv Request path: /ph/Views/MediaUpload.aspx User host address: 192.168.10.10 User: 50077 Is authenticated: True Authentication Type: Forms Thread account name: NT AUTHORITYNETWORK SERVICE Thread information: Thread ID: 15 Thread account name: NT AUTHORITYNETWORK SERVICE Is impersonating: False Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.WriteSni() at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush() at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags) Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
View Replies !
The Underlying Connection Was Closed: Could Not Establish Trust Relationship For The SSL/TLS Secure Channel
I'm using SQL Server 2005 (SP1) Reporting Services on Windows Server 2003 SP1. I access the report server from Internet using SSL, but the server is not exposed directly to the internet. It is behind a firewall, where the required ssl port is setup and is working fine. In my Reporting Server, the /ReportServer folder works perfect and I can navigate and view all reports. It is the /Reports folder the one that does not work fine. I can enter the /Reports folder, and can list all the reports. But, when I select one of the reports, and it starts rendering, I get the error message: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure." How can I fix this? Thanks, Julio
View Replies !
The Underlying Connection Was Closed: Could Not Establish Trust Relationship With Remote Server.
I am trying to setup SQL Server 2000 Reporting services with an SSL connection. The SQL Server (Windows Server 2003 SP2 Standard) and Reporting Server (Windows Server 2003 R2 SP2 Standard) are on separate machines. I have tried setting up Certificates from both and Stand-Alone and Enterprise CA. I have tried several combinations of the Issue To name (server | server.company | server.company.local) I have modified the rsWebApplication.config and rsReportServer.config to match the certificate€™s Issue to exactly. I have tried installs with both Domain Accounts and NT AUTHORITYSYSTEM logins. I have managed to get https://server/ReportServer to work but I have had no luck with the report manager https://server/reports. How do I fix this error? Thankyou
View Replies !
Framework 2.0 Changes - TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.
If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host." This happens against both 2005 and 2000 servers. If I re-run the query it works. However, this happens in our VB.NET app as well for clients with Wireless connections. So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work?
View Replies !
Can No Longer Access Report Manager - The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.
Hi, For a long time I've had SQL Server 2000 with RS on a Server2003 machine. When I want to publish a report from my Dev box, I remove anon. access on the Production machine, deploy the report, then go into report manager to tweak a couple of parameters. I then re-enable anon. access so users can continue. Yesterday, I removed anon. access and deployed the report but when I went into Report Manager I received the above error message... "The underlying connection was closed: An unexpected error occurred on a receive." I can get into report manager with anonymous access enabled, but I don't have authority to do anything. What's happened!!!? More importantly, how do I fix it?
View Replies !
Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC)
I 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?
View Replies !
Provider: TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.
Hi, One of our customers is getting this error about 3-4 times a day, in an .NET application that runs 24/7: (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) They have several App servers, Windows 2003 SP1 32 bit... connecting to several SQL 2005 SP 1 servers, 64 bit. All of their 4 application servers have had this error with 3 or 4 different SQL instances running on 4 different SQL servers. There is a firewall in between but that does not seem to be the problem. We use the same firewall setup in dozens of environments without any issues like this, and the firewalls are not imposing any maximum TCP session times. There are lots of people reporting this same problem with SQL 2005 only - it does not seem to be an issue with the same applications running against SQL 2000. Any hints as to how to fix these errors? I am going to try adjusting the Keep Alive setting in the SQL client config to 10000 instead of 30000 but judging by the number of people getting this error, this seems to be some sort of bug with .NET's connection pooling and SQL 2005. People are saying the easiest way to reproduce this is to do a SQL query.... unplug the network cable and plug it back in again... then run another query. They say it causes this error every time, but I have not tested this since we are only seeing this problem in a production environment. Thanks for your help, Jeremy
View Replies !
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 !
Large Reports - Error: &&"The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.&&"
First off I understand that it is a horrible idea to run extremely large/long running reports, but sometimes it ends up being the best possible solution due to external forces. I've got a 25,000 page report that we recently converted from crystal reports to SSRS. The SSRS server is a 64bit 2003 server with 32 gigs of ram running SSRS 2005. When running the report through the report manager web application, it renders in the browser/viewer after about 12 minutes. Exporting to pdf through the browser/viewer in the report manager takes an additional 55 minutes. It does work and it produces a whopping 1.03gb pdf. Unfortunately, I've run into a problem when trying to do this from a console application using the SSRS client API. After about 30-35 minutes I get an exception on the client with the following error: Exception Message: The underlying connection was closed: An unexpected error occurred on a receive. InnerException = Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Here is the api call: Code Snippet byte[] m_data = reportingService.Render(this.ReportPath, this.ExportFormat, null, deviceInfo, selectedParameters, null, null, out encoding, out m_mimeType, out usedParameters, out warnings, out streamIds); Here are some things I've tried so far: set the HttpRuntime ExecutionTimeout value to 3 hours on the report server disabled http keep alives on the report server increased the script timeout on the report server set the report to never time out on the server set the report timeout to several hours on the client call Disabled antivirus on the client side, and verified there was no antivirus running on the reporting server. Tried using default credentials in the ReportingService object as opposed to supplying credentailsAny ideas would be appreciated. I understand the best solution is to split the report up into smaller reports, which is the backup option, but being able to keep it as one report is the goal.
View Replies !
"ODBC--Call Failed" And "ODBC--connection To 'SQLServerMYSERVER' Failed"
We are using Access as a front end to a DB we house on a SQL 2000 SP2 box. I have 2 users utilizing this front end and they keep recieving these two errors "ODBC--Call Failed" and "ODBC--connection to 'SQLServerMYSERVER' failed" when trying to run a query window. They get the called failed message 99% of the time. I on the other hand, have no problems doing any of this without a File DSN defined. I verified all the file permissions to rule that out. And I also verified how their permissions were setup in Enterprise Manager and they are set the same as mine. The other users get the errors with or without the File DSN defined. After relinking the tables in the front end, it seems to go away for awhile, but then reappears. The only other way I could get the errors to disappear was to make them a domain admin like myself. When I did that, everything seemed to work fine. Now obviously I can't leave them like that, so I was hoping someone would be able to kindly point me in the right direction on how to resolve this. Please help, I am completely out of ideas here. Thanks in advance. Mike
View Replies !
T-SQL ODBC Connection
Would someone provide a code snip example of a T-SQL script using an ODCB connection against a non-SQL2K database. I can hit the outside database using DTS (so I know it is possible) but I'm having trouble with the parameters using a script. Thanks, Fred.
View Replies !
ODBC Connection
I am currently running a application and a database server they are connected via ethernet. Only the application is connected to our network. Is there a way to connect MS Access to the database server without connecting the database server to the network? I've tried several different approaches and it still dosent work. Any help would be greatly appreciated. Dale
View Replies !
ODBC - ASP Connection
We are upgrading from Access to SQL 2000 for our Intranet backend database. This is on a separate server. I have installed Server 2000 ODBC drivers on the IIS machine. I get the following error message which I can't sort out: Microsoft OLE DB Provider for ODBC Drivers error 80040e4d [Microsoft[ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITYANONYMOUS LOGON' The ODBC is set up on the IIS server to use NT Authentication. The account logged on has administrative rights for the domain. The only solution I can think of is to publish to the MSDE I have installed on the IIS machine. Anyone out there able to help? Thanks Bob
View Replies !
ODBC DSN Connection
By defining a System DSN I can specify a simple ODBC connection string like DSN=SomeDSNname. With some repeated testing I've found that using a trusted connection (NT) in the DSN, I can set up either named pipes or TCP/IP and the connection works fine. When I try to set up SQl server authentication I can only get named pipes to work and not TCP/IP. Any ideas?
View Replies !
ODBC Connection
Hi everyone I installed the MS SQL server 7.0 on a Windows NT 4.0 SP 4 server. The network runs with TCP/IP. I want to connect the SQL server by a ODBC-connection. Only a connection on the server (local) was successful. The odbcping-utility reports following: COULD NOT CONNECT TO SQL SERVER SQLState: 08001 Native Error: 6 Info. Message: [Microsoft][ODBC SQL Server Driver][DBNMPNTW]Selected SQL server not found. SQLState: 01000 Native Error: 53 Info. Message: [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile()). Do I forget to install a SQL server component? Or a network service? Thank you for your help. Greetings Steven
View Replies !
ODBC Connection
I have DSN setup on IIS 4.0 server that is configure using TCP/IP connection to talk to SQL Server to retrieve data for one of our web site. The problem I am having is that the DSN cofiguration connection changes automatically to Named Pipe on the IIS 4.0 server, causing web site to generate ODBC connection failure. This happends at least once a week. To resolve the issue I have to reconfigure the DSN to TCP/IP connection. Does any one have any idea how to resolve this issue. Thank You, Piyush Patel
View Replies !
ODBC Connection
Has anyone had an issue with the ODBC data source that when you set it up for SQL, it does not retain the username and password you entered and keeps defaulting back to the NT windows verification instead of using the SQL verification that you choose? I add a datasource, select validation based off of SQL profile/password assigned, enter the user and password I assigned on SQL, go through the setup and test successfully. Then I try to connect using that datasource with my VB application and it says connection failure. When I go back to the datasource, it has changed back to NT verification and removes the user/password I entered for SQL verification. Maybe there is an service pack from MS on this? any help is appreciated. At the very least, I can just hard code into my VB app, but that is my last resort. Thanks!
View Replies !
Can't See ODBC Connection
I am connecting to Informix via ODBC. When I go to the ODBC manager, I can create a connection DSN and it tests OK. When I look at the list of available drivers, there are only 3 in the list When I try to run a report & set up the data source, it can't find the DSN but it shows a lsit of dozens of drivers...none of which are Informix Any insight? Thanks JPS
View Replies !
ODBC Connection
I have front-end visual basic program that use an ODBC connection to connect with SQL server, and my questions is there any automated procedure to configure this ODBC connection instead of configure it manually specially of the user profiles was changed I have to configure it again. Please advise
View Replies !
Odbc Connection
We have three users that access a particular sqlserver database via microsoft access, two of the users have no problem, the third user used to be able to use the access database but is now getting a sql server error 18452 followed by an error message 'login failed for user '(null)' reason: not associated with a trusted sql server connection. When reviewing the odbc setup that the user that is having problems has, we find two sqlserver entries when it asks 'which sqlserver do you want'. How do i go about finding out where that entry comes from so i can look into removing one of them. None of the other users have two sqlserver entries. The othere users have no problem accessing this sqlserver database via ms access, I'm trying to find out why all of a sudden this one user is having problems
View Replies !
ODBC Connection
Hi, I just start working on SQL Server 2005, could someone help me to make link of few tables through ODBC. Thanks AA
View Replies !
ODBC Connection
I am trying to connect to SQL Server using a 3rd party report generating software (dbextra). Everything is located on my local box. I am trying to establish connection through ODBC. Is this installed during setup or is this a function I have to manually set up and configure?
View Replies !
ODBC Connection
Hello - I'm trying to creat an ODBC connection and the db I created is not showing up in the dropdown for 'Change the default database to:' option. I'm logged into SQL using Windows Authentication, create the db, restored it w/ a backup and then added a user w/ no problems. Any ideas?
View Replies !
Creating ODBC Connection
In my project, I have added a database called aspnetdb.mdf and I store all the required information here. Now I want to write a seperate Cryatl Report for my manager, that accesses this database and display required data. This report is not a part of the asp.net project. This is only for my manager. My database is not attached to any server. I just use the attachdb in the coonection string of my project to attach this database. no I want my crystal report to access this database. If I can create an ODBC connection to this database, it will solve my problem. Dows any body know how to access this database from Crystal with or without ODBC? Any help is greatly appreciated.
View Replies !
ODBC Connection Failing
First of all i apologise if this is in the wrong area. My problem is as follows. I had set up a couple of aspx pages on our webserver which accessed a sql database on another server. These pages were set up using frontpage 2003 and everything worked fine. A week ago the pages stopped working giving the error "Server Error in '/' Application". As far as I know nothing has been changed on the servers. On top of this frontpage has started having connection problems. Frontpage will connect to the database but is unable to access the fields giving the following error. Server error: Unable to retrieve schema information from the record source ' NAME' in a database using the connection string: 'DRIVER={SQL Server};SERVER=servername;DATABASE=live;UID=********;PWD=********'. The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.-------------------------------------------------------[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'NAME'. Source: Microsoft OLE DB Provider for ODBC DriversNumber: -2147467259 (0x80004005) I have been trying for the past few days to solve this one, but am reasonable new to SQL, so this may be an easy one. Hope someone can help me
View Replies !
ODBC Connection Fails
I am attempting to connect to Altiris Deployment Server through ODBC and this is the error I get: Microsoft SQL Server ODBC Driver Version 03.70.1146 Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. TESTS FAILED! I am connecting through a workstation shortcut. Funny thing is when I log onto the server that is actually running DS the ODBC connection connects immediately. Soemthing tells me it is a rights issue but I can not seem to isolate the problem. Any help with this problem is greatly appreciated! Thanks again! griedel :(
View Replies !
ODBC -Connection Failed
I create a Test database in SQL server, also I add new user in security folder. Also I add this user in Test database, the permission are: Public, and db_owner. But when I let the user try to open the database, it is ODBC – Connection failed. I add another user a few months ago, she works fine. But the new user I added in didn’t work, did you know why. I am sure I add the same permission as the later user. Thanks.
View Replies !
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 !
Loosing ODBC Connection
Hi all, We recently converted an application from accecc97 to access2003. We used to have 2 databases : 1 with all and only the data (axelD.mbd), 1 with all the forms, query's, ... (axelP.mdb) We replaced the data (axelD.mdb) with an MSDE database, through UPSIZE and so on. That all worked fine. This database is placed on the dataserver (DATA1), the converted programm is on the FRONT2 server (FRONT1 stil usess access97 until conversion is totally ready). We are able to connect to the MSDE by using ADODB recordsets. We are also perfect able to link the MSDEtables in our axelP.mbd database We started to test some heavier parts of our application and started to get the following error: "ERROR 3151" "ODBC--connection to 'JOROSOFT' failed" Nothing more. This happened in a quite complex routine, whitch updates a lot of records, several times and so on. We could reproduce the same error when executing the following code: Public Function TestBestellingen() Dim sql As String Dim intervalset As DAO.Recordset Dim planset As DAO.Recordset Dim tellerke x = Opendatabases() tellerke = 0 sql = "Select bestelnummer from vkpbestellijn where bestelnummer > 100000" Set planset = Db_AxelP.OpenRecordset(sql, dbOpenDynaset) Do While Not planset.EOF tellerke = tellerke + 1 Debug.Print tellerke & " - " & planset!Bestelnummer & " --> " & IsKlantStof(planset!Bestelnummer) planset.MoveNext Loop End Function Function IsKlantStof(p_bestelnummer) Dim sql As String, rst As DAO.Recordset Dim hulp_klantstof As Boolean hulp_klantstof = False x = Opendatabases() sql = "select klantstof from vkpbestellijn where bestelnummer = " & p_bestelnummer Set rst = Db_AxelP.OpenRecordset(sql, dbOpenSnapshot) With rst Do While Not .EOF If !KlantStof = True Then hulp_klantstof = True .MoveLast End If .MoveNext Loop End With rst.Close Set rst = Nothing IsKlantStof = hulp_klantstof End Function Function Opendatabases() If Db_AxelP Is Nothing Then Set Db_AxelP = DBEngine(0)(0) End If End Function I know this code makes no sence in a real-time environment, but it was to reproduce the error. This code basically runs trough a 30.000 records and does a little check for certain fields After 1981 records we get the above error. (sometimes after 1979 or 1980 or 1982 records) 1977 - 100859 --> True 1978 - 100860 --> True 1979 - 100860 --> False 1980 - 100861 --> True 1981 - 100861 --> True "vkpbestellijn" is a table that is linked in the AxelP.mdb trough an ODBC connection. We get the same error (and after 1981 times) if I change the where to a totally other range of "bestelnummer" I have installed the latest patches of Jet 4.0, MSDE-server, ... I've been searching the internet for abour 3 days now, and just cant even find the smallest clue what could make this happen. I hope someone here has an idea. If you need more details, just ask. tia, Axel. P.S. I'm from Belgium, so my english aint "correct to the point".
View Replies !
|
TRACKER
