Hi. I have this problem: I have a database in MS SQL Server 2005 and I need to connect to this database via ODBC. But - via ODBC there will be...
Thank you! The PERMISSION_SET was needed! Now I am able to use the ST.Import function with files that are in C:Program FilesMSSQL... folder. But - is...
Well, yes - it is a CLR. It is using an external DLL file... Yes, I tried it on the same machine. And also tried to copy it to the Program...
Hi. I have questions about SQL Server 2005 accessing an external file. I have a procedure called ST.ImportFromShapefile - and this imports a file...
I am sorry everybody - I have solved this problem. Well - I still don't understand why it is so, but now it works. The thing wasn't in the select *...
Well, that's really interesting! So why it gives me the error? On the net there are really more people with the same problem - but I couldn't find...
Yes, well that is useful I think. But again there are 2 reasons I can't do it: 1. the code used to create the table from .shp file is written in a...
Well, yes, when the user uploads a file CITIES.shp it creates a table dbo.CITIES. This is a fact - it is because every .shp file can have another...
Ok - so you mean to manually create archive tables for all of the tables in geodatabase. But there are 2 reasons I can't do it this way: 1. I have to...
Hi. Thanks, bu I am afraid I don't get it. Well, maybe it is some misunderstanding - I need to create a copy of a table that was checked by user to...
Ok, I will explain my trigger. It is used for a geodatabase - I have a metadata table (called met.METADATA) where is info about geodata in the...
Wow, that was really quick :) Thanks, I will try to do something and I'll send you my trigger in the evening Thank you!!!
Hi. I have a little (big) problem with a trigger. I think the fault is in the MSSQL side, not on the mine - I hope you can give me some suggestion...
Separate names with a comma.
