|
I don't think there is much of a difference between 2003/2007.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi, guys. I need some help with the DoCmd.OutputTo method in MS Access. I would like to export the file to a .CSV file but the only options that I have are as follows:
AcFormat can be one of these AcFormat constants.
acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS
The code for DoCmd.OutputTo is as follows:
DoCmd.OutputTo acOutputTable, "tblInputFile", _
acFormatTXT, "C:\test\output.csv", True
I tried to use the acFormatTXT option to export to the .CSV file. I need the result to be a comma delimited list, but it comes out like this:
--------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | Facilities & Real | 4 | 57AU |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | General Supply | 0 | 57AU |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | Marketing | 0 | 57AU |
-----------------------------------------------------------------------------------------------------------
-- modified at 13:13 Monday 29th October, 2007
|
|
|
|
|
hi All
i have some DTS that run at night. they were running for year now, but Sudenly the give this Errors when i run them.
Select permission denied on object 'sysobjects',database
'Tshwane_valuations',owner 'dbo'.(
Microsoft Ole DB Provider for SQL
(0):Started-OITPS_ALL_Create_Temp)
What Could be a Problem.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
You do not have permission on this system table.
If, you have database team then contact them, they will definately solve your problem..
|
|
|
|
|
Thanks man , it helped me a lot
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
System.ArgumentException: Redirect URI cannot contain newline characters.
I'm getting this error while selecting one of the record from a datagrid using a Request.String and display the records value into another page.
Pls help me in this regard.
|
|
|
|
|
|
Good Day,
I have installed MS SQL 2005 Express on my Desktop and Laptop machine. Most of the development are being done in my desktop. Sometimes, My bro uses the desktop and I'm using the laptop to do development. (C#)
How can I retrieve some data from the SQL Server installed in my Desktop using my LAPTOP? What are the settings I need to fix inside the SQL Server Configuration Manager. (TCP/IP ?)
Please advice, Thanks.
Ian Uy
|
|
|
|
|
Ian Uy wrote: What are the settings I need to fix inside the SQL Server Configuration Manager. (TCP/IP ?)
That would seem to be sensible. Remember to block the port that SQL Server is using on your external firewall.
|
|
|
|
|
Thanks for the reply.
What are the exact settings that I need to adjust in my DESKTOP to allow in-bound connections from my laptop?
|
|
|
|
|
Ian Uy wrote: What are the exact settings that I need to adjust in my DESKTOP to allow in-bound connections from my laptop?
Turn TCP/IP on in SQL Server. Ensure that the firewall permits the port (usually 1433) within your network (but not outwith your network)
|
|
|
|
|
|
Good Day,
I have read the article and have executed every instruction properly.
But I am getting a weird error, I have search for the answer but have failed.
This is the error:
<br />
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)<br />
|
|
|
|
|
Hi,
This is rajendran,working as a web developer.I have doubt in SQL server 2005 like How to get the alias name for field name using Cursor..Plz reply me..
Thanks
Ra jendran
|
|
|
|
|
Raa ju wrote: Hi,
This is rajendran,working as a web developer.I have doubt in SQL server 2005 like How to get the alias name for field name using Cursor..Plz reply me..
Thanks
I dont know how it would help by posting the question over and over again... you need to be patient. If you havent received any answers so far, it is possible that others have either not seen your post yet or you might have to provide more information for them to be able to help you...
|
|
|
|
|
ChandraRam wrote: dont know how it would help by posting the question over and over again...
It doesn't and it makes people less likely to reply.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi,
This is rajendran,working as a web developer.I have doubt in SQL server 2005 like How to get the alias name for field name using Cursor..Plz reply me..
Thanks
Ra jendran
|
|
|
|
|
Quit asking the same thing over and over again.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Previously i have used sql authentication for my application but due to some reasons sql server 2000 was reinstalled with mixed mode(both windows and sql authentication). when i run my application "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." error message is showing
pls help me out
|
|
|
|
|
Does the login exist for the user? Logins are held in the master database while the users are held in each individual database. The application will fail if the login does not exist.
|
|
|
|
|
Mixed mode is the correct option if you want to use SQL Authentication. You cannot turn off Windows authentication. It's most likely that the server was reinstalled with Mixed Mode disabled, i.e. Windows Authentication only.
You will need the administrator to re-enable Mixed Mode. In Enterprise Manager, connect to the server, then right-click the server in the tree and select Properties. On the Security tab, ensure that Authentication is set to "SQL Server and Windows" rather than "Windows only". Click OK, then you will have to restart SQL Server.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Thanks for ur reply.
I have changed it to "sql server and windows" and also created a login for the domainname\username and in the connection string i have given "data source=domainname,intial catalog=appliactionname,persist security info=false"
when im giving trusted connection=none
then it is showning error while running the application itself
so pls help me with some solution
|
|
|
|
|
You need to associate a certain user to the database you want to access.
Using Object Explorer, Go to Security -> Login, Right click Login then select New Login, create your user account. Then on the left side, select User Mapping then put a check on the database you want to access with this user account, check everything below except the denyreader and denywriter (It's up to your preference).
|
|
|
|
|
I had detached my MSSQL 2005 DB and attached the DB without log file because it is getting too big. After attaching the log, the log seem to be NOT growing anymore. What has happen to my log file? Is there anyway or software that can view the log file?
|
|
|
|
|
If you attached the database without the log file, SQL Server may have created a new log file, depending on the options you selected. It may well not be in the location you expect. In SQL Server Management Studio, right-click the database and click Properties. Under Files, scroll to see the Path and File Name columns. This will show where the log file is and the name of the file.
The transaction log is used to record all operations that are performed in the database. This is done using slow, reliable I/O in such a way that the log can be used to undo the operations should a power outage or other failure occur, or if a transaction is aborted. In practice the log is also used to defer writing back changes to the database itself - after the log data is written to disk, SQL Server only updates the affected areas in memory, lazy-writing these. It does ensure that the writes to the database file are done in a fairly timely fashion - it tries to ensure that recovery after a failure will take a bounded time, which is configurable (the 'recovery interval' option, which is set per-server, and defaults to 'automatic' which currently means about one minute). When performing a recovery operation, SQL Server may need to actually reperform actions that made it into the log but weren't yet written to the data files.
What happens to log records that represent changes that have been committed, and securely written to disk, depends on whether SQL Server thinks you want to retain the log records. If not, these log records then become available for reuse. When the end of the log file is reached, if the area at the beginning is available for reuse SQL Server will wrap around, otherwise it has to grow.
Whether SQL Server retains the log records depends on the recovery model and whether you've backed up. If the recovery model is set to Simple, SQL Server does not retain the logs. If, however, it is set to Full or Bulk Logged, and you have made at least one full database backup, it assumes that you do want to keep a backup chain and does retain the logs.
Why would you want to do this? Because if you have the log file and log backups available, you can restore not just the last full backup but also roll forward to the point of failure, or to a given point in time. If you are using Full recovery model, you should ensure that you're regularly backing up the transaction logs as well as the database - a full backup does not clear the transaction log chain (unlike Exchange, for example).
If you are using Full or Bulk Logged recovery model but want to reset your log chain, you can issue the command
BACKUP LOG database WITH TRUNCATE_ONLY which marks all committed transaction log records as reusable. It will then not keep a log chain until you next do a full backup. To actually shrink the log file you will need to then use the Shrink Database feature.
There are tools available that can view the log file but they're not cheap.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
