ODBC Connectivity Issues
Jan 26, 2005
I have a windows 98 pc trying to connect to a sql server running on Windows Server 2003 via a frame relay. The 98 pc will connect to the domain and it is able to ping the server. However, when I try to use my MS Access program that connects to the sql server, I get this error message:
Connection Failed
SqlState: '01000'
Sql ServerError: 11001
[Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Connection Open (Connect ()).
Connection Failed
SqlState: '08001'
Sql ServerError: 6
[Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Specified Sql server not found.
I have other pcs that connect to the Sql Server fine but they are located locally in the same building as the server. I've tried connecting through named pipes but for some reason, I get the same error. I have downloaded and installed the new MDAC drivers for the 98 pc. Any suggestions?
View 2 Replies
ADVERTISEMENT
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
Jan 12, 1999
We are trying to extract data from DB2 on an as400 machine. Can we simply use SQL statements to extract the proper data that we need from as400 using the SQL Server 7.0 functionality? How do we do that?
We think this needs to be done via DTS(Data Transformation Service).
Thanks in advance.
Shaikh & Sande.
View 1 Replies
View Related
Aug 14, 2007
Hi,
I have created DSN connection with sql server authentication in Sql server 2005. There is message comes "Connection Succeeded".
After I try through my application again asking username and password for the DSN at run time. My application is developed in Powerbuilder 5.0.
The connection string as follows,
SQLCA.dbms= "ODBC"
SQLCA.dBparm = "CONNECTSTRING='DSN=ntm',APPNAME = 'ntm',uid='sa',pwd='sierra'"
Can you help me?
View 3 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
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
Apr 24, 2008
how should i change my comnnetion string when i host the website in the server. i am having errors? but in local host its working fine?
View 3 Replies
View Related
Sep 3, 2001
Hi,
I am responsible for an application that uses the Borland Database Engine to connect clients to the database server - it's called SalesLogix. I am in the process of upgrading the databases in the working environment to SQL 7 from SQL 6.5 and on the whole it has been (relatively) successful, however I have a majorly inconvenient issue with a few client machines. Occasionally, after upgrading the SQL client and having upgraded the database server I cannot make a connection any longer and instead when I try through the BDE I am presented with the message 'General SQL Error' and the BDE error code for a general SQL error, and nothing more. It has only happened on a couple of machines, but with no apparent pattern. The clients can still connect to SQL 6.5 databases as long as the SQL 6.5 client utilities are still installed so I don't know what to think. Any ideas?
Cheers,
Anthony
View 1 Replies
View Related
Sep 8, 2003
Please Help.
I can ping my sql server using the IP address but not using the host name.
I run win XP desktop and SQL 2k sp 3 on WIN 2k SP3 two nodes active/passive cluster configuration.
Urgent
View 1 Replies
View Related
Sep 7, 1999
i have a server in US and the other at india iam trying to connect both the sql servers but iam unable to do it. Please tell me how to connect them
regards
aafreen
View 1 Replies
View Related
Jul 13, 2006
Hello everybody.
I am connecting my computer to the internet and when i see the ip address of my computer i try:
telnet ipaddress 1433 but it says 'connection failed'.
this happens even when i try to access my sql server from another computer through the internet.
I have installed service pack 4,configured the server connectivity by adding the tcp/ip protocol and checked the port:it is 1433.
Also checked the firewalls ,but no results.
please help
View 4 Replies
View Related
Nov 22, 2007
We are trying to setup a role based security access within our client software so that users have read only access to the database. Right now we are not able to connect to the database. This is a blocking issue for us on the project right now
Please let us know how to proceed now ?
Thanks in advance
Kishore
View 4 Replies
View Related
Jul 20, 2005
Is it possible to approach a MS SQL Server using TCP/IP? I have lookedeverywhere but have not found any documentation about the protocol toconnect to MS SQL Server.I wish to connect to MS SQL Server directly through TCP/IP, without using MSlibraries (since i am not doing this on a windows system).Thanks in advance,Eddie Gieze
View 2 Replies
View Related
May 31, 2006
I am building a C# Windows app. I have a form and have also create a db. I tested the db connectivity in Server Explorer and the test came back successfully. According to my manual, I just need to drag the db item from the server explorer to my form designer to creation the connection. When I do this nothing happens... what am I doing wrong?
If I do the same thing in VS2003 the sqlConnection1 shows up, how do I accomplish the same thing with 2005?
View 1 Replies
View Related
Nov 6, 2006
hi friends,
i am developing a dictionary for pocket device
i am using sql ce database .
i have included and copied that file in the project but every time exception occurs saying check the directory . file can not be found.....
may be this a little one but help me......
its urgent..........
View 5 Replies
View Related
Jan 21, 2008
hi,
how to connect the database for first time
iam working for a website in that i have a form. how to connect the form to the database.
throw enterprice managment
thanks
View 1 Replies
View Related
Dec 27, 2004
Hi:
I m in new in ASP.net and can't connect sql server db with ASP.net.I write exact code.but it give error in connection string and server error some time.I found that error is in web.config file.can any one have running project of asp.net with sqlserver db..
if any one have then mail the project at this mail address..
ray_boby@hotmail.com
View 1 Replies
View Related
Jul 26, 2005
Hi im new to ASP.NET.. can anyopne pelase tell me how to make database connectivity with sql server 2000.i need to insert data into sqlserver2000 database from an ASP.NET Web form. please provide me with a asample code.thank you
View 1 Replies
View Related
Dec 13, 2005
I am using webforms for ASP .NET which has code in C#. My database is running on SQL Server 7. Whats the best way to connect to database. I have tried ODBC connection through myConnection=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);but it gives me an error that can not connect to the SQL Server 2005 or it does not allow remote connections though it is running SQL Server 7 and not SQL Server 2005. Thanks in advance.
View 1 Replies
View Related
Jan 11, 2006
I am using SQL SERVER 2000 and asp.net How shoul i connect using OLEDB provider?.
In connection string, i am giving Provider=SQLOLEDB.1,datasource .
It's giving error in conn.open() that login failed for database. i am also poroving username and password in connection string, so i want code for the same.
awaiting for reply...
View 2 Replies
View Related
Apr 2, 2001
Hi,
I have a sql server that I cannot connect to in Enterprise Manager. I can connect no problem with Query Analyzer, but EM always gives me a "timeout expired" error. I am using tcp/ip, and my network card is configured exactly the same as another server that i can connect to fine. Any ideas? I really need to figure this out. this has nothing to do with timeout intervals, or anything like that, as it's all default settings, same as the other database...thanks.
View 1 Replies
View Related
Apr 2, 2001
Here's my post from a few minutes ago, thanks for the answer but that's not a fix, and trying to reconnect doesn't help. it never connects. I'm posting again, as otherwise people wouldn't read the older thread once it's replied too
I have a sql server that I cannot connect to in Enterprise Manager. I can connect no problem with Query Analyzer, but EM always gives me a "timeout expired" error. I am using tcp/ip, and my network card is configured exactly the same as another server that i can connect to fine. Any ideas? I really need to figure this out. this has nothing to do with timeout intervals, or anything like that, as it's all default settings, same as the other database...thanks.
View 1 Replies
View Related
Jul 2, 2001
I have a few ASPs that were written to pull from an Access 97 database. Now that we have converted the data over to a SQL database, the ASPs have been changed accordingly. My problem is that I have two ASPs which use an Inner Join between three tables where the main field (in this case it is called "INDEX") is what the pull is based on. When I try to run the ASPs I recieve this error .
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INDEX'.
The line that it identifies is where the connection is actually opened.
This is only occuring on the ASPs that use the column INDEX and an inner join. The straight style number pulls (which have the same connection string)
are working fine. Any ideas?
View 1 Replies
View Related
Feb 17, 2000
hello , i have a small problem , an associate want to connect to a micrsoft sql server under nt from a pc with only dos! can such a thing be done?
View 1 Replies
View Related
Mar 17, 1999
What do I need to do to enable a client PC to See a SQL server database? I keep getting ODBC timeout errors.
Help
View 2 Replies
View Related
Jan 5, 2003
Hi all,
I'm currently trying to connect my ASP page with an SQL server 2000 DB. I already know, how to connect with Access, through the the cobnnection object...
examlpe:
---------------------------
Dim objConn
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.ConnectionString = "DSN=cb_access_db"
'objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=F:dbCB_database.mdb"
objConn.Open
---------------------------
Now, i have SQL 2000 running on my local syste, and i'v ecreated a DSN..
How would i connec to it???
any input, or exampkles would help.Thanks!
DAve
View 2 Replies
View Related
Aug 6, 2003
Hi,
We have a client machine that has Win98. From that they are running VB app that connects SQL 2000 Server.
Here is the code in the registry under
HKEY_CURRENT_USERSOFTWAREVB and VBA Program SettingsAppname folder
for running that application.
Provider=SQLOLEDB.1;Initial Catalog=dbname;Data Source=xxxx;Integrated Security=SSPI
From ODBC the system can connect to the database.
But from SQLOLEDB
It comes back with error:
-2147467259
Unable to connect.
Any ideas?
Thanks,
Anu
View 4 Replies
View Related
Aug 5, 1999
I cannot (most of the time!!) get ODBC to make a connection to SQL Server 6.5 over the network. I get the following error:
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.
I've looked in the SQL Server log and I've found:
"Error 17826, Severity:18, State:0 Unable to set up ListenOn Connection 'My Server Name'; OS Error: 10047"
I can get ODBC to connect from the same machine as SQL Server so it seems to be a network problem. I've tried using TCP/IP, Named Pipes, Multiprotocol, no joy. The network is ok i.e. I can ping and can otherwise find the server on the network. What's wierd is that on occassion I can get ODBC to connect!
Does anyone know what's going on???
Thanks.
View 1 Replies
View Related
Mar 24, 2005
Hello Everyone,
What is the best way to test connectivity with the database from the application on a frequest basis?
Thanks.
View 6 Replies
View Related
May 1, 2006
Hi -
I'm having a problem with a VB6 program I'm writing that posts data to a SQL server. The problem occurs when the SQL server is unavailable. When this happens it causes the program to hang for at least 30 seconds before releasing. The hang happens at the code that connects to the SQL server, because the server isn't there. I've added code found on this site to test the connectivity prior to making my actual data connection, but this causes the same hang. Is there any way to verify connectivity to an SQL server without actually trying to make the connection? I'm really trying to eliminate the hang that occurs when the server is unavailable.
Thanks
View 13 Replies
View Related
Mar 12, 1999
This problem occurs in a Visual Basic 5 application which accesses the SQL Server 6.5 database through Jet Engine(DAO).
If a user starts a transaction and then his application terminates abnormally (before rolling back or committing), say due to power failure or if the user kills the application with Ctrl+Alt+Delete, then the transaction started by him is not terminated (rolled back) by SQL Server. Even the process cannot be killed using the "Kill" command and the user keeps holding all the locks that he has already acquired. Also nobody can use Enterprise Manager. This happens when you have lock on more than 8 tables including tables in tempdb. The only way to solve this problem is to restart the server which is never expected in a multiuser system.
One can know the threadID of the process that needs to be killed using "Sysprocesses" system table. Is it possible to kill the thread in Windows NT?
Is there any setting due to which SQL SERVER will automatically kill a process or rollback a transaction started by a disconnected client ?
Is it possible that a process or transaction will have to release lock after the specified time ?
Is there any other way to tackle this problem?
-Gunvant Patil
gunvantp@mail.usa.com
View 2 Replies
View Related
