|
Hello,
I've got two databases and need to copy one table to the another database. The table doesn't exist in the target DB, so I need a table with all columns etc.
Are there any fast solutions or must I get all values and create the sql command?
|
|
|
|
|
What DB are you using. You can use the DTS in SQL Server.
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
I have a mdb database.It has a password (123456), i found out password with a password cracker program. I exactly dont know why this password exist . I try to connect this database via VB.Net, OLEDB Connection. My Connection string is "Provider=Microsoft.Jet.OLEDB.4.0;Password=123456;Data Source=C:\Documents and Settings\creek\Desktop\AC115DataBase.mdb; Mode=Read;Persist Security Info=True"
i cant connect to database with this connection string. I get this error "Application cannot be started. Work File is missed, or any user opened file excluesive mode"
i dont know user name or any extra information about mdb file. I am so confused.
Question is What is wrong,
|
|
|
|
|
Where did you get the database?
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
at the end i solved my problem myself Line i missed is Bold.
Dim oOleDbConnection As New OleDb.OleDbConnection<br />
Dim strPassword As String = "123456"<br />
Dim strDataBasePath As String = "C:\Documents and Settings\creek\Desktop\AC115DataBase.mdb"<br />
<br />
Dim sConnString As String = _<br />
"Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source=" & strDataBasePath & ";" & _<br />
"Jet OLEDB:Database Password=" & strPassword & ";"
|
|
|
|
|
I have two tables Animal and AnimalClassification joined by a forgein key in the AnimalClassification table called HerdBookNumber. I want to count animals that have a given sire (paramSire) in each of six class types (AnimalClassification.FinalClass). The problem is that each animal could have several enteries in the AnimalClassification table and I only want the entry with the highest Lactation Number (AnimalClassification.LactationNumber) for each animal. The query below counts each entry in the AnimalClassification table not just the one with the highest lactation nubmer.
NOTE: It is not the highest LactationNumber in the AnimalClassification table but the highest LactationNumber in the AnimalClassification table for the associated animal.
SELECT COUNT(Animal.HerdBookNumber) AS Daughters, AnimalClassification.FinalClass
FROM Animal INNER JOIN AnimalClassification ON Animal.HerdBookNumber = AnimalClassification.HerdBookNumber
WHERE (((Animal.Sex)=1) AND Animal.Sire = paramSire)
GROUP BY Animal.Sire, AnimalClassification.FinalClass;
Could you please suggest how to get the information I require?
Thanks
|
|
|
|
|
Something like this might work:
SELECT
COUNT(a.*) AS Daughters,
ac.FinalClass
FROM
Animal a
INNER JOIN
AnimalClassification ac
ON (a.HerbBookNumber = ac.HerbBookNumber)
WHERE
(ac.LactationNumber =
(SELECT
MAX(LactationNumber)
FROM
AnimalClassification
WHERE
HerbBookNumber = a.HerbBookNumber)) AND
(Animal.Sex = 1) AND
(Animal.Sire = paramSire)
GROUP BY
ac.FinalClass
|
|
|
|
|
Hi,
I found this note from the download page of ODP.Net
- Do not install ODP.NET over a previous Oracle Home version (e.g. Oracle8i) if you have applications dependent on the older Oracle Home and are not certified with an Oracle9i Release 2 Home. For example, the Microsoft OLE DB provider for Oracle (MSDAORA) may not work with Oracle9i Release 2 client because the provider has not been tested for it.
According to it, my understanding is:
(1) ODP.NET only work with oracle client of Oracle9i Release 2 or high version
(2) if there's an application using oracle8i client and connect to oracle by odbc, then it's not recommended to install oracle 9i client and ODP.Net on it
(3) if there's an application using oracle9i client and connect to oracle by odbc, then it's ok to install odp.net and my .net application on it
Correct me if I am wrong. Thanks in advance.
|
|
|
|
|
i want ot import data from excel .xls file to sql server 2000 into an existing table.
should i use some stored procedures or else
softpioneer
|
|
|
|
|
You should be able to use the DTS Wizard to accomplish this task. Right-click your database in Enterprise Manager and select All Tasks > Import Data. For the data source pick the Microsoft Excel 97-2000 then select the file to import and click Next. The destination should already be the database you selected; click Next.
If you just want a copy of the data in a particular sheet, select 'Copy table(s) and view(s) from the source database' and click Next. Now check the sheet(s) you want to copy. Under Destination, select the target table. You can customise the transformation by clicking the [...] button in the Transform column.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
As you know, the =, like operators for string comparison in MS SQL are just for not-case sensitive string comparison. So my concern is how to compare two strings in case sensitive mode?
Thank in advance!
|
|
|
|
|
|
Cast the string to varbinarys and then compare - here is a small script you can run in Query Analyzer to test it if you would like.
DECLARE @Str1 VARCHAR(20)
DECLARE @Str2 VARCHAR(20)
DECLARE @Str3 VARCHAR(20)
SET @Str1 = 'abcdefg'
SET @str2 = 'ABCDEFG'
SET @Str3 = 'abcdefg'
IF @Str1 = @str2
Print 'Case Insentative: Equal'
ELSE
Print 'Case Insentative: Not Equal'
IF CAST(@Str1 AS VARBINARY(50)) = CAST(@Str2 AS VARBINARY(50))
Print 'Case Sensitive 1: Equal'
ELSE
Print 'Case Sensitive 1: Not Equal'
IF CAST(@Str1 AS VARBINARY(50)) = CAST(@Str3 AS VARBINARY(50))
Print 'Case Sensitive 2: Equal'
ELSE
Print 'Case Sensitive 2: Not Equal'
|
|
|
|
|
That's great! Thanks all of you!
|
|
|
|
|
How can i create a new database by PL/SQL statements ?
Thanks!
|
|
|
|
|
It can be accomplished with a statement as simple as
CREATE DATABASE MyDatabase;
Chris Meech
I am Canadian. [heard in a local bar]
Gently arching his fishing rod back he moves the tip forward in a gentle arch releasing the line.... kersplunk [Doug Goulden]
Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]
|
|
|
|
|
Och! How silly i am!
Thanks a lot!
|
|
|
|
|
Does anyone know of a clever way to display the current rowset index within an SQL statement?
For example:
Executing something like:
SELECT Field1, Field2, CURINDEX() FROM tblA
would return:
Field1 | Field2 | Idx |
-------+--------+-----|
Text 1 | Text 2 | 0 |
Text 3 | Text 4 | 1 |
Text 5 | Text 6 | 2 |
...
So from the above example the 'Idx' field would be the current returned order.
I Dream of Absolute Zero
|
|
|
|
|
Normally you would create a table (temp or memory) with a new identity field. Fill it then return that table.
If you have a unique field(s) in the query then you can also execute a correlated subquery.
SELECT
t.Field1,
t.Field2,
(Select Count(*) FROM tblA WHERE Field1+Field2 < t.Field1+t.Field2) AS Idx
FROM
tblA t
ORDER BY
Field1,
Field2
On a brighter note, I understand that SQL 2005 will give us a function for this.
|
|
|
|
|
Thanks for the reply.
I understand that each rowset returned from a query are 'stateless' so I by logic I didn't expect there to be an SQL function for this.
I guess a quick VBA macro using ADO will be the best method to achieve what I want.
I Dream of Absolute Zero
|
|
|
|
|
hi all !
Now I'm using MSDE2000A, I want to backup (restore) databse. How can i do that ? thank alot
I used command is "osql -S 175.3.2.24 -U sa -P mypass -d dbname"
it showed 1>
continue to type: BACKUP DATABASE mydb TO DISK = 'C:\MSDE\Backup\mydb.bak'
after type GO, enter. Have a error appear:
Cannot open backup device 'C:\MSDE\Backup\mydb.bak'. Device error or device off-line. See the SQL Server error log for more details.
please, help me. Thank
hanhquang
|
|
|
|
|
hi all,
I am using following autherization in the web config file using following tags
<authorization>
<allow roles="mydomain\mygroup"/>
<deny users="?" roles="BUILTIN\users"/>
</authorization>
<identity impersonate="true"/>
this works fine. But due to this , i am facing following problem...
when i try to connect to a remote SQL server, where login id and pwd of user is given in the connection string , then i am not allow to connect to the SQL server, with exception "either sql server doesn't exist or access is denied". But when i remove the deny tag from above tags then the authentication works fine. Can some body tell me what's the problem there and how can i overcome this problem. The connection string i am using is following
server=myserver;uid=testuser;pwd=12345;database=mytestdatabase;Integrated security=false
it is to mention that, this user "testuser" has administrators rights on the sql server .
|
|
|
|
|
I'm using ADO to write a ms access database program, it's very wierd to me that when i add a record into database and calling requery immediately, the count property of record set is wrong, but after a while, several seconds, when i requery again, the count is corrent. I think there is a delay in ado to reflect it.
How to resolve this issue. thanks.
I love C++
|
|
|
|
|
I'm writing a program to access the SQL SERVER using OLE DB Consumer templates. There was a strange problem found when I was trying to modify row data using CRowset::SetData method. Here is some key source code:
CDBPropSet ps(DBPROPSET_ROWSET);
ps.AddProperty(DBPROP_IRowsetChange,true);
ps.AddProperty(DBPROP_UPDATABILITY,DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);
//...
Ctheclass record; //class Ctheclass :
public Command<CAccessor<CtheAccessor> >
record.Open(session,_T("TABLE_NAME"),&ps)
_tcscpy(record.column1,_T("Data to modify"));
record.SetData();
The problem is that sometime these code runs ok and the row data has been modified as expected but sometime the row data did not changed even the SetData() method returned S_OK.
Can any tell me if there is something wrong with my code or something I was missing.
Lisoft
|
|
|
|
|
I am modifiying code that sets up an excel connection string as follows:
Dim sExcelConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=NO;IMEX=1"""
The problem is that when I use a data adapter to fill the data set I get a "Not a legal OleAut date" error because sometimes I am trying to import and older version of an excel file. I don't get an error if the file is the latest version of excel. Basically, I need a way to determine the version of the excel file before I execute this statement. I would appreciate any suggestions.
Thank you
Glen
Glen
|
|
|
|