|
|
For anyone interested, this is one way that works:
DECLARE
SEQ_ID NUMBER;
BEGIN
SELECT AN_OTHER_TABLESPACE.CUSTOMERID_SEQ.NEXTVAL INTO SEQ_ID FROM dual;
EXECUTE IMMEDIATE 'CREATE SEQUENCE CUSTOMERID_SEQ
MINVALUE 1
MAXVALUE 99999999
INCREMENT BY 1
START WITH ' || SEQ_ID || '
NOCYCLE
NOORDER
NOCACHE';
END;
/
|
|
|
|
|
I have one script task. Withing this script task, I need to create and execute Execute SQL Task.
Can be do so?
CodeManiac
xxxxxxxxxx
xxxxxxxxxx
|
|
|
|
|
Hello Friends,
I am in trouble while loading data to SQL Server. i am using bulkcopy code to load datas.
I dont have much knowledge with SQL
While loading, if error occurs (in xtreme cases) loading wont be perfect(ie I having four tables to be loaded. error may occur while loading the fourth table. for me its like corrupting the tables. because for tables are interconnected)
So if error occurs i want to roll back other three tables to last state.
The below code is i used for loading and these function is calling four times for updating four tables
Can Rollback property be applied to the below code?? Please do help
Or any other way to prevent the tables from getting corrupted
------------------------------------------
Public Function rb_BCP(ByVal Server As String, ByVal Database As String, _
ByVal Table As String, ByVal FileName As String)
Dim objServer As SQLDMO.SQLServer
Dim objBCP As SQLDMO.BulkCopy
Dim objDB As SQLDMO.Database
On Error GoTo ErrorHandler
Set objServer = New SQLDMO.SQLServer
Set objBCP = New SQLDMO.BulkCopy
objServer.LoginSecure = True
objServer.EnableBcp = True
objServer.QuotedIdentifier = True
objServer.Connect (Server)
Set objDB = objServer.Databases(Database)
With objBCP
.UseExistingConnection = True
.DataFilePath = FileName
.RowDelimiter = vbCrLf
.IncludeIdentityValues = True
.ServerBCPKeepNulls = True
.DataFileType = SQLDMODataFile_SpecialDelimitedChar
.ColumnDelimiter = "|"
.IncludeIdentityValues = True
.ImportRowsPerBatch = 1000000
'Below speeds things up
'but does not log the bulk copy operation
'comment out if this is not what you
.UseBulkCopyOption = True
End With
objDB.Tables(Table).ImportData objBCP
Set objBCP = Nothing
objServer.Disconnect
Set objServer = Nothing
Exit Function
ErrorHandler:
MsgBox "Error " & Err.Number & vbCrLf & Err.Description
End Function
jishith
|
|
|
|
|
|
Hello.
Im running a webserver with apache and mysql 5.xx
Now I want to connect to the MySQL database on a server outside my own. But it doesnt allow remote connections from my mysql database.
I have port 3306 open and the firewall off.
How can I setup MySQL to accept remote connection?
Best Regard
Mads
|
|
|
|
|
Did you check the "Enable TCP/IP connections" option when you run the instance configuration? If not you can just reconfigure.
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
|
|
|
|
|
I installed it together with wamp.
And can't find such just thing in the mysql.ini .. What do I have to change in the mysql.ini to enable TCP/IP connections ?
|
|
|
|
|
Try this one[^] the url looks insultingly explanatory. lol
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
|
|
|
|
|
I use windows for hosting mysql..
I have tried look in my.ini for these bind-adress and the other configs.. But can't find anything at all in my.ini that seems to have something to do with TCP/IP configuration.
|
|
|
|
|
Why SQL "blocks" when it cannot connect to a server? I would want it to return immediately on failure. Connection-timeout attribute looks like useless. I gave it as 5 seconds, but it continues to block for an eternity. Any help?
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
|
|
|
|
|
Please Explain in Detail what is your Problem
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
I thought I explained enough. Anyway here I go:
1. There's an SQL server waiting for you to connect. It's address it 123.134.1.2.
2. Now your application connects, uses DB, finally closes connection. Fine.
3. Now server shuts down, restarts. It's IP is 123.134.2.3 (changed)
4. Your application tries to connect to the old address 123.134.1.2, which doesn't exist.
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
5. Throws a DB exception (May be wrong server/network error)
I want to remove
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
and want it to throw the error immediately.
He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus
|
|
|
|
|
Why do you use an IP ? Because it changes, why dont you use its name ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
|
Hey friends
can anyone suggest the method for creating Table Dynamically in Oracle 9i..
Will b very Thankfull for ur Help..
|
|
|
|
|
You'd do a "create table" from code.
No thanks, you're welcome
I are troll
|
|
|
|
|
InStr(AUD_COMMENTS,tTempEx1,1,1)-(InStr(AUD_COMMENTS,tTempEx +,1,1)+2)
|
|
|
|
|
You're looking for the parts about CharIndex and SubString , and the documentation is here[^]
I are troll
|
|
|
|
|
Hi All,
There is a table with 200,000 rows and 7-8 columns with registeration number as a unique key.
Now i have xls sheet where i have got 16,000 registeration numbers. I need to crossmatch these numbers with the one in sql 2008 database to see how many matches with the database ?
Any help would be greatly appreciated.
Thanks
|
|
|
|
|
You need to import the Excel spreadsheet into a new table in the database and then join the existing table onto the new table using the registration number as the join condition.
It definitely isn't definatley
|
|
|
|
|
cheers. I will try to do that now.
|
|
|
|
|
I have created new table with registeration number id and now trying to import the xls sheet into that table but data type is not matching. In xls the data type is 'double' and in sql there is no option to select data as double. Tried bigint etc but no success.
The below is the source information, So how to match it with new table ?
[Source Information]
Source Location : C:\abc.xls
Source Provider : Microsoft.ACE.OLEDB.12.0
Table: `'Users'`
Column: regxyz
Column Type: Double
SSIS Type: double-precision float [DT_R8]
Mapping file (to SSIS type): C:\Program Files (x86)\Microsoft SQL Server\100\DTS\MappingFiles\JetToSSIS.xml
Any idea ??
Thanks
|
|
|
|
|
I'm confused - are you saying that the data type of the registration number in the Excel spreadsheet is a double? Or are we talking about another column in the spreadsheet? What is the data type of the registration number in your database table?
It definitely isn't definatley
|
|
|
|
|
Basically the excel spreadsheet contains list of only one column which is registeration number - 5 to 8 digits numbers and while importing it through sql import wizard, it says source is double type and does not match with the column i created in new table in sql.
The reg number in the old databasse table is nvarchar and the new one i created just now is bigint but i will now try it with nvarchar ?
So once i get import the reg no to the sql table then i want to match that with the existing reg no in database to see how many reg no already exist.
|
|
|
|