...getting exported. So the excel has only the data without column names.
Any ideas?
This is what i am doing.
cdlAdHoc.ShowSave
cdlAdHoc.Filter = "*.xls"
strFileName = cdlAdHoc.FileName
constr = "DSN=" & gDSN & ";"
constr = constr & "UID=" & gLoginID & ";"
constr = constr &...
Hi,
I am trying to create a VSS object. using the following code
Set vssObj = Server.CreateObject("SourceSafe")
vssObj.Open "\\myserver\srcsafe.ini",userId, ""
However i get the following error, at the open statement
Microsoft VBScript runtime error '800a0007' Out of memory
Any idea... i am...
Hi
"SELECT MIN(SPID) FROM SYSPROCESSES WHERE DBID= <ID OF A DATABASE>"
What is the possibility of getting a SPID 5 (which is a task manager - system process) while using a query specified above. Provided a database id is specified in the where clause
I used a above specified query...
Hi
"SELECT MIN(SPID) FROM SYSPROCESSES WHERE DBID= <ID OF A DATABASE>"
What is the possibility of getting a SPID 5 (which is a task manager - system process) while using a query specified above. Provided a database id is specified in the where clause
I used a above specified query...
hi,
I need to write a function that would store the userid in a cookie on the users machine and automatically fill it when the user visits the same website.How do i do this!!!!....help
Thanks
Hi All,
Need some urgent help..
I optimizing Stored Procedures. The current database is of 5 GB in size and a specific tables have more than a million records. And this is just the sample db. The original has more than 20 to 30 million records and expected to grow at the rate of 5 million record...
Hi All
I have a html page with two frames and a print button in one frame.On the click event of this print button i shld be able to print the contents of both the frame in one page.Is it possible to do this operation..coz the window.print option prints the contents of the frame which...
I have an ASP page with multiple windows. I need to print the contents of all the frames using a Print button.
"window.print() or top.print() or parent.window.print()" is not helping me.
Hi,
I am in a critical state..somebody pls help me.
I need to import data from a DB2/AS400 to a SQL Server7.0
I have no knowledge of DB2/AS400.
Anybody aware of a solution, pls let me know asap.
Thanks
thanks a lot for your responses..
i had already gone thru msdn, and books online......
The data type is nvarchar
My issue is especially with Chinese & Japanese... other languages are working fine...
My issues are
1. I tried inserting value using query analyzer saying
INSERT INTO test...
hi think the problem is with u r vb code ..u shld always bind variables
ur connection variable and the record set variable is not bound
u shoul either do early binding or late binding
try this in ur vb code
dim adocon as new adodb.connection
dim adors as new adodb.recordset
it shldnt give...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.