I am very new to all this
I have a access databse wich uses a ODBC conection to mysql server. I
can open the and run the database find but if i leave the dadabase
loaded but do not use it when i go back to it is has lost the
conection and i need to close the databse and reopen it
If there a way to make sure i alwasy have a coenction
Thanks
Hi,
I am trying to connect some users to the server using ODBC.
But when I do that I get an error that the user is not asociated as a concexcion of confidence of SQL Server.
From my PC it works fine as I am the administrator.
Where do I have to change it?
Thx
Johny
Good day.I have dts running every 10 minutes in a server of slqserver 2000 who is in a country and that it sends data to another country which has a data base sybase12.5.The problem is when by reasons for the WAN the connection fails from a country to another one the dts or job fails executing its processes and I must soon give click to stop and start so that it continues. That I can do so that when the connection is lost and i need to dts reconected automatically and is continued its processing?
thanks and sorry my english :)
Hi,
Now I really need you help. I have an application that needs to conect to a server
over the internet and I have change the MSQL port to 2015 cos the server even with a
firewall it has been attempt to be hacked. So I needed to change the port but my application
cannot conect to the server if I change it. If I left in the firewall 1433 and SQL it works fine
but once I change it to 2015 it doesn´t work.
I´m using ADO conection as folow:
Variables string parameters:
01=password
02=user
03=database
04=server IP adress
"Provider=SQLOLEDB.1;Password='+01+';Persist Security Info=True;User ID='+02+';Initial Catalog='+03+';Data Source='+04;"
Using this conection string I can conect to the server using 1433 port but if I change the port I get the folow message:
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
I´d try to add the new port number to IP adress but it doesn´t work as (200.121.65.140:2015) and it return the folow message:
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
What I need to know or to do? Please somebody help me cos I don´t know more what to do and my superiors need awnsers.
Thanks for attetion.
Leonardo Almeida.
Hello world.
I have a big problem.
Im writing an application in Sql 2005 Etl.
This application use 2 kind of ole db connection. One towards a Sql Server, and the other towards As400
to use ole db towords As400 is necessary to save user and password to connect.
There is a flag to save password.........and obviously a checked it. !!!!!
The problem is:
If I stay inside Visual studio and i use this application.......all is correct.
If I use my application in sql like a job.........loose password information and crash immediatly
someone can help me ?????????
thanks all in advance.
Alberto.
Hi,
We have 3 -rd party application connected to one of our sql server 24 X 7
Once or twice a day application crashes
with application error (connection lost).
1.Is possible to trace application errors using SQL profiler ?
2. Create SQL alert or write to SQL log in case of falure for specific application ?
Thank you
Alex
When trying to connect to my SQL Server I'm getting the following error:
******************************************
A connection could not be established to (local).
Reason: Logon failed for user.
Please vertify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.
******************************************
SQL Server is definately running, but I'm unable to connect.
I've tried changing the ODBC settings but I can't get past the "MIcrosoft SQL Server DNS Configuration" window. I choose "With Windows NT authentication using the network lognin ID" and click "Conect to SQL Server to obtain default setting for the additional congiruation options" and click "Next" but I get stopped by the following error:
connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user machine1Administrator'
Does anyone have any ideas on what I need to do to fix this? If it helps, this all seems to have started occuring since I changed the Administrator password
Hi,
I have one database configured with the Recovery Model "Simple".
I am getting alot of full transaction log messages... is this supposed to happen?
Another question is:
Imagine i am in a middle of a big select into statement... and in another query i run the backup truncate log... am i going to loose information on the other batch ("select into?")??
Kind Regards,
Luis Simões
Hello --
I'm building an app that will allow users to create their own photo galleries. At this point, I'm planning on storing all photos as byte arrays in SQL server image fields.
Besides the organizational benefit, is there a space benefit to doing this? That is, if I have 1MB of .jpg's, will those same images take up less than 1MB of file space within the database?
One of the reasons I ask is that most hosting plans out there seem to offer more "normal" disk space than is allocated for the database, so I'm trying to make a best plan to accommodate what will probably end up being the biggest disk space consumer in my app (the photos, that is).
Any other recommendations re: this scenario (hosting, best practices) are appreciated.
TIA,
Eric
I need solve this problem. I have this software running at 2 locations (1 and 2)
- the 1) got a app server and the data base, in the same computer;
- the 2) got a app server, acessing the data base of the 1)
- the conection between the two is all right, like a local network, by air.
- at 1) it runs all right, but the 2), when have to acess the data base (at 1), the conection becames too
slowwwwwwww.... impossible to work
Somebody acess data base via internet, or acess a data base that stay phisically away from the app server ??
Could it be a data trasmisson protocol problem ???
sorry the language errors ... thats the best i can :) hehe
thank you , since now
Júlio
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 ?
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.
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?
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 RelatedHi,
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.
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
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)
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 :)
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
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
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 RelatedI 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
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?
To set-up a Merge Replication do you need to setup an ODBC link? All suggestions are welcome.
Regards,
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,
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
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
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
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
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.
Can somebody please help me install and setup ODBC Drivers for SQL server . Thanks
View 20 Replies View RelatedI 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 RelatedI 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