HELP! ODBC Becoming Unusable
Mar 29, 2004
Here goes: We have situation at a customer site where users are suddenly unable to connect to SQL 2K via ASP using ODBC via DSN. While the customer is in this state, our Windows clients, which connect using OLE DB (ADO) to the same DB as the ASP, seem to be connecting without problems. Therefore, the problem seems to be with ODBC.
Additional details about the problem site:
SQL ODBC 3.50
Win2K Server SP 4.
SQL2k SP2.
MDAC 2.62
<100 users total
Moderate usage of our ASP interface
Note: SQL2k and IIS are on the same LAN-side server.
FYI: Another part of the problem is that I'm a developer and am not that familiar with the tools available to help me troubleshoot this kind of problem.
We've tried using Perfmon to monitor connection pooling, but nothing stood-out.
We've tried using netstat (with various switches), but nothing stood-out.
Does anybody have any advice?
View 6 Replies
ADVERTISEMENT
Sep 19, 2007
I have a database that I just copy its datafile(.mdf) and the log file to another place in my system. Due to the fact that the sql server instance developed internal error, then i have to forcefully uninstall it and later install it (done successfully). After re-installation, I attach the database file back to the package withoou first and foremost copy it to the Data folder in sql server directory, but rather from where I kept the file. When I decided to create a full-text sraching on a table, the name of the catalog to be used has been afore-configured before. So I decided not to create a new one, then when I applied ful-text indexing on one the table i have index use the procedure (full-text indexing), an error generate sayingFull-text catalog is in an unusable state. I tried to google it and the advice is to drop the catalog and re-create a new catalog. Then when i use this statementdrop fulltext catalog <name>; Error is prompted saying it can not be commited because of the associated table(s) that have been indexing. Is there any way to easily drop all these indexes and re-create another catalog as well as a new indexing on the affected tables. Any suggestions/help is welcome. Very urgentthanksTechnology Consultantwww.legwork.com.ng
View 2 Replies
View Related
Feb 26, 2007
Hi,
I have a problem with my SQL Server 2005 instance after trying to install SP2.
My machine has a default instance of SQL server 2005, and 2 instances of SQL 2005 express.
I installed Express SP2 and this installed without a hitch.
Then I installed SP2 for SQL Server 2005. After the install, all the components had installed correctly except the Database Engine, which had a status of failed. I did not investigate why, I simply re-ran the install.
It failed again, so I investigated further and I found out it failed because it had not been able to start the service VSS Writer. I looked at the service, and found I had changed the user which gives the service rights to start. I changed this back to Local System so the service could start correctly.
I then re-ran the SP2 install. This time it failed in a different place. The reason this time was my user was not a valid user for my server. This is a first, because I logged onto the database using this user name minutes before running the install. The install must have deleted my user. Then I tried to login using the sa account only for my server telling me that the sa account has been disabled.
I now cannot log into my database at all, and am stuck. If I try to rerun the install it tells me it cannot connect to the server to perform the update because there is no user.
Please Help!
View 5 Replies
View Related
Feb 13, 2008
Using SQL Server 2005 (9.0.3042), I can not get a full-text search query to work with order by or group by. For example, if I run the following query...
SELECT s.networkID, i.interID
FROM Interactions i
INNER JOIN CONTAINSTABLE(Interactions, text, 'ipo') t ON t.[key] = i.interID
INNER JOIN Sessions s ON i.sessionID = s.sessionID
WHERE i.startTime BETWEEN 1051772400000 AND 1054537199000
It returns two rows immediately.
If I add an "order by" or "group by" like...
SELECT s.networkID, i.interID
FROM Interactions i
INNER JOIN CONTAINSTABLE(Interactions, text, 'ipo') t ON t.[key] = i.interID
INNER JOIN Sessions s ON i.sessionID = s.sessionID
WHERE i.startTime BETWEEN 1051772400000 AND 1054537199000
ORDER BY s.networkID, i.interID
The CPU shoots to 100% and I have to kill the query. I have tried many variations of the above and I can not get the query to work with order by or group by. Is this a bug in SQL Server? Is there a fix or workaround?
View 1 Replies
View Related
May 31, 2007
While attempting to query a Full-Text enabled database where a catalog exists for the database, I receive the following error: "Full-text catalog %database% is in an unusable state. Drop and re-create this full-text catalog." I have dropped and re-created the full-text catalog numerous times with no luck. I have also stopped and restarted the SQL Server service and Full-Text service engines mulitple times with no luck. Other items to note are, we're running SQL 2005 64 bit Enterprise Edition SP1 on a Windows 2003 server. We have an identical setup in development and full-text indexing works without any hitches. I have also checked both the SQL server permissions and the local file-system permissions and they also seem to be more then adequate; in addition, they match the security configurations of our development environment. Lastly, the production database is a restore of the development database.
In short, I'm hoping that someone may have a potential solution other then reinstalling SQL Server...which may end up being the only solution.
Any help or ideas are greatly appreciated!
View 6 Replies
View Related
Aug 2, 2007
I'm trying to connect to a SQL Server 2005 database engine on a local network server. When I am presented with the Connect to Server dialog box, if I select Windows Authentication from the Authentication drop-down, the User name & Password area is grayed out and unusable. The domain user account I'm authenticated with is visible, but grayed out, and the password field is blank and unusable. I'd like to be able to connect as described in help:
User name
Enter the user name to connect with. This option is only available if you have selected to connect using Windows Authentication.
I can connect with either SQL Server or Windows authentication... but with Windows Authentication I'd love to be able to type a specific user name to select with :-)
View 4 Replies
View Related
Jun 1, 2015
I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.
When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.
I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?
View 9 Replies
View Related
May 13, 2007
Hi,
I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".
When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.
How can I use DDL statements via ODBC?
I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.
Thanks for help!
Regards,
Stefan D.
View 14 Replies
View Related
Feb 13, 2007
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 4 Replies
View Related
Dec 25, 2005
Hi all,I am having trouble getting linked Oracle 9 server in MS SQL Server2005 Express to work properly. My machine is running Windows XP.The Microsoft and Oracle OLE DB Providers have problems dealing withOracle's Numeric Data Type, so I decided to use Microsoft's OLE DB forODBC Provider and an Oracle ODBC source. When using the Microsoft ODBCfor Oracle Driver in my ODBC source I have inconsistent behavior.Sometimes my queries are processed properly, then other times I get thefollowing errorOLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC driver for Oracle][Oracle]".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDASQL"for linked server "ODBCBEAST".I have no idea why sometimes I can connect to the linked server with noproblems andwhy other times it performs like this. I'm not changing anything aboutthe system I can think of. When I use an Oracle client (PL/SQL) I haveabsolutely no problems connecting. TNSPING returns that the connectionis good.This is unacceptable so I decided to try my luck with the Oracle 10gODBC driver. However when I use this and perform an openquery selectagainst the linked server I get back only 11 rows, when I know that thedatabase has over 100 rows (in fact when using the Microsoft ODBCdriver and it works that's what I get). I figured maybe the buffersetting needed to be raised in the ODBC configuration so I took it from64000 to 600000 (a magnitude of 10) but I still get back only 11 rows.I'm at my wit's end.Any suggestions on resolving one or the other problem would be muchappreciated.Thanks much
View 2 Replies
View Related
Oct 28, 2004
Hi,
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
Any help will be appreciated.
Thanks,
vtluu.
View 1 Replies
View Related
Dec 10, 2003
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
View 5 Replies
View Related
Mar 12, 2008
I am using the following connecting string in report.aspx.vb and would like to use ODBC (DSN) string, how to?
Dim myConnString As String = "server=TESTSQLEXPRESS;database=test;uid=test;pwd=12345"Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(myConnString)
View 3 Replies
View Related
Jan 4, 2006
HeyI have developed a asp.net 2 system on my local machine using a local sql2000 server.Now i'm trying to deploy it to a windows 2003 server, using a sql2000 server on another windows 2003 server. I thought the only thing i had to do was to create a ODBC connection to the sql server, and change the connectionstring. But no :)
What kind of changes do i need to do. Do i need to change the dataprovider.
I get this 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 settings sql Server does not allow remote connections. (Provider: Named Pipes Provider, error: 40 - Could not open a connection to sql server)
But i don't use a sql 2005 server.
Pleace help :)
View 7 Replies
View Related
Jul 10, 2001
What is the native way of a front end app connecting to SQL server ? Heard
it is faster than traditional ODBC. Is it SQL OLE ? If so, how do I work with
ODBC mgr in windows control panel? SQL OLE is not there !
Thanks for directions.
Ivan
View 1 Replies
View Related
Nov 6, 2000
I get the follwing error when I try to link table in MS Access or try to connect to an oracle data source in a DTS Package.
[ORACLE][ODBC ORACLE DRIVER][ORACLE OCI]ORA-12532: TNS:invalid argument.
(#12532) [Microsoft][ODBC Drvier Manager] Driver's SQLSetConnectAttr failed (#0).
I can set up the same datasource and connect to it on some machines but then
on some others I get the above error.
This is an orcale connection so there is no way to test it until I actually try to connect. I understand it might be a problem
with WINS (resolving computer name to IP address. I do not know much about
WINS, can someone tell me how to check WINS to see if this is my problem?
Thanks
View 1 Replies
View Related
May 24, 2000
If your database is using NT authentication and a user creates an ODBC data source to your database, does this mean that this user can now read and write to your database?
View 3 Replies
View Related
Nov 3, 2000
I get the follwing error when I try to link table in MS Access or try to connect to an oracle data source in a DTS Package.
[ORACLE][ODBC ORACLE DRIVER][ORACLE OCI]ORA-12532: TNS:invalid argument.
(#12532) [Microsoft][ODBC Drvier Manager] Driver's SQLSetConnectAttr failed (#0).
I can set up the same datasource and connect to it on some machines but then
on some others I get the above error. Any Ideas?
Thanks
View 1 Replies
View Related
Nov 20, 2000
I was wondering if anyone out there can help out. Anytime I run Query Analyzer I get the following error messages:
(SQL Server Query Analyzer requires ODBC Driver version 3.7 or greater and ODBC Driver Manager version 3.5 or greater. Incompatible versions of odbc32.dll and/ or sqlsrv32.dll are installed on this machine. Are you sure you want to use SQL Server Query Analyzer?) After checking the web site the only version I came acrossed was ODBC version 2.65.0240 and I need version 3.7 or greater, can anyone tell me what to do now?
View 1 Replies
View Related
Jan 11, 2001
To set-up a Merge Replication do you need to setup an ODBC link? All suggestions are welcome.
Regards,
View 1 Replies
View Related
May 14, 1999
Has anyone connected from Access 2 16 bit ODBC to SQL Server 7??
I have not seen 16 bit ODBC Drivers. SQL 6.0 and 6.5 came with 16 bit drivers.
PS: Phase one is to convert Access 2.0 to use SQL followed by phase to goto Access 2000.
Thanks,
View 2 Replies
View Related
Apr 9, 1999
Hi,
I have Access database as front end for SQL Server 6.5.
I go to the Control Panel - ODBC to install SQL Server driver, I have
version 2.65.02.13 (07.05.97).
When I try to connect I have error message:
SQL Server Login:
Connection failed:
SQL State: '01000'
SQLServer Error: 10061
[Microsoft][ODBC SQL Server Driver][DBMSSOCN]ConnectionOpen(connect())
Connection failed:
SQL State:'08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBMSSOCN]General network error.
Check your network document.
Guys, If you have idea how to help me,please help!!!
Thanks in advance
Alona
View 1 Replies
View Related
Nov 10, 1998
Hey everyone,
I have a very small SQL 6.5 server that we use for development purposes in our office. However, our other office now needs access to it as well and this is what I have done:
Since the other office is in a totaly diffrent domain, I have setup their PDC to log into our WINS server. Now that the networks can find each other (via TCP/IP across the internet), a two way trust has been established. However, even though we are able to see into each others networks they are NOT able to create an ODBC connection to our SQL server. It simply keeps responding, server not found. Any ideas? Or am I just out of luck here?
Thanks,
jmoore@directedje.com
View 2 Replies
View Related
Jun 1, 2004
Hi board, I'm very new to databases and am taking over my small company's saleslogix database before too long...
My question is:
What is the relationship between ODBC and BDE? For connectivity purposes, are they independent from each other or do they interact with in some way? As far as I can tell they have the same function.
thanks for your help! i'll be spending a lot of time on this board as i begin a DB crash course.
Ryan
View 1 Replies
View Related
Mar 22, 2007
Hi,
I have two server with two IP address, In one server I Installed SQL and in another server I installed IIS means all my ASP files are in this server.
Now in wich server I want create ODBC. and how to connect SQL from sql installed server to IIS installed server.
With regards
Shaji
View 3 Replies
View Related
Jul 18, 2007
Hi,
I am trying to create a report in Microsoft Visual Studio, the database is coming from an ODBC database and at the min it works fine.
The problem im having is that i am using an SQL Query to pull the data from the ODBC database.
The query i am using atm is:
SELECT ORDER_NUMBER, REFERENCE, INVOICE_NET, ACCOUNT_REF
FROM PURCHASE_ORDER
WHERE REFERENCE Like '?'
order by Reference desc
The '?' allows me to read the entire database but in the field i cant enter a blank field, if i change the Like '?' to '%' it will then load up the whole database and doesnt sort the request i had.
Is there any way i can get it so that when i request the reference number if i enter a blank field it will load them all up if not then it will load the request.
View 1 Replies
View Related
Nov 29, 2007
Can somebody please help me install and setup ODBC Drivers for SQL server . Thanks
View 20 Replies
View Related
Jul 23, 2005
I need to create a C/C++ function using ODBC interface to get thestring length of a column in a table.What is the proper function to use ?
View 1 Replies
View Related
Jul 20, 2005
I am into a new project where I have to write C programs on UNIXconnecting to SQLServer through ODBC. I am not able to find sampleprograms to learn about APIs. Can anyone point out to documentationcontaining ODBC APIs for C.TIA.
View 4 Replies
View Related
Apr 16, 2007
Hi,
I can't get ntext field value from my database (or nvarchar).
If I write in my database in english, I get only the 2 first letters.
If I write in my database in hebrew, I get gibbrish letters.
please I need some help
I'm using sql serser 2000, CRecordset, CDatabase, ODBC
Code Snippet
CDBVariant val;
rs.GetFieldValue("activity",val);
CString activity = (*activityVal.m_pstring).GetBuffer(0);
View 4 Replies
View Related
Feb 1, 2007
hi,
I have a search function.
I was able to display attributes of a record in one table, but
I also need to get one attribute from another table.
My question is how can I implement inner join in this kind of query in odbc command?
this is a part of my code:1 '||||| Create Command Object
2 Dim odbcCommand_search As OdbcCommand = New OdbcCommand("Select TM0001.syain_id, TM0001.syain_name, TM0001.syain_pass, TM0001.empl_date, TM0001.birth_date, TM0011.office_name from TM0001,TM0011 where TM0001.syain_id = ? or TM0001.syain_name = ? and TM0011.office_id = TM0001.office_id ", MyConn)
3
4 '||||| Parameters and set values.
5 odbcCommand_search.Parameters.Add("@P1", OdbcType.Char).Value = TextBox_id_name.Text 'emp_id.ToString
6 odbcCommand_search.Parameters.Add("@P1", OdbcType.Char).Value = TextBox_id_name.Text 'emp_name.ToString
7
8
9 Dim objReader As Odbc.OdbcDataReader
10 objReader = odbcCommand_search.ExecuteReader()
11 While objReader.Read()
12
13 TextBox_id.Text = objReader("syain_id")
14 TextBox_name.Text = objReader("syain_name")
15 TextBox_pswd.Text = objReader("syain_pass")
16 DropDownList_office.Text = objReader("office_name")
17 hire_date = objReader("empl_date")
18
19
20 End While
21
22 objReader.Close()
23
24
All values can be displayed except for the "office_name" which is from another Table "TM0011".
hope you can help me with this.
thanks
sheila
View 2 Replies
View Related
Feb 6, 2005
I need to write a VB.Net application in VS.net 2003 that copies several tables from an ODBC data source to MSDE tables. I do not have Enterprise Manager or DTS to use. Is there an example of this in VS? I was hoping VS has some built in tools for this. If not, bulk Insert?
Help appreciated.
thanks,
Frank
View 2 Replies
View Related
Mar 22, 2001
Hi Guys.
If I create a SYSTEM DSN ODBC for SQL Server 7.0 (3.70.09.61),
will the password be encrypted in standard 128 bit encryption?
I want to make sure that it is safe to use ODBC for SQL Server.
I found something on MS on Trace.... I am not sure whether it is applicable
for ODBC 3 or more.
Any related docs or urls for this?
Any comments and suggestion are always welcome.
-MAK
View 1 Replies
View Related
