I have two servers named Zulu and Zul1 with SQL Server 2000 Standard Edition.
I am trying to implement SQL Server 2000 replication. Before do this, I would like checking the connectivity between the two servers by using "ping" and "odbcping" command.
With ping command, the result is good (I get the reply from other server).
When I use odbcping, from Zulu to reach Zul1, I get this error:
“ Could not connect to sql server
SQLState: 08001 Native Error:17
Info. Message [Microsoft][ODBC SQL Server Drive][DBNETLIB]This Sql server doesn't exist or access is refused
SQLState: 01000 Native Error:1326
Info. Message [Microsoft][ODBC SQL Server Drive][DBNETLIB]ConnectionOpen <Connect<>> ”
But when I use odbcping from Zul1 to reach Zulu, I get the good message
Note:
* I use the same SQL Server user i.e. sa with the same password in the odbcping command.
* Zulu1 is under a firewall, Zulu is on our DMZ zone for public access.
* Zulu1 is a Windows NT 4.0, SP 5 and Zulu is a Windows 2000 server.
Hi, Just upgraded some development desktops to Vista Business. However we need to still connect to some older remote windows 2000/SQL 2000 servers.
Trying to setup an ODBC system DSN on our Vista Business local desktop we get the following errors -
-START ERROR WINDOW- Connection Failed: SQLState: '01000' SQL Server Error: 772 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (SECDoClientHandshake()0. Connection failed: SQLState: '08001' SQL Server Error: 18 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error -END ERROR WINDOW-
Any help greatly appreciated as this is stopping us from making database/table connections etc. We've checked the firewall setup and all is well there.
PS - we can still connect fine using XP or windows 2000 desktops and their local DSNs.
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.
I am trying to setup Transaction Replication, and I am having problem setting up connection from backup server to prime server. My primary server has name “xxxxxxxxx”, and my backup server is “xxxxxxxxx”. I have no problem making connection from primary to backup, but I can’t setup connection the other way. I check the PORT number on “xxxxxxx” server, and it’s 1433 (default). I am wondering if this “xxxxxxx” naming gave me trouble. I posted messages on some SQL Server forum, and some people gave me advices, but so far the problem was not solved.
BTW, I can PING the machine where xxxxxxx Instance residing.
I am a real newbie to SQL Server 2000 and databases in general. I am on a WINXP box. I am using an ODBC connection in a perl script. My problem is this. I get this error in my perl script when I try to execute a query against an existing table in my database:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'wrk_taxonomic_unit'. (SQL-42S02) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at validate.pl line 89. DBD::ODBC::st fetchrow_array failed: (DBD: no select statement currently executing err=-1) at validate.pl line 90. The problem seems to be the table name. if I append the owner of the database to the front of the table name, it works. I don't really like this solution. Is there something I can specify in my DSN to avoid this dilemma? Any help is appreciated.
SQL Server and the service pack seemed to install fine on a Windows 2003 Standard box. I configured the ODBC connection and got a "connection successful". However, when the next application tries to install, i am getting the "data source name not found and no driver specified". My client and db box are the same. Is my client not configured correctly?
Hello, We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell How do I upgrade the ODBC driver so that they can connected to SQL 2000. The client pc's have an older version of ODBC drivers which supports Sql 7.0 Which dll do I need ? ? Where do I get it? Does it have on sql 2000 cd?
We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell after updating the ODBC driver to SQL 2000 would it support SQL Server 7.0 ?
I have a customer who has a SQL Server 2000 DB and we are needing toget to this DB through ODBC. I had setup a DSN last week thatconnected fine to this DB, and was preparing to build a script tomanage transfers of data to and from one table to another.The then began to have troubles with their DB Backup (this is not atall related to the issue at hand). The problem they claim was that the"sa" was needing to have certain roles applied to it that were not partof it's default properties. My understanding is that the "sa" is theKing of the Kingdom sotospeak, and has all rights, permissions, rolecapabilities, etc...To make a long story short she tried to apply the write and read rolesto the "sa" and it would not allow for this to be applied. She thenapplied a password to the "sa" account (previous it did not have oneand was set to blank) and upon doing this she then removed the passwordand set it back to blank.Since she made these changes we have not been able to connect to her DBvia our DSN. When we get to the point of telling the DSN to use SQLAuthentication, and apply the sa account for use with a blank password- it comes back with an error similar to "database is not available orpassword is incorrect".Has anyone had this problem before, and if so is there any simpleresolve? Something other than the customer having to restore a previousbackup of the DB?Much thanks in advance...
Hello all!I have such question to all of you.I have some tables linked from MS SQL Server 2000. Is time of processingquerybased on these linked tables from MS SQL Server 2000, faster or slower thanthe time of processing the same query based on tables, which are not linkedbutimported to MS Access?Can you answer this question?Thank you in advance for postsMarcin from Poland.
How viable is it to use MS Access as a front end (via ODBC) to a SQL Server2000 database?The users would access via the internet using a netgear vpn setup.Thanks,Paul S
hi all,I am trying to create a dts package to transfer data from tables in mysql server 2000 database to a db2 UDB v8.1.4 database. When I use ibmdb2 oledb driver for the destination this works fine except that rowsare committed on a row by row basis thus performance is slow. I wantto use the odbc driver but when I define it as the destination, i geterrors saying that the maximum number of rows failed has exceeded theminimum.Does anybody know what to do in order to get the transfer workingusing ibm db2 odbc as the datasource?ThanksLyn
I setup a new ODBC connection to MS SQL Server 2000 on Windows XP and keep getting the following errors when I try to either register a new SQL Server 2000 group within Enterprise Manager or test the new ODBC connection:
Current configuration
- MS SQL Server 2000 -Windows XP -ODBC 3.85.1117
Errors:
I. Within SQL Server 2000 Enterprise Manager
Error: SQL Server connection open
II. When I test the ODBC connection:
Microsoft SQL Server ODBC Driver Version 03.85.1117
Running connectivity tests...
Attempting connection [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
TESTS FAILED!
Now here is what has me totally confused:
I can use the command line ISQL to access the database on the server and IP is all correct and port is available.
When our administrators login on the workstation the application works well. But when ordinary users login they get the following error. (We only have 1 domain)
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
Then the standard SQL Server Login window pops up asking for the Login ID and Password. On the window the 'Use Trusted Connection' is checked and the name of the user on the workstation appears on the LoginID. What we do is uncheck the 'Use Trusted Connection' then login using the credentials above.
Here's my situation:I have an ODBC DSN setup for Timberline Data (An accounting packagethat uses pervasive.sql) on my sql box. I set up a linked server usingthe supplied timberline odbc driver. I have two sql instances setup,the default instance and a named instance. On the default instance,the linked server works great no matter who is logged in using it (allauthentication is NT integrated). However on the named instance onlythe NT account that the MSSqlserver$NAMED service is logged in undercan utilize the linked server. All others get a ODBC error:"error 7399: OLE DB Provider 'MSDASQL' reported an error. AccessDenied. OLE DB error trace [OLE/DB Provider 'MSDASQL'IUnknown::QueryInterface returned 0x80070005: Access Denied.]."Far as i can tell, both instances are setup the same, except that oneis the default and one is a named instance.Why the different results for the default instance vs a named instance.Any ideas?Thanks
I changed from Access97 to AccessXP and I have immense performanceproblems.Details:- Access XP MDB with Jet 4.0 ( no ADP-Project )- Linked Tables to SQL-Server 2000 over ODBCI used the SQL Profile to watch the T-SQL-Command which Access ( whocreates the commands?) creates and noticed:1) some Jet-SQL commands with JOINS and Where-Statements aretranslated very well, using sp_prepexe and sp_execute, including thesimilar SQL-Statement as in JET.2) other Jet-SQL commands with JOINS and Where-Statements aretranslated very bad, because the Join wasn´t sent as a join, Accesscollects the data of the individual tables seperately.Access sends much to much data over the network, it is a disaster!3) in Access97 the same command was interpreted wellCould it be possible the Access uses a wrong protocol-stack, perhapsJet to OLEDB, OLEDB to ODBC, ODBC to SQL-Server orJet to ODBC, ODBC to OLEDB and OLEDB to SQL-Server instead ofJet to ODBC and ODBC direct to SQL-ServerDoes anyone knows anything about:- Command-Interpreter of JetODBC, Parameters, how to influence thecommand-interpreter- Protocol-Stack of a Jet4.0 / ODBC / SQL-Server applicationThanks , Andreas
I am getting the error message as "DIAG [00000] [ODBC Access Driver 52.1.150.0] -26 Driver not capable (-26)" at the time of retrieving the catalog infromation by SqlTables methode. it is shown "?" as catalogname but this not supported by odbc access driver. can you please help out how can i resolve using C++ code in SqlTables methode.
I have a ASP.Net application. I'm trying to access access data using SQL Server my web config has <add key="connectionString" value="DRIVER={Sql Server};Server=(local);initial catalog=ymquizco_registration;User ID=sa;pwd=test"/> MY CONNECTION STRING HAS THIS VALUE "DRIVER={Sql Server};Server=localhost;initial catalog=ymquizco_registration;User ID=sa;pwd=test" But the conn.Open();is throwing this error: {"ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\ASPNET'. ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\ASPNET'. ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute" } My SQL Server is configured at mixed mode authentication. This seems like a install issue. Can someone think of something.
When trying to access an ASP page connecting to a SQL database, I receive the following error from the driver
[Microsoft][ODBC SQL Server Driver][SQL Server]Create of work table failed because the row size would be 3697. This exceeds the maximum allowable size of a row in a table, 2014.
I can't remember if one of the sp_configure options handles this or not. Can anyone refresh my memory?
I am getteing need help Query analyzer error Unable to connect server local Msg17, level 16,state 1 ODBC SQL server driver [DBNETLIB]SQL server does not exist
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
I am trying to connect SQL server7.0 through ODBC 3.5,when i tried to create DSN ,i am getting below error message.I added alias with server name as IP Address in client network utility,But no use.I tried to connect through query analyzer but no use. ( Client M/c and Sql Servers are on T1 network)
** But i am able to connect through ISQL
I am not understanding why i am not able to connect through ODBC and query analyzer.Can some one help me in this.
ERROR MESSAGE: **************************************** unable to connect to the server {....IP Address....}. odbc:Msg 0, Level 16, State 1 [Microsoft][ODBC SQL Server Driver]Timeout expired ******************************************
I have a problem with ODBC Driver for SQL Server 6.5. The user always receive the following message in client machine when try to access the application : "08S01 : [Microsoft][ODBC SQL Server Driver]Communication link failure".
Hi, When Iam browsing my website, It showing an error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbl_Users'. (this is the table name)
I am experiencing the following error in a server 2003 and SQL 2005 environment. I don't know much about SQL, and any help would be appreciated. I have been told to look at the ODBC, as well as several items in SQL. But alas I have not been able to do much with it. Software program was purchased and support for the system is extremely limited.
Here is the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'insert server name' in sysservers. Execute sp_addlinkedserver to add the server in sysservers.
Current (working) Environment within same domain: Quote: MS SQL (v8 sp3?) on windows 2000 sp3 web server on windows 2000 sp3
New (not working) Environment: Quote: MS SQL (v8 sp3?) on windows 2000 sp3 web server on windows 2003 sp3
when i try to connect to the remote sql db (the asp page code has remained unchanged), i get this error: Quote: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Default.asp, line 567 line 567 is the attempt to open the connection (again, no code changes).
The ODBC reg tree has the IUSR internet guest account permissions.
When I try to create a system DSN via the ODBC manager on the current, working system, I can see a list of the SQL boxes on the network. When I try the same on the new 2003 server...our SQL server list isn't displayed.
Any ideas on why I'm getting this error in the asp page? {UPDATE} Creating a system DSN on the new 2003 server works, if the "Named Pipes" network libraries are choosen in the set up. If the TCP/IP network libraries are choosen...the connection fails. Named pipes uses port(s) 445 & 139. The TCP/IP libraries use port 1433.
Why would Named pipes work and not TCP/IP?
Thanks.
P.S. I posted this in the O/S forum, but it looks like no one browsing that forum can help on this, so it was suggested I post in the DB forum. http://forums.devshed.com/showthrea...061#post1086061
