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 Complete Forum Thread with Replies
Related Forum Messages:
ODBC Connection - Lost Tables
I have a SQL Server database that I connect a front end to using an ODBC connection. Our LAN folks upgraded the server recently and now I can no longer see any of the tables through the ODBC connection that the user used for login has permission in SQL Server Enterprise Manager to see - throught the ODBC connection the user can only see things like: dbo.spt_datatype_info dbo.spt_datatype_info_ext dbo.spt_fallback_db dbo.spt_fallback_dev dbo.spt_fallback_usg . . . INFORMATION_SCHEMA.CHECK_CONSTRAINTS INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE etc. I've tried deleting the user for the connection and re-establishing it with owner permissions. I've tried deleting the dsn and re-establishing that as well but nothing so far. Please help!!!
View Replies !
Visual Studio 2005 The Remote Connection To The Device Has Been Lost. Please Verify The Device Connection And Restart Debugging.
Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get The remote connection to the device has been lost. Please verify the device conection and restart debugging. I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back! My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've rebooted my PC and done a soft reset on the PDA but it didn't help. I'm using ActiveSync 4.1. Does anyone know how to resolve this problem?
View Replies !
ODBC Connection Query With Date Parameter
Hi Can someone please give me an example of how I can use a date parameter with an ODBC connection? When I use MSQuery to query the database this is how it shows up as a SQL statement looks similar to this: SELECT * FROM table WHERE (datefield={d '2007-04-10'}) In SRS I tried using "?", SELECT * FROM table WHERE (datefield=?) but it just doesn't return any result... Thank you in advance!
View Replies !
Query To Select Multiple Tables In Dataset Through ODBC Connection
Hi there, I have a MS Access database (mdb) containing the following tables: Crime Criminal CrimeCommitted Hideout CriminalType The Criminal table contains information about each criminal and the CrimeCommitted table contains information about the specific crimes. I've written the following query to return only the latest crime committed by each criminal: Code Snippet SELECT Criminal.CriminalID, Criminal.Firstname, Criminal.Lastname, Criminal.Nickname, Criminal.Gender, Criminal.DOB, Criminal.Eyes, Criminal.Complexion, Criminal.Weight, Criminal.Height, Criminal.Build, Criminal.Scars, Criminal.Occupation, Criminal.CrimeOrgID, Criminal.IQ, Criminal.Hideout, Criminal.CriminalType, Max(CrimeComitted.Date) AS Last_Crime_Comitted FROM Criminal INNER JOIN CrimeComitted ON Criminal.CriminalID=CrimeComitted.CriminalID GROUP BY Criminal.CriminalID, Criminal.Firstname, Criminal.Lastname, Criminal.Nickname, Criminal.Gender, Criminal.DOB, Criminal.Eyes, Criminal.Complexion, Criminal.Weight, Criminal.Height, Criminal.Build, Criminal.Scars, Criminal.Occupation, Criminal.CrimeOrgID, Criminal.IQ, Criminal.Hideout, Criminal.CriminalType; This query works fine for obtaining the Criminal table data, but once i've include CrimeCommitted.Country in the SELECT statement, the data returned contained all the crimes committed by each criminal (i just need the latest crime). The query doesn't work when another table, other than Criminal, is selected. How can i obtain the columns in the CrimeCommitted table in this query?
View Replies !
Lost Connection During Replication
Hi everyone, this is my first time here and I have learned so much already from all the threads I have read. I hope somebody can help me. We have 3 servers, A, B, and C. A is our source and we just did a snapshot replication on B. Is there any easier way to automatically divert the C users to B while replicating to C without them losing connection or having any errors? or Can you point me to any white paper that can give us some info on how to handle this issue? Thanks
View Replies !
Lost Connection With Sqlexpress
I installed on a w2k/sp4 local machine SQLEXPRESS. I copied the database also to the localmachine With the sqlexpressmanager I attached the database. Everythinks looks fine. I quit the manager, but then I start the manager again. Now the manager can't find the sqlserver. Timeout Expired is the message. Why is that? I installed SQLEDXPRESS on a lot of machines. No problems. But those machine the manager lost the connection after the first time. thanks again. klaas http://www.planmatigonderhoud.nl
View Replies !
Rollback Transaction After Connection Lost
Hi,I have a problem. When my computer loses connection toserver during transaction it is rolled back automaticlyby server after 2-5 minutes. During the time a can resetmy computer, run my program again and I can seedata from not commited transaction becouse I have toset isolation level to read uncommited.How to force the server immediately rollback transaction?TIAclint
View Replies !
Link Server Connection Lost
I have set up linked servers and they worked fine but after a week or so it didn't work any more. I dropped the link and re-created and then it worked again. The remote server is on another domain. Is this loss of connection to the local server known bug? Ranjit
View Replies !
Rollback Transaction On Lost Connection
Hello; I am creating a transaction to a certain query. if the client using this transaction abnormaly closes the application before commit or rollback (power failure for example), the tables in the transaction remains locked? is there an option in MS SQL or ADO.NET to rollback the transaction on connection lost? Thnx anyway
View Replies !
Lost Connection To Report Server
I've run int o a perplexing problem. I have a SSRS setup on my local box. Everything has been working fine for weeks, up until now. Recently, I had to change my password in our domain - which chouldn't be a big deal. But now when trying to connect to the report server, I get the following: The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) What's odd is the fact that I'm able to connect to the database just fine via Management Studio and run queries. I haven't changed ANY settings in SSRS or IIS. And everything is set up to use Windows Integrated authorization... What gives?!?! Any insight would be appreciated!
View Replies !
Best Connection For MYSQL?
Hi, I am using Mysql ODBC 3.51 connection . this works fine with DTS But it hangs when I use with SSIS ... MS Visual Studio is giving message like " MS Visual Studio is Busy" Which driver should I use for SSIS? thanks, J
View Replies !
Connection To Sql Server Being Lost After A Period Of Inactivity
I updated my SQL Server 2005 db server with Windows 2003 SP2 and other windows updates and now other applications are loosing their connections to the SQL server after a period of inactivity. The ERP software and MSSS Managment Studio loose their connections if the connection sits idle for a couple of hours. When in Management Studio I get the following error: Msg 10054, Level 20, State 0, Line 0 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.).... Has anyone seen this? Do I need to add SP1 for MS SQL 2005? Thanks-Dave
View Replies !
Lost Connection To Remote Data On SBS SQL 2005
I need help! I have Outlook 2007 w/BCM running on XP Pro workstation connecting to a SBS 2003 R2 hosting my SQL 2005 database. I have two problems: First I can get the BCM to connect to the remote data but periodically the connection is lost and many times it requires a reboot to reconnect. Secondly related to teh first, I can never get MS Accounting 2007 to connect to the same server and database from my client. I have already set up the server to use port 5356 via TCP amd added a hole through my client windows firewall for the same port. Both client and server are set to share files and printers. Any suggestions?
View Replies !
Lost Connection To SQL 2000 After SQL 2005 Install
I've had a VB 6 / SQL Server 2000 app running in a network enviroment for a couple of years now at a client of mine. Recently, he upgraded to the latest version of Quickbooks which installed SQL Server 2005 on the server. Now there is SQL Server 2000 and 2005 residing on the same server. My VB app still runs on the server but will not run on other machines. I can ping the server from the other machines. Has SQL 2005 taken over the port I was using or maybe has new security features that won't let me access SQL 2000 using my current connection string? Here is my current connection string: mstrConnStr = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=" & strServerLogin & ";Password=" & strServerPW & ";Initial Catalog=" & strDBName & ";Data Source=" & strServer. Any help will be greatly appreciated. Keith
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 !
Connection To MySql In SSIS
I have a process that copies data from a MySql database to Sql Server. This process has worked fine on another server but is failing on a new server. I created an ODBC connection to the MySql database which works fine. In the job, it has a Connection Manager object to the MySql database which Tests successfully. The job has a Datareader source with a very simple SQL command in it. When I run the job, I get the following error: Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Error: 0xC0047062 at Data Flow Task, DataReader Source [1]: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction) Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "DataReader Source" (1) failed validation and returned error code 0x80131937. Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. It says that the Data Source Name Not Found. If this was so, how is the connection manager test succeeding? I am running the MySql driver version 3.51.12. Any ideas what might be causing this to fail will be greatly appreciated!
View Replies !
Failure Sending Mail: The Transport Lost Its Connection To The Server
More and more often, I am seeing this error message in RS subscriptions. I would assume it means the IIS server can't connect to the corporate exchange server. However I was wondering if there is some timeout setting/configuration in RS or the IIS server (or any other kind of setting) I can change to help alleviate this problem. Has anyone else experienced this? Or know how to fix it? Thanks, Jeff UPDATE: After looking closer at the subscriptions, I have noticed that subscriptions set up by a RS Admin (who is also a server admin) seem to be working fine. It is the subscriptions that are set up by ordinary users that are failing...
View Replies !
Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string. Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value. Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask. Is this an intrinsic issue?
View Replies !
Failed OLEDB Connection: Cannot Aquire Connection From Connection Manager
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error. Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection. Thanks, John T
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 !
ODBC Connection Is Not Working
I have these two workstation in same domain. PC A is running on Windows 2000 Professional, with MSSQL 7.0 installed. PC B is on Windows XP, in which I try to create an ODBC connection to one database in the above MSSQL server. When I add a system DSN from the ODBC Data Source Administrator, I couldn't connect with the following message: --------- Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Auserabc'. --------- I have created the userabc in PC A, both as system adminstrator and as an user permitted to use the database. I tried both "With windows NT authentication using the network login ID" and "With SQL Server authentication", but both were not working. Any hint about what may go wrong? Thanks.
View Replies !
ODBC Connection In UNIX
Hi Folks, I need to access the MSSQL data in Oracle. For that i need to first create the data source (ODBC Connection) to the MSSQL server on UNIX. Can anybody help me in creating the ODBC connection. Thanks, Amit
View Replies !
How To Get ODBC Connection Attributes?
I'm using SQLDriverConnect(Driver=SQL Server) to connect to MS SQL Server 2000/2005. I want to get the value of the following ODBC connection attributes: AnsiNPW AutoTranslate QuotedID Regional 1. Which ODBC API functions should I use to get those attributes? 2. Which constants do I pass to the ODBC API functions for those attributes? 3. Which header file (.h) contains the constants? Thanks.
View Replies !
ODBC Connection Error
Hi, I'm new to SQL Server, but regularly connect to Oracle via ODBC. I'm trying to a) connect to our SQL Server over an ISP and b) Run Enterprise Manager over the ISP. Both actions work fine over our campus network but fail across an ISP. The first returns the message: Connection failed:SQLState: '01000' SQL server Error: 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen[CreateFile()]. Connection failed:SQLState:'08001' SQLServer Error 1326 [Microsoft][ODBC SQL Server Driver][Client unable to establish connection The second returns the message: Unable to connect to server [reason:[DB-Library]Unable to connect. SQL Server is unavailable or does not exist. Register anyway. I had previously received a different error (in case 1) and, through the knowledge Base discovered I needed MDAC drivers for named pipes. I installed them but get a new error. I can find nothing in the KB or previous SWYNK messages. Please help..... TIA
View Replies !
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 Replies !
Slow ODBC Connection.
Hi All We have a web server using iss4.0 and coldfusion. Connection to the database server SQL 7.0 is thru odbc. Would appreciate if some one could explain how to increase the performace web server performace. Any special setting required on iss orcold fusion or SQL regards rajeev
View Replies !
|
TRACKER
