Creating a custom migration process for SQL Remote databases / handling of SQL Remote tables
I would like to invite you have a look at one more SQL Remote-related
question on the SQLA website (particularly, as I have asked them:)
...SQL Anywhere 9 How to use cursor on table in remote server
Is it possible to declare a cursor on 2 tables where one table is on the
I can run the query in I-SQL without any problems.
The open cursor statement returns sqlstate 00000, but when fetch next is
called an error pops up "cursor not open"
declare cursor_x dynamic scroll cursor for
select Id from table A join ProxyTabe B on A.Id = B.Id
where A.CodeFld <> B.CodeFld;
open cursor_x; //sqlstate = 00000
fetch next cursor_x into variable
if sqlStatus <> 0 then leave l1 end if;
close curso...How to connect to Remote SQL Server database using SQL Server 2005 Express
Hi,I've an account with a hosting service provider online for SQL Server database. I've downloaded SQL Server 2005 Express from ASP.Net. How can I use it to connect to my SQL Server Database which is sitting on remote server? The hosting provider gave me following things to connect to the remote database.Server NameDatabase NameUser NamePasswordRegards,A.K.R
I don't want to ask the obvious, but is there not a Read Me file
included with the download of SQL Express which would explain how to
Sorry I can't be more helpful, but I've only ever briefly ...Using the SQL Remote Message Agent only for one remote user
Currently we have Sql Anywhere 184.108.40.2066.
I was wondering if it was possible to use the SQL Remote Message Agent
(dbremote.exe), at the consolidated, to run only for a specific remote user.
We have for example a setup with 50 remote users at our consolidated. But we
only want to run dbremote for remote_user20 if remote_user20 is online and
requests to synchronize.
We don't want dbremote at the consolidated to import all files from all 50
users and then make exports for 50 users if only remote_user20 is online.
I'm aware of the fact that SQL Remote doesn...login authentcation using a remote sql table
Hi all, I apologize for what could possibly be a redundant post however we still have been unable to resolve this issue. We have created a test site using only master pages, menu bar, asp controls...login, gridview etc.. after putting the site on the server we found that it was looking for a local sql express to access the uthentication database, fine we have a different server running sql and we'll just connect to that. We created the users in the table and configured the string but nothing. After a few diffeerent trys we removed the main login page and past...Remote RPC Execution using Proxy Table
We have been using Proxy tables for a remote procedure to load data from one
Sybase ASE to another Sybase ASE. We are planning to migrate our system to IQ.
How can we create a proxy table for a remote procedure to load data from Sybase
ASE to Sybase IQ. Kindly get back a reply with a work around if no direct method
Thanks is advance,
Abraham A. Samuel
---== Posted via the PFCGuide Web Newsreader ==---
Kindly reply if anybody knows
We have been using Proxy tables for a remote procedu...SQL Anywhere Remote Crashes after extended use
I have two servers running Sybase SQL Anywhere 5.5.04 (or whatever the
latest is). Anyway, the one database updates the other through the
Remote using SMTP (updates are broken into mail messages, which are then
pulled by the second database using POP). The problem that is occuring
is that when the Remote is left running overnight, it crashes. The
specs are: 2XPent 200 128Mb RAM, NT 4.0 SP3. The only messages in the
event log are something about the SQLCTRS.DLL being unable to load
(Event ID 2003) and an unknown from perflib (event ID 1008). Both of
these are related to performance...Replicating passwords from one remote database to other remote databases
I am attempting to replicate password changes from a remote database to
the consolidated database to all other remote databases.
The reason I am attempting this is we are implementing "multi-user"
remote databases, where a db user created on the consolidated can be on
one or more remote databases.
I want to only allow remote users to change their db passwords, but have
those password changes replicate to all other remote databases.
My initial thought was to have a table that maintained db user name and
encrypted password that would be subscribed to by all remote databas...Multi-Tier replication using SQL Anywhere Remote
Do you have an idea on how to setup a 2nd remote server that can replicate
with the main site? 2nd site has its own set of laptop users using
DBREMOTE as well. I am using FILE as message link, and I don't know how to
deal with SQLREMOTE in the 2nd site.
- Software: SQL Anywhere Studio 7.03
- Replication method: DBREMOTE.EXE
- Message Link: FILE
- Server: 1 HQ Server
- Client: Several PCs directly using HQ DB Server , some laptops using
own DB and replicated daily using DBREMOTE
- SQLREMOTE Setting : \\HQ\DBS (This contains the mess...Multi-Tier replication using SQL Anywhere Remote (Follow up)
Any advise on this?
That's my solution fow now. The laptops in the third tier are directly
connecting to \\hq\dbs. But since I am using dial up, its clogging up my
connection. I am looking for a solution wherein only the server in second
site will use the dial up line, and eventually it will communicate these
changes to other terminals using LAN.
Thanks for your help!
"Reg Domaratzki" <email@example.com> wrote in message
> Why doesn't the third tier (i.e. laptops from second site...login not working on remote server
I have a problem.
I have uploaded an asp.net 2.0 web project that uses asp.net membership/roles to my hosting service. I had already on my local machine converted the sqlexpress security database to an sql2005 one and imported all these tables, scripts, etc to my application database. That database was also uploaded to the host. So my one database has all my former sql Express roles/membership tables, sp’s, etc. and my application tables, etc.
My web program correctly works when I do not use the login screens (if I use the gue...How can I use embedded sql to connect to a remote database server
I have written a program (embedded sql) on Solaris platform. It needs to
connect to a remote server. However, I can use the isql to connect the
remote database server .
However, I have set the following in the .odbc.ini .
[ODBC Data Sources]
SybaseASA=Adaptive Server Anywhere ODBC driver 8.0.x
The SQLCODE returns -101, which is Database Server not Connected.
Any suggestion to solve this problem.
...Not able to connect to remote sql anywhere using ado.net
I know this is quite newbie quest.
Actuall I am new to Sybase and not having any good database
knowledge either , Here is my problem:
I want to connect to remote database with ado.net, I am not
even to connect to remote server using connection string, It
is working fine with local database that is on my PC.
Connection string I am using for local database connection
OleDbConnection myConnection = new
It is working fine.
I have tried everything to connect to remo...Replication of consolidated database to remote database; for columns added to a table in the consolidated database.
I want to find out if I add columns to a data table in the consolidated
database and then extract it for a remote database. Will the added columns
appear in the remote database automatically? or do I have to deploy the
extracted remote database by copying it to the remote machine.
Currently the consolidated database and the remote database get replicated
nightly and they have connections already established. Due to established
connections, will the extracted database automatically get deployed to the
remote machine with the updated table?
Try it, that is the best way to check ...