Temporary stored procedures
Tue, 4 Sep 2007 12:16:37 +1200
I have a C++ application that creates a stored procedure, executes it and
then deletes it. The code works perfectly fine until I change the stored
procedure to a temporary stored procedure by simply prefixing the name with
a pound sign (#).
The error I get is in the first call to SQLDescribeParam:
07009 ...
|
Re: SQL 2005 Linked Table in MS Access returns #Deleted
Fri, 31 Aug 2007 23:03:40 -0700
check out this
http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=1441905&p
age=&view=&sb=5&o=&vc=1
*** Sent via Developersdex http://www.developersdex.com *** ...
|
Re: SQL Server To Paradox
Thu, 30 Aug 2007 07:38:05 -0700
Additionally, if any has a list of commands or limitations the the driver can
support from SQL Server, it would be helpful for us to have.
"Jonathan Psaila-Depasquale" wrote:
> Hi Brian,
>
> The Microsoft Paradox driver should work just fine. Could you give us
> more details on what is going wrong with ...
|
Re: SQL Server To Paradox
Thu, 30 Aug 2007 07:32:01 -0700
I would be glad to.
We are doing some further diagnostics on the SQL stuff now. But, there
appears to be some limitations on the drivers ability to handle certain types
of SQL code. For example here are some extracts from the ODBC log:
sqlservr 1cc0-1c84 EXIT SQLDriverConnectW with return code ...
|
Security - Remote Access SQL Server
Wed, 14 Mar 2007 03:48:12 GMT
Hi,
Due to our web application is hosted at Web Hosting company and it is
required to access to our
SQL server which is hosted internally, just wondering what is the best
solution/practise to achieve this as open the SQL server port to public might
raise the possibility of the information leaking (hacking) ...
|
64 Bit MSDASQL
Tue, 13 Mar 2007 08:26:51 -0700
Hi All,
It has been stated that Microsoft will "not" provide a 64 bit version of
MSDASQL...but I have found a response from the MDAC Team stating otherwise
(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1239339&SiteID=1).
When will this be available (dates please)?? We are migrating many apps from ...
|
Append Data on event
8 Mar 2007 08:26:23 -0800
Hello I just recently downloaded sql server express to test out as we
want to eventually migrate from access to sql server express. Im fresh
into how sql server works so i have some elementary questions. what do
i need to do to run an 'append' query that will insert records into my
tables on a daily basis? Can ...
|
|
|
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting
Thu, 08 Mar 2007 04:10:40 GMT
Search Engine Optimization http://www.yourseoconsulting.com/ Seo Optimization , Semantic Results, Artificial intelligence in Search, Auto Content Generators, Search Engine Results. SEO optimizer. SEO consulting
...
|
Smart join when working with UNION
Mon, 5 Mar 2007 13:23:35 +0100
Hi,
a have a query, which used UNION to collect data from 70 identical tables.
My problem is now that I need to join these data against another table with
a join. Is there a smart way of doing this ??
I want to avoid adding the join code for each of my 70 unions.
regards
jorgen
...
|
need help about call sp sql server in vb.net
Sun, 04 Mar 2007 11:51:47 -0800
need help about call sp sql server in vb.net
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com ...
|
