|
Hello,
After filling a DataTable with the DataAdapter i get no information regarding which column is the unique key one.
Basically it sets all of the column to false on the unique property of the column even if it's not so on the DataBase.
Also i go through hell to retrieve the Sql Data type of the column in the DataTable.
Anyone has an answer to that?
thanks,
Leo
|
|
|
|
|
You dont know how to do it?
all of us here allready knows.
|
|
|
|
|
Hi guys, I've got this problem, hope someone can help me out.
I've written and application and it works fine on my computer and i can connect to SQL through a Text file
connection string in the Text box : Data Source= NameOfMyDataSource;Initial Catalog= DataBaseName ;Integrated Security=True
As I said, it works fine on my computer but NOT on other computers !!!
I installed my application on another computer and also installed SQL server, then attached my database and it works fine, but when i run my progran and enter ID and Pass get this error !
System.Data.SqlClient.SqlException: 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)
A friend from here suggested:
By default, SQL Server blocks remote access. To get round this, log into SQL Server Configuration Manager and make sure that you have enabled Named Pipes. Then, go into the Surface Area Configuration Tool and make sure it's set for Local and/or remote connections for Named Pipes. Now, restart the SQL Server instance.
I did that but still get the same error !!! what should I do ???
Thanx
|
|
|
|
|
I am guessing that your servername is incorrect. On the machine that it is not working on, try ping the server name. If you are using something like localhost that for sure would not work on remote systems. If you can't ping the sql server, then you might have a name resolution issue which would be solved with a DNS entry on your network.
Hope that helps.
Ben
|
|
|
|
|
Hey, how can I fix this resolution issue thing ???
Mr.K
|
|
|
|
|
Can you ping the ip address or sql server name?
Ben
|
|
|
|
|
It's not on a server, everything 's on a single computer !
so i don't think I can ping the IP !
Mr.K
|
|
|
|
|
If everything is on a single computer, you probably don't want to put in the ip address, but you still would need to put the sql server name. You should still be able to create an odbc connection to it and the test connection should work.
Ben
|
|
|
|
|
Check these two things, it might help:
1. Add SQL Server instance to the permitted list of applications in the firewall settings (Control Panel-> Security)
2. Check if port 1434 is not block using telnet <sql ip=""> 1434.
Regards,
Pratyush Shukla
ssssssssssss
|
|
|
|
|
One more thing to check - make sure that you are using the database instance name, if any.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi, How can I check my database instance name ???
Mr.K
|
|
|
|
|
Adding another issue, you may not be able to use Integrated Security (Windows Authentication) if the server and client are not members of the same domain. If they are not, the user running the client needs to have a Windows account on the server and the passwords need to be the same.
Also, your database server will need to grant the CONNECT privilege to the user or to a group that the user belongs to, and the login will need to be mapped to a user in the database you're trying to use, with appropriate rights for what you're trying to do.
|
|
|
|
|
The thing is this is all happening on one computer, I'm soot running it on a server then connect to it with clients. everything is on one computer !
|
|
|
|
|
Hi,
You should connect to SQL Server by SQL Server Authentication(User sa) and not Windows Authentication.
|
|
|
|
|
Hi i have a table of tests each of which has its own col but when displaying this test data it must be displayed down the table ie
Test Name Average Res Results
test 1 a res 1 res 1
tes 2 a res 2 res 2
so i am just lookin for some advice on how to go about altering the layout and specifically whether i shud try and do it with C# or SQL and help is appreciated
Thanks
Tim
|
|
|
|
|
Dear all,
I am trying sql server reporting service 2005.
I made one simple report through business intelligence project and deployed that project to report server.Now when i trying to export to pdf or excel or any option. it only get hanged, does not export.
I am currently not able to identify problem.
Please suggest some idea where i am going wrong
Thanks
regards
imran khan
|
|
|
|
|
Hi all,
Here am Using oracle10g database as backend in my application.
In my database there is some data table having Name Field.
For instance consider,There is a Name value called Bobby.
In Future,at the time of data insertion i wanna check whether the Name value(Here Bobby)already exists or not and that too it must b case insensitive.
Means it mustnt take bobby,boBBy,bobbY etc.
Programatically in c# am having awareness abt remaining part,but strucked at this Query part.
Here i tried with this Query but no clarity.
SELECT e.ID from Emp e , Empusers ue WHERE e.ID = ue.UID
AND e.employeename = :employeename
Pls Guide me,thanks in advance
Have a Nice Day Dudes
|
|
|
|
|
Try:
SELECT e.ID from Emp e
WHERE UPPER(e.employeename) = UPPER(:employeename) If that is too slow then Oracle allows you to specify a unique function-based index that uses "UPPER(EmployeeName)" instead of a column.
|
|
|
|
|
Thanks for the Reply,
Got the solution by using Lower(),as u said earlier.
Have a Nice Day Dudes
|
|
|
|
|
I'm using the Execute method of ADODB.Connection in VB 6 to execute an SQL delete statement. The rows from the table are deleted but I (sometimes) get a runtime error:
ADO Error #-2147352566
Description Out of present range.
Source Provider
A normal reason for this would be trying to insert a numerical value that is indeed out of range - but this is a deletion(!?). I can execute the SQL (cut and pasted from the VB) in PL/SQL Developer and get no error. It's as though the state of the connection or another component of the ADO is causing the failure . Initially thought that it was something to do with the number of strings in the SQL's IN statement (169 of them, all 9 chars matching against a VARCHAR2(9) in the table) but I have now tested up to the 1000 limit (after which I get the expected Oracle error).
I have Googled for:
ADO Error Out of present range
ADO Error -2147352566
ADO Error 0x8002000A
ADO Error 8002000A
and variations on this theme but have not found anything useful.
Have any of you guys encountered this before (where it's not for the obvious reason - out of range)? Any ideas?
|
|
|
|
|
Which database driver and connection string are you using?
|
|
|
|
|
The ODBC driver is "Oracle in Oracle9iDS"
The connection string is "Data Source=TLINK30.world;User Id=T301;Password=XXXXXX;"
The application maintains this one connection throughout. All of the other queries run fine and a similar query (differering in the contents of the IN part of the expression) runs fine. It's as though one of the terms in the IN part contains invalid characters or something but they all appear to be nine characters (and are from another query on a VARCHAR2 field in another table).
I'm going to try make a query with a 10 character string in the IN part and see if I get the same error and then try to identify which string is making it fail in the real query.
|
|
|
|
|
hi
i would like to display the last 12 record from my database,using sql statement,
i tried this code:
strSQL = "SELECT last 10 *FROM tab5"
but am having the followig error message:
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. can anyone tell me a solution
|
|
|
|
|
Hi Dear ,
You could use order by descending like "select top 10 from tabs5 order by desc"
Thanks And Pleasure ,
Navneet Hegde
Develop2Program & Program2Develop
|
|
|
|
|
I know you have been told this before - please don't cross post on the forums. It's bad manners.
Deja View - the feeling that you've seen this post before.
|
|
|
|