I need to make some simple sql query (like select COUNT(*)) on ArcSDE Table stored on a MS SQL server.
When I use the SQLExecutor, I can't connect to my DB. How to connect.
I can read with a reader, I can write with a writer, but I need to perform some simple SQL query.
How to do this.
Server ?
Database ?
Do I have to create an OLDB connection on my windows OS ?
Thanks!
MS SQL Server Reader: Connection failed. Connection string `Provider=SQLOLEDB;Data Source=Q1541BE;Initial Catalog=gs0599_i5;User ID=DMY_USER];Password=dMY PASSWORD]'. Provider error `(-2147467259) )DBNETLIB]BConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé.'
Failed to open reader
Failed to open reader
A fatal error has occurred. Check the logfile above for details
A fatal error has occurred. Check the logfile above for details
what are the (working) connection parameters you're using to connect with SDE? And which parameters have you tried for the MS SQL Server reader?
David
Server : s.o. (mean nothing but have to write something)
Username : my_user
Password : my_password
Instance Name : sde:sqlserver:q1541VIP,1456
Database : gs0599_i5
If I want to use SQLExecutor I need those parameters :
The value entered does not work...
Format : Microsoft SQL Server Non-spatial
Dataset : gs0599_i5
Server : q1541VIP,1456
Database : gs0599_i5
Username : my_user
Password : my_password
when I look at the error message that you posted above and compare it with what you posted just now, I see a discrepancy between the server names:
Log server name: Q1541BE
SQLExecutor server: q1541VIP
Could this be the cause?
David
Yes, thats depends on where I run my FME. I need to connect BE (for Backend) on another machine, but I need to use VIP on my computer, but it's the same.