Recent content by ahartong

OK, I can try the ODBC trace to see what is happening. Never knew that existed. I was just instructed to use a typical connection string. Here it is. DRIVER={SQL Server};Server=ahartong-01\ahsql2;Database=ZOOTH;Uid=sa;Pwd=;

I have a 3rd party app that I am trying to use that connects to an sql database. It runs as a service, and I have it running on one system, but cannot get it to run on other systems, that appear to have the exact some setup. I have a dsn-less connection string that I am using to connect to the...

I am trying to build statements using a variable for my database name.(Ex. @DB.dbo.tablename) This is working fine using sp_executesql, but I am having trouble building a cursor from a large select statement with joins. It seems to let me run the statement, but it does not seem to keep the...

I am mapping an edi 850 to a flat file. I am having a problem wih looping segments. On an N1 loop, I have an N1, N2, N3, and N4 declared. But, when testing, if I receive an N1 and N3, it still prints the N2 and N4. Is there a way to suppress the segments in the loop?

I need to create an HTML file in t-sql that will be emailed. I am having trouble running the commands to generate the HTML that needs to be written to an output file. What would be my best option? I've tried some scripts with the xp_cmdshell command, but it can't write html tags to the file...

I am trying to write a SQL statement in a stored procedure, and I'm not sure if SQL has the functionality to handle what I am tring to do. Once the call is made, I use the @PONum variable in the proc. Here is my example statement: SET @SQLString = N'select ' + @PONUM + ' = PONUMBER from ' +...