|
cross posting!!
I was born intelligent
Education ruined me!.
|
|
|
|
|
Here is my problem.
My code reveives a ADO recordset. I have no control over the cursor types etc on this recordset. I need to copy this recordset to another Recordset. The new recordset is not connected to any database or any source.
Then I am to do stuff to the data in the new recordset, delete some of the rows and then pass the recordset on to a module that expects a Recordset as input.
How do I create a recordset, and then copy data from an existing recordset to this one. Each time I try some code it blows up. Is it even possible?
I tried something like:
while not eof
localRecordset.AddNew //It blows up here if the recordset is not open.
If I do recordset.Open //Then I do not know what parameters to open it with
Thanks
|
|
|
|
|
Hi..
Use the method Clone of the recordset object to copy a recordset into another..
Set rs2 = rs1.Clone (LockType)
|
|
|
|
|
My users will be uploading a comma-delimited text file that I need to check for format (I do not have control over the file they create) and consistency with my existing data. If the file passes the checks I will import the file into the database otherwise, I'll tell them to go back, fix the file and try again.
I can upload the file, perform the checks (once it's in a table) and report the errors. Here's the question.
How do I import a tex file of an unknown format (what I need to check)
Since this is web-based how do I accomodate multiple-users (i.e. I can't import into one temp file 'cause users will step all over each other)
Thanks
David
|
|
|
|
|
You might want to use DTS (distributed transaction server) to do a bulk insert from your file. You can even set DTS to run at a later point in time too. Check the SQL Server documentation, I don't remember exactly how DTS works, but there is a VBScript object for it.
|
|
|
|
|
I agree, I could use either a BULK INSERT or DTS - if I knew that the uploaded file was going to be in the proper format (i.e. # of columns, datatypes etc.) I beleive for either method we need to stipulate the format. However, since this is what I need to check and I want to tell the user the errors in the file (i.e. You file does not contain the required field "x" or the required field "x" must be of datatype "y")I need a method that will import the data into a table regardless of the format, so that I can check it.
I'm thinking of writing an XML file from the comma-delimited upload. Any comments
|
|
|
|
|
If you can't verify that the data has the proper column delimiters and the proper row delimiters then you don't really have a data file, just a text file. You will need to parse it yourself to verify that validity of the data.
You could just import each row into a TEXT field in SQL Server and try to parse the data yourself, but you don't know if the user put the proper row delimiter in the file before uploading it, so you may have incorrect data in this TEXT field.
Your best bet would be to write a parser yourself and parse the file looking for all the propery column delimiters and row delimiters and report the errors as you find them.
If you want to write your own bulk copy program, look at the IRowsetFastLoad interface if you are using OLE-DB, or if your going to program in ODBC, look at the bcp_* functions in the SQL Books Online.
|
|
|
|
|
Hi,
I use VB.NET to access SqlServer 2000 arabic Database.
I wrote a query for searching customers having names contain some arabic characters as follows :
Select * from client where contains(cust_name,'أحمد')
it's not working. I even test it under SqlServer Query Analyser also it's not working.
i tried the same query with the (Like "%") comparison, no result.
i tried ltrim(rtrim(cut_name)) but also no result.
I attract your attention that :
- The type of Cut_Name Field is nvarchar(50).
- The table is full-Text Indexed on cust_name field
does someone have an idea?
Thank you very much.
* *
*
* *
|
|
|
|
|
Just a guess:
Change Collation of your database or that specific column to one of Arabic options.
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
Hi..
I entered arabic data in a column in an existing database and and searched it using
like operator.. it worked..
the column was nchar(50) but I did not try full search..
maybe the problem is the colations installed.. but collation should affect
only char or varchar columns..
So it is a strange problem..
but anyway try adding Arabic collation..This may fix the problem..
|
|
|
|
|
I have a table which requires records to be deleted programmatically at time intrvals.
I have an created field which stores the time it was created and I can't figure out how to delete records older than 3 hours.
ie:
DELETE FROM temp WHERE created < now()+(3600*3)
I'm using mysql BTW, but I don't think SQL or SQL would have much discrepancies here would they?
Thanks for you time 
"Two wrongs don't make a right, but three lefts do!" - Alex Barylski
|
|
|
|
|
DELETE FROM temp WHERE created <= DATEADD( h, CURDATE(), -3);
This will work for SQL Server, but I'm not sure about MySQL. Give it a shot
|
|
|
|
|
this solution can work for SQL Server:
DELETE FROM temp WHERE DATEDIFF(Hour,created,getdate()) > 3
|
|
|
|
|
What is an AutoNumber field's maximum limit? What happens when the maximum limit is reached?
|
|
|
|
|
Its the limit of a long interger, roughly 2 billion. I would be interested to know what happens when it hits the max too
|
|
|
|
|
You get an error :
Server: Msg 8115, Level 16, State 1, Line 1<br />
Arithmetic overflow error converting IDENTITY to data type int.<br />
Arithmetic overflow occurred.
|
|
|
|
|
 Hi
I am trying to develop my web application
ASP.NET to query my SQL Database
but when trying to running it
i got this error message (after the application has been
succesfully compiled and running on the IIS:
Login failed for user 'PRESARIO1692\ASPNET'.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'PRESARIO1692\ASPNET'.
Line 31: sqlDataAdapter1.Fill(dataSet11);
I think i need to grant an access for user ASPNET
but i don't know how.
I am running a Microsoft SQL desktop engine
deployed with the Visual C#.net standard edition.
Thanks
marnicola90@hotmail.com
 
|
|
|
|
|
marnicola wrote:
I think i need to grant an access for user ASPNET
but i don't know how.
Yes,this is your problrm. Open enterprise manager and open Security folder in it.Write click on "Login",and then choose New Login.While windows authentication is chosen,select ASPNEt account with browse button.In the bottom of the dialog ,chosee the name of database you want to use.
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
Well I don't know where is it this enterprise manager but i can't find it. Where is it ? Is it of the SQL ? (I have deskttop engine version). Is it of Windows2k ? I am running on Win2k ITA . Tell me the name of the exe.
Thanks.
|
|
|
|
|
Oh,you mean you have MSDE,so you don't have it.
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
Yes i think i don't have the enterprise manager.
In a newsgroup i received this reply
C:\>osql -E
1> use master
2> exec sp_grantlogin 'PRESARIO1692\ASPNET'
3> go
Granted login access to 'PRESARIO1692\ASPNET'.
1> use pubs
2> exec sp_grantdbaccess 'PRESARIO1692\ASPNET'
3> go
Granted database access to 'PRESARIO1692\ASPNET'.
1> exec sp_addrolemember 'db_datareader','PRESARIO1692\ASPNET'
2> go
'PRESARIO1692\ASPNET' added to role 'db_datareader'.
1> quit
i think it's correct. What you think ?
It's may case. DOS command right because of the MSDE.?
|
|
|
|
|
Yes,this commands equal to what I told you.I've never run SQL commands from command line,Let me know if it works for you.
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
Well now i have try to run a scrip i have fount on the CD
that before i haven't done because i didn't know how to run scripts this is the result :
C:\Programmi\Microsoft SQL Server>osql -E sa -i installcontacts.sql
1> 2> 3> 4> Msg 3702, Level 16, State 4, Server PRESARIO1692, Line 3
Cannot drop the database 'Contacts' because it is currently in use.
1> 2> 3> 4> Msg 1801, Level 16, State 3, Server PRESARIO1692, Line 2
Database 'Contacts' already exists.
1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3>
1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3
> 1> 2> 3> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3>
4> 5> 'ASPNET' added to role 'db_accessadmin'.
1> 2> 3> 4> 'ASPNET' added to role 'db_backupoperator'.
1> 2> 3> 4> 'ASPNET' added to role 'db_datareader'.
1> 2> 3> 4> 'ASPNET' added to role 'db_datawriter'.
1> 2> 3> 4> 'ASPNET' added to role 'db_ddladmin'.
1> 2> 3> 4> 'ASPNET' added to role 'db_denydatareader'.
1> 2> 3> 4> 'ASPNET' added to role 'db_denydatawriter'.
1> 2> 3> 4> 'ASPNET' added to role 'db_owner'.
1> 2> 3> 4> 'ASPNET' added to role 'db_securityadmin'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 8>
9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 2
9> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 1> 2>
3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23> 24> 25> Msg 170, Level 15, State 1, Server PRESARIO1692
, Line 15
Line 15: Incorrect syntax near 'Contact Types'.
It seems the Contacts db(my db) was already added to the master.mdf infact master in the beginning was 1 M now it's about 12M. I think Visual Studio did.
Plus the script added ASPNET user as reader writer and so on.
But still i have the same error , after the compilation was okay . I get the error when the browser open and contact both servers.
I don't know
|
|
|
|
|
The funny thing is that i try to refresh the connection after i got the login message Visual Studio Server Explore return this message :
QueryInterface for interface IOleServiceProvider failed.
and then the connection on the treeview expire
when before the compilation the connection test was
succesfull.
Plus i can see everything from the Database from visualstudio ,Tables records . Everything.
Do you think my problem is that i am running on Win2K SP2 Italian and VisualStudio is English so MSSQL (MSDE) ?????
|
|
|
|
|
Plus after the connection is expired from Server Explorer , visual studio show me an empty database, but with all tables and fields, but not data.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
